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

COSCO 2000PLUS(21)

Trodat(14)

ACCUSTAMP(9)

Identity Group(6)

C.H. Hanson(4)

Xstamper ECO-GREEN(4)

Stack Stamp(3)

Bates(2)

COSCO(2)

Stamp-Ever(1)

 
Size

0.38 x 1.25(1)

 
Ink Color(s)

Red(43)

Blue/Red(32)

Blue(25)

Black(18)

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)

10048(1)

10071(1)

10070(1)

10069(1)

10067(1)

10065(1)

10063(1)

10062(1)

10060(1)

10058(1)

10056(1)

10054(1)

10052(1)

10049(1)

10047(1)

10080(1)

10046(1)

10045(1)

10044(1)

10043(1)

098373(1)

098372(1)

098371(1)

098370(1)

098369(1)

098368(1)

098367(1)

065005(1)

039605(1)

035661(1)

10075(1)

10081(1)

035658(1)

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

RD015(1)

E4853L(1)

E4822(1)

10104(1)

E4820(1)

E4817(1)

E4756(1)

E4754(1)

E4752(1)

8802(1)

8801(1)

8800(1)

5916(1)

5915(1)

4630(1)

10157(1)

10156(1)

10136(1)

035659(1)

035656(1)

9820315(1)

012731(1)

035536(1)

035535(1)

035534(1)

035533(1)

035532(1)

035525(1)

035524(1)

035523(1)

035521(1)

034590(1)

030726(1)

030725(1)

026138(1)

011200(1)

035538(1)

011098(1)

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

035537(1)

035539(1)

035655(1)

035582(1)

035654(1)

035653(1)

035606(1)

035605(1)

035601(1)

035596(1)

035594(1)

035593(1)

035590(1)

035587(1)

035586(1)

035585(1)

035584(1)

035583(1)

035581(1)

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

035542(1)

035541(1)

66211(1)

 
Country of Origin

CN(65)

US(34)

AT(32)

TW(2)

 
Suggested Use

Clothing(1)

 
Impression Width

1.63"(47)

1.69"(23)

1 1/2"(8)

1"(7)

1.75"(4)

1.81"(3)

2.13"(2)

2 1/4"(2)

2"(2)

1 5/8"(1)

2.25"(1)

1.25"(1)

2.75"(1)

1.88"(1)

1 3/4"(1)

2 1/2"(1)

3/4"(1)

1 3/8"(1)

1 1/4"(1)

0.16"(1)

1.5"(1)

 
Message(s)

COPY(7)

PAID(7)

RECEIVED(6)

FAXED(5)

ENTERED(5)

VOID(4)

POSTED(4)

ORIGINAL(3)

APPROVED(3)

FILE COPY(3)

FOR DEPOSIT ONLY(3)

CONFIDENTIAL(3)

EMAILED(3)

DRAFT(3)

COMPLETED(3)

SCANNED(3)

DATE(3)

PAST DUE(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 12 Common Business Phrases(1)

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

RECEIVED; DATE; TIME(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)

DATE plus 11 Common Business Phrases(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)

Customizable Message(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)

Message Dater(22)

Dater(8)

Numberer(7)

Hand Stamp Set(4)

Symbol(2)

Custom Message(2)

Custom Dater(1)

 
Frame/Housing Material(s)

Plastic(60)

ABS Plastic(31)

Metal;Plastic(8)

Steel(6)

Metal(2)

 
Impression Height

0.5"(41)

0.56"(24)

1"(7)

9/16"(7)

0.38"(6)

3/8"(3)

0.63"(3)

0.75"(3)

0.16"(2)

1.31"(2)

0.94"(2)

1.81"(2)

1/8"(1)

15/16"(1)

5/16"(1)

1/4"(1)

3/16"(1)

5/8"(1)

1.63"(1)

0.25"(1)

 
Replacement Ink

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

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)

ACCU•STAMP 090684 (Black)(1)

2000 PLUS 011097 (Red)(1)

2000 PLUS 011096 (Black)(1)

2000 PLUS 061797(1)

Universal IK60 (Black)(1)

2000 PLUS 061794 (Black)(1)

Trodat Replacement Ink Pad USSP4750BR(1)

Trodat P4911BK (Black)(1)

Trodat P4911RE (Red)(1)

Trodat P4850BR (Blue/Red)(1)

Trodat Replacement Ink Pad USSP4850BR(1)

Trodat P5430BK (Black)(1)

Trodat P5460BK (Black)(1)

Trodat P5440BR (Blue/Red)(1)

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

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

 
Number of Lines

1(6)

2(1)

3(1)

1 to 4(1)

1 to 2(1)

 
Impression Diameter

5/8"(10)

0.75" dia.(3)

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)

 
Type Size(s)

1.5(4)

2(3)

E(2)

1/8"(2)

1(2)

1.5"(2)

1 1/2(2)

1/4"(1)

3/8"(1)

 
Number of Wheels

4(5)

6(2)

1(1)

 
Ink Types

Pre-Inked; Re-Inkable(62)

Pre-Inked(31)

Self-Inking(28)

Conventional(6)

 
 
 

© 2020-2021 Dependable Office Supply, All Rights Reserved