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

Folgers(51)

Starbucks(29)

Lavazza(24)

Peet's Coffee & Tea(20)

Day to Day Coffee(17)

Tully's Coffee(14)

Dunkin Donuts(11)

PapaNicholas Coffee(10)

Caribou Coffee(10)

Maxwell House(9)

Java One(9)

Eight O'Clock(9)

Barista Prima Coffeehouse(8)

Melitta(7)

Distant Lands Coffee(6)

Donut House(6)

Gloria Jean's(6)

Café Bustelo(6)

The Original Donut Shop(6)

Timothy's World Coffee(6)

New England Coffee(5)

Diedrich Coffee(5)

Newman's Own Organics(5)

revv(4)

Hills Bros.(4)

Gevalia(4)

Seattle's Best(4)

Nescafé(4)

Café Escapes(4)

Folgers Simply Gourmet(3)

Chase & Sanborn(3)

National Coffee Roasters(3)

Panera Bread(3)

Yuban(3)

Van Houtte(2)

Emeril's(2)

BUSTELO cool(2)

Krispy Kreme Doughnuts(2)

Kahlúa(2)

Office Snax(2)

Coffee People(1)

Cinnabon(1)

Coffee-mate(1)

Chock full o'Nuts(1)

 
Quantity

24 per box(111)

96 per carton(60)

1 each(46)

42 per carton(33)

18 per box(21)

22 per box(12)

14 per box(9)

18 per carton(8)

50 per carton(8)

100 per box(7)

2 per carton(7)

6 per carton(6)

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

36 per carton(6)

40 per carton(5)

88 per carton(5)

30 per carton(4)

42 per box(4)

24 per box.(3)

50 per box(3)

60 per carton(3)

24 per carton(3)

15 per box(3)

12 per pack(2)

100 per carton(2)

40 per box(2)

80 per box(2)

8 per box(2)

16 per box(2)

63 per carton(1)

3 per pack(1)

150 per carton(1)

294 per pallet(1)

108 per carton(1)

4 per carton(1)

160 per carton(1)

1 bag(1)

210 per pallet(1)

18 per pack(1)

 
Packing Type

K-Cup(190)

Bag(48)

Fraction Pack(44)

Packet(30)

Pod(26)

Can(15)

Canister(12)

Filter Pack(8)

Stick(8)

Cartridges(5)

Portion Pack(5)

Lavazza BLUE Capsule(3)

Vacuum Bag(3)

Vacket Pack(3)

Vue Pack(2)

Pump Bottle(1)

Brick Pack(1)

Jar(1)

 
Flavor

French Roast(22)

Breakfast Blend(16)

House Blend(14)

Classic Roast(12)

Dark Roast(12)

Original Blend(10)

French Vanilla(9)

Hazelnut(9)

Italian Roast(7)

Regular(7)

Classic Roast Decaf(6)

Original(6)

Assorted(6)

Espresso(6)

Medium Roast(5)

Colombian Decaf(5)

Black Silk(5)

100% Colombian(4)

Colombia(4)

House Blend Decaf(4)

Colombian(4)

Classic Roast Regular(4)

Breakfast Blend Decaf(4)

Major Dickason's Blend(4)

Pike Place(4)

Pike Place Decaf(4)

Decaf House Blend(4)

Vermont Country Blend(4)

Morning Blend(3)

Nantucket Blend(3)

Pumpkin Spice(3)

Vermont Country Blend Decaf(3)

Decaf(3)

Veranda Blend(3)

Decaffeinated(3)

Our Blend(3)

Lake & Lodge(2)

Hawaiian Blend(2)

Donut House(2)

Morning Edition(2)

Chocolate Glazed Donut(2)

Colombian Fair Trade Select(2)

Caramel Vanilla Cream(2)

Island Coconut(2)

Butter Toffee(2)

Caribou Blend Decaf(2)

Gran Filtro Dark Roast(2)

Gran Filtro Light Roast(2)

Hazelnut Créme(2)

Hazelnut Crème(2)

Filtro Classico Medium Roast(2)

Kona Blend(2)

Emeril's Big Easy Bold(2)

Caffè Verona(2)

Hawaiian Islands Blend(2)

Colombian Supremo(2)

Kahlúa Original(2)

Caribou Blend(2)

Mahogany(2)

Mocha(2)

Wild Mountain Blueberry(2)

Daybreak Morning Blend(2)

Half-Caff(2)

Hazelnut Decaf(2)

