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

Cleaning Cloths & Wipes(9)

Candy, Gum & Mints(8)

Disinfectants & Sanitizers(8)

File Cabinets(8)

Chairs/Stools(8)

Plates(8)

High-Density Trash Bags(8)

Surge Protectors(8)

Self-Stick Note Pads(7)

Cups(7)

Food Containers & Lids(6)

Executive & Office Desks(6)

Batteries(6)

Dishwashing Detergents(5)

Shelving Units(5)

Toner Cartridges(5)

Hand Soaps(4)

Perforated Roll & Hand Towels(4)

Scouring Pads & Sticks(4)

Adapters/Chargers(4)

Creamers(3)

Sprayers & Pumps(3)

Page Flags(3)

Office Paper(3)

Scanners(3)

Copier/Fax/Multifunction Machines(3)

Snacks(3)

School & Reading Desks(2)

Laundry Detergents(2)

Staplers(2)

Binders(2)

Floor Dusters & Accessories(2)

Ink Cartridges(2)

Forms(2)

Furniture Cleaners(2)

Toilet Bowl Cleaners(1)

Calculators(1)

Laser Printers(1)

Web Cameras/Webcams(1)

Caffeinated(1)

Cables(1)

Digital & Smart Pads(1)

Shredders(1)

Food Storage Containers & Lids(1)

Glue(1)

 
Brand

Boardwalk(30)

Alera(19)

HP(10)

Paper Mate(8)

Office Snax(8)

Dixie(8)

Tripp Lite by Eaton(8)

HON(8)

Professional LYSOL Brand(7)

Dart(7)

SOLO(7)

Post-it Notes Super Sticky(7)

LYSOL Brand(6)

Duracell(6)

Dawn(5)

BIC(5)

Innovera(4)

Scott(4)

Hammermill(3)

Post-it Flags(3)

Coffee mate(3)

Brother(3)

Safco(2)

Kellogg's(2)

Avery(2)

Swingline(2)

Adams(2)

Texas Instruments(1)

Universal(1)

Lavazza(1)

Jif To Go(1)

Pilot(1)

Logitech(1)

Boogie Board(1)

Fellowes(1)

Canon(1)

Verbatim(1)

 
Height

5.5"(5)

58"(3)

1.75"(3)

9.5"(2)

1.5"(2)

23"(1)

13"(1)

1.25"(1)

15.75"(1)

1.2"(1)

6.06"(1)

20.75"(1)

30"(1)

33"(1)

3.4"(1)

7.1"(1)

5.9"(1)

47"(1)

46"(1)

38"(1)

10.8"(1)

 
Color(s)

White(20)

Black(13)

Clear(10)

Natural(8)

Light Gray(6)

Green/Burgundy(6)

Brown/White(3)

Canary Yellow(3)

Pink(2)

Silver/Black/Orange(2)

Yellow(2)

Black; Gun Metal Gray(2)

Putty(2)

Green(2)

Charcoal(2)

Wanderlust Pastels(2)

Cool Gray(1)

Bright Green(1)

Red(1)

Magenta(1)

Oasis(1)

Oasis Collection(1)

Cyan(1)

Tri-Color(1)

Dark Blue(1)

Black/Gray(1)

 
Depth

1.2"(2)

15.9"(1)

11.97"(1)

2.13"(1)

13"(1)

1.75"(1)

1.63"(1)

1.5"(1)

27"(1)

2"(1)

25"(1)

14"(1)

1.4"(1)

1.9"(1)

2.3"(1)

2.5"(1)

2.9"(1)

1.25"(1)

 
Size

1 x 1.75(3)

3.13 x 6(1)

 
Overall Width

36"(7)

42"(4)

30"(1)

48"(1)

 
Overall Depth

18"(11)

16"(1)

24"(1)

 
Flavor

Assorted(7)

Original Marshmallow(2)

Salted Caramel Chocolate(2)

Randomly Assorted(2)

Caramel(1)

Chocolate Peanut Butter(1)

 
Diameter

8.5"(5)

6.87"(2)

8.9"(1)

10.13"(1)

8"(1)

 
Binder Sheet Size

11 x 8.5(2)

 
Binder Style

View(2)

 
Beverage Type

Latte(1)

 
Paper Color(s)

White(2)

 
 
 
 

© 2025-2026 Office 8, All Rights Reserved

Powered by Dealer Commander