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

Shelving Units/Bookcases(17)

Labels(10)

File Cabinets(8)

Envelopes/Mailers(8)

Chairs/Stools(8)

Cleaners & Detergents(7)

Air Fresheners/Odor Eliminators(7)

Packing Tape(6)

Pens(6)

Binders(6)

Cups(4)

Scissors(4)

Towels & Wipes(4)

Storage Cabinets(4)

Index Dividers(4)

Meals & Snack Bars(3)

Personal Soaps(3)

Monitor Filters(3)

Label Maker Supplies(3)

Headset Accessories(2)

Clothes Racks(2)

Page Flags(2)

Self-Stick Pad Dispensers(2)

Frames(2)

Surge Protectors(2)

Office Paper(2)

Markers(2)

File Jackets/Sleeves/Wallets(2)

Dryer Sheets(1)

Cases(1)

Calculators(1)

Facial Tissues(1)

File Folders(1)

Hanging File Systems(1)

Safes(1)

Condiment Organizers(1)

Label Makers(1)

Correction Tapes(1)

Adhesives/Glues(1)

Hand Sanitizers(1)

Paper Pads/Note Pads(1)

Keyboard & Mouse Combinations(1)

Mice(1)

Tapes(1)

 
Brand

Avery(20)

Alera(17)

HON(11)

Quality Park(8)

Scotch(7)

Boardwalk(5)

Tennsco(5)

Safco(4)

Westcott(4)

Pilot(4)

Rubbermaid Commercial(4)

LYSOL Brand(4)

Dart(4)

DYMO(4)

KIND(3)

BIC(3)

Seventh Generation(3)

Fellowes(3)

Pendaflex(2)

Post-it Flags(2)

Belkin(2)

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

Iceberg(2)

Sharpie(2)

DAX(2)

Innovera(2)

Maxell(2)

Smead(1)

Astrobrights(1)

Universal(1)

Texas Instruments(1)

Swiss Mobility(1)

Five Star(1)

SureSeal By FireKing(1)

PURELL(1)

Elmer's(1)

Mind Reader(1)

Clorox(1)

GOJO(1)

Hammermill(1)

Puffs(1)

Bounce(1)

Gain(1)

Tide(1)

Febreze(1)

 
Color

Black(12)

Putty(3)

Dark Gray(3)

Silver(2)

Black Anthracite(2)

Light Gray(2)

Charcoal(1)

Modern Walnut(1)

Espresso(1)

Medium Cherry(1)

Mahogany(1)

 
Height

10 1/2"(3)

9"(2)

1 3/4"(2)

75"(2)

8 1/2"(1)

12 1/8"(1)

12 1/2"(1)

11 7/8"(1)

12 3/4"(1)

 
Color(s)

White(15)

Clear(12)

Black(9)

Brown Kraft(2)

Silver(2)

Assorted Primary/Brights(1)

Gray(1)

Taupe(1)

Gold(1)

Assorted Primary(1)

 
Depth

18"(2)

3 3/8"(1)

11 4/5"(1)

1"(1)

 
Quantity

1 each(11)

1000 per carton(4)

 
Size

1.88" x 54.6 yds(5)

Letter(2)

1/2" x 1 3/4"; 1" x 1 3/4"(2)

3 3/8 x 6 3/8(1)

1.88" x 800"(1)

3/4" x 1296"(1)

2 19/20"w x 4 49/50"d x 1 67/100"h(1)

 
Packing Type

Bottle(6)

Aerosol(4)

Bar(3)

Pump Bottle(3)

Cartridge(2)

Box(1)

Pen(1)

Spray Bottle(1)

Bottles(1)

 
Refillable

Refillable(4)

Yes(2)

Nonrefillable(2)

 
Overall Width

36"(8)

48"(6)

34 1/2"(5)

15"(5)

15 7/8"(4)

3.8"(2)

32"(1)

 
Overall Depth

18"(8)

13 1/2"(5)

24"(5)

22 7/8"(4)

20 1/2"(4)

3.8"(2)

12"(1)

13"(1)

15"(1)

 
Flavor

Peanut Butter Dark Chocolate(1)

Dark Chocolate Chunk(1)

Oats & Honey with Toasted Coconut(1)

 
Closure

Redi-Strip(4)

Self-Adhesive(4)

Zipper(1)

 
Diameter

4 1/4"(1)

4.13"(1)

4 1/8"(1)

 
Expansion

No(5)

 
Base Color

Black(7)

Chrome(1)

 
Binder Sheet Size

11 x 8.5(6)

 
Binder Style

View(6)

 
Envelope/Mailer Type

Business/Trade(4)

Catalog/Booklet(4)

 
Envelope Size

6 x 9(2)

4 1/8 x 9 1/2(2)

9 x 12(2)

3 5/8 x 8 5/8(1)

3 7/8 x 8 7/8(1)

 
Opening

Open Side(4)

Open End(4)

 
 
 

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