French Vanilla Decaf(2)

Donut House Decaf(2)

Southern Pecan(2)

Café Domingo Blend(2)

Organic Sumatran Extra Bold(2)

Arabica Blend(2)

Double Black Diamond Extra Bold(2)

Donut Shop Decaf(2)

Kenyan AA(2)

Newman's Own Special Decaf(2)

Hazelnut Cream(2)

French Roast Decaf(2)

Newman's Own Special Blend Extra Bold(2)

Half Caff(2)

Dark Magic Extra Bold(2)

Dark Magic Decaf Extra Bold(2)

Donut Shop(2)

Simply Smooth(2)

Dunkin WB Original(1)

Love at First Sip (Medium Roast)(1)

Buzzworthy (Dark Roast)(1)

Parisian Vanilla(1)

Sumatra Mandheling(1)

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

Original Roast Decaf(1)

Dunkin Original(1)

Breakfast Blend (Light Roast)(1)

Crema Dolce/Light Roast(1)

Intenso/Medium Roast(1)

Dunkin Decaf(1)

Eye Opener(1)

Tierra 100% Arabica Blend(1)

Dunkin French Vanilla(1)

Aroma Club 100% Arabica Blend(1)

Crema Aroma Arabica/Robusta(1)

Dunkin Dark Roast(1)

100% Arabica Blend Decaf(1)

Aroma Point Blue Arabica/Robusta(1)

Rotondo/Dark Roast Double(1)

Special House Blend(1)

Veranda(1)

Jet Fuel(1)

Colombia Medium(1)

Café Verona(1)

Decaf Signature-Level 3(1)

Level 2(1)

Regular Roast(1)

Special Delivery(1)

Level 4(1)

Signature-Level 3(1)

Cafe Verona(1)

Medium Decaf(1)

Natural Vanilla(1)

Colombian Blend(1)

Natural Caramel(1)

Natural Cinnamon(1)

Café con Leche(1)

Decaffeinated French Roast(1)

Medium(1)

Sumatra(1)

Cafe Domingo(1)

Hazelnut Creme(1)

Cafe Mocha(1)

Special Roast(1)

Decaf Italian Roast(1)

Extra Bold Breakfast Blend(1)

Brazil Minas Naturais(1)

Original Decaf(1)

Lively Colombian(1)

Vanilla Biscotti(1)

German Chocolate Cake(1)

Rainforest Espresso(1)

Cinnamon Pastry(1)

Caramel Drizzle(1)

Toasted Marshmallow Mocha(1)

Cinnamon Roll(1)

Cinnamon Sugar Cookie(1)

Signature Blend Decaf(1)

Dark Royal(1)

Original Roast(1)

Espresso Roast(1)

Fair Trade Organic Breakfast Blend(1)

Coconut Mocha(1)

Holiday Blend(1)

Light Roast(1)

Vanilla Hazelnut Decaf(1)

Morning Edition Decaf(1)

Rio Blend(1)

Country Roast(1)

Dark Magic(1)

Nantucket(1)

Organic House Blend(1)

Signature Blend(1)

Decaf Extra Bold(1)

Colombian De Jardin(1)

Estate Costa Rican(1)

Café con Leche Chocolate(1)

Gourmet Supreme(1)

Vanilla Hazelnut(1)

Traditional Roast(1)

Raspberry Chocolate Truffle(1)

Morning Café(1)

Lively Colombian Decaf(1)

Italian Blend(1)

Vanilla(1)

Caramel(1)

Caramel Hideaway(1)

Traditional Roast Decaf(1)

100% Colombian Regular(1)

100% Colombian Decaf(1)

Costa Rican La Sonrisa(1)

 
Beverage Type

Coffee(348)

Decaffeinated Coffee(51)

Instant Coffee(3)

Coffee Pod(3)

Coffee Drink(2)

Half-caffeinated Coffee(2)

Decaffeinated Instant Coffee(1)

 
Manufacturer Part Number

4066(2)

0427(1)

705024(1)

70400(1)

60000(1)

70500(1)

0460(1)

1450(1)

2401(1)

0603(1)

0490(1)

0470(1)

4097(1)

40300(1)

30220(1)

302742(1)

302142(1)

30210(1)

30200(1)

30400(1)

30800(1)

2410(1)

39930404021(1)

39930274021(1)

308042(1)

4073(1)

2431(1)

75413(1)

75415(1)

75412(1)

75411(1)

75410(1)

75416(1)

