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

Low-Density Trash Bags(8)

Creamers(8)

Cups(7)

Table Tops(7)

Art Markers(6)

Caffeinated(6)

Cleaning Cloths & Wipes(6)

Paper Wraps(5)

Scissors & Speed Cutters(5)

Bar Soaps(5)

Oral Care(4)

File Jackets/Sleeves/Wallets(4)

Mobile Device Accessories(4)

Board Components(4)

Food Storage Containers & Lids(4)

Resealable Bags(4)

Highlighters(4)

Toilet Tissues(4)

Foil Wraps(3)

Adapters/Chargers(3)

Chairs/Stools(3)

Tables(3)

Monitor Filters(3)

Indoor Seating(3)

Shampoos, Conditioners, & Body Washes(3)

Dusters(2)

Dishwashing Detergents(2)

Table Bases/Legs(2)

External Hard Drives(2)

Chair Mats(2)

Hand Sanitizer Refills(2)

Hand Sanitizer Dispensers(2)

Reception & Lounge Tables(2)

Plates(2)

Security and Surveillance Accessories(1)

Sofas(1)

Hubs(1)

Loveseats(1)

Signs & Sign Holders(1)

Pocket Folders(1)

File Folders(1)

Hanging File Folders(1)

Clay(1)

Furniture Cleaners(1)

Buckets & Wringers(1)

Sprayers & Pumps(1)

Office Paper(1)

Soap Refills(1)

Carts(1)

Disinfectants & Sanitizers(1)

Soap Dispensers(1)

Drawing & Design Pads(1)

Pan Liners(1)

Laminators(1)

Glue(1)

First Aid Kits(1)

Shredders(1)

Toner Cartridges(1)

 
Brand

Dart(18)

Verbatim(13)

Boardwalk(13)

HON(13)

Coffee mate(8)

Heritage(8)

U Brands(7)

Sharpie(6)

Folgers(6)

Westcott(5)

Alera(5)

Dial Professional(5)

Rubbermaid Commercial(5)

Handy Wacks(5)

Rubbermaid Commercial HYGEN(4)

Post-it(4)

Colgate(4)

BIC(4)

Iceberg(4)

PURELL(4)

Reynolds Wrap(3)

Dawn(2)

deflecto(2)

Eco-Products(2)

Pactiv Evergreen(2)

Creative Arts(1)

Fellowes(1)

Endust(1)

Pacon(1)

HP(1)

WypAll(1)

LYSOL Brand(1)

Johnson & Johnson Red Cross(1)

Dixie(1)

GBC(1)

Gyration(1)

Pledge(1)

Crayola(1)

Headline Sign(1)

Hammermill(1)

 
Height

5.5"(5)

36"(3)

32"(3)

10.31"(2)

13.39"(2)

3.4"(2)

9"(1)

12.99"(1)

13.58"(1)

12.25"(1)

4"(1)

4.25"(1)

58"(1)

39"(1)

11"(1)

15"(1)

21"(1)

3.06"(1)

8.75"(1)

3.1"(1)

2.6"(1)

7.1"(1)

5.89"(1)

8"(1)

0.5"(1)

 
Color(s)

Clear(22)

White(14)

Black(12)

Translucent(6)

Assorted(4)

Black/Gray(3)

Natural(2)

Green(2)

Black/Clear(2)

Yellow(2)

Space Gray(1)

Gray(1)

Black; Purple; White(1)

Black; White(1)

Red(1)

Ocean(1)

Dark Gray(1)

Blue(1)

Graphite(1)

Light Blue(1)

Light Gray/White(1)

Silver(1)

 
Depth

3.96"(2)

2"(1)

2.9"(1)

2.5"(1)

2.3"(1)

1.4"(1)

3.38"(1)

7"(1)

17"(1)

1.6"(1)

8.5"(1)

8.88"(1)

0.13"(1)

2.2"(1)

 
Size

Letter(4)

6 x 9(1)

 
Overall Width

23.63"(2)

26.18"(2)

72"(2)

77"(1)

55.5"(1)

60"(1)

14.25"(1)

 
Overall Depth

18"(3)

31.5"(2)

20"(2)

16.5"(1)

 
Flavor

Classic Roast(3)

Original(2)

French Vanilla(2)

Hazelnut(2)

Black Silk(1)

Gourmet Supreme(1)

100% Colombian(1)

French Vanilla; Hazelnut; Original(1)

Italian Sweet Cream(1)

 
Diameter

30"(3)

5.5"(2)

36"(2)

42"(2)

6"(1)

9"(1)

7"(1)

8.9"(1)

22.1(1)

 
Expansion

1"(1)

 
Base Color

Black(2)

Mahogany(1)

Silver(1)

 
Beverage Type

Coffee(6)

 
 
 
 

© 2025-2026 Office 8, All Rights Reserved

Powered by Dealer Commander