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`.`special_type`='special' and `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','spl_call_for_price') 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

Food Containers & Lids(16)

Cleaning Cloths & Wipes(14)

Chairs/Stools(14)

Storage Cabinets(13)

Executive & Office Desks(12)

Plates(11)

Cups(11)

Easel Pads(10)

Disposable & Single Use Gloves(10)

Pens(10)

Indoor Waste Receptacles(9)

Markers(9)

Self-Stick Note Pads(8)

Office Paper(8)

Disinfectants & Sanitizers(8)

File Jackets/Sleeves/Wallets(7)

Perforated Roll & Hand Towels(7)

Condiment Organizers(7)

Name Badge Kits(7)

School & Reading Desks(7)

Copier/Fax/Multifunction Machines(6)

Low-Density Trash Bags(6)

General Purpose Pads(5)

Boards(5)

Composition Books(5)

Bowls(5)

Dusters(5)

Towels & Wipes(5)

File Cabinets(5)

Label Makers(5)

Tool Storage & Organizers(5)

Hanging File Folders(5)

Bottled Water(4)

Awards & Certificates(4)

Caffeinated(4)

Cables(4)

File Boxes(4)

Toilet Tissues(3)

Desktop Supplies Organizers(3)

Sanitizing Wipes(3)

Highlighters(3)

Cushioned Mailers(3)

Tables(2)

Air Cleaner Machines(2)

File Inserts/Tabs(2)

Erasers(2)

File Folders(2)

Soap Refills(2)

Floor Dusters & Accessories(2)

Cases(2)

Mouse Pads & Wrist Rests(2)

Binders(2)

Drawstring & Kitchen Bags(2)

Scouring Pads & Sticks(2)

Furniture Cleaners(2)

Insecticides(2)

Mops(2)

Cup Lids(2)

Reporting & Stenography Pads(1)

Sweepers(1)

High-Density Trash Bags(1)

Beverage Trays(1)

Buckets & Wringers(1)

Kitchen & Service Carts(1)

Shelving Units/Bookcases(1)

Toilet & Urinal Deodorizers(1)

Laser Printers(1)

Mop Heads(1)

Correction Tapes(1)

Pocket Folders(1)

Art Markers(1)

Bathroom Cleaners(1)

Index Dividers(1)

Respiratory Protection(1)

Scissors & Speed Cutters(1)

Pencils(1)

Shipping & Storage Bags(1)

Punches(1)

Hanging File Systems(1)

Luncheon Napkins(1)

Sponges(1)

Pocket Charts(1)

Carts(1)

Decaffeinated(1)

Laminators(1)

Document Holders(1)

Hand Sanitizers(1)

Air Fresheners & Odor Eliminators(1)

Hand Soaps(1)

Ink Cartridges(1)

Signs & Sign Holders(1)

All Purpose Cleaners & Degreasers(1)

Air Cooling Equipment(1)

Multimedia Projectors(1)

Adapters/Chargers(1)

Disposable Sporks(1)

Electronics Cleaners(1)

First Aid Kits(1)

Disposable Knives(1)

Floor Pads-Cleaning, Buffing & Polishing(1)

Cable Management(1)

Packing Tapes(1)

Laundry Detergents(1)

Crafting Tape(1)

Footrests(1)

 
Brand

Boardwalk(45)

HON(30)

Universal(14)

Rubbermaid Commercial(13)

U Brands(11)

Avery(10)

Eco-Products(10)

Post-it Easel Pads Super Sticky(9)

OIF(9)

Post-it Greener Notes(7)

SOLO(7)

Mind Reader(7)

Dart(7)

Alera(7)

TOPS(6)

Innovera(6)

EXPO(6)

Hirsh Industries(6)

PURELL(6)

Pactiv Evergreen(6)

Pentel(6)

Scott(5)

WypAll(5)

Pendaflex(5)

Swiffer(5)

Sharpie(5)

Geographics(5)

Workspace by Alera(4)

Unger(4)

1850(4)

BIC(4)

Smead(4)

Crystal Geyser(4)

HP(4)

Bankers Box(4)

Professional LYSOL Brand(3)

Brother(3)

Paper Mate(3)

LYSOL Brand(3)

Murphy Oil Soap(3)

Cascades PRO(3)

Quartet(3)

Tork(3)

Fellowes(3)

DYMO(3)

Post-it Tabs(2)

Earthsense Commercial(2)

Epson(2)

Clorox(2)

Read Right(2)

Solo(2)

Post-it Notes Super Sticky(2)

Scotch(2)

Dixie(2)

TruSens(1)

Rubbermaid(1)

Scrubbing Bubbles(1)

Raid(1)

Vegware(1)

Stout by Envision(1)

Pilot(1)

Staedtler(1)

Swingline(1)

Scotch-Brite(1)

Mr. Clean(1)

Folgers(1)

Brother P-Touch(1)

Carson-Dellosa Education(1)

Pine-Sol(1)

Canon(1)

Durable(1)

deflecto(1)

Dial(1)

Combat(1)

Diversey(1)

Flipside(1)

GBC(1)

Comet(1)

Georgia Pacific Professional(1)

Hammermill(1)

HP Papers(1)

Honeywell(1)

Johnson & Johnson Red Cross(1)

Kleenex(1)

Command(1)

Post-it(1)

ocelo(1)

3M(1)

Charmin(1)

Windsoft(1)

 
Brightness

