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

Cups(23)

Plates(13)

Chairs/Stools(12)

Tables(11)

Cleaning Cloths & Wipes(11)

Calligraphy & Illustrator Pens(10)

Earbuds & Headphones(10)

Easel Pads(10)

Log Books & Journals(10)

Food Containers & Lids(10)

Foil Wraps(9)

Correction Tapes(9)

Pencils(9)

Cup Lids(8)

Art & Design Paper(7)

Art Markers(7)

Boards(7)

Ink Cartridges(7)

Facial Tissues(7)

Binders(7)

Hand Soaps(7)

Repro Trash Bags(6)

Pens(6)

Copier/Fax/Multifunction Machines(6)

Staplers(6)

Laser Printers(6)

Cases(6)

Bottled Water(5)

Disinfectants & Sanitizers(5)

Indoor Waste Receptacles(5)

Toner Cartridges(5)

Multimedia Projectors(5)

High-Density Trash Bags(5)

Hand Sanitizers(5)

General Purpose Notebooks(4)

Office Paper(4)

Cables(4)

Low-Density Trash Bags(4)

Cutlery Kits(4)

Inkjet Printers(4)

First Aid Kits(4)

Name Badge Kits(4)

Bowls(4)

Glue(4)

Scouring Pads & Sticks(3)

Towels & Wipes(3)

Label Maker Supplies(3)

Keyboards(3)

Scissors(3)

Table Tops(3)

Dispenser Napkins(2)

Keyboard & Mouse Combinations(2)

Monitor Filters(2)

Steam Table Parts(2)

Transcriber/Dictation Machines(2)

Adapters/Chargers(2)

Snacks(2)

Label Makers(2)

Scissors & Speed Cutters(2)

Sanitizing Wipes(2)

Caffeinated(2)

Decaffeinated(2)

Table Bases/Legs(2)

Table covers & Skirts(1)

Disposable & Single Use Gloves(1)

Beverage Napkins(1)

Permanent Markers(1)

Imaging Drums/Photoconductors(1)

Bandages(1)

Letters, Numbers & Symbols(1)

Napkin Dispensers(1)

All Purpose Cleaners & Degreasers(1)

Luncheon Napkins(1)

Hangers/Hooks(1)

Composition Books(1)

Meals & Snack Bars(1)

Locking Devices(1)

Mice(1)

Projection Screens(1)

Projector Accessories(1)

Self-Stick Note Pads(1)

 
Brand

HON(26)

Dixie(19)

Heritage(14)

SOLO(12)

Boardwalk(12)

Avery(11)

HP(11)

Epson(11)

Innovera(10)

Maxell(10)

Post-it Easel Pads Super Sticky(10)

Paper Mate(10)

Rocketbook(10)

Reynolds Wrap(9)

Eco-Products(9)

Quartet(8)

Ticonderoga(8)

Sharpie(7)

Kleenex(7)

Brother(7)

PURELL(7)

Dart(7)

Fellowes(6)

Clorox(6)

Cascades PRO(6)

Solo(6)

Zebra(6)

Rubbermaid Commercial(5)

Kensington(5)

Pacon(5)

Westcott(5)

Lexmark(5)

GEN(5)

Dial Professional(5)

Nescafé(4)

Family Guard(4)

Brother P-Touch(4)

LYSOL Brand(4)

Elmer's(4)

Universal(4)

Five Star(4)

Crystal Geyser(3)

Mr. Clean(3)

Zebra Technologies(3)

First Aid Only(3)

Prang(2)

SICURIX(2)

True Clear(2)

Magicard(2)

Kodak(2)

PhysiciansCare by First Aid Only(2)

Alera(2)

Fargo(2)

Viva(2)

Philips(2)

Tablemate(1)

Evolis(1)

Tork(1)

BIC(1)

HFA(1)

Jif To Go(1)

Jif(1)

Softsoap(1)

RePrime(1)

Dial(1)

