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') 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

File Cabinets(16)

Binders(9)

Office Paper(8)

Meals & Snack Bars(7)

Desks(7)

Cover Stock(6)

Pens(6)

Cleaners & Detergents(5)

Hanging File Folders(5)

Chairs/Stools(5)

Monitor Filters(5)

File Boxes(4)

Markers(4)

Tapes(4)

Coffee(4)

Calculators(3)

Personal Soaps(3)

Page Flags(3)

Self-Stick Pads(2)

File Folders(2)

Reception Seating & Sofas(2)

Sponges(2)

Stands(2)

Mops(2)

Paper Pads/Note Pads(2)

Hand Sanitizers(2)

Gloves(2)

Envelopes/Mailers(2)

Heaters(2)

Adhesives/Glues(2)

Label Makers(2)

Surge Protectors(2)

Shredders(1)

Adapters/Chargers(1)

Suggestion Boxes(1)

Frames(1)

Facial Tissues(1)

Art Paper(1)

Self-Stick Pad Dispensers(1)

Dusters(1)

Clocks(1)

Hand Cleaner Dispensers(1)

Scissors(1)

Safety Glasses(1)

Staplers(1)

 
Brand

Alera(14)

HON(13)

Astrobrights(13)

Avery(9)

Safco(8)

KIND(7)

Pendaflex(7)

Bankers Box(4)

Paper Mate(4)

Scotch(4)

Sharpie(4)

Green Mountain Coffee(4)

Post-it Flags(3)

Innovera(3)

PURELL(3)

Fellowes(3)

MCR Safety(3)

Boardwalk(2)

PAK-IT(2)

Pentel(2)

Belkin(2)

Post-it Pop-up Notes(2)

Mr. Clean(2)

Casio(2)

TOPS(2)

Dial(2)

DYMO(2)

Elmer's(2)

Dawn Professional(2)

Scrub Daddy(1)

GBC(1)

Blueline(1)

Swiffer(1)

Bostitch(1)

Puffs(1)

Pacon(1)

Post-it Pop-up Notes Super Sticky(1)

Howard Miller(1)

Black n' Red(1)

Fiskars(1)

Dial Professional(1)

DAX(1)

Artistic(1)

xerox(1)

 
Color

Black(10)

Putty(6)

Black/Silver(2)

Black Leather(2)

Light Gray(2)

Charcoal(2)

Beech/White(1)

Cherry/Black(1)

White(1)

 
Height

1 3/4"(3)

10.75"(3)

17 3/8"(1)

10.06"(1)

4 1/8"(1)

6"(1)

5 4/5"(1)

16"(1)

11.68"(1)

9.44"(1)

9 1/2"(1)

6.12"(1)

12.75"(1)

10.12"(1)

11"(1)

12 5/8"(1)

1.3"(1)

17"(1)

 
Color(s)

White(6)

Black(5)

Transparent(4)

Clear(3)

White/Blue(3)

Yellow(2)

Blue/Gray(2)

Red/Silver(1)

Marseille Collection(1)

Cape Town Collection(1)

Red(1)

Kraft/Green(1)

Bright Green(1)

White/Gray(1)

Orange(1)

White Pearlescent(1)

Black/Clear(1)

 
Depth

16"(2)

24.13"(2)

7 3/8"(1)

4 3/8"(1)

10.23"(1)

6.25"(1)

2"(1)

8 1/2"(1)

14"(1)

 
Quantity

1 each(8)

1 kit(1)

 
Size

0.75" x 83.33 ft(3)

1" x 1 3/4"(3)

6 1/2" x 11 5/8"(1)

5.42" x 4.39" x 1.15"(1)

0.75" x 70.83 ft(1)

 
Packing Type

Bar(7)

K-Cup(4)

Bottle(3)

Pump Bottle(3)

Water-Soluble Liquid Packet(2)

Stick(2)

Pack(2)

Spray Bottle(1)

 
Overall Width

15"(8)

36"(4)

42"(4)

21"(2)

53.5"(1)

73"(1)

3 3/8"(1)

 
Overall Depth

18"(8)

26.5"(8)

28.75"(2)

16"(2)

4"(1)

 
Flavor

Dark Magic Extra Bold(1)

Single Origin Colombian Select(1)

Breakfast Blend(1)

French Vanilla(1)

Cranberry Almond plus Antioxidants(1)

Chocolate Cherry Cashew plus Antioxidants(1)

Peanut Butter Dark Chocolate plus Protein(1)

Dark Chocolate Nuts & Sea Salt(1)

Caramel Almond & Sea Salt(1)

Dark Chocolate Almond & Coconut(1)

Salted Caramel and Dark Chocolate Nut(1)

 
Closure

Two Flaps(4)

Gummed(1)

Self-Adhesive(1)

 
Base Color

Black(5)

 
Binder Sheet Size

11 x 8.5(9)

 
Binder Style

View(9)

 
Beverage Type

Coffee(4)

 
Opening

Open Side(2)

 
Paper Color(s)

Color Varies(1)

 
 
 

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