SELECT `pinfo`.`sku`,`pinfo`.`vendor`, IF(`pinfo`.`multi_level_pricing_check`=1,(`mlrp`.`cost`/`mlrp`.`min_qty`),IF(CURDATE() >= `ds`.`expiration_date`, `ds`.`price`, `crp`.`contract_price`)) AS `price`, CONCAT(IF(`pinfo`.`vendor`=2,`desc_long`,`desc_short`),' ',`pinfo`.`sku`,' ',`category_1`,' ',`category_2`,' ',`category_3`,' ',`category_4`,' ',IF(`pinfo`.`vendor`=2,`sales_copy`,`desc_long`),' ',IF(`dealer_sku`!='',`dealer_sku`,''),' ',`manufacturer_name`,' ',`color`) AS `search_string` FROM `product_info` `pinfo` INNER JOIN `vendor_base_costs` `vbcc` ON `pinfo`.`sku`=`vbcc`.`sku` LEFT JOIN `contract_price_1` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` LEFT JOIN `bestseller_priority_detail` AS `bpd` ON `pinfo`.`sku`=`bpd`.`sku` LEFT JOIN `bestseller_priority_master` AS `bpm` ON `bpm`.`list_id`=`bpd`.`list_id` LEFT JOIN `dealer_special` AS `ds` ON `ds`.`sku`=`pinfo`.`sku` AND CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` LEFT JOIN `multi_level_retail_price` AS `mlrp` ON `mlrp`.`sku`=`pinfo`.`sku` AND `mlrp`.`preferred_vendor`=`pinfo`.`preferred_vendor` AND (`mlrp`.`cost`/`mlrp`.`min_qty`)>0 WHERE (`category_id` IN ('281')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_pricing_check`=1 THEN TRUE ELSE `crp`.`contract_price`>0 END AND `pinfo`.`sku` NOT IN (SELECT `alias_sku` FROM `internal_alias_detail`) GROUP BY `pinfo`.`sku` ORDER BY ISNULL(`bpm`.`list_priority`) ASC, `bpm`.`list_priority` ASC, ISNULL(`bpd`.`priority`) ASC, `bpd`.`priority` ASC, CASE WHEN `pinfo`.`sku` LIKE '%StampPads' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('StampPads' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+StampPads' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"StampPads"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"StampPads"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"StampPads"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"StampPads"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+StampPads' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='StampPads',`category_4` ='StampPads') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'StampPads,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('StampPads', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Stamp Pads

Refine Search

  GO
 
Brand

Identity Group(29)

COSCO 2000PLUS(17)

Carter's(11)

COSCO(7)

NIO(3)

Bates(2)

LEE(2)

SICURIX(1)

Colop e-mark(1)

 
Size

2.25 x 1.75(2)

0.56 x 1.5(2)

2 3/8" x 4"(1)

 
Packing Type

Bottle(1)

 
Ink Color(s)

Black(31)

Red(16)

Blue(10)

Blue/Red(9)

Uninked(1)

Cyan/Magenta/Yellow(1)

Noble Blue(1)

Brave Red(1)

Gray(1)

Black/Red(1)

 
Manufacturer Part Number

21021(1)

P4727BK(1)

P4817BK(1)

P4750BR(1)

P4750BK(1)

P4729BR(1)

P4729BK(1)

P4727BR(1)

P46140BK(1)

P4850BR(1)

6193(1)

03127(1)

03027(1)

071519(1)

071513(1)

071510(1)

P4850BK(1)

P4911BK(1)

065487(1)

P5440BR(1)

P5470BK(1)

P5460RD(1)

P5460BR(1)

P5460BL(1)

P5460BK(1)

P5440RD(1)

P5440BL(1)

P4911RE(1)

P5440BK(1)

P5430RD(1)

P5430BR(1)

P5430BL(1)

P5430BK(1)

P5415BL(1)

P5415BK(1)

065488(1)

065479(1)

21071(1)

21381(1)

011097(1)

011096(1)

38010(1)

9808196(1)

9806452(1)

21448(1)

21371(1)

030257(1)

21282(1)

21281(1)

21271(1)

21261(1)

21082(1)

21081(1)

030255(1)

030258(1)

065478(1)

065470(1)

065476(1)

065475(1)

065474(1)

065473(1)

065472(1)

065471(1)

065468(1)

039203(1)

065467(1)

065466(1)

065465(1)

065103(1)

061961(1)

061797(1)

061794(1)

P5470RD(1)

 
Country of Origin

AT(49)

MX(11)

CN(6)

US(5)

MY(1)

CZ(1)

 
Capacity (Volume)

2 oz (59.15mL)(1)

 
Stamp Pads Type

Inked Replacement(51)

Inked Felt(4)

Inked Micropore(4)

Inked Fingerprint(3)

Inked Microgel(3)

Replacement Ink Pads(3)

Inked Foam(2)

Uninked Felt(1)

Uninked Replacement(1)

 
Pad Size (Width)

4 1/4"(7)

1.63"(3)

1"(3)

2.75"(3)

2.38"(3)

3.13"(3)

6 1/6"(2)

1.94"(2)

2"(2)

6 1/4"(2)

2.81"(2)

3"(2)

2.25"(2)

1.5"(2)

4.25"(2)

1 1/2"(1)

4"(1)

0.38"(1)

1.13"(1)

 
Pad Size (Depth)

0.25"(15)

2 3/4"(7)

2.75"(5)

1.63"(3)

3 1/4"(2)

1"(2)

3 1/8"(2)

1.75"(2)

2"(2)

0.56"(2)

2 3/8"(1)

 
Ink Types

Stamp Pad Ink(1)

 
Refill(s) For

2000 PLUS 1SI20PGL(3)

2000 PLUS 1SI40PGL, 1SI40P(3)

Trodat T5460(3)

Trodat T5440(3)

Trodat T5430(3)

NIO 071509(3)

2000 PLUS 1SI60P(3)

Trodat T4729(2)

Trodat T4727(2)

2000 PLUS 1SI15P(2)

2000 PLUS 1SI50P(2)

Trodat T5470(2)

2000 PLUS 1SI30PGL(2)

Trodat T5415(2)

Trodat E4750, E4750N, E4752, E4754, E4756(2)

Trodat E4850L, E4850(1)

Trodat E4911(1)

Trodat T5546, T5430, T5030(1)

Trodat E4911, E4820(1)

Trodat T5440, T5444(1)

Trodat T5558, T55510, T5460, T5117(1)

Carter's Reinkable Stamp Pads(1)

Trodat E4850(1)

Trodat E4817(1)

GBC 9806440, 9806445, 9806452(1)

COSCO 026304(1)

COSCO 01113, 011030(1)

2000 PLUS Economy Message Daters(1)

COSCO 010129(1)

COSCO 039201(1)

2000 PLUS 011092(1)

2000 PLUS 011091(1)

GBC 9820311 Series, 9802060(1)

Trodat T46140(1)

 
Ink Pad Type

Cartridge(50)

Conventional Pad(17)

Self-Inking(3)

Ink Roller(2)

 
 
 

© 2020-2021 Office Solutions & Innovations, Inc., All Rights Reserved