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 ('283')) 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 '%Stamps' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('Stamps' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Stamps' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Stamps"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Stamps"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Stamps"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Stamps"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Stamps' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Stamps',`category_4` ='Stamps') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Stamps,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Stamps', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Stamps

Refine Search

  GO
 
Brand

ACCUSTAMP2(39)

Universal(26)

Trodat(14)

COSCO 2000PLUS(13)

Identity Group(6)

C.H. Hanson(4)

Xstamper ECO-GREEN(4)

Stack Stamp(3)

Bates(2)

ACCUSTAMP(2)

NIO(2)

Colop e-mark(1)

COSCO(1)

Stamp-Ever(1)

 
Size

4 x 5 x 3(1)

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

 
Ink Color(s)

Red(34)

Blue/Red(31)

Blue(19)

Black(16)

Full Color(1)

blue/red(1)

Fancy Gray(1)

Aqua; Fuchsia; Hot Pink(1)

Aqua; Lime Green; Neon Orange(1)

Fuchsia; Hot Pink; Lime Green(1)

 
Manufacturer Part Number

9806450(1)

10060(1)

10104(1)

10081(1)

10080(1)

10075(1)

10071(1)

10070(1)

10069(1)

10067(1)

10065(1)

10063(1)

10062(1)

10058(1)

10156(1)

10056(1)

10054(1)

10052(1)

10049(1)

10048(1)

10047(1)

10046(1)

10045(1)

10044(1)

10043(1)

071596(1)

071509(1)

10136(1)

10157(1)

039605(1)

RD015(1)

66210(1)

52112(1)

52111(1)

T5558(1)

T55510(1)

T5546(1)

T5444(1)

T5117(1)

T5030(1)

T2910(1)

T2754(1)

RN028(1)

E4853L(1)

4630(1)

E4850L(1)

E4822(1)

E4820(1)

E4817(1)

E4756(1)

E4754(1)

E4752(1)

8802(1)

8801(1)

8800(1)

5916(1)

5915(1)

065005(1)

039201(1)

9820315(1)

011098(1)

035538(1)

035537(1)

035536(1)

035535(1)

035534(1)

035533(1)

035532(1)

035525(1)

035523(1)

035521(1)

012731(1)

011200(1)

011093(1)

035540(1)

011092(1)

011091(1)

011090(1)

011034(1)

011033(1)

011032(1)

010180(1)

010129(1)

20624(1)

20601(1)

20581(1)

20541(1)

035539(1)

035541(1)

035661(1)

035582(1)

035654(1)

035606(1)

035605(1)

035601(1)

035596(1)

035594(1)

035590(1)

035587(1)

035586(1)

035585(1)

035584(1)

035583(1)

035581(1)

035542(1)

035580(1)

035578(1)

035577(1)

035576(1)

035575(1)

035574(1)

035573(1)

035572(1)

035571(1)

035570(1)

035544(1)

035543(1)

66211(1)

 
Country of Origin

CN(54)

US(34)

AT(27)

TW(2)

MY(1)

 
For Use With

NIO 071519; NIO 071510; NIO 071513(1)

NIO 071509(1)

 
Suggested Use

Clothing(1)

Office; Personal(1)

 
Impression Width

1 5/8"(46)

1 11/16"(23)

1"(7)

1 3/4"(5)

1 13/16"(3)

2 1/4"(3)

1 1/2"(2)

1 1/4"(2)

2"(2)

2 1/8"(2)

2 3/4"(1)

5/32"(1)

1 3/8"(1)

Customizable(1)

1 7/8"(1)

 
Message(s)

PAID(5)

RECEIVED(5)

COPY(5)

FAXED(4)

PAST DUE(3)

APPROVED(3)

ORIGINAL(3)

VOID(3)

COMPLETED(3)

CONFIDENTIAL(3)

ENTERED(3)

POSTED(3)

FOR DEPOSIT ONLY(3)

DRAFT(3)

SCANNED(3)

Customizable Message(3)

DATE(3)

FILE COPY(2)

DATE; ENTERED; FAXED; PAID; RECEIVED(2)

FAX'D; PAID; REC'D(2)

EMAILED(2)

FILE(2)

DATE; RECEIVED(2)

STAR (ICON)(1)

PAID ONLINE(1)

A+, Checkmark, Frowning Face, Smiley Face, Star, Thumbs Up, "Great Job," "Good Work," "Needs Work," "Way To Go"(1)

EMAILED; FAXED; RECEIVED(1)

COPY; DRAFT; ORIGINAL(1)

APPROVED; ENTERED; PAID(1)

12 Common Business Phrases(1)

DATE Only, APPROVED + DATE, COPY + DATE, EMAILED +DATE, SCANNED + DATE(1)

DATE plus 12 Common Business Phrases(1)

RECEIVED; DATE; TIME(1)

DATE plus 11 Common Business Phrases(1)

APPROVED; CONFIDENTIAL; COPY; EMAILED; ENTERED; FAXED; FOR DEPOSIT ONLY; ORIGINAL; PAID; POSTED; RECEIVED; VOID(1)

DATE; E-MAILED; FAXED; PAID; RECEIVED(1)

DATE Only, APPROVED + DATE, COPY + DATE, ENTERED +DATE, SCANNED + DATE(1)

Obscures Data(1)

A.M.; ANS'D; ENT'D; P.M.; PAID; REC'D(1)

SMILEY FACE (ICON)(1)

ANSWERED; CANCELLED; PAID; SHIPPED; ENTERED; COMPLETED; VOID; BILLED; RECEIVED; DELIVERED; FILED; APPROVED(1)

APPROVED; CANCELLED; CHARGED; CHECKED; CREDIT; DELIVERED; E-MAILED; FAXED; PAID; RECEIVED; SHIPPED; URGENT(1)

DATE; PAID(1)

COMPLETED; EMAILED; ENTERED; SCANNED(1)

MAILED(1)

REVISED(1)

RUSH(1)

INITIAL HERE(1)

CHECK MARK (ICON)(1)

RECEIVED; FAXED; PAID; ENTERED(1)

Customizable(1)

CANCELLED(1)

E-MAILED(1)

RUSH!(1)

URGENT(1)

ARROW (ICON)(1)

 
Choking Hazard

Y(1)

 
Stamp Type

Message(72)

Message Dater(18)

Dater(12)

Numberer(6)

Hand Stamp Set(4)

Custom Message(3)

Self-Inking Stamp(1)

Stamp Voucher(1)

Custom Dater(1)

 
Frame/Housing Material(s)

Plastic(60)

ABS Plastic(31)

Metal;Plastic(8)

Steel(6)

Metal(2)

 
Impression Height

1/2"(39)

9/16"(24)

3/8"(9)

1"(7)

5/8"(4)

15/16"(3)

3/4"(3)

1 13/16"(2)

5/32"(2)

1 5/16"(2)

1/4"(1)

1/8"(1)

3/16"(1)

Customizable(1)

1 5/8"(1)

 
Replacement Ink

ACCUSTAMP 090682 (Blue), 090683 (Red)(17)

ACCUSTAMP 090683 (Red)(12)

ACCUSTAMP 090682 (Blue)(8)

2000 PLUS 061961 (Blue/Red)(3)

U. S. Stamp & Sign P5460BK (Black)(2)

Trodat P4750BR (Blue/Red)(2)

Trodat P4911RE (Red)(1)

U. S. Stamp & Sign P5430BK (Black)(1)

Trodat P5440BR (Blue/Red)(1)

Trodat P5460BK (Black)(1)

Trodat P5430BK (Black)(1)

Trodat Replacement Ink Pad USSP4850BR(1)

Trodat P4850BR (Blue/Red)(1)

Bates 9800659 (Black Ink), 9806452 (Uninked Pad)(1)

Trodat P4911BK (Black)(1)

Trodat Replacement Ink Pad USSP4750BR(1)

2000 PLUS 061794 (Black)(1)

NIO 071510; NIO 071513; NIO 071519(1)

2000 PLUS 061797(1)

Colop e-mark 039203 (TriColor)(1)

2000 PLUS 011097 (Red)(1)

2000 PLUS 011096 (Black)(1)

Universal IK60 (Black)(1)

 
Number of Lines

1(4)

2(1)

3(1)

1 to 4(1)

1 to 2(1)

 
Impression Diameter

5/8"(3)

3/4" dia.(3)

1.56"(1)

2" dia.(1)

 
Maximum Characters Per Line

14(1)

18(1)

16(1)

 
Years

10(12)

5(7)

8(4)

6(2)

 
Number of Bands

4(17)

6(3)

8(2)

1(1)

10(1)

 
Custom Order Information

Voucher only with unique code. Visit design.my-nio.com to redeem your code and begin the design process.(1)

 
Type Size(s)

1 1/2(7)

2(3)

E(2)

1/8"(2)

1(2)

1/4"(1)

3/8"(1)

1.5(1)

 
Number of Wheels

4(5)

6(2)

1(1)

 
Ink Types

Pre-Inked; Re-Inkable(46)

Pre-Inked(30)

Self-Inking(28)

Conventional(6)

Inkjet Cartridge(1)

 
 
 

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