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

Currently Filtered by

Category

Stamps And Stamp Supplies

Refine Search

  GO
 
Brand

Universal(38)

COSCO 2000PLUS(14)

Xstamper(13)

Trodat(7)

Monarch(5)

C.H. Hanson(4)

Stack Stamp(3)

Xstamper ECO-GREEN(3)

Bates(2)

LEE(2)

Identity Group(2)

SICURIX(1)

 
Color(s)

Black(2)

 
Size

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

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

 
Ink Color(s)

Black; Blue; Green; Red; Violet(32)

Red(16)

Blue(10)

Black(5)

Black; Blue; Green; Non-Metallic Gold; Orange; Red; Violet(5)

Black; Blue; Red; Blue/Red(5)

Black; Blue; Green; Red; Purple(2)

Light Green; Black; Blue; Green; Red; Brown; Light Blue; Orange; Pink; Purple; Yellow(2)

Aqua; Fuchsia; Hot Pink(1)

Aqua; Lime Green; Neon Orange(1)

Fuchsia; Hot Pink; Lime Green(1)

Black; Blue; Red(1)

 
Manufacturer Part Number

9806452(1)

10080(1)

8802(1)

8801(1)

8800(1)

10157(1)

10156(1)

10136(1)

10104(1)

10081(1)

10075(1)

E4750N(1)

10071(1)

10070(1)

10069(1)

10067(1)

10065(1)

10063(1)

10062(1)

10060(1)

10058(1)

E4750(1)

E4822(1)

10054(1)

1XPN11(1)

N68(1)

1XPN42(1)

1XPN40(1)

1XPN32(1)

1XPN18(1)

1XPN16(1)

1XPN14(1)

1XPN13(1)

1XPN12(1)

1XPN10(1)

T46140(1)

1XPN05(1)

1XDN82(1)

1XDN78(1)

1XDN77(1)

T95114(1)

T95113(1)

T5510N(1)

T4729(1)

T4727(1)

10056(1)

10052(1)

9808196(1)

1SD2360(1)

03027(1)

1SI60P(1)

1SI50P(1)

1SI40PGL(1)

1SI40P(1)

1SI20PGL(1)

1SI20P(1)

1SI15P(1)

1SI10P(1)

1PIHD50(1)

925072(1)

1PIHD45(1)

1PIHD40(1)

1PIHD30(1)

1PIHD20(1)

20624(1)

20601(1)

20581(1)

20541(1)

38010(1)

03127(1)

925073(1)

10049(1)

10032GN(1)

10048(1)

10047(1)

10046(1)

10045(1)

10044(1)

10043(1)

10035GN(1)

10034GN(1)

10033GN(1)

10031GN(1)

925082(1)

10030GN(1)

10029GN(1)

10028GN(1)

10027GN(1)

10026GN(1)

10025GN(1)

10024GN(1)

925201A(1)

925083(1)

N99(1)

 
Country of Origin

US(94)

 
Suggested Use

Office; Personal(5)

Return Address(2)

Stamping Return Addresses On Envelopes Or Stationery(2)

Date/Received Stamping(1)

Date/Time Stamping(1)

Larger Stamp For Extra-Long Messages Or Addresses(1)

Bank Endorsements; Logos; Signatures(1)

Business Addresses; Large Endorsement Stamps; Logos(1)

Initializing; Inspection Professionals; Notary(1)

 
Impression Width

1 11/16"(23)

2"(6)

2 3/8"(3)

1 5/8"(3)

1 13/16"(3)

1 3/4"(2)

2 5/16"(2)

2 1/2"(2)

2 3/4"(2)

1 15/16"(2)

1/2"(2)

3 3/4"(2)

2 5/8"(2)

1 1/4"(1)

2 1/4"(1)

2 1/8"(1)

2 7/16"(1)

3 1/4"(1)

1 1/2"(1)

3"(1)

3 1/2"(1)

2 15/16"(1)

13/16"(1)

2 3/16"(1)

2 11/16"(1)

1"(1)

1 1/8"(1)

3 3/16"(1)

5/8"(1)

 
Message(s)

Customizable Message(5)

COPY(2)

RUSH!(1)

APPROVED; ENTERED; PAID(1)

COPY; DRAFT; ORIGINAL(1)

EMAILED; FAXED; RECEIVED(1)

SCANNED(1)

PAID ONLINE(1)

Obscures Data(1)

FILE COPY(1)

STAR (ICON)(1)

SMILEY FACE (ICON)(1)

CHECK MARK (ICON)(1)

VOID(1)

URGENT(1)

