Banner1 Banner1
 
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') 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(45)

2000 PLUS(23)

Carter's(13)

COSCO(11)

GBC(3)

LEE(2)

DYMO(1)

Baumgartens(1)

 
Quantity

1 each(13)

1(1)

12 per pack(1)

 
Size

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

2 oz(2)

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

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

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

2 3/8" x 4"(1)

 
Ink Color(s)

Black(36)

Red(26)

Blue(21)

Blue/Red(12)

Black/Red(1)

Uninked(1)

 
Manufacturer Part Number

P4729RD(1)

P4750BK(1)

P4729BR(1)

P4729BL(1)

P4729BK(1)

P4750BL(1)

P4750BR(1)

P4850BL(1)

P4850BK(1)

P4817BK(1)

P4750RD(1)

P4727RD(1)

P4727BR(1)

6193(1)

03127(1)

03027(1)

47001(1)

P46140BK(1)

P46140BL(1)

P4727BL(1)

P4727BK(1)

P46140RD(1)

P46140BR(1)

P4850BR(1)

P4850RD(1)

P5460BK(1)

P5460BL(1)

P5440RD(1)

P5440BR(1)

P5440BL(1)

P5460BR(1)

P5460RD(1)

P5470RD(1)

P5470BR(1)

P5470BL(1)

P5470BK(1)

P5440BK(1)

P5430RD(1)

P5415BK(1)

P4912BK(1)

P4911RE(1)

P4911BK(1)

P5415BL(1)

P5415BR(1)

P5430BR(1)

P5430BL(1)

P5430BK(1)

P5415RD(1)

065488(1)

065487(1)

38010(1)

011096(1)

9808196(1)

9808003(1)

9806452(1)

011097(1)

030253(1)

030257(1)

030256(1)

030255(1)

030254(1)

21448(1)

21447(1)

21261(1)

21082(1)

21081(1)

21071(1)

21271(1)

21272(1)

21381(1)

21371(1)

21282(1)

21281(1)

030258(1)

061794(1)

065476(1)

065477(1)

065475(1)

065474(1)

065473(1)

065478(1)

065479(1)

065486(1)

065485(1)

065484(1)

065483(1)

065472(1)

065471(1)

065103(1)

061961(1)

061940(1)

061797(1)

065465(1)

065466(1)

065470(1)

065469(1)

065468(1)

065467(1)

21021(1)

 
Country of Origin

AT(70)

MX(13)

CN(10)

US(6)

 
Stamp Pads Type

Inked Replacement(74)

Inked Microgel(6)

Inked Micropore(5)

Inked Felt(4)

Inked Fingerprint(3)

Inker(2)

Uninked Replacement(2)

Inked Foam(2)

Uninked Felt(1)

 
Pad Size (Width)

4 1/4"(11)

1"(6)

2 3/8"(3)

3"(3)

2 13/16"(3)

1 15/16"(3)

3 1/8"(3)

1 5/8"(3)

1 1/2"(3)

6 1/4"(3)

6 1/6"(3)

2"(2)

2 1/4"(2)

1 1/8"(1)

1 7/8"(1)

4"(1)

3/8"(1)

 
Pad Size (Depth)

1/4"(21)

2 3/4"(11)

3 1/8"(3)

3 1/4"(3)

1 5/8"(3)

9/16"(2)

2"(2)

1 3/4"(2)

1"(2)

3/4"(1)

2 3/8"(1)

 
Refill(s) For

Trodat T4729(4)

Trodat T5415(4)

Trodat T5470(4)

Trodat T4727(4)

Trodat T46140(4)

2000 PLUS 1SI15P(3)

2000 PLUS 1SI50P(3)

Trodat T5440(3)

Trodat T5430(3)

Trodat E4850(3)

Trodat E4750, E4750N, E4752, E4754(3)

2000 PLUS 1SI60P(3)

2000 PLUS 1SI10P(3)

2000 PLUS 1SI40PGL, 1SI40P(3)

Trodat T5460(3)

2000 PLUS 1SI20PGL(3)

2000 PLUS 1SI30PGL(3)

Carter's Reinkable Stamp Pads(2)

GBC 9820311 Series, 9802060(2)

Trodat E4912(1)

GBC 9806440, 9806445, 9806452(1)

Trodat E4911(1)

Trodat T5558, T55510, T5460, T5117(1)

Trodat E4911, E4820(1)

Trodat T5440, T5444(1)

Trodat T5546, T5430, T5030(1)

2000 PLUS 011091(1)

COSCO 026304(1)

COSCO 01113, 011030(1)

2000 PLUS Self-Inking Daters(1)

2000 PLUS Economy Message Daters(1)

DYMO 47002(1)

2000 PLUS 011092(1)

Trodat E4817(1)

Trodat E4750, E4750N, E4752, E4754, E4752(1)

COSCO 010129(1)

Trodat E4850L, E4850(1)

 
Ink Pad Type

Cartridge(73)

Conventional Pad(21)

Ink Roller(3)

Refill Ink(2)

 
 
 

© 2019-2020 Onestop, Inc., All Rights Reserved