75421(1)

390390(1)

04658(1)

04648CT(1)

04648(1)

970(1)

950(1)

2851(1)

2850(1)

2709(1)

2440(1)

3302(1)

4202(1)

940(1)

7512(1)

7509(1)

4483(1)

PB4141CT(1)

PB4141(1)

6813(1)

6873(1)

6812(1)

6803CT(1)

6803(1)

6990(1)

6990CT(1)

6994CT(1)

6994(1)

6992CT(1)

6992(1)

6792CT(1)

6792(1)

6745(1)

6746(1)

6744(1)

6743CT(1)

6743(1)

6758(1)

6758CT(1)

6783CT(1)

6783(1)

6772CT(1)

6772(1)

6995(1)

6995CT(1)

7602(1)

7602CT(1)

7534CT(1)

7534(1)

7522CT(1)

7732(1)

7732CT(1)

9352(1)

9341(1)

7792CT(1)

7792(1)

7522(1)

71550(1)

7000(1)

6999CT(1)

6999(1)

6996(1)

70520(1)

70570(1)

70670(1)

70664(1)

70600(1)

70575(1)

862400(1)

866150(1)

011067985CT(1)

011067986(1)

011067985(1)

011067984CT(1)

011067984(1)

011067986CT(1)

011067987(1)

11008130(1)

011068092CT(1)

011068092(1)

011067987CT(1)

011067983CT(1)

011067983(1)

501677(1)

504874(1)

501619(1)

501546(1)

501487(1)

504913(1)

504914(1)

504918(1)

504917(1)

504916(1)

504915(1)

11008131(1)

11018131(1)

11008558(1)

11008560(1)

11008556(1)

11008554(1)

11029358(1)

1014962(1)

PB4137(1)

866550(1)

863070(1)

04707(1)

PB4137CT(1)

11023061(1)

11020676(1)

11018190(1)

11018192(1)

11018187(1)

11018186(1)

11018185(1)

11018193(1)

11018194(1)

11019881(1)

11019880(1)

11019631(1)

11018197(1)

500705(1)

500689(1)

01101(1)

02059(1)

01096(1)

01084(1)

01027(1)

32410(1)

32420(1)

22003(1)

22002(1)

21001(1)

33000(1)

00058(1)

00034(1)

026260(1)

026480(1)

026190(1)

026160(1)

866350(1)

026530(1)

15782(1)

86073(1)

83426(1)

66488(1)

32486(1)

22005(1)

23001(1)

33300(1)

33700(1)

32006(1)

32003(1)

25188(1)

33750(1)

39000(1)

500350(1)

39003(1)

39002(1)

39001(1)

25187(1)

25186(1)

23005(1)

23004(1)

23003(1)

23002(1)

24001(1)

25181(1)

25185(1)

25184(1)

25183(1)

25182(1)

6732CT(1)

6732(1)

63102(1)

63103(1)

63101(1)

63100CT(1)

63100(1)

63104(1)

72909(1)

0570(1)

0448(1)

0243(1)

0162(1)

63018(1)

63006(1)

20513(1)

20513CT(1)

20421PL(1)

20421EA(1)

20421CT(1)

20527(1)

20527CT(1)

52320(1)

20631CT(1)

20540CT(1)

20540(1)

0845(1)

0846(1)

192719(1)

192719CT(1)

192619CT(1)

192619(1)

192519CT(1)

192919(1)

192919CT(1)

4050CT(1)

4050(1)

193019CT(1)

193019(1)

192519(1)

192419CT(1)

1101(1)

0849(1)

0848(1)

0847(1)

1102(1)

1109(1)

192419(1)

1135(1)

1120(1)

1113(1)

10117(1)

10107(1)

0000126(1)

0000128(1)

0000125(1)

320840(1)

320820(1)

00016(1)

00019(1)

00374EA(1)

00374CT(1)

00055(1)

00050(1)

8599961590(1)

599961590(1)

60051-052(1)

60051052CT(1)

60051046CT(1)

60051-046(1)

60051012CT(1)

60052-101(1)

60052101CT(1)

1099961590(1)

60224101CT(1)

60224-101(1)

60052-103(1)

00678(1)

00679(1)

06433(1)

06437(1)

06430(1)

06239(1)

06125(1)

06451(1)

06897(1)

06931(1)

06930(1)

06927(1)

06922(1)

06122(1)

06119(1)

01014(1)

00690(1)

00681(1)

00680(1)

01500(1)

