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

Folgers(54)

Starbucks(22)

Peet's Coffee & Tea(18)

1850(16)

Day to Day Coffee(15)

Lavazza(15)

Caribou Coffee(14)

Café Bustelo(14)

Tully's Coffee(14)

Maxwell House(12)

PapaNicholas Coffee(10)

Java One(9)

Dunkin Donuts(9)

New England Coffee(9)

Eight O'Clock(9)

Melitta(8)

Barista Prima Coffeehouse(7)

Nescafé(6)

Distant Lands Coffee(6)

Donut House(6)

Gloria Jean's(6)

Diedrich Coffee(6)

Seattle's Best(5)

The Original Donut Shop(5)

NESCAFÉ Dolce Gusto(5)

Newman's Own Organics(5)

Coffee People(4)

Gevalia(4)

McCafe(4)

Café Escapes(4)

Krispy Kreme Doughnuts(3)

National Coffee Roasters(3)

revv(3)

Yuban(3)

illy(2)

Tim Hortons(2)

Hills Bros.(2)

Chase & Sanborn(2)

BUSTELO cool(2)

Kahlúa(1)

Chock full o'Nuts(1)

Cinnabon(1)

 
Quantity

36 per carton(4)

42 per carton(4)

24 per box(2)

40 per box(2)

24 per carton(1)

12 per pack(1)

96 per carton(1)

42 per box(1)

18 per carton(1)

 
Packing Type

K-Cup(190)

Bag(46)

Fraction Pack(37)

Packet(33)

Pod(31)

Can(14)

Canister(13)

Filter Pack(8)

Stick(8)

Portion Pack(5)

Capsule(5)

Cartridges(3)

Lavazza BLUE Capsule(3)

Vacket Pack(3)

Brick Pack(2)

Jar(2)

Coffee Pod(1)

 
Flavor

French Roast(21)

Classic Roast(15)

House Blend(15)

Breakfast Blend(14)

Espresso(11)

Hazelnut(10)

French Vanilla(8)

Regular(8)

Dark Roast(7)

Original(7)

Original Blend(6)

Italian Roast(6)

Assorted(6)

Medium Roast(6)

100% Colombian(6)

Hazelnut Creme(5)

Decaffeinated(5)

Colombian(5)

Black Gold(5)

Classic Roast Decaf(5)

Black Silk(5)

Pioneer Blend(5)

Major Dickason's Blend(4)

House Blend Decaf(4)

Breakfast Blend Decaf(4)

Morning Blend(4)

Decaf House Blend(3)

Caramel(3)

Daybreak Morning Blend(3)

Colombian Decaf(3)

Colombian Supremo(3)

Caffe Verona(3)

Caribou Blend(3)

Lantern Glow(3)

Island Coconut(2)

Traditional Roast(2)

Caramel Vanilla Cream(2)

Half-Caff(2)

Caribou Blend Decaf(2)

Mahogany(2)

Single Origin Colombian Select(2)

Mocha(2)

Wild Mountain Blueberry(2)

Southern Pecan(2)

Pumpkin Spice(2)

Donut House(2)

Lake & Lodge(2)

Dark Magic Decaf Extra Bold(2)

Morning Edition(2)

Café Domingo Blend(2)

Our Blend(2)

Vermont Country Blend(2)

Hawaiian Blend(2)

Colombia(2)

Donut Shop Regular(2)

Nantucket Blend(2)

Chocolate Glazed Donut(2)

French Vanilla Decaf(2)

Vanilla Hazelnut(2)

Double Black Diamond Extra Bold(2)

Pike Place Decaf(2)

Espresso Decaf(2)

Simply Smooth(2)

Dark Magic Extra Bold(2)

Vermont Country Blend Decaf(2)

Half Caff(2)

French Roast Decaf(2)

Special Roast(2)

Hawaiian Islands Blend(2)

Hazelnut Cream(2)

Trailblazer(2)

Butter Toffee(2)

Pike Place(2)

Special Blend Extra Bold(2)

Special Decaf(2)

Organic Sumatran Extra Bold(2)

Donut House Decaf(2)

