0

 

Total:$0.00

 
 
 
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 ((`desc_short` like 'k-cups' OR `desc_long` like 'k-cups' OR `desc_title` like 'k-cups' OR `keywords` like 'k-cups' OR `category_1` like 'k-cups' OR `category_2` like 'k-cups' OR `category_3` like 'k-cups' OR `category_4` like 'k-cups' OR `manufacturer_name` like 'k-cups' OR `color` like 'k-cups') OR (MATCH(`desc_short`, `desc_long`, `desc_title`, `keywords`, `category_1`, `category_2`, `category_3`, `category_4`, `manufacturer_name`, `color`) AGAINST('+(>kcups>kcups)' IN BOOLEAN MODE) OR MATCH(`desc_short`, `desc_long`, `desc_title`, `keywords`, `category_1`, `category_2`, `category_3`, `category_4`, `manufacturer_name`, `color`) AGAINST('"k-cups"' IN BOOLEAN MODE) OR (`pinfo`.`sku` like '%k-cups%' OR `pinfo`.`sku` like '%kcups%' OR (FIND_IN_SET('k-cups', REPLACE(`keywords`,' ;', ',')) OR FIND_IN_SET('k-cups', REPLACE(`keywords`,'; ', ',')) OR FIND_IN_SET('k-cups', REPLACE(`keywords`,';', ',')) OR FIND_IN_SET('k-cups', REPLACE(`keywords`,' ,', ',')) OR FIND_IN_SET('k-cups', REPLACE(`keywords`,', ', ','))) ) OR (CASE WHEN `pinfo`.`vendor`=2 THEN `pinfo`.`desc_long` like 'k-cups' ELSE `pinfo`.`desc_title` like 'k-cups' END))) 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 '%kcups' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('kcups' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+kcups' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"kcups"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"kcups"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"kcups"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"kcups"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+kcups' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='kcups',`category_4` ='kcups') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'kcups,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('kcups', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Keyword

K Cups

Refine Search

  GO
 
Category

Cups(359)

Cups & Mugs(289)

Coffee(102)

Cup Lids(93)

Food Containers(69)

Pencil Holders(25)

Coffee Condiments(16)

Cups & Mugs Accessories(15)

Snacks(14)

Candy, Gum & Mints(13)

Tea(13)

Cup Trays(9)

Thermos/Carafe(7)

Air Fresheners/Odor Eliminators(7)

Utensils(6)

Storage Boxes & Containers(6)

Pencil Boxes(5)

Beverage Straws & Stir Sticks(4)

Dinnerware(4)

Cocoa(4)

Cup Sleeves(4)

Desktop Organizers(3)

Storage Pouches(3)

Cup Dispensers/Organizers(3)

Medicines(3)

Plates(2)

Coffee and Tea Filters(2)

Coffee Brewers(2)

Cleaning Kits(2)

Water Filters & Purifying Dispensers(2)

Craft Supplies(2)

Breakroom Organizers(1)

Cup Dispensers(1)

Juices(1)

Condiments(1)

Creative Learning(1)

Condiments & Other Food(1)

Suction Cup Hooks(1)

Binder Pockets(1)

Multimedia Player Cases & Bags(1)

Decanters/Pitchers(1)

Drug Testing Kits(1)

Multimedia Player Chargers(1)

Coffee Makers(1)

 
Brand

Dart(299)

Dixie(103)

Eco-Products(77)

Genuine Joe(70)

Boardwalk(58)

Solo(51)

SOLO Cup Company(46)

Pactiv(20)

World Centric(19)

Fabri-Kal(19)

Green Mountain Coffee(17)

Starbucks(14)

Konie(12)

Huhtamaki(12)

Coffee-mate(11)

Reese's(10)

Advantus(9)

Hefty(8)

SKILCRAFT(8)

Snack Box Pros(7)

Genpak(7)

Hormel(7)

Fresh Products(7)

Dunkin Donuts(6)

CEP(6)

Celestial Seasonings(6)

Tully's Coffee(6)

Caribou Coffee(6)

Chinet(5)

Comet(5)

Green Mountain Coffee Roasters®(5)

Lavazza(5)

International Delight(4)

Gevalia(4)

The Original Donut Shop(4)

Gloria Jean's(4)

Café Escapes(4)

Lorell(4)

WNA(4)

Classicware(4)

Keurig(4)

Bigelow(3)

We Proudly Serve(3)

Maxwell House(3)

Tim Hortons(3)

Artistic(3)

Rolodex(3)

revv(3)

Panera Bread at HOME(3)

Dole(3)

Brita(3)

Barista Prima Coffeehouse(3)

Hoffmaster(2)

Rubbermaid Commercial(2)

Kellogg's(2)

Five Star(2)

Coffee Pro(2)

OIC(2)

Reynolds Food Packaging(2)

Rubbermaid(2)

Bare(2)

San Jamar(2)

Sparco(2)

Storex(2)

NatureHouse(2)

Victor(2)

Weiman(2)

Sabra(2)

AJM Packaging Corporation(2)

National Brand(2)

Eight O'Clock(2)

Aurora(2)

PerfecTouch(2)

Krispy Kreme Doughnuts®(2)

Diedrich Coffee(2)

Newman's Own Organics(2)

Emeril's(2)

Kahlúa(2)

Fellowes(1)

Mind Reader(1)

Georgia-Pacific(1)

Wholly Guacamole(1)

Dixie®(1)

Njoy(1)

Deflecto(1)

TOPS(1)

Brilliant Basics(1)

Creativity Street(1)

WinCup(1)

Dentyne Ice(1)

Business Source(1)

Baumgartens(1)

Gem Office Products(1)

Milan(1)

Chobani(1)

Office Suites(1)

GEN(1)

Jif(1)

CLI(1)

Hygloss(1)

Krispy Kreme Doughnuts(1)

International Paper(1)

Lipton(1)

Snapple(1)

Keebler(1)

Kraft(1)

Peet's Coffee & Tea(1)

Caribou Coffee®(1)

Carnation(1)

Jif To Go(1)

Green Mountain(1)

Del Monte(1)

Café Bustelo(1)

Brew Rite(1)

Dopaco(1)

Swiss Miss(1)

ZIPIT(1)

 
Color

White(126)

Clear(81)

Multi(36)

Black(25)

Green(22)

Brown(18)

Translucent(16)

Assorted(14)

Red(10)

Maroon(7)

Blue(5)

Assorted Bright(5)

Beige(3)

Purple(2)

Gray(2)

Multicolor(2)

Coffee Haze(2)

Silver(2)

Mahogany(1)

Transparent(1)

Teal(1)

Yellow(1)

Crystal Clear(1)

Green Edge(1)

Amber(1)

Tan(1)

Kraft(1)

Pink(1)

Clear Base(1)

Gunmetal Gray(1)

Arctic Blue(1)

 
Size

7.75" Length x 0.24" Diameter(2)

7.75" Length x 0.22" Diameter(1)

7.50" Length(1)

 
Recycled

No(303)

Yes(25)

 
 
 

© 2020-2021 Regal Office Supplies, All Rights Reserved