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

Folgers(56)

Starbucks(37)

Peet's Coffee & Tea(20)

Lavazza(18)

1850(16)

Day to Day Coffee(15)

Tully's Coffee(14)

Café Bustelo(14)

Caribou Coffee(14)

Maxwell House(12)

PapaNicholas Coffee(10)

Dunkin Donuts(10)

Java One(9)

New England Coffee(9)

Eight O'Clock(9)

Melitta(8)

Barista Prima Coffeehouse(7)

Distant Lands Coffee(6)

Gloria Jean's(6)

Donut House(6)

Nescafé(6)

Diedrich Coffee(6)

NESCAFÉ Dolce Gusto(5)

The Original Donut Shop(5)

Newman's Own Organics(5)

Seattle's Best(5)

Coffee People(4)

Gevalia(4)

Café Escapes(4)

McCafe(4)

Hills Bros.(4)

Yuban(3)

National Coffee Roasters(3)

Krispy Kreme Doughnuts(3)

revv(3)

Chase & Sanborn(2)

Emeril's(2)

BUSTELO cool(2)

illy(2)

Tim Hortons(2)

Kahlúa(2)

Cinnabon(1)

GFIC(1)

Office Snax(1)

Dolce Gusto(1)

Chock full o'Nuts(1)

 
Quantity

36 per carton(4)

42 per carton(4)

24 per box(3)

40 per box(2)

18 per carton(1)

96 per carton(1)

12 per pack(1)

24 per carton(1)

 
Packing Type

K-Cup(208)

Bag(52)

Fraction Pack(39)

Packet(34)

Pod(31)

Can(15)

Canister(13)

Stick(10)

Filter Pack(9)

Capsule(6)

Portion Pack(5)

Lavazza BLUE Capsule(3)

Vacket Pack(3)

Cartridges(3)

Jar(2)

Brick Pack(2)

Coffee Pod(1)

 
Flavor

French Roast(23)

Breakfast Blend(16)

Classic Roast(16)

House Blend(15)

Espresso(11)

Original Blend(9)

Hazelnut(9)

Regular(9)

French Vanilla(8)

Dark Roast(7)

Italian Roast(7)

Original(7)

100% Colombian(6)

Classic Roast Decaf(6)

Assorted(6)

Medium Roast(6)

Black Silk(5)

Black Gold(5)

Decaffeinated(5)

Caffe Verona(5)

Pioneer Blend(5)

Colombian(5)

Pike Place Decaf(4)

Breakfast Blend Decaf(4)

Hazelnut Creme(4)

Pike Place(4)

Decaf House Blend(4)

House Blend Decaf(4)

Morning Blend(4)

Major Dickason's Blend(4)

Colombian Supremo(3)

Caribou Blend(3)

Pumpkin Spice(3)

Colombia(3)

Colombian Decaf(3)

Caramel(3)

Veranda Blend(3)

Daybreak Morning Blend(3)

Lantern Glow(3)

Hazelnut Decaf(2)

Mocha(2)

Lake & Lodge(2)

Wild Mountain Blueberry(2)

Donut House(2)

Emeril's Big Easy Bold(2)

Mahogany(2)

Hawaiian Islands Blend(2)

Donut House Decaf(2)

Caribou Blend Decaf(2)

Single Origin Colombian Select(2)

Café Domingo Blend(2)

Our Blend(2)

Nantucket Blend(2)

Caramel Vanilla Cream(2)

Island Coconut(2)

Chocolate Glazed Donut(2)

Kahlúa Original(2)

Southern Pecan(2)

Vanilla Hazelnut(2)

Vermont Country Blend(2)

Hawaiian Blend(2)

Butter Toffee(2)

Donut Shop(2)

Half-Caff(2)

Simply Smooth(2)

French Roast Decaf(2)

Espresso Decaf(2)

Special Blend Extra Bold(2)

Morning Edition(2)

Half Caff(2)

Trailblazer(2)

Traditional Roast(2)

Vermont Country Blend Decaf(2)

Hazelnut Cream(2)

Special Decaf(2)

Special Roast(2)

Double Black Diamond Extra Bold(2)

French Vanilla Decaf(2)

Organic Sumatran Extra Bold(2)

Gran Filtro Light Roast(2)

Dark Magic Extra Bold(2)

Dark Magic Decaf Extra Bold(2)