Dark(1)

Rotondo/Dark Roast(1)

Decaffeinated Medium Roast(1)

Aroma Club 100% Arabica Blend(1)

Costa Rica Paraiso(1)

Special Delivery(1)

100% Arabica Blend Decaf(1)

Kenya Highlands(1)

Kahlúa Original(1)

Crema Aroma Arabica/Robusta(1)

Sumatra Mandheling(1)

Costa Rican La Sonrisa(1)

Estate Costa Rican(1)

Colombian De Jardin(1)

Veranda(1)

Portside Blend(1)

Crema Dolce/Medium Roast(1)

Decaf Portside Blend(1)

Veranda Blend(1)

Pike Place Roast(1)

Decaf Pike Place Roast(1)

Colombia Medium(1)

Sumatra(1)

Decaffeinated French Roast(1)

Special House Blend(1)

Veranda Blend Blonde Roast(1)

FT Vanilla(1)

Kona Blend(1)

Colombian Blend(1)

Vanilla Latte Macchiato(1)

Chococino(1)

Parisian Vanilla(1)

Cappuccino(1)

Lungo Decaf(1)

Eye Opener(1)

French Dark Roast(1)

Original Roast Decaf(1)

Parisian Café (Dark Roast)(1)

Breakfast Blend (Light Roast)(1)

Pier 70 Blend(1)

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

Love at First Sip (Medium Roast)(1)

6th Avenue Bistro(1)

Buzzworthy (Dark Roast)(1)

Decaf(1)

Lively Colombian(1)

Dark Blend(1)

100% Colombian Decaf(1)

Dark Royal(1)

Original Roast(1)

Signature Blend(1)

Extra Bold Breakfast Blend(1)

Caramel Coffee Cake(1)

Dunkin' Dark(1)

Dunkin' Decaf(1)

Lively Colombian Decaf(1)

Morning Café(1)

Donut Shop Blend(1)

Traditional Roast Decaf(1)

Cinnamon Sugar Cookie(1)

Pioneer Blend Decaf(1)

Country Roast(1)

Decaf Classic(1)

Gourmet Supreme(1)

Café con Leche Chocolate(1)

Café con Leche(1)

Estilo Espresso(1)

Medium Decaf(1)

Donut Shop(1)

Decaf Caribou Blend(1)

Signature Blend Decaf(1)

Perfetto(1)

Round the Clock Blend(1)

TURBOCHARGER(1)

Cinnamon(1)

Premium Roast Decaf(1)

Premium Roast(1)

Peppermint Bark(1)

Caramel Hideaway(1)

Bold 1937(1)

NO SURRENDER(1)

Cafe Vanilla(1)

Rio Blend(1)

Morning Edition Decaf(1)

AFTERBURNER(1)

Gran Aroma(1)

Caramel Drizzle(1)

Big Bang(1)

Vanilla Biscotti(1)

Brazil Minas Naturais(1)

Original Decaf(1)

Cinnamon Roll(1)

Coconut Mocha(1)

Holiday Blend(1)

Classic Decaf(1)

Classic(1)

Regular Roast(1)

 
Beverage Type

Coffee(331)

Decaffeinated Coffee(59)

Instant Coffee(6)

Half-caffeinated Coffee(4)

Coffee Drink(2)

Instant Decaffeinated Coffee(1)

Hot Chocolate(1)

 
Manufacturer Part Number

008710(1)

7790(1)

302142(1)

30210(1)

30200(1)

PB4141CT(1)

8784(1)

8087(1)

7792CT(1)

7792(1)

7791(1)

7746(1)

302742(1)

7732CT(1)

7732(1)

7608(1)

7607(1)

7605(1)

7602CT(1)

7602(1)

7595(1)

7594(1)

7586(1)

30220(1)

30400(1)

7563(1)

1450(1)

75412(1)

75411(1)

75410(1)

970(1)

953(1)

910(1)

4483(1)

4202(1)

2709(1)

0603(1)

30800(1)

0470(1)

0460(1)

705024(1)

70500(1)

70400(1)

60000(1)

