0

 

Total:$0.00

QUICK VIEW 0
 

 
 
 
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') 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(349)

Cups & Mugs(259)

Cup Lids(96)

Coffee(92)

Food Containers(73)

Pencil Holders(27)

Tea(14)

Coffee Condiments(12)

Cups & Mugs Accessories(10)

Snacks(9)

Thermos/Carafe(7)

Cup Trays(7)

Air Fresheners/Odor Eliminators(7)

Storage Pouches(6)

Cocoa(6)

Storage Boxes & Containers(6)

Pencil Boxes(5)

Utensils(5)

Beverage Straws & Stir Sticks(4)

Coffee Brewers(4)

Medicines(4)

Dinnerware(3)

Desktop Organizers(3)

Cup Sleeves(3)

Coffee Makers(2)

Coffee Filters(2)

Plates(2)

Craft Supplies(2)

Cup Dispensers/Organizers(2)

Condiments(1)

Creative Learning(1)

Breakroom Organizers(1)

Juices(1)

Decanters/Pitchers(1)

Water Filters & Purifying Dispensers(1)

Multimedia Player Cases & Bags(1)

Suction Cup Hooks(1)

Binder Pockets(1)

Drug Testing Kits(1)

Multimedia Player Chargers(1)

 
Brand

Dart(299)

Dixie(99)

Genuine Joe(70)

Eco-Products(68)

Boardwalk(58)

SOLO Cup Company(48)

Solo(39)

Green Mountain Coffee(18)

Fabri-Kal(17)

Starbucks(14)

Konie(12)

Advantus(10)

Pactiv(10)

Hefty(8)

Fresh Products(7)

Coffee-mate(7)

Hormel(7)

Tully's Coffee(7)

SKILCRAFT(7)

Caribou Coffee(7)

Genpak(7)

Dart®(7)

Celestial Seasonings(6)

CEP(6)

NatureHouse(6)

Dunkin Donuts(6)

Chinet(6)

Comet(6)

Keurig(5)

Lorell(5)

Lavazza(5)

Rubbermaid Commercial(5)

Café Escapes(4)

Gevalia(4)

ZIPIT(4)

International Delight(4)

Green Mountain Coffee Roasters(4)

Dixie®(4)

Gloria Jean's(4)

Classicware(4)

Panera Bread at HOME(3)

Coffee Pro(3)

Rolodex(3)

Rubbermaid(3)

WNA(3)

Milan(3)

Artistic(3)

revv(3)

Tim Hortons(3)

Maxwell House(3)

Bigelow(3)

Reynolds Food Packaging(2)

Five Star(2)

PerfecTouch(2)

OIC(2)

The Original Donut Shop(2)

Dole(2)

Krispy Kreme(2)

Brita(2)

Hoffmaster(2)

Bare(2)

Sparco(2)

Storex(2)

Victor(2)

WinCup(2)

Aurora(2)

Kellogg's(2)

AJM Packaging Corporation(2)

Lipton(2)

Diedrich Coffee(2)

Laughing Man® Coffee Company(2)

Newman's Own Organics(2)

Eight O'Clock(2)

Swiss Miss(2)

Folgers(1)

Deflecto(1)

Krispy Kreme Doughnuts(1)

Creativity Street(1)

We Proudly Serve(1)

Snapple(1)

Barista Prima Coffeehouse(1)

BUNN(1)

Njoy(1)

Plastifar(1)

Savannah(1)

TOPS(1)

Café Bustelo(1)

Business Source(1)

Baumgartens(1)

Gem Office Products(1)

Donut House(1)

Dunkin Donuts®(1)

Dopaco(1)

Kraft(1)

Kahlúa(1)

GEN(1)

Jif(1)

Hygloss(1)

Brilliant Basics(1)

International Paper(1)

Office Suites(1)

Keebler(1)

Green Mountain(1)

Gatorade(1)

Fellowes(1)

Keurig®(1)

Carnation(1)

Mind Reader(1)

Georgia-Pacific(1)

AbilityOne(1)

Bigelow®(1)

Office Settings(1)

CLI(1)

 
Color

White(115)

Clear(73)

Multi(31)

Black(26)

Brown(17)

Assorted(14)

Green(13)

Red(10)

Maroon(7)

Translucent(6)

Assorted Bright(6)

Blue(5)

Purple(3)

Silver(3)

Coffee Haze(2)

Gray(2)

Pink(2)

Multicolor(2)

Beige(2)

Clear Base(1)

Kraft(1)

Tan(1)

Crystal Clear(1)

Green Edge(1)

Transparent(1)

Bronze(1)

Yellow(1)

Teal(1)

Mahogany(1)

Gunmetal Gray(1)

 
Size

7.75" Length x 0.24" Diameter(2)

7.75" Length x 0.22" Diameter(1)

7.50" Length(1)

 
Recycled

No(273)

Yes(22)

 
 
 

© 2019-2020 Regal Office Supplies, All Rights Reserved