Comet(1)

Dixon(1)

Post-it Notes Super Sticky(1)

Command(1)

Mead(1)

KIND(1)

Professional LYSOL Brand(1)

 
Brightness

4,000 lm(2)

3,200 lm(1)

3,600 lm(1)

3,800 lm(1)

 
Height

30"(5)

2.4"(5)

3"(3)

1.5"(2)

3.6"(2)

9"(2)

7"(2)

16.5"(2)

21.12"(1)

29.1"(1)

20.4"(1)

17.5"(1)

12.5"(1)

7.2"(1)

4.6"(1)

5.7"(1)

9.1"(1)

13.5"(1)

14.2"(1)

18.75"(1)

19"(1)

2"(1)

3.5"(1)

1.25"(1)

10.2"(1)

1.96"(1)

6.3"(1)

1.3"(1)

13.6"(1)

5.9"(1)

10"(1)

2.12"(1)

6.19"(1)

4.1"(1)

3.4"(1)

7.5"(1)

2.75"(1)

8"(1)

1.8"(1)

6.8"(1)

14"(1)

 
Color(s)

White(48)

Black(29)

Clear(22)

Green/Burgundy(9)

Black; Cyan; Magenta; Yellow(8)

Kraft(5)

Tan(4)

Silver(4)

Translucent(4)

Blue(3)

Gray(3)

Multicolor(3)

Yellow(2)

Magenta(2)

Cyan(2)

Dark Gray(2)

Gold(2)

Orange(2)

Black with Interchangeable Pink/Blue/Silver Caps(2)

White/Brown/Green(1)

Green(1)

Red(1)

Black/Gold(1)

Beige(1)

Cyan; Magenta; Yellow(1)

Summer Joy Collection(1)

Tri-Color(1)

Kraft/Green(1)

Light Pink(1)

Light Green(1)

Blue/White(1)

Natural(1)

Red/White(1)

Light Gray(1)

 
Depth

11"(3)

8.5"(3)

9.8"(3)

2.5"(2)

8"(2)

10.2"(2)

22"(2)

9.92"(2)

14.2"(1)

21.9"(1)

20.1"(1)

16.6"(1)

1"(1)

0.43"(1)

2"(1)

0.4"(1)

1.5"(1)

0.7"(1)

10.6"(1)

9.13"(1)

4.5"(1)

16"(1)

16.5"(1)

5.75"(1)

7"(1)

22.8"(1)

25"(1)

20.6"(1)

22.3"(1)

7.01"(1)

0.63"(1)

8.16"(1)

12"(1)

9"(1)

3"(1)

13.7"(1)

19.8"(1)

11.5"(1)

3.19"(1)

5.5"(1)

5"(1)

4,27"(1)

6.3"(1)

6.28"(1)

6.65"(1)

5.62"(1)

14.23"(1)

13.5"(1)

6"(1)

 
Size

3.62 x 2.25 x 1.5(1)

Medium(1)

 
Overall Width

72"(5)

48"(3)

60"(3)

26.18"(2)

 
Overall Depth

24"(7)

30"(4)

 
Flavor

Spring(3)

House Blend(2)

Creamy Peanut Butter(2)

Caramel Almond & Sea Salt; Dark Chocolate Nuts & Sea Salt(1)

Decaffeinated(1)

Decaf House Blend(1)

 
Diameter

8.5"(5)

6"(4)

5.8"(2)

6.78"(2)

36"(2)

9"(2)

4.6"(1)

3.6"(1)

10.13"(1)

30"(1)

5"(1)

0.45"(1)

8"(1)

 
Expansion

No(1)

 
Base Color

Black(12)

 
Binder Sheet Size

11 x 8.5(6)

8.5 x 5.5(1)

 
Binder Style

View(5)

Non-View(2)

 
Beverage Type

Water(5)

Instant Coffee(4)

 
 
 
 

© 2024-2025 Office 8, All Rights Reserved