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

Starbucks(21)

Peet's Coffee & Tea(17)

Lavazza(17)

1850(14)

Tully's Coffee(12)

Maxwell House(10)

PapaNicholas Coffee(9)

Caribou Coffee(9)

Eight O'Clock(9)

Day to Day Coffee(8)

Melitta(8)

New England Coffee(8)

Café Bustelo(7)

Java One(7)

Nescafé(6)

Gloria Jean's(6)

Dunkin Donuts(6)

Barista Prima Coffeehouse(5)

The Original Donut Shop(4)

Seattle's Best(4)

Diedrich Coffee(4)

Café Escapes(4)

McCafe(4)

Newman's Own Organics(4)

Yuban(3)

Distant Lands Coffee(3)

NESCAFÉ Dolce Gusto(3)

Gevalia(3)

revv(3)

Donut House(2)

Tim Hortons(2)

illy(2)

Krispy Kreme Doughnuts(2)

National Coffee Roasters(2)

Kahlúa(1)

Chock full o'Nuts(1)

Chase & Sanborn(1)

BUSTELO cool(1)

Cinnabon(1)

 
Quantity

24 per box(16)

22 per box(3)

96 per carton(2)

24 per box.(1)

 
Packing Type

K-Cup(162)

Bag(38)

Fraction Pack(35)

Pod(24)

Packet(20)

Canister(13)

Can(11)

Filter Pack(8)

Stick(8)

Portion Pack(4)

Vacket Pack(3)

Cartridges(3)

Capsule(3)

Brick Pack(2)

Jar(1)

 
Flavor

French Roast(16)

Classic Roast(14)

Breakfast Blend(13)

House Blend(13)

Hazelnut(10)

French Vanilla(8)

Original(7)

Espresso(7)

Medium Roast(6)

Assorted(6)

Regular(6)

Hazelnut Creme(5)

Classic Roast Decaf(5)

100% Colombian(5)

Black Silk(5)

Dark Roast(5)

Black Gold(4)

Decaf House Blend(4)

Major Dickason's Blend(4)

Colombian(4)

Pioneer Blend(4)

Italian Roast(4)

Decaffeinated(4)

Caffe Verona(3)

Pumpkin Spice(3)

Original Blend(3)

Lantern Glow(3)

Breakfast Blend Decaf(3)

Our Blend(2)

Café Domingo Blend(2)

Vermont Country Blend(2)

Lake & Lodge(2)

Hawaiian Blend(2)

Colombia(2)

Donut House(2)

Butter Toffee(2)

Nantucket Blend(2)

Caramel Vanilla Cream(2)

Morning Edition(2)

Dark and Bold(2)

Hawaiian Islands Blend(2)

Southern Pecan(2)

Wild Mountain Blueberry(2)

Mocha(2)

Dark and Intense(2)

Mahogany(2)

Caribou Blend(2)

Daybreak Morning Blend(2)

Caribou Blend Decaf(2)

Half-Caff(2)

Vermont Country Blend Decaf(2)

Single Origin Colombian Select(2)

French Vanilla Decaf(2)

Hazelnut Cream(2)

Organic Sumatran Extra Bold(2)

Pike Place Decaf(2)

Trailblazer(2)

Pike Place(2)

Half Caff(2)

Simply Smooth(2)

French Roast Decaf(2)

House Blend Decaf(2)

Colombian Supremo(2)

Special Decaf(2)

Special Blend Extra Bold(2)

Dark Magic Extra Bold(2)

Double Black Diamond Extra Bold(2)

Dark Magic Decaf Extra Bold(2)

Donut Shop Regular(2)

Kahlúa Original(1)

Veranda Blend Blonde Roast(1)

Decaf Portside Blend(1)

Gold Selection(1)

Light and Aromatic(1)

Pier 70 Blend(1)

Special Delivery(1)

Sumatra Mandheling(1)

Crema Aroma Arabica/Robusta(1)

Aroma Club 100% Arabica Blend(1)

6th Avenue Bistro(1)

Portside Blend(1)

100% Arabica Blend Decaf(1)

Veranda Blend(1)

Costa Rica Paraiso(1)

Parisian Vanilla(1)

Sumatra(1)

Colombian Blend(1)

Decaffeinated French Roast(1)

Cappuccino(1)

Lungo Decaf(1)

Eye Opener(1)

French Dark Roast(1)

Original Roast Decaf(1)

