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_36` 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 ('113781')) 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 '%SelfInkingStamps' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('SelfInkingStamps' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+SelfInkingStamps' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"SelfInkingStamps"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"SelfInkingStamps"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"SelfInkingStamps"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"SelfInkingStamps"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+SelfInkingStamps' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='SelfInkingStamps',`category_4` ='SelfInkingStamps') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'SelfInkingStamps,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('SelfInkingStamps', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Self Inking Stamps

Refine Search

  GO
 
Brand

COSCO(31)

Xstamper(24)

Trodat(4)

Consolidated Stamp(4)

stackSTAMP(3)

ACCUSTAMP2(3)

Stamp-Ever(1)

SKILCRAFT(1)

COSCO 2000PLUS(1)

Learning Resources(1)

Sparco(1)

 
Recycled

No(69)

Yes(1)

 
Packaged Quantity

1 Each(69)

30 / Each(1)

 
Limited Warranty

1 Year(1)

 
Weight (Approximate)

8 oz(3)

10.56 oz(3)

12 oz(2)

11.04 oz(1)

6.08 oz(1)

3.04 oz(1)

9.44 oz(1)

4.80 oz(1)

3.20 oz(1)

2.40 oz(1)

1.28 oz(1)

 
Warranty

Manufacturer's limited one-year warranty.(1)

 
Impression

PAID(8)

RECEIVED(8)

FAXED(5)

REC'D(3)

ENT'D(3)

ANS'D(3)

COPY(3)

ORIGINAL(2)

ENTERED(2)

DRAFT(2)

CHARGED(2)

APPROVED(2)

SHIPPED(2)

E-MAILED(2)

CANCELLED(2)

FILE COPY(2)

POSTED(2)

COMPLETED(2)

Thumbs Up(1)

FILED(1)

Great Job(1)

Star(1)

C.O.D.(1)

FILLED(1)

Checkmark(1)

EMAILED(1)

Good Work(1)

Way To Go(1)

A+(1)

Frowning Face(1)

Smiley Face(1)

Great work!(1)

PAST DUE(1)

CONFIDENTIAL(1)

VOID(1)

Completed(1)

Entered(1)

Scanned(1)

Emailed(1)

REVISED(1)

FOR DEPOSIT ONLY(1)

A.M.(1)

P.M.(1)

Needs Improvement(1)

Late(1)

SCANNED(1)

Super!(1)

Needs Work(1)

 
Impression Type

Message Stamp(33)

Message/Date Stamp(13)

Date Stamp(10)

Custom Message/Date Stamp(7)

Number Stamp(3)

Date & Time Stamp(2)

Message/Design Stamp(1)

Custom Message Stamp(1)

 
Impression Color

Red(32)

Blue(30)

Assorted(14)

Black(13)

 
Impression Length

1.63"(30)

1.75"(4)

2.25"(3)

1.81"(3)

1.56"(3)

2.63"(2)

2"(2)

2.50"(1)

2.12"(1)

1.13"(1)

0.63"(1)

0.94"(1)

1.25"(1)

1.87"(1)

 
Number of Impressions

20000(26)

7000(7)

10000(1)

5000(1)

 
Message(s)

AIR MAIL(1)

COPY(1)

VOID(1)

FAXED(1)

 
Manufacturer Part Number

T5558(1)

T55510(1)

T5546(1)

40140(1)

40150(1)

40311(1)

40310(1)

40160(1)

E4756(1)

8802(1)

3523019(1)

LER0678(1)

035606(1)

CS60459(1)

4630(1)

8801(1)

8800(1)

40312(1)

40330(1)

M72(1)

M71(1)

M70(1)

M73(1)

M74(1)

P45(1)

P44(1)

P40(1)

M51(1)

M44(1)

M31(1)

M30(1)

40340(1)

M32(1)

M40(1)

M42(1)

M41(1)

035601(1)

035596(1)

035532(1)

035524(1)

035521(1)

035533(1)

035535(1)

035539(1)

035538(1)

035537(1)

32881(1)

026138(1)

11041(1)

011034(1)

011032(1)

011091(1)

011092(1)

011200(1)

011098(1)

035541(1)

035570(1)

035584(1)

035583(1)

035582(1)

035585(1)

035587(1)

035594(1)

035593(1)

035581(1)

035580(1)

035573(1)

035572(1)

035571(1)

035574(1)

035575(1)

035578(1)

035577(1)

10129(1)

 
Country of Origin

China(39)

United States(21)

Austria(10)

CN(3)

AT(1)

 
Material

Plastic Frame(32)

Rubber Handle(26)

Plastic(12)

Metal(8)

Steel(4)

Plastic Handle(3)

Metal Frame(3)

Rubber Foot(1)

Polymer Plate(1)

ABS Plastic(1)

 
Height

5"(1)

1.5"(1)

 
Width

3"(1)

5.1"(1)

1.5"(1)

 
Depth

1.8"(1)

 
Ink Color(s)

Blue/Red(2)

Red(1)

Blue(1)

 
Impression Width

0.50"(26)

0.94"(4)

1"(4)

1.13"(3)

1.25"(3)

1 5/8"(3)

0.63"(3)

0.88"(2)

1.81"(2)

1.50"(1)

1.19"(1)

1.38"(1)

1.37"(1)

0.38"(1)

0.16"(1)

1 3/4"(1)

0.93"(1)

 
Ink Types

Pre-Inked; Re-Inkable(3)

Self-Inking(1)

 
Stamp Type

Message(3)

Message Dater(1)

 
Frame/Housing Material(s)

Plastic(3)

ABS Plastic(1)

 
Impression Height

1/2"(3)

1"(1)

 
Impression Diameter

0.63"(1)

1.63"(1)

 
Number of Lines

1(1)

 
Replacement Ink

ACCUSTAMP 090682 (Blue)(1)

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

2000 PLUS 061961 (Blue/Red)(1)

 
Years

6(1)

 
 
 

© 2018-2019 Rhino Office Products, All Rights Reserved