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 (`category_id` IN ('1010')) 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 '%Coffee' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('Coffee' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Coffee' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Coffee"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Coffee"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Coffee"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Coffee"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Coffee' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Coffee',`category_4` ='Coffee') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Coffee,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Coffee', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Coffee

Refine Search

  GO
 
Brand

Green Mountain Coffee(55)

Folgers(48)

Starbucks(21)

Peet's Coffee & Tea(18)

1850(14)

Tully's Coffee(14)

Lavazza(12)

Maxwell House(12)

Caribou Coffee(10)

Eight O'Clock(9)

PapaNicholas Coffee(9)

Day to Day Coffee(8)

Melitta(8)

Dunkin Donuts(8)

New England Coffee(8)

Café Bustelo(7)

Java One(7)

Diedrich Coffee(6)

Gloria Jean's(6)

Nescafé(6)

Donut House(6)

Barista Prima Coffeehouse(5)

Newman's Own Organics(5)

The Original Donut Shop(4)

Café Escapes(4)

Seattle's Best(4)

McCafe(4)

Coffee People(4)

NESCAFÉ Dolce Gusto(4)

Gevalia(4)

revv(3)

Distant Lands Coffee(3)

Krispy Kreme Doughnuts(3)

Yuban(3)

illy(2)

Tim Hortons(2)

National Coffee Roasters(2)

Kahlúa(1)

Green Mountain Coffee Roasters®(1)

Dunkin' Donuts®(1)

Chock full o'Nuts(1)

Chase & Sanborn(1)

BUSTELO cool(1)

Cinnabon(1)

 
Quantity

24 per box(3)

96 per carton(1)

 
Packing Type

K-Cup(184)

Bag(35)

Fraction Pack(32)

Pod(24)

Packet(21)

Canister(13)

Can(11)

Filter Pack(8)

Stick(8)

Portion Pack(4)

Capsule(4)

Vacket Pack(3)

Cartridges(3)

Brick Pack(2)

Jar(1)

 
Flavor

French Roast(18)

House Blend(15)

Classic Roast(14)

Breakfast Blend(13)

Hazelnut(10)

French Vanilla(8)

Original(7)

Espresso(7)

Regular(6)

100% Colombian(6)

Assorted(6)

Medium Roast(6)

Dark Roast(5)

Black Silk(5)

Hazelnut Creme(5)

Colombian(5)

Decaffeinated(5)

Classic Roast Decaf(5)

Pioneer Blend(4)

Black Gold(4)

Major Dickason's Blend(4)

House Blend Decaf(4)

Italian Roast(4)

Decaf House Blend(3)

Lantern Glow(3)

Breakfast Blend Decaf(3)

Original Blend(3)

Caffe Verona(3)

Island Coconut(2)

Caramel Vanilla Cream(2)

Vermont Country Blend(2)

Pike Place Decaf(2)

Colombia(2)

Hawaiian Blend(2)

Donut House(2)

Our Blend(2)

Lake & Lodge(2)

Café Domingo Blend(2)

Pike Place(2)

Wild Mountain Blueberry(2)

Chocolate Glazed Donut(2)

Caribou Blend Decaf(2)

Hawaiian Islands Blend(2)

French Vanilla Decaf(2)

Vermont Country Blend Decaf(2)

Donut House Decaf(2)

Vanilla Hazelnut(2)

Half-Caff(2)

Caramel(2)

Morning Edition(2)

Daybreak Morning Blend(2)

Caribou Blend(2)

Mahogany(2)

Mocha(2)

Southern Pecan(2)

Pumpkin Spice(2)

Butter Toffee(2)

Nantucket Blend(2)

Single Origin Colombian Select(2)

Double Black Diamond Extra Bold(2)

Trailblazer(2)

Morning Blend(2)

Colombian Supremo(2)

Hazelnut Cream(2)

Simply Smooth(2)

French Roast Decaf(2)

Special Blend Extra Bold(2)

Special Decaf(2)

Organic Sumatran Extra Bold(2)

Dark Magic Extra Bold(2)

Half Caff(2)

Dark Magic Decaf Extra Bold(2)

Donut Shop Regular(2)

Parisian Vanilla(1)

Pier 70 Blend(1)

Breakfast Blend (Light Roast)(1)

Portside Blend(1)

6th Avenue Bistro(1)

Vanilla Crème Brulee (Vanilla Caramel)(1)

Love at First Sip (Medium Roast)(1)

Buzzworthy (Dark Roast)(1)

100% Arabica Blend Decaf(1)

Original Roast Decaf(1)

Aroma Club 100% Arabica Blend(1)

Special Delivery(1)

Crema Aroma Arabica/Robusta(1)

Sumatra Mandheling(1)

Kahlúa Original(1)

Kenya Highlands(1)

Costa Rica Paraiso(1)

Parisian Café (Dark Roast)(1)

Eye Opener(1)

French Dark Roast(1)

Decaffeinated French Roast(1)

Café con Leche(1)

Veranda(1)

Pike Place Roast(1)

Decaf Pike Place Roast(1)

Veranda Blend(1)

Colombia Medium(1)

Sumatra(1)

Veranda Blend Blonde Roast(1)

Gourmet Supreme(1)

Special House Blend(1)

Special Roast(1)

Dark(1)

Colombian Blend(1)

Vanilla Latte Macchiato(1)

Decaf Portside Blend(1)

Cappuccino(1)

Lungo Decaf(1)

Kona Blend(1)

Pioneer Blend Decaf(1)

Decaf(1)

Original Roast(1)

AFTERBURNER(1)

Extra Bold Breakfast Blend(1)

Caramel Drizzle(1)

Big Bang(1)

Vanilla Biscotti(1)

Lively Colombian(1)

Signature Blend(1)

Brazil Minas Naturais(1)

Caramel Coffee Cake(1)

Dark Royal(1)

Signature Blend Decaf(1)

Perfetto(1)

Original Decaf(1)

Gran Aroma(1)

Cinnamon Roll(1)

Coconut Mocha(1)

Classic Decaf(1)

TURBOCHARGER(1)

Morning Edition Decaf(1)

Dark Blend(1)

100% Colombian Decaf(1)

Round the Clock Blend(1)

Country Roast(1)

Cinnamon(1)

Classic(1)

Premium Roast Decaf(1)

Premium Roast(1)

Peppermint Bark(1)

Traditional Roast(1)

Caramel Hideaway(1)

Rio Blend(1)

Donut Shop Blend(1)

Bold 1937(1)

NO SURRENDER(1)

Cafe Vanilla(1)

Morning Café(1)

Lively Colombian Decaf(1)

Dunkin' Decaf(1)

Dunkin' Dark(1)

Regular Roast(1)

 
Beverage Type

Coffee(293)

Decaffeinated Coffee(49)

Instant Coffee(6)

Half-caffeinated Coffee(4)

Coffee Drink(1)

 
Manufacturer Part Number

60051-012(1)

7602CT(1)

7790(1)

7746(1)

7732CT(1)

7732(1)

7674(1)

7608(1)

7607(1)

7605(1)

7602(1)

7792(1)

7596(1)

7595(1)

7594(1)

7586(1)

7564(1)

7563(1)

7534CT(1)

7534(1)

7791(1)

7792CT(1)

7522(1)

70400(1)

4202(1)

2709(1)

1450(1)

0603(1)

0470(1)

0460(1)

705024(1)

70500(1)

60000(1)

8087(1)

40300(1)

308042(1)

30800(1)

302742(1)

30220(1)

30200(1)

PB4141CT(1)

8784(1)

7522CT(1)

7468(1)

75410(1)

6744(1)

6783CT(1)

6783(1)

6772CT(1)

6772(1)

6758CT(1)

6758(1)

6746(1)

6745(1)

6743CT(1)

6792CT(1)

6743(1)

6732CT(1)

6732(1)

6728(1)

6727(1)

6722CT(1)

6722(1)

6720CT(1)

6792(1)

6803(1)

7467(1)

6995(1)

7466(1)

7465(1)

7428(1)

7000(1)

6999CT(1)

6999(1)

6996(1)

6995CT(1)

6994CT(1)

6803CT(1)

6994(1)

6992CT(1)

6992(1)

6990CT(1)

6990(1)

6974(1)

6873(1)

6813(1)

6812(1)

4483(1)

75411(1)

6700CT(1)

504915(1)

11017860EA(1)

11017854(1)

11015640(1)

11008131(1)

11008130(1)

504918(1)

504917(1)

504916(1)

504914(1)

11018131(1)

504913(1)

501677(1)

501619(1)

501546(1)

501487(1)

500705(1)

500350(1)

33750(1)

11017871(1)

11018185(1)

33300(1)

11028473(1)

863070(1)

04707(1)

11008560(1)

11008558(1)

11008556(1)

11008554(1)

11029358(1)

11028510(1)

11023061(1)

11018186(1)

11020676(1)

11019631(1)

11018197(1)

11018194(1)

11018193(1)

11018192(1)

11018190(1)

11018187(1)

33700(1)

32006(1)

75412(1)

390390(1)

15782(1)

026530(1)

026480(1)

026260(1)

026190(1)

866350(1)

866150(1)

862400(1)

04658(1)

27329(1)

04648PLT(1)

04648CT(1)

04648(1)

75424(1)

75421(1)

75416(1)

75415(1)

75413(1)

15782CT(1)

27376(1)

32003(1)

23003(1)

25188(1)

25187(1)

25186(1)

25185(1)

25184(1)

25183(1)

25181(1)

23004(1)

23002(1)

32486(1)

23001(1)

21001(1)

33000(1)

01096(1)

87066(1)

86073(1)

77317(1)

66488CT(1)

66488(1)

6720(1)

6700(1)

60051012CT(1)

60514(1)

63006(1)

60518(1)

60517(1)

60516EA(1)

60516(1)

60515EA(1)

60515(1)

60514EA(1)

60513EA(1)

63100CT(1)

60513(1)

52320(1)

21513(1)

21512(1)

21511(1)

21510(1)

20672(1)

20540CT(1)

63100(1)

63101(1)

20527CT(1)

0845(1)

192419(1)

1281(1)

1279(1)

0995(1)

0849(1)

0848(1)

0847(1)

0846(1)

0570(1)

63102(1)

0448(1)

0162(1)

0040(1)

0038(1)

0037(1)

0036(1)

63104(1)

63103(1)

20540(1)

20527(1)

192519(1)

320840(1)

01014(1)

00518X(1)

00374EA(1)

00374CT(1)

00055(1)

00050(1)

00019(1)

00016(1)

320820(1)

01720(1)

8599961590(1)

599961590(1)

60052101CT(1)

60052-101(1)

60051052CT(1)

60051-052(1)

60051046CT(1)

60051-046(1)

01500(1)

01720CT(1)

20513CT(1)

06927(1)

20513(1)

20421PL(1)

20421EA(1)

20421CT(1)

10117(1)

10107(1)

06931(1)

06930(1)

06922(1)

06114(1)

06897(1)

06547(1)

06451(1)

06437(1)

06433(1)

06430(1)

06239(1)

06125(1)

06122(1)

192419CT(1)

192519CT(1)

6694CT(1)

6523(1)

6546(1)

6545(1)

6544(1)

6543(1)

6542(1)

6534CT(1)

6534(1)

6523CT(1)

6520CT(1)

6570(1)

6520(1)

6503CT(1)

6503(1)

6502CT(1)

6502(1)

6501CT(1)

6501(1)

6425(1)

6547(1)

6570CT(1)

6407(1)

6661(1)

6694(1)

6685CT(1)

6685(1)

6680(1)

6664(1)

6663CT(1)

6663(1)

6662(1)

6659(1)

6602(1)

6613CT(1)

6613(1)

6612(1)

6611CT(1)

6611(1)

6606CT(1)

6606(1)

6602CT(1)

6408(1)

6406CT(1)

192619(1)

4051(1)

4067(1)

4066CT(1)

4066(1)

4061CT(1)

4061(1)

4060CT(1)

4060(1)

4051CT(1)

4050CT(1)

5303(1)

4050(1)

193019CT(1)

193019(1)

192919CT(1)

192919(1)

192719CT(1)

192719(1)

192619CT(1)

4067CT(1)

5304(1)

6406(1)

6106(1)

6405CT(1)

6405(1)

6376(1)

6305(1)

6248(1)

6111(1)

6110(1)

6107(1)

6006(1)

5305(1)

6003CT(1)

6003(1)

6002(1)

6001(1)

6000(1)

5471(1)

5470(1)

5469(1)

5339(1)

866550(1)

 
Country of Origin

US(337)

IT(9)

CA(3)

GB(3)

United States(1)

ES(1)

 
Weight (Approximate)

11.90 oz(1)

 
For Use With

Keurig K-Cup System(175)

Commercial Coffee Brewers(19)

Pod Brewers(8)

Single Cup Brewers(7)

Drip Coffee Brewers(7)

B-40; B-60; B-70; B-100(5)

Keurig Brewing System(4)

NESCAFÉ Dolce Gusto Machines(4)

Standard Coffee Brewers(4)

LavAzza Espresso Point Machine(2)

In-Room Lodging Standard 4-Cup Brewers(1)

LavAzza Espresso Point Machine (sold separately)(1)

 
Capacity (Volume)

10 oz(2)

48 oz(1)

8 oz(1)

25.1 oz(1)

0(1)

 
Capacity (Weight)

2.5 oz(28)

1 lb(18)

0.3 oz(15)

1.5 oz(12)

12 oz(10)

2 oz(8)

0.35 oz(6)

0.9 oz(6)

0.06 oz(4)

1.4 oz(4)

1.75 oz(3)

28 oz(3)

30.5 oz(3)

30.6 oz(3)

0.25 oz(3)

32 oz(2)

1.2 oz(2)

1.1 oz(2)

0.12 oz(2)

0.1 oz(2)

0.4 oz(2)

1.05 oz(2)

10 oz(2)

22.6 oz(2)

25.4 oz(2)

31.1 oz(2)

24.2 oz(2)

34.5 oz(1)

36 oz(1)

0.6 oz(1)

0.33 oz(1)

0.8 oz(1)

16 oz(1)

29.3 oz(1)

7 g(1)

2.2 lbs(1)

8 oz(1)

31 oz(1)

 
Serve Type

K-Cup(2)

 
Coffee Type

Caffeinated(2)

 
Roast Type

Medium(105)

Dark(75)

Light(32)

Mild(1)

 
Compatible Brewer

K-Cup Brewer(2)

 
Product Type

Coffee(2)

 
Packaged Quantity

24 / Box(2)

 
Flavor/Blend

Pumpkin Spice(1)

Nutmeg(1)

Cinnamon(1)

Arabica(1)

Buttery Pecan(1)

Maple(1)

 
Coffee Roast Level

Medium(1)

Light(1)

 
 
 

© 2020-2021 Meadows Office Supply, All Rights Reserved