RECEIVED(1)

APPROVED(1)

POSTED(1)

PAST DUE(1)

PAID(1)

ORIGINAL(1)

E-MAILED(1)

FOR DEPOSIT ONLY(1)

FAXED(1)

ENTERED(1)

DRAFT(1)

CONFIDENTIAL(1)

CANCELLED(1)

COMPLETED(1)

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

 
Stamp Type

Custom Message(37)

Message(30)

Custom Dater(8)

Hand Stamp Set(4)

Custom Numberer(2)

 
Frame/Housing Material(s)

ABS Plastic(39)

Plastic(34)

Steel(4)

Metal;Plastic(1)

 
Impression Height

9/16"(25)

1"(8)

1 3/8"(5)

5/8"(4)

1/2"(4)

3/4"(3)

7/8"(2)

1 3/16"(2)

3/8"(2)

11/16"(2)

2 1/4"(1)

1 1/2"(1)

1/8"(1)

1 5/16"(1)

1 5/8"(1)

2 3/16"(1)

1 3/4"(1)

1 1/16"(1)

13/16"(1)

1 7/16"(1)

5/16"(1)

1 11/16"(1)

2 3/8"(1)

 
Model

1131(3)

1136(2)

 
Stamp Pads Type

Inked Fingerprint(3)

Inked Replacement(2)

Uninked Replacement(1)

 
Replacement Ink

2000PLUS HD Ink(5)

Xstamper 062050(2)

Universal IK60 (Black)(1)

Trodat P4750BK (Black), P4750BL Blue, P4750RD (Red), P4750BR (Blue/Red)(1)

Trodat P4750BK (Black), P4750BL (Blue), P4750RD (Red), P4750BR (Blue/Red)(1)

Trodat P4911RE (Red)(1)

Trodat P46104BK (Black), P46104BL (Blue), P46104RD (Red), P46104BR (Blue/Red)(1)

Trodat P4727BK (Black), P4727BL (Blue), P4727RD (Red), P4727BR (Blue/Red)(1)

Trodat P4729BK (Black), P4727BL (Blue), P4729RD (Red), P4729BR (Blue/Red)(1)

Trodat P5510NBK (Black), P5510NBL (Blue), P5510NRD (Red)(1)

 
Number of Lines

4(8)

1(8)

5(7)

3(6)

7(5)

1 to 3(5)

9(2)

6(2)

11(2)

2(2)

1 to 7(2)

8(1)

1 to 5(1)

1 to 9(1)

1 to 11(1)

1 to 13(1)

1 to 2(1)

 
Impression Diameter

3/4" dia.(3)

1 3/4" dia.(3)

1 5/8" dia.(1)

5/8" dia.(1)

 
Pad Size (Width)

2 1/4"(2)

1 1/2"(1)

 
Pad Size (Depth)

1 3/4"(2)

 
Maximum Characters Per Line

34(4)

38(4)

28(4)

19(4)

22(3)

42(3)

23(3)

26(2)

15(2)

31(2)

8(2)

27(2)

26;18;7(1)

30(1)

24(1)

33(1)

21(1)

25(1)

36(1)

29(1)

20(1)

14(1)

45(1)

32(1)

39(1)

 
Years

10(4)

5(1)

6(1)

5 (+1 overlap year)(1)

 
Number of Characters

8(3)

16(2)

 
Number of Bands

1(1)

2(1)

4(1)

 
Custom Order Information

To Order: Specify Stock No., Type Style, Ink Color, Text;(For example: SHN05, Type Style, Red, Second Notice)(11)

To Order: Specify Stock No., Text, Ink Color, Font, Style, Layout, Quantity(9)

To Order: Specify Stock No., Type Style, Ink Color, Text;(For example: USST5510N, Type Style, Red, Second Notice)(6)

 
Type Size(s)

1/8"(2)

1/4"(1)

3/8"(1)

1(1)

 
Number of Wheels

1(1)

 
Label Height

7/16"(3)

5/8"(2)

 
Label Width

7/8"(5)

 
Ink Types

Pre-Inked(33)

Pre-Inked; Re-Inkable(27)

Self-Inking(16)

Pre-Inked; Self-Inking(1)

 
Refill(s) For

GBC 9806440, 9806445, 9806452(1)

GBC 9820311 Series, 9802060(1)

Xstamper N26(1)

 
Ink Pad Type

Cartridge(3)

Conventional Pad(3)

 
Characters Per Line

8(5)

 
Shape/Size

Round(1)

Rectangular(1)

 
 
 

© 2020-2021 Desert West Office Supply, All Rights Reserved