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

Folgers(38)

Starbucks(27)

Peet's Coffee & Tea(19)

Lavazza(19)

Tully's Coffee(16)

Day to Day Coffee(16)

Dunkin Donuts(11)

Caribou Coffee(10)

Eight O'Clock(9)

Java One(9)

PapaNicholas Coffee(9)

Gloria Jean's(8)

Barista Prima Coffeehouse(8)

Maxwell House(8)

The Original Donut Shop(6)

Timothy's World Coffee(6)

Donut House(6)

Newman's Own Organics(5)

New England Coffee(5)

Diedrich Coffee(5)

Café Bustelo(4)

Distant Lands Coffee(4)

Café Escapes(4)

Gevalia(4)

Seattle's Best(4)

Folgers Simply Gourmet(3)

Panera Bread(3)

Kahlúa(2)

Emeril's(2)

Yuban(2)

Krispy Kreme Doughnuts(2)

Van Houtte(2)

Hills Bros.(2)

Nescafé(2)

Chase & Sanborn(2)

Office Snax(2)

Cinnabon(1)

 
Quantity

24 per box(109)

96 per carton(62)

1 each(39)

42 per carton(32)

18 per box(15)

22 per box(10)

14 per box(9)

16 per box(8)

50 per carton(8)

18 per carton(7)

2 per carton(7)

18 (Each box contains 18 packs weighing 2.5 ounces)(6)

30 per carton(4)

88 per carton(4)

40 per carton(4)

100 per box(4)

36 per carton(4)

50 per box(3)

24 per box.(3)

6 per carton(3)

60 per carton(2)

24 per carton(2)

100 per carton(2)

3 per pack(1)

210 per pallet(1)

160 per carton(1)

63 per carton(1)

150 per carton(1)

1 bag(1)

42 per box(1)

 
Packing Type

K-Cup(187)

Bag(47)

Fraction Pack(42)

Packet(23)

Pod(15)

Can(9)

Vue Pack(7)

Filter Pack(6)

Portion Pack(5)

Canister(5)

Cartridges(5)

Stick(4)

Vacket Pack(3)

Vacuum Bag(3)

Jar(1)

Travel Mug Vue Pack(1)

 
Flavor

French Roast(23)

Breakfast Blend(17)

House Blend(15)

Hazelnut(9)

French Vanilla(9)

Classic Roast(9)

Regular(7)

Italian Roast(6)

Assorted(6)

Original Blend(6)

Dark Roast(6)

Colombian Decaf(5)

Classic Roast Decaf(5)

House Blend Decaf(4)

Vermont Country Blend(4)

Decaf House Blend(4)

Pike Place Decaf(4)

Medium Roast(4)

Breakfast Blend Decaf(4)

Colombian(4)

Nantucket Blend(4)

Major Dickason's Blend(4)

Espresso(4)

Black Silk(4)

Original(4)

Colombia(3)

Pumpkin Spice(3)

Classic Roast Regular(3)

Vermont Country Blend Decaf(3)

Our Blend(3)

100% Colombian(3)

Half-Caff(3)

Morning Blend(3)

Veranda Blend(3)

Mocha(2)

Daybreak Morning Blend(2)

Wild Mountain Blueberry(2)

Caribou Blend(2)

Mahogany(2)

Chocolate Glazed Donut(2)

Butter Toffee(2)

Café Domingo Blend(2)

Donut House(2)

Hawaiian Blend(2)

Caramel Vanilla Cream(2)

Mocha Nut Fudge(2)

Caribou Blend Decaf(2)

Island Coconut(2)

Southern Pecan(2)

Donut House Decaf(2)

Hawaiian Islands Blend(2)

Kona Blend(2)

Donut Shop(2)

Pikes Place(2)

Mudslide(2)

Emeril's Big Easy Bold(2)

Pike Place(2)

Caffè Verona(2)

Decaffeinated(2)

Filtro Classico Medium Roast(2)

Kahlúa Original(2)

Hazelnut Decaf(2)

French Vanilla Decaf(2)

Hazelnut Crème(2)

Hazelnut Créme(2)

Donut Shop Decaf(2)

Gran Filtro Dark Roast(2)

Gran Filtro Light Roast(2)

Lake & Lodge(2)

Morning Edition(2)

Kenyan AA(2)

Light Roast(2)

Colombian Fair Trade Select(2)

Newman's Own Special Blend Extra Bold(2)

Newman's Own Special Decaf(2)

Organic Sumatran Extra Bold(2)

Dark Magic Extra Bold(2)

French Roast Decaf(2)

Dark Magic Decaf Extra Bold(2)

Decaf(2)

Double Black Diamond Extra Bold(2)

Original Roast Decaf(1)

Eye Opener(1)

Dunkin WB Original(1)

Dunkin Dark Roast(1)

Tierra 100% Arabica Blend(1)

Aroma Club 100% Arabica Blend(1)

Crema Aroma Arabica/Robusta(1)

Aroma Point Blue Arabica/Robusta(1)

100% Arabica Blend Decaf(1)

Rainforest Espresso(1)

Italian Blend(1)

Gourmet Supreme(1)

