SELECT `pinfo`.`sku`,`pinfo`.`vendor`, 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_12` 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 ((`desc_short` like 'stamps' OR `desc_long` like 'stamps' OR `desc_title` like 'stamps' OR `keywords` like 'stamps' OR `category_1` like 'stamps' OR `category_2` like 'stamps' OR `category_3` like 'stamps' OR `category_4` like 'stamps' OR `manufacturer_name` like 'stamps' OR `color` like 'stamps') OR (MATCH(`desc_short`, `desc_long`, `desc_title`, `keywords`, `category_1`, `category_2`, `category_3`, `category_4`, `manufacturer_name`, `color`) AGAINST('+(>stamps>stamps)' IN BOOLEAN MODE) or (`pinfo`.`sku` like '%stamps%' OR `pinfo`.`sku` like '%stamps%' OR (FIND_IN_SET('stamps', REPLACE(`keywords`,' ;', ',')) OR FIND_IN_SET('stamps', REPLACE(`keywords`,'; ', ',')) OR FIND_IN_SET('stamps', REPLACE(`keywords`,';', ','))) ) OR (CASE WHEN `pinfo`.`vendor`=2 THEN `pinfo`.`desc_long` like 'stamps' ELSE `pinfo`.`desc_title` like 'stamps' END))) 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_cost`=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 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

Keyword

Stamps

Refine Search

  GO
Category Filter

Stamps(225)

School Supplies(101)

Stamp Pads(79)

Stamps & Stamp Pads(74)

Labels(21)

Paint(13)

Bottled Inks(11)

Pricemarkers(9)

Craft Bags(4)

Math(3)

Playground Balls(2)

Embossers(2)

Vinyl Numbers & Letters(2)

Art & Craft Kits(2)

Label Maker Supplies(1)

Giant(1)

Holiday/seasonal(1)

Lab Equipment(1)

Self-Inking Stamps(1)

Stamp Trays(1)

Role Play(1)

Brand

COSCO 2000PLUS(54)

Identity Group(45)

ACCUSTAMP2(41)

Universal(38)

PRES-a-ply(21)

Trodat(21)

Xstamper(18)

AbilityOne(16)

MELISSA & DOUG LCI(15)

COSCO(13)

Carter's(11)

ACCUSTAMP(9)

Xstamper ECO-GREEN(7)

Bates(5)

Monarch(5)

Garvey(4)

C.H. Hanson(4)

Stack Stamp(3)

LEE(2)

Seiko(1)

DYMO(1)

Stamp-Ever(1)

SICURIX(1)

Height

11.50(2)

2 7/8"(1)

15.00(1)

19.75(1)

Color(s)

Black(2)

Clear(1)

Width

9.00(2)

2 1/2"(1)

9.50(1)

11.75(1)

Size

0.56 x 1.5(2)

2.25 x 1.75(2)

0.38 x 1.25(1)

0.75 x 1.78(1)

2 3/8" x 4"(1)

#1(1)

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

Packing Type

Bottle w/Brush Cap(1)

Bottle(1)

Ink Color(s)

Red(68)

Black(61)

Blue/Red(44)

Blue(42)

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

Black; Blue; Red; Blue/Red(6)

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

Black; Blue; Green; Red; Purple(2)

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

Green(2)

Purple(1)

Black; Blue; Red(1)

Black/Red(1)

Black, Blue or Red(1)

blue/red(1)

Uninked(1)

Aqua; Fuchsia; Hot Pink(1)

Aqua; Lime Green; Neon Orange(1)

Fuchsia; Hot Pink; Lime Green(1)

Color Family

White(19)

Clear(2)

Country

China(4)

Interpack Quantity Description

30/Sheet, 50 Sheets/Box(2)

30/Sheet, 25 Sheets/Pack(2)

10/Sheet, 50 Sheets/Box(1)

80/Sheet, 25 Sheets/Pack(1)

80/Sheet, 100 Sheets/Pack(1)

2/Sheet, 100 Sheets/Pack(1)

4/Sheet, 100 Sheets/Pack(1)

10/Sheet, 250 Sheets/Box(1)

14/Sheet, 250 Sheets/Box(1)

14/Sheet, 100 Sheets/Box(1)

20/Sheet, 100 Sheets/Box(1)

30/Sheet, 100 Sheets/Box(1)

10/Sheet, 100 Sheets/Box(1)

6/Sheet, 100 Sheets/Box(1)

20/Sheet, 250 Sheets/Box(1)

30/Sheet, 250 Sheets/Box(1)

10/Sheet, 25 Sheets/Pack(1)

Layouts Available

Custom Layout(5)

146(1)

190(1)

324(1)

323(1)

141(1)

203(1)

800(1)

Special Features

Address Labels-For laser printers.(9)

Shipping Labels-For laser printers.(4)

Pre-Inked Micropore-Delivers the sharpest, cleanest details and never needs re-inking.(4)

Model S 360(3)

Pre-Inked Felt-Re-inkable.(3)

Pricemarker Kit-Includes pricemarker, one ink roll, one roll each of white and fluorescent red labels.(2)

Pre-Inked Foam-Re-inkable.(2)

Kit-Includes nine rolls of labels and two ink rollers.(2)

Labeler Only-Includes one roll of labels and one ink roller.(2)

Shipping Labels-For laser and inkjet printers.(2)

Order online or by mail-Receive a pre-inked stamp in red, blue or black ink.(1)

Date Stamping-The date model features a rotating outer ring that allows you to adjust the day of the month, while incorporating a dater in the center that prints the month and year.(1)

Date and Time Stamping-The date/time model features a rotating outer ring that allows you to adjust the time of the day (AM or PM), while incorporating a dater in the center that prints the month, day and year.(1)

8 Digit Numberer(1)

10 Digits(1)

6 Digit Numberer(1)

Full-Sheet Labels-For laser and inkjet printers.(1)

Full-Sheet Labels-For laser printers.(1)

Address Labels-For inkjet printers.(1)

File Folder Labels-For laser printers.(1)

Address Labels-For laser and inkjet printers.(1)

File Folder Labels with Assorted-Color Borders -For laser and inkjet printers.(1)

Un-Inked Felt(1)

Round Pad(1)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor HP Qualified Supplies Partner

© 2020-2021 United Supply Corp, All Rights Reserved