01501(1)

06114(1)

0529CPL(1)

0529C(1)

01720CT(1)

4051(1)

4051CT(1)

6547(1)

6570(1)

6546(1)

6545(1)

6544(1)

6570CT(1)

6602(1)

6611(1)

6606CT(1)

6606(1)

6602CT(1)

6543(1)

6542(1)

6503(1)

6503CT(1)

6502CT(1)

6502(1)

6501CT(1)

6520(1)

6520CT(1)

6534CT(1)

6534(1)

6523CT(1)

6523(1)

6611CT(1)

6612(1)

6700(1)

6700CT(1)

6694CT(1)

6694(1)

6685CT(1)

6720(1)

6720CT(1)

6728(1)

6727(1)

6722CT(1)

6722(1)

6685(1)

6680(1)

6614CT(1)

6614(1)

6613CT(1)

6613(1)

6624(1)

6659(1)

6663CT(1)

6663(1)

6662(1)

6661(1)

6501(1)

6425(1)

4732(1)

4792(1)

4493(1)

4461(1)

4441(1)

5161(1)

5303(1)

5469(1)

5339(1)

5305(1)

5304(1)

4432(1)

4426(1)

4060CT(1)

4061(1)

4060(1)

4057CT(1)

4057(1)

4061CT(1)

4062CT(1)

4162(1)

4067CT(1)

4067(1)

4066CT(1)

5470(1)

5471(1)

6305(1)

6336(1)

6248(1)

6204(1)

6111(1)

6405(1)

6405CT(1)

6408(1)

6407(1)

6406CT(1)

6406(1)

6110(1)

6107(1)

6000(1)

5814(1)

5531(1)

5493(1)

6001(1)

6003(1)

6106(1)

6024(1)

6006(1)

6003CT(1)

60051-012(1)

 
Country of Origin

US(330)

CA(55)

IT(21)

CO(4)

 
For Use With

Keurig Brewing System(188)

Drip Coffee Brewers(17)

Commercial Coffee Brewers(11)

Commercial Brewers(11)

Single Cup Brewers(9)

Pod Brewers(6)

LavAzza Espresso Point Machine (sold separately)(5)

Single Serve Pod Brewing Systems(3)

K-Cup Brewer(3)

Standard Coffee Brewers(3)

Keurig Vue Brewing System(2)

Drip Coffee Maker; French Press(2)

Standard and Commercial Coffee Makers(2)

Lavazza BLUE 2312 and 910 Machines(1)

Lavazza BLUE Single-Cup Brewing System(1)

Lavazza 2312 BLUE Machine(1)

K-Cup; Keurig Brewing System(1)

1/2-Gallon Brewers(1)

Home Brewers(1)

Any traditional coffee maker(1)

Electric Espresso Machines(1)

 
Capacity (Volume)

12 oz(3)

8 oz(2)

1.5 L(1)

8 g(1)

0.9 oz(1)

10 oz(1)

 
Capacity (Weight)

2.5 oz(26)

2 oz(16)

0.3 oz(16)

1.5 oz(16)

1 lb(13)

0.4 oz(7)

0.9 oz(7)

2.2 oz(7)

0.35 oz(6)

0.25 oz(5)

10 oz(5)

2.2 lbs(4)

1.4 oz(4)

2.25 oz(4)

5 lb(4)

0.12 oz(4)

28 oz(3)

4 lb(3)

20 oz(3)

1.5 oz.(3)

1.1 oz(3)

2.5 lbs(3)

1.75 oz(3)

31.1 oz(3)

30.5 oz(3)

30.6 oz(2)

0.1 oz(2)

12 oz(2)

1.25 oz(2)

25.4 oz(2)

1.2 oz(2)

24.2 oz(2)

0.06 oz(2)

32 oz(2)

22.6 oz(2)

16 oz(2)

48 oz(2)

34.5 oz(1)

40 oz(1)

31 oz(1)

26 oz(1)

33.9 oz(1)

8 oz(1)

0.8 oz(1)

18.4 oz(1)

20.8 oz(1)

36 oz(1)

1.05 oz(1)

0.634 oz(1)

11.5 g(1)

8 g(1)

7 g(1)

8.8 oz(1)

29.3 oz(1)

 
Roast Type

Medium(103)

Dark(60)

Light(39)

Dark Roast(5)

Light Roast(3)

Medium Roast(1)

 
 
 
 
 

© 2018-2019 Office 8, All Rights Reserved