German Chocolate Cake(1)

Espresso Roast(1)

Lively Colombian Decaf(1)

Decaf Signature-Level 3(1)

Veranda(1)

Traditional Roast Decaf(1)

100% Colombian Decaf(1)

Level 2(1)

Signature-Level 3(1)

Regular Roast(1)

Special Delivery(1)

Traditional Roast(1)

Level 4(1)

Colombia Medium(1)

Hazelnut Cream(1)

Hazelnut Creme(1)

Decaffeinated French Roast(1)

Special House Blend(1)

Cinnamon Pastry(1)

Sumatra(1)

Morning Café(1)

Café Verona(1)

Cafe Verona(1)

Raspberry Chocolate Truffle(1)

Colombian Blend(1)

Decaf Extra Bold(1)

Caramel Drizzle(1)

Vanilla Biscotti(1)

Lively Colombian(1)

Signature Blend Decaf(1)

Dark Royal(1)

Morning Edition Decaf(1)

Special Roast(1)

Original Roast(1)

Decaf Italian Roast(1)

Cinnamon Sugar Cookie(1)

Natural Vanilla(1)

Original Decaf(1)

Toasted Marshmallow Mocha(1)

Coconut Mocha(1)

Holiday Blend(1)

Vanilla Hazelnut Decaf(1)

Summer Sunrise(1)

Brazil Minas Naturais(1)

Rio Blend(1)

Signature Blend(1)

Extra Bold Breakfast Blend(1)

Dunkin Original(1)

Dark Magic(1)

Dunkin Decaf(1)

Cinnamon Roll(1)

Estate Costa Rican(1)

Colombian Supremo(1)

Dunkin French Vanilla(1)

Nantucket(1)

Organic House Blend(1)

Fair Trade Organic Breakfast Blend(1)

Natural Cinnamon(1)

Natural Caramel(1)

Vanilla(1)

Caramel(1)

Vanilla Hazelnut(1)

Caramel Hideaway(1)

Sumatra Mandheling(1)

 
Beverage Type

Coffee(314)

Decaffeinated Coffee(50)

Instant Coffee(2)

Half-caffeinated Coffee(2)

 
Manufacturer Part Number

4066(2)

30400(1)

302742(1)

30220(1)

30800(1)

302142(1)

40300(1)

60000(1)

4097(1)

4073(1)

30210(1)

308042(1)

30200(1)

9312(1)

9304(1)

9303(1)

9301(1)

9335(1)

9341(1)

PB4141CT(1)

PB4141(1)

9352(1)

70400(1)

705024(1)

4202(1)

2851(1)

2850(1)

2709(1)

4483(1)

7509(1)

04648(1)

7512(1)

7511(1)

7510(1)

2440(1)

2431(1)

0470(1)

0460(1)

0427(1)

9300(1)

0490(1)

0603(1)

2410(1)

2401(1)

1450(1)

70500(1)

7792CT(1)

6812(1)

6803CT(1)

6803(1)

6792CT(1)

6813(1)

6990(1)

6994(1)

6992CT(1)

6992(1)

6990CT(1)

6792(1)

6783CT(1)

6752CT(1)

6752(1)

6746(1)

6745(1)

6758(1)

6758CT(1)

6783(1)

6772CT(1)

6772(1)

6994CT(1)

6995(1)

7534(1)

7522CT(1)

7522(1)

71550(1)

7534CT(1)

7602(1)

7792(1)

7732CT(1)

7732(1)

7602CT(1)

70670(1)

70664(1)

6999CT(1)

6999(1)

6996(1)

6995CT(1)

7000(1)

70520(1)

70600(1)

70575(1)

70570(1)

04658(1)

862400(1)

011067986(1)

011067985CT(1)

011067985(1)

011067984CT(1)

011067986CT(1)

011067987(1)

11008130(1)

011068092CT(1)

011068092(1)

011067987CT(1)

011067984(1)

011067983CT(1)

504914(1)

504913(1)

501677(1)

501619(1)

504915(1)

504916(1)

011067983(1)

504918(1)

504917(1)

11008131(1)

11018131(1)

11008558(1)

11008556(1)

11008554(1)

11029358(1)

11008560(1)

1014962(1)

866550(1)

863070(1)

PB4137CT(1)

PB4137(1)

11023061(1)

11020676(1)

11018190(1)

11018187(1)

11018186(1)

11018185(1)

11018192(1)

11018193(1)

11019631(1)

11018197(1)

11018194(1)

501546(1)

501487(1)

32410(1)

01101(1)

01084(1)

00058(1)

33000(1)

21001(1)

23001(1)

22005(1)

22003(1)

22002(1)

00034(1)

86073(1)

026160(1)

866350(1)

866150(1)

6744(1)

026190(1)

026260(1)

32486(1)

026530(1)

026480(1)

23002(1)

23003(1)

39000(1)

33750(1)

33700(1)

32006(1)

39001(1)

39002(1)

500705(1)

500689(1)

500350(1)

39003(1)

32003(1)

25188(1)

25181(1)

24001(1)

23005(1)

23004(1)

25183(1)

25184(1)

25187(1)

25186(1)

25185(1)

