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

Cups(14)

Chairs/Stools(11)

Cutlery Kits(11)

Foil Wraps(10)

Shipping Boxes(10)

Cushioned Mailers(9)

Clips/Clamps(9)

Low-Density Trash Bags(8)

Feminine Care Products(7)

Packing Tapes(7)

All Purpose Cleaners & Degreasers(6)

Web Cameras/Webcams(6)

Tables(6)

File Cabinets(6)

Labels(5)

Bottled Water(5)

Stretch Film & Shrink Wrap(5)

Feminine Care Dispensers & Receptacles(5)

Feminine Care Dispenser Liners(5)

Condiments(4)

Office Paper(4)

Cup Lids(4)

Hand Soaps(4)

Cleaning Products(4)

Shelving Units/Bookcases(4)

Floor Pads-Stripping(4)

Markers(4)

Disposable Spoons(4)

Pens(3)

Composition Books(3)

Headsets(3)

Packing Tape Dispensers(3)

Highlighters(3)

Packaging Materials(3)

General Purpose Notebooks(3)

Disinfectants & Sanitizers(3)

Permanent Markers(3)

Toilet Tissues(3)

Towels & Wipes(3)

Executive & Office Desk Components(3)

Floor Pads-Cleaning, Buffing & Polishing(3)

Sanitizing Wipes(2)

Reporting & Stenography Pads(2)

Sectionals(2)

Benches & Ottomans(2)

Returns(2)

Art Markers(2)

Scouring Pads & Sticks(2)

Kitchen & Service Carts(2)

Decaffeinated(2)

Food & Utility Bags(2)

Self-Stick Note Pads(2)

Easel Pads(2)

Caffeinated(2)

Disposable Forks(2)

Calculators(2)

Disposable Knives(2)

Souffle & Portion Cups(1)

Hutches(1)

Desktop File Folder Sorters(1)

Credenzas(1)

Bar Soaps(1)

Sofas(1)

Soap Refills(1)

Log Books & Journals(1)

General Purpose Pads(1)

Medicines(1)

Footrests(1)

Pencils(1)

Storage Cabinets(1)

Knives & Multi-Purpose Tools(1)

Cases(1)

Boards(1)

Snacks(1)

Glass Cleaners(1)

Roll Cutters(1)

Cable Management(1)

Scissors & Speed Cutters(1)

Indoor Dining & Cafe Tables(1)

Page Flags(1)

High-Density Trash Bags(1)

Drawstring & Kitchen Bags(1)

Face Masks(1)

Luncheon Napkins(1)

School & Reading Desks(1)

Executive & Office Desks(1)

Carts & Trucks(1)

Carts(1)

Copier/Fax/Multifunction Machines(1)

Speakers(1)

Label Makers(1)

Disposable Sporks(1)

 
Brand

Boardwalk(75)

Universal(50)

Alera(38)

Scotch(19)

HOSPECO(8)

Dart(8)

Dixie(7)

Rubbermaid Commercial(6)

Innovera(6)

Eco-Products(6)

Adesso(6)

Avery(5)

GEN(5)

Sharpie(5)

Pregis(5)

HON(5)

Softsoap(5)

Crystal Geyser(5)

Windsoft(4)

Kotex(3)

Smucker's(3)

Nescafé(3)

PURELL(3)

Fabri-Kal(3)

Post-it Easel Pads Super Sticky(2)

Always(2)

Tampax(2)

Setton Farms(1)

Solo(1)

U Brands(1)

Tork(1)

Spracht(1)

Midol(1)

Jif(1)

Windex(1)

Clorox(1)

Starbucks(1)

Iceberg(1)

Brother(1)

HP(1)

Microban(1)

COSCO(1)

Post-it Flags(1)

Post-it Notes(1)

Post-it Notes Super Sticky(1)

Dial(1)

 
Height

8"(4)

32"(3)

6"(3)

3"(3)

58"(3)

10.5"(2)

10.75"(2)

5.5"(2)

1.66"(2)

1.47"(2)

4"(2)

12"(2)

11"(1)

9"(1)

8.5"(1)

1.75"(1)

7.75"(1)

11.63"(1)

18"(1)

2.36"(1)

7.1"(1)

9.38"(1)

7.82"(1)

3.38" to 5.13"(1)

2"(1)

2.6"(1)

5.89"(1)

46"(1)

39"(1)

33"(1)

27.4"(1)

13.5"(1)

 
Color(s)

Black(39)

Clear(38)

White(30)

Brown(14)

Brown Kraft(10)

Gray(7)

Silver(6)

Red(5)

Translucent(4)

Natural Kraft(4)

Black/Silver(3)

Crystal Clear(2)

Black/Mahogany(2)

Mahogany(2)

Medium Cherry(2)

Stainless Steel(1)

Putty(1)

Assorted Brights(1)

Canary Yellow(1)

Supernova Neons Collection(1)

Black /Silver(1)

Tan(1)

Green(1)

Aqua(1)

Orange(1)

Blue/Black(1)

Blue(1)

Charcoal(1)

Natural(1)

Semi-Opaque Black(1)

 
Depth

9"(2)

4.5"(2)

2.36"(1)

5.25"(1)

0.75"(1)

1.5"(1)

4"(1)

7"(1)

3.25"(1)

3"(1)

4.88"(1)

17.35"(1)

17.75"(1)

1.4"(1)

2.6"(1)

2.5"(1)

8.8"(1)

8.3"(1)

8.31"(1)

6"(1)

5.3"(1)

12"(1)

8.75"(1)

 
Size

1.88" x 54.6 yds(3)

4" x 9"(1)

7.21 x 5.31 x 1.52(1)

6.5 x 4.13 x 0.63(1)

1.88" x 66.66 ft(1)

1.88" x 22.2 yds(1)

1.88" x 10 yds(1)

0.5 x 1.75(1)

1.88" x 25 yds(1)

 
Overall Width

14"(3)

26.38"(3)

72"(2)

36"(2)

35.63"(2)

11.81"(2)

15.63"(2)

47.25"(1)

25.9"(1)

18.63"(1)

34"(1)

70.63"(1)

42"(1)

96"(1)

70.88"(1)

65.75"(1)

65.13"(1)

60"(1)

48"(1)

34.13"(1)

 
Overall Depth

11.81"(4)

18"(4)

30"(2)

24"(2)

26.38"(2)

20.5"(2)

29.63"(1)

36"(1)

21.5"(1)

26.13"(1)

22.25"(1)

15"(1)

22.75"(1)

33.63"(1)

45.2"(1)

17.38"(1)

 
Flavor

Spring(3)

House Blend(1)

Decaffeinated(1)

Decaf House Blend(1)

Pike Place Roast(1)

Sweet & Salty(1)

Creamy Peanut Butter(1)

Honey(1)

Strawberry(1)

Concord Grape(1)

 
Diameter

20"(5)

7"(4)

9"(4)

13"(1)

17"(1)

36"(1)

0.75"(1)

5"(1)

 
Base Color

Charcoal(1)

Black Anthracite(1)

Gray(1)

Black(1)

Silver(1)

 
Beverage Type

Water(5)

Instant Coffee(3)

Coffee(1)

 
Opening

Open End(9)

 
Folded Height

3.5"(2)

2"(1)

 
 
 
 

© 2024-2025 Office 8, All Rights Reserved