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

Cups & Mugs(260)

Cup Lids(97)

Coffee(94)

Food Containers(73)

Pencil Holders(27)

Tea(14)

Coffee Condiments(13)

Cups & Mugs Accessories(10)

Snacks(9)

Cup Trays(8)

Air Fresheners/Odor Eliminators(7)

Thermos/Carafe(7)

Cocoa(6)

Storage Pouches(6)

Storage Boxes & Containers(6)

Utensils(5)

Pencil Boxes(5)

Medicines(4)

Cup Sleeves(4)

Beverage Straws & Stir Sticks(4)

Desktop Organizers(3)

Dinnerware(3)

Coffee Brewers(3)

Coffee Makers(2)

Coffee Filters(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(303)

Dixie(99)

Genuine Joe(70)

Eco-Products(70)

Boardwalk(58)

SOLO Cup Company(48)

Solo(40)

Fabri-Kal(21)

Green Mountain Coffee(18)

Starbucks(14)

Konie(12)

Pactiv(10)

Advantus(10)

Hefty(8)

Coffee-mate(7)

Hormel(7)

Caribou Coffee(7)

Tully's Coffee(7)

Genpak(7)

Fresh Products(7)

SKILCRAFT(7)

NatureHouse(7)

Comet(6)

Chinet(6)

CEP(6)

Celestial Seasonings(6)

Dunkin Donuts(6)

Dart®(5)

International Delight(5)

Lorell(5)

Lavazza(5)

Keurig(5)

Rubbermaid Commercial(5)

Café Escapes(4)

Gevalia(4)

Classicware(4)

ZIPIT(4)

Gloria Jean's(4)

Green Mountain Coffee Roasters(4)

Dixie®(4)

Coffee Pro(3)

Milan(3)

WNA(3)

Rubbermaid(3)

WinCup(3)

Panera Bread at HOME(3)

Rolodex(3)

revv(3)

Tim Hortons(3)

Maxwell House(3)

Bigelow(3)

Artistic(3)

PerfecTouch(2)

The Original Donut Shop(2)

OIC(2)

Krispy Kreme(2)

Kellogg's(2)

Aurora(2)

Kraft(2)

Reynolds Food Packaging(2)

Sparco(2)

Storex(2)

Brita(2)

Bare(2)

Hoffmaster(2)

Dole(2)

Victor(2)

Five Star(2)

Lipton(2)

Kahlúa(2)

Eight O'Clock(2)

Laughing Man® Coffee Company(2)

Newman's Own Organics(2)

Swiss Miss(2)

AJM Packaging Corporation(2)

Diedrich Coffee(2)

SCT(1)

Café Bustelo(1)

We Proudly Serve(1)

Deflecto(1)

Snapple(1)

Barista Prima Coffeehouse(1)

Savannah(1)

Business Source(1)

Baumgartens(1)

Gem Office Products(1)

Green Mountain(1)

BUNN(1)

Emeril's(1)

Creativity Street(1)

Krispy Kreme Doughnuts(1)

TOPS(1)

Njoy(1)

Plastifar(1)

Brilliant Basics(1)

Keebler(1)

CLI(1)

Office Suites(1)

International Paper(1)

Jif(1)

Folgers(1)

GEN(1)

Hygloss(1)

Bigelow®(1)

Carnation(1)

Georgia-Pacific(1)

Dopaco(1)

Gatorade(1)

Office Settings(1)

Dunkin Donuts®(1)

Fellowes(1)

AbilityOne(1)

Mind Reader(1)

Donut House(1)

 
Color

White(115)

Clear(73)

Multi(32)

Black(26)

Brown(17)

Assorted(14)

Green(13)

Red(10)

Maroon(7)

Translucent(6)

Assorted Bright(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