0

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_1` LIKE 'Office Supplies') AND (`category_2` LIKE 'Stamps & Stamp Supplies') AND `pinfo`.`is_recycled` LIKE 'Y' 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 '%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(35)

Trodat(23)

Xstamper(12)

COSCO 2000PLUS(11)

Identity Group(4)

Xstamper ECO-GREEN(3)

 
Size

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

2 3/8" x 4"(1)

 
Ink Color(s)

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

Red(18)

Blue(13)

Black; Blue; Red; Blue/Red(11)

Black(10)

Blue/Red(6)

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

Black/Red(1)

 
Manufacturer Part Number

T46140(1)

E4850L(1)

E4850(1)

E4822(1)

T4727(1)

T4729(1)

T5430(1)

T5415(1)

T5117(1)

T5030(1)

E4820(1)

E4817(1)

6193(1)

5916(1)

5915(1)

10157(1)

E4750(1)

E4750N(1)

E4756(1)

E4754(1)

E4752(1)

T5440(1)

T5444(1)

1XPN22(1)

1XPN18(1)

1XPN16(1)

1XPN14(1)

1XPN26(1)

1XPN28(1)

1XPN42(1)

1XPN40(1)

1XPN32(1)

1XPN13(1)

1XPN12(1)

T55510(1)

T5546(1)

T5470(1)

T5460(1)

T5558(1)

1XDN82(1)

1XPN11(1)

1XPN10(1)

1XPN05(1)

10156(1)

10136(1)

10028GN(1)

10027GN(1)

10026GN(1)

10025GN(1)

10029GN(1)

10030GN(1)

10033GN(1)

10032GN(1)

10031GN(1)

10024GN(1)

1SI40PGL(1)

098370(1)

098369(1)

098368(1)

098367(1)

098371(1)

098372(1)

1SI20PGL(1)

098374(1)

098373(1)

10034GN(1)

10035GN(1)

10065(1)

10063(1)

10062(1)

10060(1)

10067(1)

10069(1)

10104(1)

10071(1)

10070(1)

10058(1)

10056(1)

10046(1)

10045(1)

10044(1)

10043(1)

10047(1)

10048(1)

10054(1)

10052(1)

10049(1)

039307(1)

 
Country of Origin

US(61)

AT(25)

CN(2)

 
Suggested Use

Stamping Return Addresses On Envelopes Or Stationery(3)

Return Address(2)

Initializing; Inspection Professionals; Notary(1)

Bank Tellers; Cashiers; Inspection Stamps(1)

Business Addresses; Large Endorsement Stamps; Logos(1)

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

Bank Endorsements; Logos; Signatures(1)

 
Impression Width

1 11/16"(23)

1 5/8"(11)

1 1/2"(8)

2"(6)

1"(4)

2 3/8"(4)

2 1/4"(3)

1 15/16"(2)

3 3/4"(2)

1 1/4"(2)

1 3/4"(2)

2 1/2"(2)

2 15/16"(1)

2 7/16"(1)

2 3/4"(1)

3 5/16"(1)

5/8"(1)

3 7/8"(1)

1/2"(1)

2 1/8"(1)

3 1/2"(1)

3 1/4"(1)

1 7/8"(1)

2 5/8"(1)

3"(1)

13/16"(1)

2 5/16"(1)

 
Message(s)

COPY(3)

CONFIDENTIAL(2)

DATE(2)

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

RECEIVED(2)

VOID(2)

POSTED(2)

ENTERED(2)

PAID(2)

FAXED(2)

SCANNED(1)

PAID ONLINE(1)

DATE; RECEIVED(1)

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

12 Common Business Phrases(1)

Obscures Data(1)

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

DATE plus 12 Common Business Phrases(1)

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

ORIGINAL(1)

DRAFT(1)

CANCELLED(1)

COMPLETED(1)

APPROVED(1)

FOR DEPOSIT ONLY(1)

E-MAILED(1)

URGENT(1)

RUSH!(1)

PAST DUE(1)

FILE COPY(1)

 
Stamp Type

Message(32)

Custom Message(30)

Custom Dater(12)

Dater(5)

Message Dater(4)

Numberer(3)

Custom Numberer(1)

 
Frame/Housing Material(s)

ABS Plastic(36)

Plastic(29)

Metal;Plastic(11)

 
Impression Height

9/16"(32)

1"(11)

3/8"(8)

3/4"(5)

1/2"(4)

1 5/8"(3)

1 3/8"(3)

5/8"(2)

11/16"(2)

2 3/8"(1)

1 1/2"(1)

2 1/2"(1)

1 15/16"(1)

7/8"(1)

1/8"(1)

3/16"(1)

2 3/16"(1)

1 7/16"(1)

1 3/4"(1)

2 1/4"(1)

1 1/8"(1)

1 3/16"(1)

1 9/16"(1)

 
Stamp Pads Type

Inked Felt(1)

 
Replacement Ink

Trodat P4750BR (Blue/Red)(2)

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

Trodat P5415BK (Black), P5415BL (Blue), P5415RD (Red), P5415BR (Blue/Red)(1)

Trodat P5430BK (Black), P5430BL (Blue), P5430RD (Red), P5430BR (Blue/Red)(1)

Trodat P5460BK (Black)(1)

Trodat P5440BK (Black), P5440BL (Blue), P5440RD (Red), P5440BR (Blue/Red)(1)

Trodat P5460BK (Black), P5460BL (Blue), P5460RD (Red), P5460BR (Blue/Red)(1)

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

Trodat P5470BK (Black), P5470BL (Blue), P5470RD (Red), P5470BR (Blue/Red)(1)

Trodat P5430BK (Black)(1)

Trodat P5440BR (Blue/Red)(1)

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

Trodat P4911BK (Black)(1)

Trodat Replacement Ink Pad USSP4750BR(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 P4850BK (Black), P4850BL (Blue), P4850RD (Red), P4850BR (Blue/Red)(1)

Universal IK60 (Black)(1)

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

Trodat P4850BR (Blue/Red)(1)

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

 
Number of Lines

1(7)

1 to 3(7)

5(6)

4(5)

1 to 2(3)

7(3)

1 to 7(2)

3(1)

19(1)

11(1)

1 to 4(1)

13(1)

9(1)

6(1)

1 to 5(1)

1 to 9(1)

1 to 11(1)

1 to 13(1)

 
Impression Diameter

1 3/4" dia.(2)

5/8" dia.(1)

 
Pad Size (Width)

4"(1)

 
Pad Size (Depth)

2 3/8"(1)

 
Maximum Characters Per Line

34(4)

22(4)

28(3)

8(3)

19(3)

27(2)

24(2)

18(2)

42(2)

26(2)

47(1)

55(1)

33(1)

41(1)

39(1)

23(1)

30(1)

16(1)

29(1)

31(1)

25(1)

36(1)

20(1)

38(1)

9(1)

 
Years

10(18)

 
Number of Bands

4(7)

8(1)

10(1)

6(1)

1(1)

 
Custom Order Information

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

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

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

 
Type Size(s)

2(2)

1 1/2(2)

1(1)

 
Number of Wheels

1(1)

4(1)

 
Ink Types

Pre-Inked; Re-Inkable(34)

Pre-Inked(27)

Self-Inking(26)

 
Ink Pad Type

Conventional Pad(1)