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 ('60281')) 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(41)

Universal(36)

COSCO 2000PLUS(35)

Trodat(14)

ACCUSTAMP(9)

Identity Group(6)

C.H. Hanson(4)

Xstamper ECO-GREEN(4)

Stack Stamp(3)

Xstamper(3)

Bates(2)

COSCO(2)

Stamp-Ever(1)

 
Size

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

 
Ink Color(s)

Red(43)

Blue/Red(32)

Blue(25)

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

Black(18)

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

blue/red(1)

Aqua; Fuchsia; Hot Pink(1)

Aqua; Lime Green; Neon Orange(1)

Fuchsia; Hot Pink; Lime Green(1)

 
Manufacturer Part Number

9806450(1)

10052(1)

10043(1)

10044(1)

10045(1)

10046(1)

10047(1)

10048(1)

10049(1)

10054(1)

10033GN(1)

10056(1)

10058(1)

10060(1)

10062(1)

10063(1)

10065(1)

10067(1)

10034GN(1)

10032GN(1)

10070(1)

1SI40PGL(1)

1PIHD50(1)

1SD2360(1)

1SI10P(1)

1SI15P(1)

1SI20PGL(1)

1SI25P(1)

1SI40P(1)

1SI50P(1)

10031GN(1)

1SI60P(1)

10024GN(1)

10025GN(1)

10026GN(1)

10027GN(1)

10028GN(1)

10030GN(1)

10069(1)

10071(1)

1PIHD40(1)

T5546(1)

RD015(1)

RN028(1)

T2754(1)

T2910(1)

T5030(1)

T5117(1)

T5444(1)

T55510(1)

E4850L(1)

T5558(1)

1XPN10(1)

1XPN13(1)

1XPN14(1)

52111(1)

52112(1)

66210(1)

E4853L(1)

E4822(1)

10075(1)

5915(1)

10080(1)

10081(1)

10104(1)

10136(1)

10156(1)

10157(1)

4630(1)

5916(1)

E4820(1)

8800(1)

8801(1)

8802(1)

E4752(1)

E4754(1)

E4756(1)

E4817(1)

1PIHD45(1)

1PIHD30(1)

9820315(1)

035535(1)

035521(1)

035523(1)

035524(1)

035525(1)

035532(1)

035533(1)

035534(1)

035536(1)

030726(1)

035537(1)

035538(1)

035539(1)

035540(1)

035541(1)

035542(1)

035543(1)

034590(1)

030725(1)

035570(1)

011033(1)

20541(1)

20581(1)

20601(1)

20624(1)

010129(1)

010180(1)

011032(1)

011034(1)

026138(1)

011090(1)

011091(1)

011092(1)

011093(1)

011098(1)

011200(1)

012731(1)

035544(1)

035571(1)

1PIHD20(1)

039605(1)

035653(1)

035654(1)

035655(1)

035656(1)

035658(1)

035659(1)

035661(1)

065005(1)

035605(1)

098367(1)

098368(1)

098369(1)

098370(1)

098371(1)

098372(1)

098373(1)

035606(1)

035601(1)

035572(1)

035581(1)

035573(1)

035574(1)

035575(1)

035576(1)

035577(1)

035578(1)

035580(1)

035582(1)

035596(1)

035583(1)

035584(1)

035585(1)

035586(1)

035587(1)

035590(1)

035593(1)

035594(1)

66211(1)

 
Country of Origin

CN(66)

US(60)

AT(32)

TW(2)

 
Suggested Use

Office; Personal(5)

Clothing(1)

Return Address(1)

Stamping Return Addresses On Envelopes Or Stationery(1)

 
Impression Width

1 5/8"(49)

1 11/16"(23)

1 1/2"(10)

1"(8)

1 3/4"(6)

2"(5)

2 1/4"(3)

1 13/16"(3)

2 1/2"(3)

2 3/4"(2)

2 3/8"(2)

2 5/8"(2)

2 1/8"(2)

1 1/4"(2)

1 1/8"(1)

3"(1)

5/32"(1)

1 7/8"(1)

1 3/8"(1)

3 1/4"(1)

3 3/4"(1)