40300(1)

39930404021(1)

39930274021(1)

308042(1)

7564(1)

7534CT(1)

75415(1)

6745(1)

6792CT(1)

6792(1)

6783CT(1)

6783(1)

6772CT(1)

6772(1)

6758CT(1)

6758(1)

6746(1)

6744(1)

6803CT(1)

6743CT(1)

6743(1)

6732CT(1)

6732(1)

6728(1)

6727(1)

6722CT(1)

6722(1)

6720CT(1)

6720(1)

6803(1)

6812(1)

7534(1)

6999(1)

7522CT(1)

7522(1)

7468(1)

7467(1)

7466(1)

7465(1)

7428(1)

71550(1)

7000(1)

6999CT(1)

6996(1)

6813(1)

6995CT(1)

6995(1)

6994CT(1)

6994(1)

6992CT(1)

6992(1)

6990CT(1)

6990(1)

6974(1)

6873(1)

75413(1)

75416(1)

6700(1)

504914(1)

11017860EA(1)

11017854(1)

11015640(1)

11008131(1)

11008130(1)

504918(1)

504917(1)

504916(1)

504915(1)

504913(1)

11018131(1)

501677(1)

501619(1)

501546(1)

501487(1)

500705(1)

500350(1)

39003(1)

39002(1)

39001(1)

39000(1)

11017871(1)

11018185(1)

33700(1)

11029358(1)

863070(1)

04707(1)

1261330(1)

11008560(1)

11008558(1)

11008556(1)

11008554(1)

1092836(1)

11075823(1)

11028510(1)

11018186(1)

11028473(1)

11023061(1)

11020676(1)

11019631(1)

11018197(1)

11018194(1)

11018193(1)

11018192(1)

11018190(1)

11018187(1)

33750(1)

33300(1)

75421(1)

026260(1)

66488CT(1)

66488(1)

32486(1)

27376(1)

27329(1)

15782CT(1)

15782(1)

026530(1)

026480(1)

026190(1)

77317(1)

026160(1)

866350(1)

866150(1)

862400(1)

390390(1)

04658(1)

04648PLT(1)

04648CT(1)

04648(1)

75424(1)

69749(1)

86073(1)

32006(1)

23004(1)

32003(1)

25188(1)

25187(1)

25186(1)

25185(1)

25184(1)

25183(1)

25182(1)

25181(1)

23005(1)

23003(1)

87066(1)

23002(1)

23001(1)

22005(1)

22002(1)

21001(1)

33000(1)

32410(1)

01096(1)

01084(1)

01027(1)

6700CT(1)

6694CT(1)

008711(1)

20540CT(1)

56376(1)

56375(1)

52320(1)

21513(1)

21512(1)

21511(1)

21510(1)

20672(1)

20630(1)

20540(1)

60513EA(1)

20527CT(1)

20527(1)

20513CT(1)

20513(1)

20421PL(1)

20421EA(1)

20421CT(1)

11545BX(1)

11545(1)

11544BX(1)

60513(1)

60514(1)

11248(1)

63101(1)

0448(1)

0162(1)

0040(1)

0038(1)

0037(1)

0036(1)

63104(1)

63103(1)

63102(1)

63100CT(1)

60514EA(1)

63100(1)

63006(1)

60518EA(1)

60518(1)

60517EA(1)

60517(1)

60516EA(1)

60516(1)

60515EA(1)

60515(1)

11544(1)

10117(1)

0845(1)

1099961590(1)

00055(1)

00050CT(1)

00050(1)

00019(1)

00016(1)

320840(1)

320820(1)

8599961590(1)

599961590(1)

60224-101(1)

00374EA(1)

60052101CT(1)

60052-101(1)

60051052CT(1)

60051-052(1)

60051046CT(1)

60051-046(1)

60051012CT(1)

60051-012(1)

008715(1)

008712(1)

00374CT(1)

00518X(1)

10107(1)

06433(1)

06931(1)

06930(1)

06927(1)

06922(1)

06898(1)

06897(1)

06547(1)

06546(1)

06451(1)

06437(1)

06430(1)

