Banner1 Banner1
 
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') 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

Index Dividers(18)

Boards(13)

Dry-Erase Boards(11)

Ballpoint Retractable Pens(10)

Permanent Markers(7)

Adhesive Note Pads(7)

Paper Pads/Note Pads(7)

Appointment Books & Planners(6)

Cocoa(6)

Air Purifiers/Cleaners(5)

Dishwashing Detergents & Liquids(5)

Presentation / View Binders(5)

Cleaning Cloths & Wipes(4)

Memo / Subject Notebooks(4)

Dry Erase Markers(4)

Gel Ink Pens(4)

Easel Pads(4)

Disinfectants & Sanitizers(4)

Snacks(4)

Calculators(4)

Glue Sticks & Pens(4)

Packaging Tapes(3)

Liquid Highlighters(3)

Sit-Stand Base/Components(3)

Custom Date Stamps(3)

Felt-tip/Porous Point Pens(3)

Letter, Legal & Jr. Pads(3)

Folding Tables(3)

Storage Boxes & Containers(2)

Sit-Stand Desk Components(2)

Index Tabs & Page Markers(2)

Toilet Bowl Cleaners(2)

Insertable Tab Index Dividers(2)

Towels & Wipes(2)

Pencils(2)

Air Fresheners & Odor Eliminators(2)

Wall Planners & Organizers(2)

Notebooks(2)

Portable Storage Files & Bins(2)

Filler Papers(2)

Shredders(2)

Manila Guides(2)

Disinfectants(2)

Monitor Arms(2)

Dishwashing Detergents(2)

Reception, Side & Guest Chairs(2)

Pens/Markers/Highlighters(2)

All Purpose Cleaners & Degreasers(1)

Copy & Multi-use Colored Paper(1)

Perforated Roll & Hand Towels(1)

Furniture Cleaners(1)

Hard Drives(1)

Sorters(1)

Mice(1)

Expanding Files(1)

Tabletop Sorters/Racks(1)

Hole Punch(1)

Log Books & Journals(1)

Desktop Hole Punches(1)

Title Stamps(1)

AV Cables(1)

Power Strips(1)

Office Paper(1)

Fine Stationery(1)

Stretch Wrap & Dispensers(1)

Computer Cloths/Wipes & Dusters(1)

Metal Lateral Files(1)

Calendar Desk Pads(1)

Clothes Racks(1)

Hooks & Hangers(1)

Speakers(1)

Chairs/Stools(1)

Folding/Stacking Chairs & Carts(1)

Stools & Drafting Chairs(1)

All-Purpose Glues(1)

File Boxes(1)

Adhesives/Glues(1)

Copy & Multi-use White Paper(1)

Doorstops(1)

Buckets(1)

Tables(1)

Utility & Breakroom Tables(1)

Wireless Routers(1)

Multimedia Speakers(1)

Headphones(1)

Packing Tapes(1)

Bubble Wraps(1)

File Guides(1)

Pressboard Guides(1)

Floor & Carpet Cleaners(1)

Floor Cleaners(1)

Mops & Mop Refills(1)

Toilet Tissues(1)

 
Brand

Universal(33)

Post-it®(18)

Fellowes(14)

Sharpie(12)

HON(10)

At-A-Glance(9)

Pentel(9)

Scotch(6)

Quartet(6)

Dawn(6)

U Brands(5)

TOPS(5)

Samsill(5)

Paper Mate(5)

Zebra Pen(5)

Elmer's(5)

Clorox(5)

Black n' Red(4)

Innovera(4)

Pendaflex(4)

KIND(4)

Avery®(4)

Trodat(4)

Smead(3)

Expo(3)

Windsoft(3)

Bankers Box(3)

Tripp Lite(2)

LYSOL Brand(2)

GBC(2)

Glade(2)

Verbatim(2)

Pledge(2)

Swingline(2)

Rubbermaid Commercial(2)

Professional LYSOL Brand(2)

Microban Professional(2)

Dawn Professional(2)

Mead(2)

Alba(2)

Iceberg(2)

Nestle Hot Cocoa(2)

Nestlé(1)

Linksys(1)

Astrobrights(1)

Logitech(1)

Morpheus 360(1)

Belkin(1)

Southworth(1)

Nestle Professional(1)

Café Escapes®(1)

International Paper(1)

Gorilla Glue(1)

Windex(1)

EXPO(1)

Bounty(1)

Advantus(1)

Café Escapes(1)

Mr. Clean(1)

 
Color

Black(17)

Clear(8)

Blue(7)

White(7)

Canary Yellow(7)

Gray(3)

Purple(3)

Yellow(2)

Red(2)

Silver(2)

Ivory(1)

Cosmic Orange(1)

Re-entry Red(1)

Lunar Blue(1)

Solar Yellow(1)

Translucent Blue(1)

Lime(1)

Turquoise(1)

Hot Pink(1)

Coral(1)

Multi(1)

Brown(1)

Putty(1)

Terra Green(1)

 
Brightness

92(1)

 
Binder Capacity

1"(5)

 
Recycled

No(99)

Yes(34)

 
Height

0.50"(2)

10.8"(2)

27.3"(2)

73.67"(1)

28"(1)

9.5"(1)

30"(1)

24"(1)

7.4"(1)

0.63"(1)

15.6"(1)

30.50"(1)

9.6"(1)

32"(1)

25.5"(1)

36"(1)

5.9"(1)

25.1"(1)

20.5"(1)

17.3"(1)

15.5"(1)

11.1"(1)

10.5"(1)

10.6"(1)

49.8"(1)

35.8"(1)

5.98"(1)

0.7"(1)

 
Color(s)

White(8)

Black(3)

Black/Silver(2)

Clear/Blue(1)

Clear(1)

 
Depth

8.5"(2)

8.1"(2)

19"(2)

24.1"(2)

1"(1)

4.8"(1)

12"(1)

4.5"(1)

21"(1)

18"(1)

27.8"(1)

14"(1)

7.1"(1)

2.6"(1)

18.6"(1)

6"(1)

8.6"(1)

17.38"(1)

17.4"(1)

23.8"(1)

24"(1)

6.61"(1)

4.7"(1)

 
Size

4.13 x 2.5(1)

4.67 x 2.76 x 0.47(1)

5.75 x 4.75(1)

6.5 x 4.13 x 0.63(1)

1.88" x 54.6 yds(1)

 
Packing Type

Aerosol Spray(5)

Bottle(5)

Spray Bottle(2)

Smart Tube Spray Bottle(1)

Refill Bottle(1)

K-Cup(1)

Box(1)

Roll(1)

 
Refillable

Yes(4)

No(2)

 
Overall Width

5"(1)

48"(1)

 
Overall Depth

3.75"(1)

24"(1)

 
Flavor

Dark Chocolate(3)

Chocolate(3)

Sea Salt(2)

Almond(2)

Milk Chocolate(1)

Caramel(1)

Butter(1)

Cocoa(1)

Rich Chocolate(1)

 
Closure

Lift-Off Lid(1)

 
Diameter

5"(1)

 
Base Color

Black(1)

 
Beverage Type

Hot Cocoa(2)

 
 
 
 

© 2022-2023 Office 8, All Rights Reserved