Parisian Vanilla(1)

Gran Filtro Dark Roast(1)

Buzzworthy (Dark Roast)(1)

Crema Aroma Arabica/Robusta(1)

Aroma Club 100% Arabica Blend(1)

Estate Costa Rican(1)

Colombian De Jardin(1)

Costa Rican La Sonrisa(1)

100% Arabica Blend Decaf(1)

Crema Dolce/Medium Roast(1)

Decaffeinated Medium Roast(1)

Rotondo/Dark Roast(1)

Sumatra Mandheling(1)

Special House Blend(1)

Veranda(1)

Veranda Blend Blonde Roast(1)

Pike Place Roast(1)

Decaf Pike Place Roast(1)

Sumatra(1)

Colombia Medium(1)

Sumatran(1)

FT Vanilla(1)

Special Delivery(1)

Regular Roast(1)

6th Avenue Bistro(1)

Portside Blend(1)

Decaf Portside Blend(1)

Pier 70 Blend(1)

Cafe Domingo(1)

Decaffeinated French Roast(1)

French Dark Roast(1)

Eye Opener(1)

Original Roast Decaf(1)

Parisian Café (Dark Roast)(1)

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

Breakfast Blend (Light Roast)(1)

Caramel Latte Macchiato(1)

Lungo Decaf(1)

Kona Blend(1)

Kenya Highlands(1)

Colombian Blend(1)

Vanilla Latte Macchiato(1)

Cappuccino(1)

Chococino(1)

Love at First Sip (Medium Roast)(1)

Caramel Drizzle(1)

Caramel Coffee Cake(1)

Extra Bold Breakfast Blend(1)

Dunkin' Dark(1)

Dunkin' Decaf(1)

Lively Colombian Decaf(1)

Signature Blend(1)

Original Roast(1)

Perfetto(1)

Gran Aroma(1)

Cinnamon Sugar Cookie(1)

Signature Blend Decaf(1)

Dark Royal(1)

Morning Café(1)

Donut Shop Blend(1)

Estilo Espresso(1)

Café con Leche(1)

Medium Decaf(1)

Donut Shop Decaf(1)

Decaf Caribou Blend(1)

Café con Leche Chocolate(1)

Gourmet Supreme(1)

Traditional Roast Decaf(1)

100% Colombian Decaf(1)

Pioneer Blend Decaf(1)

Country Roast(1)

Decaf Classic(1)

Classic(1)

Classic Decaf(1)

Peppermint Bark(1)

Premium Roast(1)

Caramel Hideaway(1)

Bold 1937(1)

NO SURRENDER(1)

Premium Roast Decaf(1)

Cinnamon(1)

Decaf(1)

Dark(1)

Maple Pecan(1)

Dark Blend(1)

Round the Clock Blend(1)

Cafe Vanilla(1)

Rio Blend(1)

Original Decaf(1)

Brazil Minas Naturais(1)

Cinnamon Roll(1)

Coconut Mocha(1)

Holiday Blend(1)

Lively Colombian(1)

Vanilla Biscotti(1)

Morning Edition Decaf(1)

TURBOCHARGER(1)

AFTERBURNER(1)

Big Bang(1)

Costa Rica Paraiso(1)

 
Beverage Type

Coffee(359)

Decaffeinated Coffee(63)

Instant Coffee(6)

Half-caffeinated Coffee(4)

Coffee Drink(2)

Hot Chocolate(1)

Instant Decaffeinated Coffee(1)

 
Manufacturer Part Number

70400(1)

70500(1)

60000(1)

40300(1)

39930404021(1)

705024(1)

0460(1)

2401(1)

2410(1)

1450(1)

0603(1)

0470(1)

39930274021(1)

308042(1)

PB4141(1)

PB4141CT(1)

8784(1)

8087(1)

7792CT(1)

30200(1)

30210(1)

30400(1)

30800(1)

302742(1)

30220(1)

302142(1)

2440(1)

2709(1)

04658(1)

390390(1)

04648PLT(1)

04648CT(1)

04648(1)

395640(1)

862400(1)

026190(1)

026260(1)

026160(1)

866350(1)

866150(1)

75424(1)

75421(1)

953(1)

970(1)

910(1)

4483(1)

4202(1)

75410(1)

75411(1)

75416(1)

75415(1)

75413(1)

75412(1)

7792(1)

7791(1)

6992(1)

