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

File Cabinets(27)

Storage Cabinets(11)

Art Markers(10)

Air Fresheners & Odor Eliminators(9)

Markers(8)

Calligraphy & Illustrator Pens(8)

Monitor Filters(8)

Toilet & Urinal Deodorizers(8)

Hangers/Hooks(8)

Caffeinated(7)

Pens(7)

File Jackets/Sleeves/Wallets(6)

Hand Sanitizers(6)

Bottled Water(6)

Chairs/Stools(6)

Tables(5)

Repro Trash Bags(4)

Metered Dispenser Refills(4)

Glue(4)

Cleaning Cloths & Wipes(4)

Telephones(3)

Chair Mats(3)

Clothes Racks(3)

Boxes & Bins(3)

Snacks(3)

Copier/Fax/Multifunction Machines(3)

Shelving Units(3)

Carts(3)

Highlighters(2)

Creamers(2)

Glass Cleaners(2)

Earbuds & Headphones(2)

External Hard Drives(2)

Tea(2)

Meals & Snack Bars(2)

Disposable Forks(2)

Toner Cartridges(2)

Fabric Refreshers(2)

Air Freshener Dispensers(2)

Disposable Knives(2)

Disposable Spoons(2)

Office Paper(2)

Air Cleaner Machines(2)

Cutlery Kits(1)

Web Cameras/Webcams(1)

Condiment Organizers(1)

Keyboard & Mouse Combinations(1)

Decaffeinated(1)

Adapters/Chargers(1)

Scanners(1)

Keyboards(1)

 
Brand

Alera(30)

Boardwalk(20)

HON(17)

Sharpie(16)

Kensington(8)

Paper Mate(8)

Command(8)

Folgers(8)

Eco-Products(7)

Smead(6)

Crystal Geyser(6)

PURELL(6)

Rubbermaid Commercial(5)

Iceberg(5)

Sharpie S-Gel(5)

Brother(4)

EXPO(4)

Elmer's(4)

Heritage(4)

Durable(3)

deflecto(3)

Floortex(3)

Safco(3)

LYSOL Brand(3)

Verbatim(3)

Motorola(3)

Windex(2)

Adesso(2)

Coffee mate(2)

Morpheus 360(2)

KIND(2)

HP(2)

Hammermill(2)

Fellowes(2)

BIC(2)

Zevia(2)

Logitech(1)

WypAll(1)

Setton Farms(1)

Mind Reader(1)

Sahale Snacks(1)

Jif To Go(1)

 
Height

10"(6)

5.5"(3)

2.38"(3)

39"(2)

1.13"(2)

58"(2)

2.72"(1)

20.5"(1)

25.12"(1)

4.5"(1)

21.2"(1)

5.35"(1)

6.73"(1)

6.5"(1)

0.75"(1)

2.16"(1)

1.63"(1)

8.13"(1)

5.9"(1)

9.5"(1)

0.7"(1)

 
Color(s)

Black(28)

Light Gray(11)

Putty(10)

White(10)

Clear(9)

Charcoal(6)

Redrope(6)

Pearl White(4)

Black/Clear(3)

Blue(3)

Green(3)

Black/Silver(3)

Red(3)

Gray/Black(2)

Orange(2)

Beech(1)

Gray(1)

White/Gray/Blue(1)

White/Gray/Orange(1)

Cyan; Magenta; Yellow(1)

Black/Gray(1)

Space Gray(1)

Silver(1)

 
Depth

3"(3)

1"(3)

14.21"(2)

0.44"(2)

2.75"(1)

0.75"(1)

0.83"(1)

0.25"(1)

4.8"(1)

20.7"(1)

7.12"(1)

12.87"(1)

3.63"(1)

5.25"(1)

6.63"(1)

3.75"(1)

8.12"(1)

 
Size

Letter(5)

Medium(4)

Mini(2)

Small(1)

Legal(1)

 
Overall Width

36"(23)

15"(7)

30"(6)

42"(4)

20.79"(3)

18"(2)

48"(2)

70.9"(1)

94.5"(1)

 
Overall Depth

18"(12)

18.63"(11)

18.13"(7)

25"(6)

22"(3)

23.31"(3)

20"(2)

16"(1)

24"(1)

23.6"(1)

29.1"(1)

29.9"(1)

 
Flavor

Spring(6)

Classic Roast(4)

Black Silk(2)

Natural Vanilla(2)

Classic Roast Decaf(1)

100% Colombian(1)

Crunchy Peanut Butter(1)

Double Dark Chocolate(1)

Simply Protein(1)

Classic Fruit & Nut Trail Mix(1)

Creamy Peanut Butter(1)

Raspberry Black Tea(1)

Peach Black Tea(1)

 
Base Color

Gray(3)

 
Beverage Type

Coffee(7)

Spring Water(6)

Iced Tea(2)

Decaffeinated Coffee(1)

 
Folded Height

3"(3)

 
 
 
 

© 2025-2026 Office 8, All Rights Reserved

Powered by Dealer Commander