01014(1)

06239(1)

06125(1)

06122(1)

06114(1)

0529C(1)

01720CT(1)

01720(1)

01501(1)

01500(1)

01074(1)

0570(1)

0846(1)

6694(1)

6503(1)

6543(1)

6542(1)

6534CT(1)

6534(1)

6523CT(1)

6523(1)

6520CT(1)

6520(1)

6503CT(1)

6502CT(1)

6545(1)

6502(1)

6501CT(1)

6501(1)

6425(1)

6408(1)

6407(1)

6406CT(1)

6406(1)

6405CT(1)

6405(1)

6544(1)

6546(1)

6305(1)

6614(1)

6685CT(1)

6685(1)

6680(1)

6664(1)

6663CT(1)

6663(1)

6662(1)

6661(1)

6659(1)

6614CT(1)

6613CT(1)

6547(1)

6613(1)

6612(1)

6611CT(1)

6611(1)

6606CT(1)

6606(1)

6602CT(1)

6602(1)

6570CT(1)

6570(1)

6376(1)

6248(1)

0847(1)

192719(1)

4051CT(1)

4051(1)

4050CT(1)

4050(1)

193019CT(1)

193019(1)

192919CT(1)

192919(1)

192719CT(1)

192619CT(1)

4060CT(1)

192619(1)

192519CT(1)

192519(1)

192419CT(1)

192419(1)

1281(1)

1279(1)

0995(1)

0849(1)

0848(1)

4060(1)

4061(1)

6204(1)

5814(1)

6111(1)

6110(1)

6107(1)

6106(1)

6006(1)

6003CT(1)

6003(1)

6002(1)

6001(1)

6000(1)

5471(1)

4061CT(1)

5470(1)

5469(1)

5339(1)

5305(1)

5304(1)

5303(1)

4067CT(1)

4067(1)

4066CT(1)

4066(1)

866550(1)

 
Country of Origin

US(357)

CA(31)

IT(10)

GB(4)

AX(1)

ES(1)

 
For Use With

Keurig K-Cup System(188)

Commercial Coffee Brewers(20)

Drip Coffee Brewers(14)

Pod Brewers(9)

Single Cup Brewers(9)

NESCAFÉ Dolce Gusto Machines(5)

Single Cup Brewers Hamilton, Bunn and Newco(4)

Standard Coffee Brewers(4)

Lavazza 2312 BLUE Machine(3)

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

Keurig Brewing System(2)

LavAzza Espresso Point Machine(2)

Pod Espresso Brewer(1)

LavAzza Espresso Point Machine (sold separately)(1)

 
Capacity (Volume)

0.38 oz(4)

0.27 oz(3)

8 oz(2)

10 oz(2)

48 oz(1)

25.1 oz(1)

0(1)

 
Capacity (Weight)

2.5 oz(34)

1 lb(18)

0.3 oz(17)

1.5 oz(16)

2 oz(14)

12 oz(12)

0.9 oz(6)

0.35 oz(6)

0.06 oz(4)

1.4 oz(4)

1.75 oz(3)

30.5 oz(3)

1.1 oz(3)

30.6 oz(3)

10 oz(3)

28 oz(3)

0.4 oz(3)

0.25 oz(3)

32 oz(2)

1.2 oz(2)

8 g(2)

22.6 oz(2)

31.1 oz(2)

7 g(2)

1.05 oz(2)

0.6 oz(2)

0.1 oz(2)

8 oz(2)

24.2 oz(2)

25.4 oz(2)

0.12 oz(2)

34.5 oz(1)

1.25 oz(1)

2 oz.(1)

2.25 oz(1)

45 oz(1)

48 oz(1)

29.3 oz(1)

9 g(1)

2.2 lbs(1)

5 lb(1)

0.33 oz(1)

36 oz(1)

16 oz(1)

0.8(1)

0.8 oz(1)

31 oz(1)

 
Roast Type

Medium(118)

Dark(86)

Light(36)

Dark Roast(3)

Medium Roast(1)

 
 
 

© 2020-2021 Meadows Office Supply, All Rights Reserved