6992CT(1)

6990CT(1)

6990(1)

6974(1)

6994(1)

6994CT(1)

6999(1)

6999CT(1)

6996(1)

6995CT(1)

6995(1)

6873(1)

6813(1)

6772(1)

6772CT(1)

6758CT(1)

6758(1)

6746(1)

6783(1)

6783CT(1)

6803CT(1)

6812(1)

6803(1)

6792CT(1)

6792(1)

7000(1)

71550(1)

7602CT(1)

7605(1)

7602(1)

7596(1)

7595(1)

7607(1)

7608(1)

7746(1)

7790(1)

7732CT(1)

7732(1)

7674(1)

7594(1)

7586(1)

7467(1)

7468(1)

7466(1)

7465(1)

7428(1)

7522(1)

7522CT(1)

7564(1)

7563(1)

7534CT(1)

7534(1)

026480(1)

026530(1)

11008130(1)

11008131(1)

011068092CT(1)

011068092(1)

011067987CT(1)

11015640(1)

11017854(1)

11018185(1)

11018186(1)

11018131(1)

11017871(1)

11017860EA(1)

011067987(1)

011067986CT(1)

504917(1)

504918(1)

504916(1)

504915(1)

504914(1)

011067983(1)

011067983CT(1)

011067985CT(1)

011067986(1)

011067985(1)

011067984CT(1)

011067984(1)

11018187(1)

11018190(1)

11008556(1)

11008558(1)

11008554(1)

1092836(1)

11075823(1)

11008560(1)

1261330(1)

863070(1)

866550(1)

04707(1)

PB4137CT(1)

PB4137(1)

11075822(1)

11029358(1)

11018197(1)

11019631(1)

11018194(1)

11018193(1)

11018192(1)

11019880(1)

11019881(1)

11028510(1)

11028473(1)

11023061(1)

11020676(1)

504913(1)

504874(1)

01101(1)

02059(1)

01096(1)

01084(1)

01027(1)

32410(1)

33000(1)

23001(1)

23002(1)

22005(1)

22002(1)

21001(1)

00058(1)

87066(1)

27329(1)

27376(1)

15782CT(1)

15782(1)

02430(1)

32486(1)

66488(1)

86073(1)

77317(1)

69749(1)

66488CT(1)

23003(1)

23004(1)

39002(1)

39003(1)

39001(1)

39000(1)

33750(1)

500350(1)

500689(1)

501619(1)

501677(1)

501546(1)

501487(1)

500705(1)

33700(1)

33300(1)

25183(1)

25184(1)

25182(1)

25181(1)

23005(1)

25185(1)

25186(1)

32006(1)

32003(1)

25188(1)

25187(1)

6745(1)

6744(1)

21513(1)

52320(1)

21512(1)

21511(1)

21510(1)

56375(1)

56376(1)

60514EA(1)

60515(1)

60514(1)

60513EA(1)

60513(1)

20672(1)

20630(1)

20421CT(1)

20421EA(1)

11545BX(1)

11545(1)

11544BX(1)

20421PL(1)

20513(1)

20540(1)

20540CT(1)

20527CT(1)

20527(1)

20513CT(1)

60515EA(1)

60516(1)

0162(1)

0448(1)

0040(1)

0038(1)

0037(1)

0570(1)

0845(1)

0849(1)

0995(1)

0848(1)

0847(1)

0846(1)

0036(1)

63104(1)

60518(1)

60518EA(1)

60517EA(1)

60517(1)

60516EA(1)

63006(1)

63100(1)

63103(1)

63102(1)

63101(1)

63100CT(1)

11544(1)

11248(1)

320840(1)

00016(1)

320820(1)

8599961590(1)

599961590(1)

00019(1)

00050(1)

00374EA(1)

006546(1)

00374CT(1)

00055(1)

00050CT(1)

1099961590(1)

60224-101(1)

60051-012(1)

60051012CT(1)

008715(1)

008712(1)

008711(1)

60051-046(1)

60051046CT(1)

60052101CT(1)

60052-101(1)

60051052CT(1)

60051-052(1)

01014(1)

01074(1)

06547(1)

06897(1)

06546(1)

06451(1)

06437(1)

06898(1)

06922(1)

10107(1)

10117(1)

06931(1)

06930(1)

06927(1)

06433(1)

06430(1)

01720CT(1)

0529C(1)

