Recycle product Made in USA
 
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 `pinfo`.`sku` IN (SELECT `sku` FROM `dealer_special` `dsp` WHERE `dsp`.`expiration_date` >= CURDATE() AND (`dsp`.`status`='active' OR `dsp`.`status`='discontinued') ORDER BY `dsp`.`pick_order`) 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 '%' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('""' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('""' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('""' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('""' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='',`category_4` ='') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE ',%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Specials Items

Refine Search

  GO
 
Category Filter

Cleaners & Detergents(15)

Shredders(11)

Paper Pads/Note Pads(9)

Markers(8)

Cover Stock(7)

Cups(5)

Back Supports(5)

Self-Stick Pads(5)

Laminator Supplies(5)

Pens(5)

Desks(5)

USB Flash Drives(5)

Batteries(4)

Business Cards(4)

Furniture Hardware(4)

File Jackets/Sleeves/Wallets(3)

Coffee(3)

Coffee Condiments(3)

Page Flags(3)

Boards(2)

Partition & Panel Systems(2)

Shredder Bags(2)

Chairs/Stools(2)

Calculators(2)

Floor Mats(2)

Office Paper(2)

Mobile Devices(1)

Correction Tapes(1)

Surge Protectors(1)

Carts(1)

Air Fresheners/Odor Eliminators(1)

Bags(1)

Label Makers(1)

Desktop File Folder Sorters(1)

Toilet Tissues(1)

Footrests(1)

Keyboard & Mouse Combinations(1)

Tapes(1)

Binding Machines(1)

Scissors(1)

 
Brand

Universal(11)

Fellowes(10)

Alera(9)

Astrobrights(6)

Scotch(6)

Sharpie(5)

Post-it Notes(5)

Quartet(4)

Avery(4)

Dawn Professional(4)

Verbatim(4)

Ampad(4)

Duracell(4)

Coffee mate(3)

Safco(3)

Sharpie Roller(3)

Post-it Flags(3)

P&G Professional(3)

Smead(3)

uni-ball(3)

Arm & Hammer(3)

Dart(3)

Hammermill(2)

HON(2)

Innovera(2)

Floortex(2)

Dixie(2)

Paper Mate(2)

Comet(2)

Storex(1)

Tripp Lite(1)

Rolodex(1)

Westcott(1)

Charmin(1)

Spic and Span(1)

Dawn(1)

Black n' Red(1)

Boogie Board(1)

Krispy Kreme Doughnuts(1)

Café Bustelo(1)

GBC(1)

DYMO(1)

The Original Donut Shop(1)

Casio(1)

Glad(1)

Kaboom(1)

OxiClean(1)

BIC(1)

Neenah Bright White(1)

 
Color

Translucent Clear/Silver(2)

Black(1)

 
Height

1.75"(3)

10"(3)

2.75"(2)

20.75"(2)

21"(2)

23.25"(2)

5.88"(1)

18.5"(1)

16.87"(1)

17.4"(1)

14.96"(1)

5.3"(1)

10.5"(1)

9.5"(1)

11"(1)

4.13" to 5.63"(1)

33"(1)

6.34"(1)

24.93"(1)

 
Color(s)

Black(24)

Clear(7)

Cape Town Collection(5)

White(4)

Blue(4)

Beige(3)

Gray(2)

Multicolored(1)

White/Brown/Green(1)

Black/Silver(1)

Midnight Black(1)

Bright Green(1)

Yellow(1)

Red(1)

Transparent(1)

Dark Blue(1)

 
Depth

14.25"(2)

14"(2)

16.5"(2)

15.38"(1)

11"(1)

9.69"(1)

9.37"(1)

10.8"(1)

13.39"(1)

17"(1)

1"(1)

5.2"(1)

11.5"(1)

3"(1)

13.13"(1)

15.75"(1)

14.13"(1)

3.46"(1)

12.68"(1)

 
Size

9 x 11.5(4)

1 x 1.75(3)

Letter(3)

4 x 5.38(1)

8.3 x 6.07 x 1.63(1)

0.75" x 27.77 yds(1)

11.5 x 17.5(1)

 
Packing Type

Bottle(5)

K-Cup(3)

Jug(3)

Spray Bottle(2)

Box(2)

Canister(2)

Cube(2)

Trigger Spray Bottle(1)

Can(1)

Pump Bottle(1)

Paper Overwrap(1)

 
Overall Width

36"(1)

38"(1)

15"(1)

 
Overall Depth

48"(1)

64"(1)

16.38"(1)

 
Flavor

Donut Shop Regular(1)

Espresso(1)

Classic(1)

Sweetened Original(1)

Original(1)

French Vanilla(1)

 
Closure

Drawstring(1)

 
Diameter

13"(1)

18"(1)

 
Base Color

Black(2)

 
Beverage Type

Coffee(3)

 
Paper Color(s)

White(4)

 
 
 

© 2021-2022 Capital Services & Supplies Inc., All Rights Reserved