Colombia Medium(1)

Veranda(1)

Decaf Pike Place Roast(1)

Parisian Café (Dark Roast)(1)

Pike Place Roast(1)

Breakfast Blend (Light Roast)(1)

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

Kona Blend(1)

Love at First Sip (Medium Roast)(1)

Buzzworthy (Dark Roast)(1)

Special House Blend(1)

Vanilla Biscotti(1)

Dark(1)

Morning Café(1)

Cinnamon Sugar Cookie(1)

Dark Royal(1)

Original Roast(1)

Signature Blend(1)

Extra Bold Breakfast Blend(1)

Dunkin' Dark(1)

Dunkin' Decaf(1)

Lively Colombian Decaf(1)

Donut Shop Blend(1)

Gran Aroma(1)

Morning Blend(1)

100% Colombian Decaf(1)

Traditional Roast(1)

Pioneer Blend Decaf(1)

Country Roast(1)

Special Roast(1)

Gourmet Supreme(1)

Café con Leche(1)

Perfetto(1)

Classic(1)

Maple Pecan(1)

Morning Edition Decaf(1)

Premium Roast Decaf(1)

Premium Roast(1)

Peppermint Bark(1)

Caramel Hideaway(1)

NO SURRENDER(1)

Caramel(1)

Cafe Vanilla(1)

Rio Blend(1)

TURBOCHARGER(1)

Classic Decaf(1)

AFTERBURNER(1)

Caramel Drizzle(1)

Big Bang(1)

Lively Colombian(1)

Decaf Original(1)

Cinnamon Roll(1)

Coconut Mocha(1)

Holiday Blend(1)

Regular Roast(1)

 
Beverage Type

Coffee(283)

Decaffeinated Coffee(41)

Instant Coffee(6)

Half-caffeinated Coffee(4)

Coffee Drink(1)

 
Manufacturer Part Number

60051-012(1)

7792CT(1)

308042(1)

30800(1)

302742(1)

30220(1)

30200(1)

PB4141CT(1)

8087(1)

7792(1)

60000(1)

7791(1)

7790(1)

7732CT(1)

7732(1)

7674(1)

7602CT(1)

7602(1)

7596(1)

40300(1)

70400(1)

7522(1)

3446(1)

75412(1)

75411(1)

75410(1)

4483(1)

4202(1)

3454(1)

3451(1)

3445(1)

70500(1)

3427(1)

3425(1)

2709(1)

1450(1)

0603(1)

0470(1)

0460(1)

705024(1)

7522CT(1)

7468(1)

75415(1)

6744(1)

6783CT(1)

6783(1)

6772CT(1)

6772(1)

6758CT(1)

6758(1)

6746(1)

6743CT(1)

6792CT(1)

6743(1)

6732CT(1)

6732(1)

6728(1)

6727(1)

6700CT(1)

6700(1)

6694CT(1)

6792(1)

6803(1)

7467(1)

6995(1)

7466(1)

7465(1)

7428(1)

6999CT(1)

6999(1)

6996(1)

6995CT(1)

6994CT(1)

6803CT(1)

6994(1)

6992CT(1)

6992(1)

6990CT(1)

6990(1)

6873(1)

6813(1)

6812(1)

75413(1)

75416(1)

6685CT(1)

504917(1)

11017871(1)

11017860EA(1)

11017854(1)

11015640(1)

11008131(1)

11008130(1)

504918(1)

504916(1)

11018185(1)

504915(1)

504914(1)

504913(1)

501677(1)

501619(1)

501546(1)

501487(1)

500705(1)

11018131(1)

11018186(1)

33750(1)

11028510(1)

863070(1)

04707(1)

11008560(1)

11008558(1)

11008556(1)

11008554(1)

11029358(1)

11028473(1)

11018187(1)

11023061(1)

11020676(1)

11019631(1)

11018197(1)

11018194(1)

11018193(1)

11018192(1)

11018190(1)

500350(1)

33700(1)

75421(1)

026190(1)

27376(1)

27329(1)

15782CT(1)

15782(1)

026530(1)

026480(1)

026260(1)

866350(1)

66488(1)

866150(1)

862400(1)

390390(1)

04658(1)

04648PLT(1)

04648CT(1)

04648(1)

75424(1)

32486(1)

66488CT(1)

33300(1)

25183(1)

32006(1)

32003(1)

25188(1)

25187(1)

25186(1)

