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

Coffee(96)

Cup Lids(95)

Food Containers(70)

Pencil Holders(25)

Coffee Condiments(16)

Cups & Mugs Accessories(15)

Tea(12)

Snacks(8)

Air Fresheners/Odor Eliminators(7)

Thermos/Carafe(7)

Utensils(6)

Storage Boxes & Containers(6)

Cocoa(5)

Cup Trays(5)

Pencil Boxes(5)

Beverage Straws & Stir Sticks(4)

Medicines(4)

Dinnerware(4)

Storage Pouches(3)

Cup Sleeves(3)

Coffee Brewers(3)

Desktop Organizers(3)

Cup Dispensers/Organizers(3)

Coffee and Tea Filters(2)

Plates(2)

Craft Supplies(2)

Water Filters & Purifying Dispensers(2)

Cleaning Kits(2)

Condiments(1)

Creative Learning(1)

Decanters/Pitchers(1)

Breakroom Organizers(1)

Cup Dispensers(1)

Juices(1)

Coffee Makers(1)

Multimedia Player Cases & Bags(1)

Candy, Gum & Mints(1)

Suction Cup Hooks(1)

Binder Pockets(1)

Drug Testing Kits(1)

Multimedia Player Chargers(1)

 
Brand

Dart(302)

Dixie(105)

Eco-Products(77)

Genuine Joe(70)

Boardwalk(58)

Solo(52)

SOLO Cup Company(46)

Fabri-Kal(19)

World Centric(19)

Green Mountain Coffee(17)

Starbucks(15)

Pactiv(15)

Huhtamaki(12)

Konie(12)

Coffee-mate(11)

Advantus(9)

Hefty(8)

Fresh Products(7)

Hormel(7)

Genpak(7)

SKILCRAFT(7)

Celestial Seasonings(6)

Caribou Coffee(6)

CEP(6)

Dunkin Donuts(6)

Tully's Coffee(6)

Comet(5)

Lavazza(5)

Chinet(5)

Green Mountain Coffee Roasters®(5)

Keurig(4)

International Delight(4)

Lorell(4)

Café Escapes(4)

The Original Donut Shop(4)

Gloria Jean's(4)

WNA(4)

Classicware(4)

Gevalia(4)

Barista Prima Coffeehouse(3)

Artistic(3)

Panera Bread at HOME(3)

Coffee Pro(3)

revv(3)

Bigelow(3)

Rolodex(3)

Brita(3)

Maxwell House(3)

We Proudly Serve(3)

Tim Hortons(3)

Rubbermaid Commercial(2)

Reynolds Food Packaging(2)

Kellogg's(2)

Five Star(2)

Rubbermaid(2)

Bare(2)

San Jamar(2)

Sparco(2)

Storex(2)

OIC(2)

NatureHouse(2)

Victor(2)

Weiman(2)

Hoffmaster(2)

AJM Packaging Corporation(2)

Kahlúa(2)

Diedrich Coffee(2)

Emeril's(2)

PerfecTouch(2)

Swiss Miss(2)

Newman's Own Organics(2)

Dole(2)

Krispy Kreme Doughnuts®(2)

Eight O'Clock(2)

Aurora(2)

Dentyne Ice(1)

TOPS(1)

Creativity Street(1)

Fellowes(1)

WinCup(1)

Njoy(1)

Deflecto(1)

BUNN(1)

Business Source(1)

Baumgartens(1)

Gem Office Products(1)

Milan(1)

Georgia-Pacific(1)

Mind Reader(1)

GEN(1)

Office Suites(1)

Peet's Coffee & Tea(1)

Caribou Coffee®(1)

Krispy Kreme Doughnuts(1)

Hygloss(1)

Lipton(1)

International Paper(1)

Snapple(1)

Keebler(1)

Brilliant Basics(1)

Kraft(1)

CLI(1)

Carnation(1)

Green Mountain(1)

Café Bustelo(1)

Dopaco(1)

Jif(1)

ZIPIT(1)

 
Color

White(126)

Clear(81)

Multi(37)

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

Yes(25)

 
 
 

© 2020-2021 Regal Office Supplies, All Rights Reserved