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

Cups & Mugs(301)

Coffee(98)

Cup Lids(90)

Food Containers(70)

Pencil Holders(25)

Cups & Mugs Accessories(16)

Coffee Condiments(14)

Snacks(14)

Candy, Gum & Mints(13)

Cup Trays(12)

Tea(12)

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)

Craft Supplies(4)

Medicines(3)

Desktop Organizers(3)

Water Filters & Purifying Dispensers(3)

Cup Dispensers/Organizers(3)

Storage Pouches(3)

Plates(2)

Coffee and Tea Filters(2)

Cleaning Kits(2)

Cup Dispensers(1)

Juices(1)

Breakroom Organizers(1)

Condiments(1)

Condiments & Other Food(1)

Suction Cup Hooks(1)

Binder Pockets(1)

Multimedia Player Cases & Bags(1)

Creative Learning(1)

Coffee Brewers(1)

Decanters/Pitchers(1)

Drug Testing Kits(1)

Multimedia Player Chargers(1)

Coffee Makers(1)

 
Brand

Dart(298)

Dixie(106)

Eco-Products(77)

Genuine Joe(73)

Boardwalk(58)

Solo(52)

SOLO Cup Company(47)

Pactiv(24)

Fabri-Kal(19)

World Centric(19)

Green Mountain Coffee(18)

Starbucks(15)

Huhtamaki(12)

Konie(11)

Reese's(10)

Advantus(9)

Coffee mate(8)

SKILCRAFT(8)

Hefty(8)

Fresh Products(7)

Chinet(7)

Genpak(7)

Snack Box Pros(7)

Hormel(7)

Celestial Seasonings(6)

Comet(6)

CEP(6)

Caribou Coffee(5)

Dunkin Donuts(5)

Lavazza(5)

Tully's Coffee(5)

Green Mountain Coffee Roasters®(5)

Brita(4)

Classicware(4)

WNA(4)

Café Escapes(4)

The Original Donut Shop(4)

Gloria Jean's(4)

Lorell(4)

Panera Bread at HOME(3)

Barista Prima Coffeehouse(3)

Dole(3)

revv(3)

Creativity Street(3)

Maxwell House(3)

Bigelow(3)

Gevalia(3)

Keurig(3)

International Delight(3)

Tim Hortons(3)

Rolodex(3)

Georgia Pacific Professional(3)

We Proudly Serve(3)

Artistic(3)

Kellogg's(2)

Weiman(2)

Sparco(2)

Five Star(2)

Victor(2)

Coffee-mate(2)

Coffee Pro(2)

San Jamar(2)

Rubbermaid Commercial(2)

NatureHouse(2)

Reynolds Food Packaging(2)

Hoffmaster(2)

Rubbermaid(2)

Storex(2)

Bare(2)

OIC(2)

AJM Packaging Corporation(2)

Sabra(2)

PerfecTouch(2)

Aurora(2)

Krispy Kreme Doughnuts®(2)

National Brand(2)

Diedrich Coffee(2)

Eight O'Clock(2)

Kahlúa(2)

Fellowes(2)

Emeril's(2)

Jif(1)

Brilliant Basics(1)

Mind Reader(1)

Georgia-Pacific(1)

TOPS(1)

Njoy(1)

Swiss Miss(1)

Deflecto(1)

WinCup(1)

Dentyne Ice(1)

Business Source(1)

Baumgartens(1)

Gem Office Products(1)

Milan(1)

GEN(1)

Dopaco(1)

Newman's Own Organics(1)

Kraft(1)

Chobani(1)

Brew Rite(1)

Hygloss(1)

Del Monte(1)

International Paper(1)

Jif To Go(1)

Keebler(1)

CLI(1)

Café Bustelo(1)

Caribou Coffee®(1)

Carnation(1)

Krispy Kreme Doughnuts(1)

Lipton(1)

Peet's Coffee & Tea(1)

Green Mountain(1)

Wholly Guacamole(1)

ZIPIT(1)

 
Color

White(135)

Clear(85)

Multi(37)

Black(25)

Green(22)

Brown(18)

Translucent(16)

Assorted(15)

Red(10)

Maroon(7)

Blue(5)

Assorted Bright(5)

Beige(3)

Purple(2)

Gray(2)

Multicolor(2)

Coffee Haze(2)

Kraft(2)

Silver(2)

Mahogany(1)

Teal(1)

Yellow(1)

Crystal Clear(1)

Transparent(1)

Green Edge(1)

Amber(1)

Tan(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(317)

Yes(25)

 
 
 

© 2020-2021 Regal Office Supplies, All Rights Reserved