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_id` IN ('283')) 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 '%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(32)

2000 PLUS(23)

Trodat(12)

Identity Group(12)

ACCUSTAMP(10)

Bates(6)

Xstamper ECO-GREEN(6)

Stack Stamp(5)

COSCO(2)

Stamp-Ever(1)

ClassiX by Xstamper(1)

Xstamper(1)

 
Quantity

1 each(107)

 
Size

5/8" x 1 13/16"(2)

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

 
Ink Color(s)

Red(46)

Blue/Red(32)

Blue(31)

Black(24)

Hot Pink; Fuchsia; Aqua(2)

Aqua; Fuchsia; Hot Pink(1)

Aqua; Lime Green; Neon Orange(1)

Fuchsia; Hot Pink; Lime Green(1)

 
Manufacturer Part Number

9802060(1)

10076(1)

10065(1)

10067(1)

10069(1)

10070(1)

10071(1)

10075(1)

10077(1)

10062(1)

10078(1)

10080(1)

10081(1)

10104(1)

10105(1)

10136(1)

10156(1)

10063(1)

10060(1)

4630(1)

10046(1)

098372(1)

098373(1)

098374(1)

10043(1)

10044(1)

10045(1)

10047(1)

10058(1)

10048(1)

10049(1)

10052(1)

10053(1)

10054(1)

10056(1)

10057(1)

10157(1)

5915(1)

098370(1)

T55510(1)

T2754(1)

T2910(1)

T5030(1)

T5117(1)

T5444(1)

T5546(1)

T5558(1)

RN028(1)

40301(1)

40311(1)

52111(1)

52112(1)

52113(1)

66210(1)

66211(1)

RN034(1)

RN026(1)

5916(1)

E4754(1)

6631(1)

6632(1)

8800(1)

8801(1)

8802(1)

E4752(1)

E4817(1)

RN016(1)

E4820(1)

E4822(1)

E4850L(1)

RD000(1)

RD010(1)

RD015(1)

RD020(1)

098371(1)

098369(1)

9806450(1)

035532(1)

030726(1)

034590(1)

035521(1)

035523(1)

035524(1)

035525(1)

035533(1)

026304(1)

035534(1)

035535(1)

035536(1)

035537(1)

035538(1)

035539(1)

035540(1)

030725(1)

026138(1)

035542(1)

011032(1)

9820311(1)

9820315(1)

9820317(1)

9820325(1)

010129(1)

010180(1)

011033(1)

012731(1)

011034(1)

011090(1)

011091(1)

011092(1)

011093(1)

011098(1)

011200(1)

035541(1)

035543(1)

098368(1)

035655(1)

035596(1)

035601(1)

035605(1)

035606(1)

035653(1)

035654(1)

035656(1)

035593(1)

035657(1)

035658(1)

035659(1)

035661(1)

039307(1)

065005(1)

098367(1)

035594(1)

035590(1)

035544(1)

035577(1)

035570(1)

035571(1)

035572(1)

035573(1)

035574(1)

035575(1)

035576(1)

035578(1)

035587(1)

035580(1)

035581(1)

035582(1)

035583(1)

035584(1)

035585(1)

035586(1)

66213(1)

 
Country of Origin

CN(75)

US(38)

AT(30)

TW(8)

DE(1)

 
Impression Width

1 5/8"(48)

1 11/16"(26)

1 1/2"(9)

1"(7)

1 3/4"(5)

1 13/16"(5)

1 1/4"(3)

2 1/4"(3)

2 1/8"(3)

2"(2)

5/32"(1)

1 3/8"(1)

3/4"(1)

2 1/2"(1)

1 7/8"(1)

 
Message(s)

FAXED(9)

RECEIVED(8)

COPY(8)

PAID(7)

ENTERED(6)

POSTED(4)

CONFIDENTIAL(4)

VOID(4)

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

FILE(3)

APPROVED(3)

FILE COPY(3)

FOR DEPOSIT ONLY(3)

DRAFT(3)

ORIGINAL(3)

EMAILED(3)

PAST DUE(3)

SCANNED(3)

DATE(3)

COMPLETED(3)

CHECK MARK (ICON)(2)

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

MAILED(2)

Obscures Data(2)

DATE; RECEIVED(2)

STAR (ICON)(2)

SMILEY FACE (ICON)(2)

12 Common Business Phrases(1)

RECEIVED; DATE; TIME(1)

DATE plus 11 Common Business Phrases(1)

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

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

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

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

APPROVED; ENTERED; PAID(1)

COPY; DRAFT; ORIGINAL(1)

EMAILED; FAXED; RECEIVED(1)

Brilliant Work; Good Effort; PLEASE CORRECT(1)

GREAT JOB; Needs Improvement; Parent Signature ______(1)

DATE plus 12 Common Business Phrases(1)

RUSH!(1)

PAID ONLINE(1)

URGENT(1)

E-MAILED(1)

CANCELLED(1)

RECEIVED; FAXED; PAID; ENTERED(1)

INITIAL HERE(1)

ARROW (ICON)(1)

DATE; PAID(1)

AIR MAIL(1)

RUSH(1)

REVISED(1)

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

COMPLETED; EMAILED; ENTERED; SCANNED(1)

{clear}(1)

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

 
Choking Hazard

Y(1)

 
Stamp Type

Message(97)

Message Dater(21)

Numberer(15)

Dater(13)

Custom Message(3)

Symbol(2)

Custom Dater(1)

 
Frame/Housing Material(s)

Plastic(60)

ABS Plastic(38)

Metal(8)

Steel(8)

Metal;Plastic(8)

 
Impression Height

1/2"(41)

9/16"(34)

3/8"(9)

1"(7)

5/8"(7)

5/32"(3)

1 5/16"(3)

3/16"(2)

15/16"(2)

1 13/16"(2)

3/4"(2)

1/8"(1)

1/4"(1)

5/16"(1)

1 5/8"(1)

1 1/8"(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)

Bates 9808196 (Black Pad), 9808003 (Uninked Pad)(2)

COSCO 065103 (Black), 065105 (Blue), 065104 (Red), 065100 (Uninked Pad)(1)

ACCUSTAMP 090684 (Black)(1)

2000 PLUS 011097 (Red)(1)

2000 PLUS 011096 (Black)(1)

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

Universal IK60 (Black)(1)

2000 PLUS 061794 (Black)(1)

Trodat P4911BK (Black)(1)

Trodat P4911RE (Red)(1)

Trodat P4850BR (Blue/Red)(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), 9808196 (Black Pad), 9808003 (Uninked Pad)(1)

Xstamper 42116 (Blue/Red)(1)

 
Number of Lines

1(6)

2(1)

1 to 4(1)

1 to 2(1)

3(1)

 
Impression Diameter

5/8"(11)

3/4" dia.(6)

2" dia.(1)

 
Maximum Characters Per Line

18(1)

16(1)

 
Years

10(14)

6(7)

8(6)

4(1)

5(1)

11(1)

 
Number of Bands

4(19)

6(9)

8(2)

7(1)

1(1)

10(1)

3(1)

 
Type Size(s)

1 1/2(7)

E(5)

2(5)

1(4)

A(1)

G(1)

0(1)

3(1)

 
Number of Wheels

6(5)

4(3)

7(1)

1(1)

 
Ink Types

Pre-Inked; Re-Inkable(72)

Pre-Inked(38)

Self-Inking(25)

Conventional(12)

 
 
 

© 2019-2020 Onestop, Inc., All Rights Reserved