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

Gloves & Glove Accessories(11)

Chairs/Stools(10)

Labels(10)

Batteries(10)

Floor Mats(8)

Cleaning Cloths & Wipes(7)

Cases(7)

First Aid Kits(7)

Eye Protection(7)

Table Tops(6)

Label Maker Supplies(6)

File Jackets/Sleeves/Wallets(5)

Ink Cartridges(4)

Clothing Protection(4)

Pens(4)

Monitor Filters(4)

Signs & Sign Holders(3)

Signs(3)

Ear Protection(3)

Tables(3)

Bottled Water(3)

Art Markers(3)

Label Makers(3)

Air Cleaner Machines(3)

General Purpose Pads(3)

Smoke/CO Detectors(3)

Traffic Safety(2)

Highlighters(2)

Sorbents(2)

Office Paper(2)

Interoffice Envelopes(2)

Fire Extinguishers(2)

Hand Sanitizers(2)

Disinfectants & Sanitizers(2)

Table Bases/Legs(2)

Indoor Dining & Cafe Tables(2)

Sanitizing Wipes(2)

Bleach(2)

Sofas(1)

Scanners(1)

Hanging File Systems(1)

Copier/Fax/Multifunction Machines(1)

Indexed Sorters(1)

Furniture Cleaners(1)

Clipboards(1)

Barriers(1)

Low-Density Trash Bags(1)

Loveseats(1)

Facial Tissues(1)

Catalog Reference Racks(1)

Indoor Waste Receptacles(1)

File Cabinets(1)

Inkjet Printers(1)

Reception & Lounge Tables(1)

Reporting & Stenography Pads(1)

 
Brand

Alera(19)

MCR Safety(14)

Rubbermaid Commercial(11)

Avery(10)

Smead(9)

Duracell(9)

Crown(8)

Brother P-Touch(8)

Case Logic(7)

HON(7)

WypAll(6)

First Aid Only(6)

Sharpie(5)

Kidde(5)

Brother(5)

KleenGuard(5)

Innovera(4)

Pentel(4)

TOPS(4)

PURELL(4)

3M(3)

TruSens(3)

Crystal Geyser(3)

Smith & Wesson(3)

Clorox(3)

HP(3)

Clorox Healthcare(2)

Boardwalk(2)

Saunders(1)

FireKing(1)

DocuGard(1)

PhysiciansCare by First Aid Only(1)

Energizer(1)

deflecto(1)

Durable(1)

Cascades PRO(1)

Universal(1)

 
Height

9.5"(4)

13"(2)

9"(2)

2.75"(2)

10.06"(1)

28"(1)

22"(1)

9.88"(1)

10"(1)

40"(1)

30"(1)

20"(1)

25.63"(1)

36"(1)

25"(1)

35.75"(1)

14.2"(1)

4"(1)

58"(1)

7"(1)

7.25"(1)

11.25"(1)

22.25"(1)

9.4"(1)

16.9"(1)

19.69"(1)

16.75"(1)

11"(1)

10.25"(1)

13.75"(1)

27.3"(1)

 
Color(s)

Black(16)

White(12)

Yellow(8)

Gray(6)

Blue/Gray(5)

Black/White(5)

Fluorescent Lime w/Silver Stripe(3)

Clear(3)

Blue(2)

Charcoal(2)

Redrope(2)

Manila(1)

Assorted(1)

Black/Blue(1)

Cyan; Magenta; Yellow(1)

Black/Chartreuse(1)

Yellow/Black(1)

Black/Green(1)

Tri-Color(1)

Bright Orange/Lime; Silver Reflective Strips(1)

Gray; Neon Green; Neon Orange; Neon Pink; Purple; Yellow(1)

 
Depth

1"(2)

21"(2)

9"(2)

17.1"(1)

3"(1)

10"(1)

8"(1)

10.5"(1)

12.25"(1)

12"(1)

28.36"(1)

7.38"(1)

2.75"(1)

2.5"(1)

17.75"(1)

6"(1)

5.5"(1)

0.38"(1)

1.2"(1)

11"(1)

13.39"(1)

14"(1)

1.87"(1)

1.75"(1)

18.4"(1)

 
Size

Letter(4)

50 x 1 x 13(2)

11 x 0.38 x 9.5(1)

Legal(1)

 
Overall Width

35.38"(3)

48"(2)

27.5"(2)

72"(1)

96"(1)

17.75"(1)

32.68"(1)

26.18"(1)

53.5"(1)

77"(1)

 
Overall Depth

35.38"(3)

30"(2)

27.5"(2)

26.75"(2)

24"(1)

25"(1)

20"(1)

 
Flavor

Spring(3)

 
Diameter

35.5"(3)

27.7"(1)

 
Expansion

1.25"(2)

 
Base Color

Black(2)

Silver(2)

Charcoal(1)

Mahogany(1)

 
Beverage Type

Water(3)

 
Opening

Open Side(1)

Open End(1)

 
Clip Capacity

1"(1)

 
Folded Height

2"(1)

 
 
 
 

© 2024-2025 Office 8, All Rights Reserved