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 ('60279')) 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(34)

COSCO 2000PLUS(17)

Carter's(11)

COSCO(11)

Bates(2)

LEE(2)

SICURIX(1)

DYMO(1)

 
Size

2 1/4 x 1 3/4(2)

9/16" x 1 1/2"(2)

2 oz/59.15 ml(1)

1 3/4" x 2 5/8" x 3/8"(1)

2 3/8" x 4"(1)

3/4" x 1 7/8"(1)

 
Ink Color(s)

Black(35)

Red(18)

Blue(12)

Blue/Red(11)

Uninked(1)

Black/Red(1)

 
Manufacturer Part Number

21021(1)

P4729BK(1)

P4911BK(1)

P4850BR(1)

P4850BK(1)

P4817BK(1)

P4750BR(1)

P4750BK(1)

P4729BR(1)

P4727BR(1)

P4912BK(1)

P4727BK(1)

P46140BR(1)

P46140BK(1)

6193(1)

03127(1)

03027(1)

47001(1)

P4911RE(1)

P5415BK(1)

065487(1)

P5440RD(1)

P5470BR(1)

P5470BL(1)

P5470BK(1)

P5460RD(1)

P5460BR(1)

P5460BL(1)

P5460BK(1)

P5440BR(1)

P5415BL(1)

P5440BL(1)

P5440BK(1)

P5430RD(1)

P5430BR(1)

P5430BL(1)

P5430BK(1)

P5415RD(1)

065488(1)

065479(1)

21071(1)

21448(1)

030254(1)

030253(1)

011097(1)

011096(1)

38010(1)

9808196(1)

9806452(1)

21381(1)

030256(1)

21371(1)

21282(1)

21281(1)

21271(1)

21261(1)

21082(1)

21081(1)

030255(1)

030257(1)

065478(1)

065468(1)

065476(1)

065475(1)

065474(1)

065473(1)

065472(1)

065471(1)

065470(1)

065467(1)

030258(1)

065466(1)

065465(1)

065103(1)

061961(1)

061940(1)

061797(1)

061794(1)

P5470RD(1)

 
Country of Origin

AT(53)

MX(11)

CN(10)

US(5)

 
Stamp Pads Type

Inked Replacement(57)

Inked Microgel(6)

Inked Felt(4)

Inked Micropore(4)

Inked Fingerprint(3)

Inked Foam(2)

Uninked Felt(1)

Inker(1)

Uninked Replacement(1)

 
Pad Size (Width)

4 1/4"(11)

1 5/8"(3)

1"(3)

2 3/8"(3)

3 1/8"(3)

1 1/2"(3)

6 1/6"(3)

1 15/16"(2)

2"(2)

6 1/4"(2)

2 13/16"(2)

3"(2)

2 1/4"(2)

4"(1)

3/8"(1)

1 7/8"(1)

1 1/8"(1)

 
Pad Size (Depth)

1/4"(15)

2 3/4"(11)

3 1/8"(3)

1 5/8"(3)

3 1/4"(2)

1"(2)

1 3/4"(2)

2"(2)

9/16"(2)

2 3/8"(1)

3/4"(1)

 
Refill(s) For

Trodat T5470(4)

2000 PLUS 1SI60P(3)

Trodat T5460(3)

Trodat T5440(3)

Trodat T5430(3)

Trodat T5415(3)

2000 PLUS 1SI20PGL(3)

2000 PLUS 1SI40PGL, 1SI40P(3)

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

Trodat T4729(2)

Trodat T4727(2)

2000 PLUS 1SI15P(2)

2000 PLUS 1SI50P(2)

Trodat T46140(2)

2000 PLUS 1SI30PGL(2)

Trodat E4911(1)

GBC 9820311 Series, 9802060(1)

Trodat T5558, T55510, T5460, T5117(1)

Trodat T5440, T5444(1)

2000 PLUS 011091(1)

2000 PLUS 011092(1)

Trodat T5546, T5430, T5030(1)

COSCO 010129(1)

Trodat E4912(1)

Trodat E4911, E4820(1)

COSCO 026304(1)

Trodat E4850L, E4850(1)

Trodat E4850(1)

Trodat E4817(1)

2000 PLUS Economy Message Daters(1)

2000 PLUS Self-Inking Daters(1)

COSCO 01113, 011030(1)

GBC 9806440, 9806445, 9806452(1)

DYMO 47002(1)

Carter's Reinkable Stamp Pads(1)

 
Ink Pad Type

Cartridge(55)

Conventional Pad(20)

Ink Roller(3)

Refill Ink(1)

 
 
 

© 2020-2021 Dependable Office Supply, All Rights Reserved