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

Pens(23)

Chairs/Stools(9)

Floor Pads-Stripping(8)

General Purpose Notebooks(8)

Hangers/Hooks(6)

Floor Dusters & Accessories(5)

Tables(5)

Caffeinated(4)

Floor Pads-Cleaning, Buffing & Polishing(4)

Buckets & Wringers(4)

All Purpose Cleaners & Degreasers(3)

Plates(3)

Executive & Office Desks(3)

Binders(3)

Cleaning Cloths & Wipes(2)

Filler Paper(2)

Facial Tissues(2)

Dry Erase Boards(2)

Copier/Fax/Multifunction Machines(2)

Disinfectants & Sanitizers(2)

Carts(2)

Half-caffeinated(2)

Food Storage Containers & Lids(2)

Decaffeinated(2)

Shelving Units(2)

Pad Folios(2)

Pencils(2)

Laser Printers(2)

File Folders(2)

Mop Heads(1)

Art Markers(1)

Floor Strippers(1)

Footrests(1)

Easel Pads(1)

Pocket Folders(1)

Compressed Air Dusters(1)

School & Reading Desks(1)

Office Paper(1)

Laminators(1)

File Cabinets(1)

Label Makers(1)

Chair Mats(1)

Inkjet Printers(1)

Clips/Clamps(1)

 
Brand

HON(14)

Five Star(11)

Pentel(11)

Folgers(8)

Boardwalk(7)

Swiffer(6)

Command(6)

3M(5)

Sharpie S-Gel(5)

Rubbermaid Commercial(4)

PURELL(4)

Alera(4)

Safco(4)

Eco-Products(3)

Paper Mate(3)

BIC(3)

Avery(3)

HP(2)

Quartet(2)

Ticonderoga(2)

Kleenex(2)

Canon(2)

Clorox(2)

Pendaflex(2)

Pactiv Evergreen(2)

Samsill(2)

SC Johnson Professional(1)

Universal(1)

Sharpie(1)

Innovera(1)

Post-it Easel Pads Super Sticky(1)

Iceberg(1)

Hammermill(1)

GBC(1)

FireKing(1)

DYMO(1)

deflecto(1)

Fabuloso(1)

Brother(1)

Zebra(1)

 
Height

2.38"(2)

1.13"(2)

3"(2)

36"(2)

12.5"(2)

3.75" to 7.5"(1)

12.3"(1)

7.88"(1)

6.3"(1)

11.14"(1)

12.8"(1)

30"(1)

2.16"(1)

1.63"(1)

34.41"(1)

36.97"(1)

 
Color(s)

White(13)

Black(6)

Green(3)

Yellow(3)

Blue(2)

Black/Clear(2)

Dark Gray(2)

Clear(1)

Brown(1)

Gray(1)

 
Depth

0.75"(3)

0.44"(2)

1"(2)

23.92"(2)

19.63"(1)

19.1"(1)

9.88"(1)

12.3"(1)

18.1"(1)

25"(1)

27"(1)

0.83"(1)

9.5"(1)

8.5"(1)

22.83"(1)

22.07"(1)

 
Size

Medium(3)

Mini(2)

Small(1)

 
Overall Width

60"(5)

19"(2)

36"(2)

17.75"(1)

 
Overall Depth

24"(4)

16"(2)

18"(2)

25"(1)

30"(1)

 
Flavor

Classic Roast Decaf(2)

Classic Roast(2)

Half Caff(2)

Black Silk(2)

 
Diameter

20"(6)

13"(2)

17"(2)

12"(1)

16"(1)

10"(1)

9"(1)

6"(1)

 
Base Color

Black(3)

Gray(1)

Charcoal(1)

 
Binder Sheet Size

11 x 8.5(3)

 
Binder Style

View(3)

 
Beverage Type

Coffee(4)

Decaffeinated Coffee(2)

Half-Caffeinated Coffee(2)

 
Folded Height

2.5"(1)

 
 
 
 

© 2025-2026 Office 8, All Rights Reserved

Powered by Dealer Commander