01720(1)

01501(1)

01500(1)

0529CPL(1)

06114(1)

06239(1)

06125(1)

06122(1)

06119(1)

1279(1)

1281(1)

6570(1)

6570CT(1)

6547(1)

6546(1)

6545(1)

6602(1)

6602CT(1)

6611CT(1)

6612(1)

6611(1)

6606CT(1)

6606(1)

6544(1)

6543(1)

6503(1)

6503CT(1)

6502CT(1)

6502(1)

6501CT(1)

6520(1)

6520CT(1)

6534CT(1)

6542(1)

6534(1)

6523CT(1)

6523(1)

6613(1)

6613CT(1)

6720CT(1)

6722(1)

6720(1)

6700CT(1)

6700(1)

6722CT(1)

6727(1)

6743(1)

6743CT(1)

6732CT(1)

6732(1)

6728(1)

6694CT(1)

6694(1)

6661(1)

6662(1)

6659(1)

6614CT(1)

6614(1)

6663(1)

6663CT(1)

6685CT(1)

6685(1)

6680(1)

6664(1)

6501(1)

6425(1)

4060(1)

4060CT(1)

4051CT(1)

4051(1)

4050CT(1)

4061(1)

4061CT(1)

4067CT(1)

5303(1)

4067(1)

4066CT(1)

4066(1)

4050(1)

193019CT(1)

192519CT(1)

192619(1)

192519(1)

192419CT(1)

192419(1)

192619CT(1)

192719(1)

193019(1)

192919CT(1)

192919(1)

192719CT(1)

5304(1)

5305(1)

6248(1)

6305(1)

6204(1)

6111(1)

6110(1)

6376(1)

6405(1)

6407(1)

6408(1)

6406CT(1)

6406(1)

6405CT(1)

6107(1)

6106(1)

5471(1)

5814(1)

5470(1)

5469(1)

5339(1)

6000(1)

6001(1)

6006(1)

6003CT(1)

6003(1)

6002(1)

008710(1)

 
Country of Origin

US(383)

CA(34)

IT(13)

GB(4)

ES(1)

AX(1)

 
For Use With

Keurig K-Cup System(205)

Commercial Coffee Brewers(21)

Drip Coffee Brewers(15)

Single Cup Brewers(9)

Pod Brewers(9)

NESCAFÉ Dolce Gusto Machines(5)

Single Cup Brewers Hamilton, Bunn and Newco(4)

Standard Coffee Brewers(4)

Lavazza 2312 BLUE Machine(3)

Keurig Brewing System(3)

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

LavAzza Espresso Point Machine(2)

1/2-Gallon Brewers(1)

Pod Espresso Brewer(1)

LavAzza Espresso Point Machine (sold separately)(1)

 
Capacity (Volume)

0.38 oz(4)

0.27 oz(3)

10 oz(2)

8 oz(2)

0(1)

25.1 oz(1)

6 oz(1)

0.9 oz(1)

 
Capacity (Weight)

2.5 oz(34)

1 lb(19)

1.5 oz(17)

0.3 oz(17)

2 oz(14)

12 oz(12)

0.9 oz(6)

0.35 oz(6)

0.4 oz(5)

0.06 oz(4)

0.12 oz(4)

1.4 oz(4)

30.5 oz(3)

2.2 lbs(3)

0.25 oz(3)

1.1 oz(3)

1.75 oz(3)

10 oz(3)

28 oz(3)

30.6 oz(3)

0.1 oz(2)

1.2 oz(2)

32 oz(2)

2.25 oz(2)

8 g(2)

24.2 oz(2)

16 oz(2)

8 oz(2)

0.6 oz(2)

48 oz(2)

22.6 oz(2)

1.05 oz(2)

25.4 oz(2)

7 g(2)

31.1 oz(2)

1.25 oz(1)

31 oz(1)

2 oz.(1)

26 oz(1)

45 oz(1)

34.5 oz(1)

5 lb(1)

0.8(1)

0.8 oz(1)

36 oz(1)

0.33 oz(1)

9 g(1)

1.93 oz(1)

0.7 oz(1)

29.3 oz(1)

33.9 oz(1)

 
Roast Type

Medium(127)

Dark(95)

Light(43)

Dark Roast(3)

Medium Roast(1)

 
 
 

© 2019-2020 Meadows Office Supply, All Rights Reserved