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

Cups & Mugs(260)

Cup Lids(96)

Coffee(92)

Food Containers(73)

Pencil Holders(27)

Coffee Condiments(13)

Tea(13)

Cups & Mugs Accessories(10)

Snacks(9)

Air Fresheners/Odor Eliminators(7)

Thermos/Carafe(7)

Cup Trays(7)

Storage Boxes & Containers(6)

Storage Pouches(6)

Pencil Boxes(6)

Cocoa(5)

Utensils(5)

Medicines(4)

Beverage Straws & Stir Sticks(4)

Desktop Organizers(3)

Dinnerware(3)

Cup Sleeves(3)

Coffee Brewers(3)

Coffee Filters(2)

Coffee Makers(2)

Plates(2)

Cup Dispensers/Organizers(2)

Craft Supplies(2)

Suction Cup Hooks(1)

Binder Pockets(1)

Multimedia Player Chargers(1)

Drug Testing Kits(1)

Multimedia Player Cases & Bags(1)

Decanters/Pitchers(1)

Meals & Snack Bars(1)

Creative Learning(1)

Breakroom Organizers(1)

Juices(1)

Condiments(1)

Water Filters & Purifying Dispensers(1)

 
Brand

Dart(304)

Dixie(99)

Eco-Products(70)

Genuine Joe(70)

Boardwalk(58)

SOLO Cup Company(49)

Solo(40)

Fabri-Kal(21)

Green Mountain Coffee(18)

Starbucks(14)

Konie(12)

Advantus(10)

Pactiv(10)

NatureHouse(9)

Hefty(8)

Tully's Coffee(7)

Genpak(7)

Caribou Coffee(7)

Fresh Products(7)

Hormel(7)

Coffee-mate(7)

SKILCRAFT(7)

Dunkin Donuts(6)

CEP(6)

Celestial Seasonings(6)

Comet(6)

Chinet(5)

Keurig(5)

International Delight(5)

Lorell(5)

Rubbermaid Commercial(5)

Lavazza(5)

ZIPIT(4)

Gevalia(4)

Café Escapes(4)

Gloria Jean's(4)

Green Mountain Coffee Roasters(4)

Classicware(4)

Rolodex(3)

Panera Bread at HOME(3)

Rubbermaid(3)

revv(3)

Coffee Pro(3)

Bigelow(3)

Storex(3)

Artistic(3)

Maxwell House(3)

Tim Hortons(3)

WinCup(3)

WNA(3)

Milan(3)

Aurora(2)

Kraft(2)

Hoffmaster(2)

Reynolds Food Packaging(2)

The Original Donut Shop(2)

Five Star(2)

Brita(2)

Dole(2)

Kellogg's(2)

PerfecTouch(2)

Victor(2)

Kahlúa(2)

Diedrich Coffee(2)

Eight O'Clock(2)

Bare(2)

Krispy Kreme(2)

OIC(2)

Lipton(2)

Newman's Own Organics(2)

Sparco(2)

Swiss Miss(2)

AJM Packaging Corporation(2)

Njoy(1)

Office Settings(1)

Savannah(1)

SCT(1)

Emeril's(1)

TOPS(1)

Plastifar(1)

Dopaco(1)

We Proudly Serve(1)

Snapple(1)

Fellowes(1)

Mind Reader(1)

Office Suites(1)

Brilliant Basics(1)

Jif(1)

Georgia-Pacific(1)

Deflecto(1)

Baumgartens(1)

Gem Office Products(1)

Business Source(1)

BUNN(1)

Creativity Street(1)

GEN(1)

Folgers(1)

International Paper(1)

Hygloss(1)

Keebler(1)

CLI(1)

Carnation(1)

Gatorade(1)

Donut House(1)

Café Bustelo(1)

Green Mountain(1)

Barista Prima Coffeehouse(1)

Krispy Kreme Doughnuts(1)

AbilityOne(1)

 
Color

White(115)

Clear(73)

Multi(32)

Black(26)

Brown(17)

Assorted(14)

Green(13)

Red(10)

Maroon(7)

Assorted Bright(7)

Translucent(6)

Blue(5)

Silver(3)

Purple(3)

Coffee Haze(2)

Beige(2)

Multicolor(2)

Pink(2)

Gray(2)

Yellow(1)

Teal(1)

Mahogany(1)

Bronze(1)

Crystal Clear(1)

Clear Base(1)

Gunmetal Gray(1)

Kraft(1)

Tan(1)

Green Edge(1)

Transparent(1)

 
Size

7.75" Length x 0.24" Diameter(2)

7.50" Length(1)

7.75" Length x 0.22" Diameter(1)

 
Recycled

No(274)

Yes(22)

 
 
 

© 2019-2020 Regal Office Supplies, All Rights Reserved