390390(1)

6743CT(1)

0849(1)

0848(1)

0847(1)

0846(1)

1101(1)

1102(1)

1135(1)

1120(1)

1113(1)

1109(1)

0845(1)

0570(1)

63102(1)

63101(1)

63100(1)

63018(1)

63103(1)

63104(1)

0448(1)

0243(1)

0162(1)

192419(1)

192419CT(1)

4057(1)

4051CT(1)

4051(1)

4050CT(1)

4057CT(1)

4060(1)

4066CT(1)

4061CT(1)

4061(1)

4060CT(1)

4050(1)

193019CT(1)

192619CT(1)

192619(1)

192519CT(1)

192519(1)

192719(1)

192719CT(1)

193019(1)

192919CT(1)

192919(1)

63006(1)

52320(1)

0000126(1)

0000125(1)

320840(1)

320820(1)

0000128(1)

00016(1)

00678(1)

00374EA(1)

00374CT(1)

00055(1)

60224101CT(1)

60224-101(1)

60051-052(1)

60051046CT(1)

60051-046(1)

60051012CT(1)

60051052CT(1)

60051-056(1)

60052101CT(1)

60052-101(1)

60051056CT(1)

00679(1)

00680(1)

06927(1)

06922(1)

06897(1)

06451(1)

06930(1)

06931(1)

20540CT(1)

20540(1)

20421EA(1)

20421CT(1)

06437(1)

06433(1)

0529C(1)

01014(1)

00690(1)

00681(1)

0529CPL(1)

06114(1)

06430(1)

06239(1)

06122(1)

4067(1)

4067CT(1)

6602CT(1)

6602(1)

6570CT(1)

6570(1)

6606(1)

6606CT(1)

6613(1)

6612(1)

6611CT(1)

6611(1)

6547(1)

6546(1)

6534(1)

6523CT(1)

6523(1)

6520CT(1)

6534CT(1)

6542(1)

6545(1)

6544(1)

6543(1)

6613CT(1)

6614(1)

6720(1)

6700CT(1)

6700(1)

6694CT(1)

6720CT(1)

6722(1)

6743(1)

6732CT(1)

6732(1)

6722CT(1)

6694(1)

6685CT(1)

6661(1)

6659(1)

6624(1)

6614CT(1)

6662(1)

6663(1)

6685(1)

6680(1)

6663CT(1)

6520(1)

6503CT(1)

5470(1)

5469(1)

5339(1)

5305(1)

5471(1)

5493(1)

6003CT(1)

6003(1)

5814(1)

5531(1)

5304(1)

5303(1)

4441(1)

4432(1)

4426(1)

4162(1)

4461(1)

4493(1)

5161(1)

4792(1)

4732(1)

6024(1)

6106(1)

6425(1)

6408(1)

6407(1)

6406CT(1)

6501(1)

6501CT(1)

6503(1)

6502CT(1)

6502(1)

6406(1)

6405CT(1)

6115(1)

6111(1)

6110(1)

6107(1)

6204(1)

6248(1)

6405(1)

6336(1)

6305(1)

60051-012(1)

 
Country of Origin

US(293)

CA(53)

IT(19)

CO(3)

 
For Use With

Keurig Brewing System(188)

Drip Coffee Brewers(16)

Commercial Brewers(11)

Single Cup Brewers(9)

Commercial Coffee Brewers(7)

Keurig Vue Brewing System(6)

Pod Brewers(5)

LavAzza Espresso Point Machine (sold separately)(5)

Drip Coffee Maker; French Press(4)

Standard and Commercial Coffee Makers(2)

Standard Coffee Brewers(1)

Any traditional coffee maker(1)

Keurig Vue Brewing System(1)

Keurig Vue System Brewers(1)

K-Cup; Keurig Brewing System(1)

 
Capacity (Volume)

12 oz(3)

 
Capacity (Weight)

2.5 oz(25)

1.5 oz(16)

2 oz(14)

1 lb(13)

0.3 oz(9)

2.2 oz(7)

0.9 oz(6)

0.4 oz(6)

0.25 oz(5)

0.35 oz(5)

5 lb(4)

2.2 lbs(4)

2.25 oz(4)

12 oz(4)

10 oz(4)

1.5 oz.(3)

2.5 lbs(3)

4 lb(3)

20 oz(3)

24.2 oz(2)

1.1 oz(2)

1.2 oz(2)

0.1 oz(2)

22.6 oz(2)

28 oz(2)

32 oz(2)

48 oz(2)

1.75 oz(2)

30.5 oz(2)

0.12 oz(2)

40 oz(1)

1.4 oz(1)

1.25 oz(1)

36 oz(1)

34.5 oz(1)

33.9 oz(1)

29.3 oz(1)

0.8 oz(1)

16 oz(1)

1.05 oz(1)

8 oz(1)

18.4 oz(1)

7 g(1)

20.8 oz(1)

30.6 oz(1)

 
Roast Type

Medium(99)

Dark(51)

Light(40)

Dark Roast(4)

Light Roast(3)

Medium Roast(1)

 
 
 
 
 

© 2018-2019 Office 8, All Rights Reserved