3,600 lm(1)

 
Height

58"(5)

40.25"(4)

1.5"(4)

11"(4)

10.25"(3)

3.5"(2)

40.12"(2)

3"(2)

12.5"(2)

12"(2)

2.17"(2)

0.06"(2)

4.25"(2)

13.39"(2)

11.75"(1)

2.9"(1)

12.8"(1)

10.94"(1)

13.7"(1)

13"(1)

7.01"(1)

1"(1)

12.99"(1)

0.63"(1)

9.5"(1)

2.38"(1)

13.58"(1)

6.63"(1)

28"(1)

4.6"(1)

34.25"(1)

13.78"(1)

11.25"(1)

17.75"(1)

3.88"(1)

3.38" to 5.13"(1)

14.56"(1)

47"(1)

15.8"(1)

12.1"(1)

6.1"(1)

27.4"(1)

30"(1)

38.6"(1)

1.05"(1)

1.08"(1)

1.25"(1)

1.73"(1)

1.96"(1)

2.14"(1)

46"(1)

3.19"(1)

10.5"(1)

9"(1)

19"(1)

22.3"(1)

1.83"(1)

12.6"(1)

9.78"(1)

5.25"(1)

12.63"(1)

16.14"(1)

2.72"(1)

17.7"(1)

3.6"(1)

10.8"(1)

33"(1)

 
Color(s)

White(41)

Black(26)

Tan(12)

Clear(10)

Red/White(8)

Assorted(8)

Blue(8)

Putty(5)

Gray(5)

Sweet Sprinkles Collection(4)

Kraft/Green(4)

Natural Kraft(3)

Mahogany(3)

Canary Yellow(3)

Light Gray(3)

Multicolored(2)

Black/Silver(2)

Pinnacle(2)

Kingswood Walnut(2)

Green/Tan(2)

Teal(2)

Natural White(2)

Natural(2)

Aluminum/Green(2)

Kraft(2)

Silver/Green(2)

Translucent(2)

Blue/Gray(1)

Green(1)

Brown(1)

Ocean(1)

Blue/Gray/Yellow(1)

Blue; Clear; Gray; Green; Orange; Pink; Purple(1)

Gold(1)

Blue/Gray/Green(1)

Blue/Gray/Red/Yellow(1)

Black/Gray/Red(1)

Black/Gray(1)

White with Blue Leaf(1)

White/Green(1)

Gray/Black(1)

Yellow/Silver(1)

Assorted Pastel(1)

Natural/Gold(1)

Yellow/Green(1)

Red(1)

Blue/Red(1)

Ivory(1)

Beige(1)

Green/Burgundy(1)

White/Black(1)

Natural/Silver(1)

Supernova Neons Collection(1)

Natural/Blue(1)

Natural/Green(1)

Navy With Gold Foil(1)

Tri-Color(1)

Silver(1)

Light Blue(1)

White; Blue Stripe(1)

Brown/Yellow(1)

Transparent(1)

 
Depth

21.5"(5)

0.77"(3)

3.5"(3)

16.25"(2)

25.38"(2)

21.11"(2)

0.4"(2)

0.7"(2)

4"(2)

3.15"(2)

11"(2)

8"(2)

25"(1)

5.75"(1)

15.6"(1)

31.13"(1)

16.8"(1)

4.75"(1)

3.3"(1)

17.75"(1)

1"(1)

8.63"(1)

3"(1)

1.5"(1)

1.48"(1)

10"(1)

6.69"(1)

6.5"(1)

3.25"(1)

12.87"(1)

9.8"(1)

6"(1)

16.1"(1)

8.3"(1)

22.4"(1)

4.3"(1)

4.57"(1)

5.16"(1)

5.85"(1)

6.55"(1)

7.01"(1)

8.67"(1)

12"(1)

3.19"(1)

22.8"(1)

21.1"(1)

0.13"(1)

1.4"(1)

6.08"(1)

0.5"(1)

11.8"(1)

6.63"(1)

16"(1)

6.88"(1)

2.05"(1)

15.7"(1)

7.9"(1)

 
Size

Letter(7)

8.5 x 11(1)

1.88" x 58.33 ft(1)

0.75" x 75 ft(1)

Standard(1)

 
Overall Width

36"(13)

30"(3)

24"(2)

15"(2)

60"(2)

3.95" Sorter; 10" Tray; 2.75" Pencil Cup(2)

15.75"(1)

6"(1)

 
Overall Depth

18"(7)

20"(6)

15"(3)

25"(2)

24"(2)

5.15" Sorter; 12.3" Tray; 2.75" Pencil Cup(2)

14"(1)

16"(1)

9.88"(1)

7.2"(1)

 
Flavor

Spring(2)

Classic Roast(1)

Lantern Glow(1)

Pioneer Blend(1)

Black Gold(1)

Pioneer Blend Decaf(1)

 
Diameter

6"(5)

6.5"(2)

3.63"(2)

8.5"(2)

5.5"(1)

6.29"(1)

9"(1)

10"(1)

10.13"(1)

20"(1)

4"(1)

12"(1)

5"(1)

 
Expansion

2"(1)

1"(1)

 
Base Color

Black(2)

 
Binder Sheet Size

11 x 8.5(2)

 
Binder Style

View(2)

 
Beverage Type

Coffee(5)

Water(4)

 
Opening

Open End(3)

 
 
 
 

© 2024-2025 Office 8, All Rights Reserved