25185(1)

25184(1)

25181(1)

77317(1)

23004(1)

23003(1)

23002(1)

23001(1)

21001(1)

33000(1)

01096(1)

86073(1)

6694(1)

6685(1)

60051012CT(1)

60513(1)

60516EA(1)

60516(1)

60515EA(1)

60515(1)

60514EA(1)

60514(1)

60513EA(1)

52320(1)

60518(1)

21513(1)

21512(1)

21511(1)

21510(1)

20672(1)

20540CT(1)

20540(1)

20527CT(1)

60517(1)

63006(1)

20513CT(1)

0162(1)

0849(1)

0848(1)

0847(1)

0846(1)

0845(1)

0570(1)

0448(1)

0040(1)

63100(1)

0038(1)

0037(1)

0036(1)

63104(1)

63103(1)

63102(1)

63101(1)

63100CT(1)

20527(1)

20513(1)

1281(1)

320840(1)

00518X(1)

00374EA(1)

00374CT(1)

00055(1)

00050(1)

00019(1)

00016(1)

320820(1)

01500(1)

8599961590(1)

599961590(1)

60052101CT(1)

60052-101(1)

60051052CT(1)

60051-052(1)

60051046CT(1)

60051-046(1)

01014(1)

01720(1)

20421PL(1)

06922(1)

20421EA(1)

20421CT(1)

10117(1)

10107(1)

06931(1)

06930(1)

06927(1)

06897(1)

01720CT(1)

06451(1)

06437(1)

06433(1)

06430(1)

06239(1)

06125(1)

06122(1)

06114(1)

1279(1)

192419(1)

6680(1)

6503CT(1)

6543(1)

6534CT(1)

6534(1)

6523CT(1)

6523(1)

6520CT(1)

6520(1)

6503(1)

6545(1)

6502CT(1)

6502(1)

6501CT(1)

6501(1)

6425(1)

6408(1)

6407(1)

6406CT(1)

6544(1)

6546(1)

6405CT(1)

6613(1)

6664(1)

6663CT(1)

6663(1)

6662(1)

6661(1)

6659(1)

6613CT(1)

6612(1)

6547(1)

6611CT(1)

6611(1)

6606CT(1)

6606(1)

6602CT(1)

6602(1)

6570CT(1)

6570(1)

6406(1)

6405(1)

192419CT(1)

4050CT(1)

4066(1)

4061CT(1)

4061(1)

4060CT(1)

4060(1)

4051CT(1)

4051(1)

4050(1)

4067(1)

193019CT(1)

193019(1)

192719CT(1)

192719(1)

192619CT(1)

192619(1)

192519CT(1)

192519(1)

4066CT(1)

4067CT(1)

6305(1)

6003CT(1)

6248(1)

6204(1)

6111(1)

6110(1)

6107(1)

6106(1)

6006(1)

6003(1)

5303(1)

6002(1)

6001(1)

6000(1)

5814(1)

5470(1)

5469(1)

5305(1)

5304(1)

866550(1)

 
Country of Origin

US(315)

IT(13)

CA(4)

GB(2)

ES(1)

 
For Use With

Keurig K-Cup System(134)

Keurig Brewing System(23)

Commercial Coffee Brewers(19)

Pod Brewers(8)

Single Cup Brewers(7)

Drip Coffee Brewers(7)

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

Standard Coffee Brewers(4)

Coffee Brewer(3)

Grinder; Coffee Brewer(3)

NESCAFÉ Dolce Gusto Machines(3)

LavAzza Espresso Point Machine(2)

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)

30.6 oz(3)

0.25 oz(3)

30.5 oz(3)

2.2 lb(3)

1.75 oz(3)

28 oz(3)

1.2 oz(2)

1.1 oz(2)

32 oz(2)

0.12 oz(2)

0.1 oz(2)

0.4 oz(2)

31.1 oz(2)

10 oz(2)

22.6 oz(2)

24.2 oz(2)

25.4 oz(2)

8 oz(2)

1.05 oz(2)

34.5 oz(1)

36 oz(1)

0.8 oz(1)

2.25 oz(1)

16 oz(1)

29.3 oz(1)

7 g(1)

2.2 lbs(1)

2.2 oz(1)

31 oz(1)

 
Roast Type

Medium(94)

Dark(72)

Light(36)

 
 
 

© 2020-2021 Meadows Office Supply, All Rights Reserved