3 1/2"(1)

2 11/16"(1)

3/4"(1)

2 15/16"(1)

2 5/16"(1)

13/16"(1)

2 3/16"(1)

2 7/8"(1)

3 3/16"(1)

1/2"(1)

 
Message(s)

COPY(7)

PAID(7)

RECEIVED(6)

Customizable Message(6)

ENTERED(5)

FAXED(5)

POSTED(4)

VOID(4)

CONFIDENTIAL(3)

EMAILED(3)

APPROVED(3)

FILE COPY(3)

FOR DEPOSIT ONLY(3)

COMPLETED(3)

DRAFT(3)

PAST DUE(3)

SCANNED(3)

DATE(3)

ORIGINAL(3)

CHECK MARK (ICON)(2)

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

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

DATE; RECEIVED(2)

Obscures Data(2)

STAR (ICON)(2)

SMILEY FACE (ICON)(2)

FILE(2)

PAID ONLINE(1)

EMAILED; FAXED; RECEIVED(1)

COPY; DRAFT; ORIGINAL(1)

APPROVED; ENTERED; PAID(1)

12 Common Business Phrases(1)

DATE plus 11 Common Business Phrases(1)

RECEIVED; DATE; TIME(1)

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

DATE plus 12 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)

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

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

URGENT(1)

RUSH!(1)

E-MAILED(1)

CANCELLED(1)

RECEIVED; FAXED; PAID; ENTERED(1)

INITIAL HERE(1)

ARROW (ICON)(1)

AIR MAIL(1)

RUSH(1)

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

MAILED(1)

COMPLETED; EMAILED; ENTERED; SCANNED(1)

DATE; PAID(1)

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

REVISED(1)

 
Choking Hazard

Y(1)

 
Stamp Type

Message(87)

Custom Message(28)

Message Dater(18)

Dater(12)

Numberer(7)

Hand Stamp Set(4)

Symbol(2)

Custom Dater(2)

 
Frame/Housing Material(s)

Plastic(83)

ABS Plastic(34)

Metal;Plastic(8)

Steel(6)

Metal(2)

 
Impression Height

1/2"(44)

9/16"(34)

3/8"(10)

1"(10)

3/4"(6)

5/8"(5)

15/16"(3)

1 3/8"(3)

1/4"(2)

5/32"(2)

1 5/16"(2)

1 13/16"(2)

5/16"(2)

7/8"(1)

1/8"(1)

1 11/16"(1)

11/16"(1)

1 7/16"(1)

13/16"(1)

2 3/16"(1)

1 1/16"(1)

3/16"(1)

1 3/4"(1)

1 5/8"(1)

1 3/16"(1)

 
Replacement Ink

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

ACCUSTAMP 090683 (Red)(12)

ACCUSTAMP 090682 (Blue)(8)

2000PLUS HD Ink(5)

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)

2000 PLUS 061797(1)

ACCU•STAMP 090684 (Black)(1)

2000 PLUS 011097 (Red)(1)

2000 PLUS 011096 (Black)(1)

Universal IK60 (Black)(1)

 
Number of Lines

1(6)

4(5)

5(5)

3(3)

7(3)

9(2)

6(2)

1 to 3(2)

2(1)

1 to 9(1)

1 to 4(1)

1 to 11(1)

8(1)

1 to 7(1)

1 to 5(1)

11(1)

1 to 2(1)

 
Impression Diameter

5/8"(10)

3/4" dia.(3)

2" dia.(1)

 
Maximum Characters Per Line

38(4)

28(3)

14(2)

42(2)

34(2)

19(2)

31(2)

23(2)

20(1)

41(1)

21(1)

45(1)

29(1)

25(1)

36(1)

32(1)

26(1)

18(1)

16(1)

 
Years

10(12)

5(8)

8(4)

6(2)

 
Number of Bands

4(17)

6(3)

8(2)

1(1)

10(1)

 
Custom Order Information

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: SHN05, Type Style, Red, Second Notice)(3)

 
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(75)

Self-Inking(37)

Pre-Inked(36)

Conventional(6)

 
 
 

© 2020-2021 Dependable Office Supply, All Rights Reserved