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(12)

Towels & Wipes(10)

Markers(8)

Gloves(8)

Cups(8)

Cleaners & Detergents(7)

Tables(6)

Dinnerware(6)

Chairs/Stools(6)

Desks(5)

Personal Soaps(5)

Waste Receptacles(5)

Index Dividers(4)

Mouse Pads & Wrist Rests(4)

Chair Mats(4)

Scissors(4)

Facial Tissues(4)

File Cabinets(4)

Office Paper(4)

File Folders(4)

Cash Bags(4)

Name Badge Kits(4)

Hand Sanitizers(3)

Toilet Tissues(3)

Pencils(3)

Paper Pads/Note Pads(3)

Utensils(3)

Envelopes/Mailers(3)

Shredders(3)

Pens(3)

Broom Heads(3)

Bags(3)

Cup Lids(2)

Coffee Condiments(2)

Tapes(2)

Floor Mats(2)

Hand Cleaner Dispensers(2)

Label Makers(2)

Tape Dispensers(2)

Labels(2)

Staplers(2)

Carts(2)

File Boxes(2)

Forms(1)

Correction Tapes(1)

Safety Cones(1)

Cover Stock(1)

Photo Paper(1)

Soap Dispensers(1)

First Aid Kits(1)

Catalog Reference Racks(1)

Keyboard & Mouse Combinations(1)

Fire Extinguishers(1)

Sponges(1)

Mop Heads(1)

Respirators(1)

Mounting Tape(1)

Air Fresheners/Odor Eliminators(1)

 
Brand

Alera(14)

Dart(12)

Boardwalk(11)

PURELL(8)

Iceberg(7)

Fellowes(7)

Rubbermaid Commercial(7)

Floortex(6)

Avery(6)

Tork(6)

BIC(6)

Dixie(5)

HON(5)

Fiskars(4)

Smead(4)

TOPS(4)

Storex(4)

Scotch(4)

MMF Industries(4)

Advantus(4)

Boise(3)

Quality Park(3)

Safco(3)

Earthsense Commercial(3)

Pentel(3)

uni-ball(3)

Hammermill(3)

Bankers Box(2)

Mr. Clean(2)

Fabuloso(2)

Clorox(2)

LYSOL Brand(2)

Seventh Generation(2)

Softsoap(2)

Marcal(2)

Victor(2)

Dixie Ultra(2)

DYMO(2)

Kleenex(2)

Dial Professional(2)

Swingline(2)

Paper Mate(2)

Coffee-mate(2)

Tombow(1)

Swiffer(1)

Command(1)

Kidde(1)

Innovera(1)

PhysiciansCare by First Aid Only(1)

Durable(1)

3M(1)

Air Wick(1)

Professional LYSOL Brand(1)

Cascade(1)

Professional RESOLVE(1)

 
Color

Black(8)

Black Anthracite(6)

Silver(4)

Gray(2)

Cherry/Black(1)

Beech/White(1)

Black/Silver(1)

 
Height

9 1/2"(4)

12 1/8"(3)

9"(3)

16"(2)

32"(2)

12.13"(2)

12"(2)

7/8"(2)

3/4"(2)

10 3/4"(2)

21 5/16"(1)

33"(1)

46"(1)

58"(1)

25 1/4"(1)

21 1/4"(1)

0.98"(1)

2 3/4"(1)

2 2/5"(1)

51.569"(1)

36"(1)

 
Color(s)

White(31)

Clear(12)

Black(8)

Blue(8)

Assorted(4)

Multicolor(3)

Black/Dark Silver(3)

Maroon(3)

White/Blue(2)

Red(2)

Multi-Colored(2)

Green/Burgundy(2)

Clear;Orange(2)

Manila(2)

Gold(2)

Beige(1)

Slate Gray/Blue(1)

Gray(1)

Gray/Orange(1)

Satin Stainless(1)

Black/Chrome(1)

Yellow(1)

Gray/White(1)

Pink(1)

Rambunctious Red(1)

Tuxedo Black(1)

Black/White(1)

Deep Sea Blue(1)

Graphite(1)

Silver/White(1)

Midnight Black(1)

Clear; White(1)

 
Depth

8 1/4"(3)

2 5/16"(2)

8.56"(2)

16"(2)

24 1/8"(2)

9 1/4"(2)

9"(2)

12 1/4"(1)

Assorted(1)

12"(1)

16.625"(1)

10 7/16"(1)

17 1/4"(1)

11 5/16"(1)

5 1/2"(1)

5.71"(1)

 
Quantity

1 each(12)

1,000 per carton(8)

500 per carton(6)

1 per carton(2)

1,000 per case(2)

4 per carton(1)

12 per case(1)

 
Size

8 1/2 x 11(6)

Legal(2)

Letter(2)

3/4" x 1296"(1)

3/4" x 650"(1)

Standard(1)

 
Packing Type

Bottle(6)

Spray Bottle(2)

Box(2)

Dispenser Refills(2)

Pump Bottle(2)

Roll(1)

Flat Box(1)

Case(1)

Cube Box(1)

Pump Dispenser(1)

Packet(1)

Mini Cups(1)

Aerosol(1)

Refill(1)

 
Refillable

Yes(5)

No(3)

 
Overall Width

36"(6)

48"(6)

14 3/4"(4)

72"(2)

60"(2)

96"(1)

34"(1)

28"(1)

 
Overall Depth

18"(9)

24"(6)

18 1/4"(4)

30"(3)

16"(1)

 
Flavor

Peppermint Mocha(2)

 
Ink Color(s)

Assorted(2)

Red(1)

Black(1)

Blue(1)

 
Closure

Self-Sealing Adhesive(4)

Self-Adhesive(3)

String & Button(2)

 
Diameter

10 1/4"(2)

5 4/5"(2)

5.03"(1)

60"(1)

9"(1)

 
Expansion

No(3)

Scored for 3/4" expansion(2)

 
Base Color

Black(6)

Brown(5)

Gray(1)

 
Envelope/Mailer Type

Packing List(2)

Catalog/Booklet(1)

 
Envelope Size

5 1/2 x 4 1/2(2)

14 x 17(1)

 
Opening

Open End(3)

 
Folded Height

2 1/2"(6)

 
Paper Color(s)

White(5)

Photo White(2)

Blue(1)

Pink(1)

Gray(1)

 
 
 

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