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

Folgers(51)

Starbucks(37)

Lavazza(19)

Peet's Coffee & Tea(19)

Caribou Coffee(14)

Tully's Coffee(14)

Maxwell House(11)

Day to Day Coffee(10)

Dunkin Donuts(10)

Java One(9)

New England Coffee(9)

PapaNicholas Coffee(9)

Eight O'Clock(9)

Melitta(8)

Barista Prima Coffeehouse(8)

Café Bustelo(7)

Nescafé(6)

Diedrich Coffee(6)

Donut House(6)

Gloria Jean's(6)

1850(6)

Newman's Own Organics(6)

The Original Donut Shop(5)

Hills Bros.(4)

Coffee People(4)

Café Escapes(4)

McCafe(4)

Gevalia(4)

Seattle's Best(4)

Yuban(3)

National Coffee Roasters(3)

Distant Lands Coffee(3)

revv(3)

Krispy Kreme Doughnuts(3)

Panera Bread at HOME(2)

Emeril's(2)

Kahlúa(2)

Tim Hortons(2)

Chase & Sanborn(2)

Office Snax(1)

Cinnabon(1)

Chock full o'Nuts(1)

BUSTELO cool(1)

 
Quantity

24 per box(3)

36 per carton(2)

96 per carton(1)

 
Packing Type

K-Cup(214)

Fraction Pack(45)

Bag(40)

Packet(28)

Pod(27)

Canister(12)

Can(12)

Stick(10)

Filter Pack(8)

Portion Pack(5)

Vacket Pack(3)

Cartridges(3)

Brick Pack(2)

Jar(1)

Lavazza BLUE Capsule(1)

 
Flavor

French Roast(23)

Breakfast Blend(17)

House Blend(16)

Classic Roast(15)

Hazelnut(10)

French Vanilla(10)

Original Blend(9)

Regular(7)

Italian Roast(7)

Assorted(6)

Original(6)

100% Colombian(6)

Espresso(6)

Dark Roast(6)

Black Silk(5)

Decaffeinated(5)

Caffe Verona(5)

House Blend Decaf(5)

Hazelnut Creme(5)

Medium Roast(5)

Classic Roast Decaf(5)

Colombian(4)

Pike Place Decaf(4)

Pike Place(4)

Decaf House Blend(4)

Breakfast Blend Decaf(4)

Major Dickason's Blend(4)

Vermont Country Blend(3)

Nantucket Blend(3)

Pumpkin Spice(3)

Veranda Blend(3)

Caribou Blend(3)

Caramel(3)

Colombian Decaf(3)

Vermont Country Blend Decaf(3)

Colombia(3)

Morning Blend(3)

Daybreak Morning Blend(3)

Caramel Vanilla Cream(2)

Hawaiian Blend(2)

Filtro Classico Medium Roast(2)

Island Coconut(2)

Our Blend(2)

Chocolate Glazed Donut(2)

Donut House(2)

Half Caff(2)

Hawaiian Islands Blend(2)

Hazelnut Decaf(2)

Lake & Lodge(2)

Gran Filtro Dark Roast(2)

Café Domingo Blend(2)

Morning Edition(2)

Vanilla Hazelnut(2)

Half-Caff(2)

Kahlúa Original(2)

Donut House Decaf(2)

French Vanilla Decaf(2)

Caribou Blend Decaf(2)

Mahogany(2)

Southern Pecan(2)

Gran Filtro Light Roast(2)

Wild Mountain Blueberry(2)

Mocha(2)

Colombian Supremo(2)

Single Origin Colombian Select(2)

Simply Smooth(2)

Organic Sumatran Extra Bold(2)

Dark Magic Extra Bold(2)

Dark Magic Decaf Extra Bold(2)

Pioneer Blend(2)

Special Decaf(2)

Special Blend Extra Bold(2)

Hazelnut Cream(2)

Emeril's Big Easy Bold(2)

French Roast Decaf(2)

Black Gold(2)

Traditional Roast(2)

Double Black Diamond Extra Bold(2)

Butter Toffee(2)

Donut Shop(2)

Pier 70 Blend(1)

Portside Blend(1)

Estate Costa Rican(1)

Sumatra Mandheling(1)

Crema Aroma Arabica/Robusta(1)

Decaf Portside Blend(1)

6th Avenue Bistro(1)

Sumatran(1)

Special House Blend(1)

Donut Shop Regular(1)

Dark Magic(1)

Special Blend(1)

Regular Roast(1)

Columbia Select Single Origin(1)

Decaffeinated French Roast(1)

Special Delivery(1)

Kenya Highlands(1)

Costa Rica Paraiso(1)

Aroma Club 100% Arabica Blend(1)

100% Arabica Blend Decaf(1)

French Dark Roast(1)

Breakfast Blend (Light Roast)(1)

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

Love at First Sip (Medium Roast)(1)

Veranda(1)

Parisian Café (Dark Roast)(1)

Colombia Medium(1)

Original Roast Decaf(1)

Pike Place Roast(1)

Buzzworthy (Dark Roast)(1)

Parisian Vanilla(1)

Colombian Blend(1)

Kona Blend(1)

Veranda Blend Blonde Roast(1)

Donut Shop Decaf(1)

Eye Opener(1)

Crema Dolce/Medium Roast(1)

Decaf Caribou Blend(1)

Sumatra(1)

Decaf Pike Place Roast(1)

Cafe Vanilla(1)

Toasted Marshmallow Mocha(1)

Cinnamon Sugar Cookie(1)

Country Roast(1)

Signature Blend Decaf(1)

Dark Royal(1)

Perfetto(1)

Gran Aroma(1)

Coconut Mocha(1)

Holiday Blend(1)

Classic Decaf(1)

Classic(1)

Original Roast(1)

Signature Blend(1)

Dunkin' Decaf(1)

Dunkin' Dark(1)

Lively Colombian Decaf(1)

Morning Café(1)

Donut Shop Blend(1)

Caramel Coffee Cake(1)

100% Colombian Decaf(1)

Traditional Roast Decaf(1)

Lantern Glow(1)

Trailblazer(1)

Extra Bold Breakfast Blend(1)

Cinnamon Roll(1)

Original Decaf(1)

Caramel Hideaway(1)

Premium Roast(1)

Bold 1937(1)

NO SURRENDER(1)

Café con Leche(1)

Premium Roast Decaf(1)

Estilo Espresso(1)

Dark Blend(1)

Round the Clock Blend(1)

Cinnamon(1)

Medium Decaf(1)

Rio Blend(1)

Morning Edition Decaf(1)

Decaf Italian Roast(1)

Gourmet Supreme(1)

Special Roast(1)

Brazil Minas Naturais(1)

Lively Colombian(1)

Vanilla Biscotti(1)

TURBOCHARGER(1)

AFTERBURNER(1)

Caramel Drizzle(1)

Big Bang(1)

Decaf(1)

 
Beverage Type

Coffee(338)

Decaffeinated Coffee(62)

Instant Coffee(6)

Half-caffeinated Coffee(4)

Coffee Drink(1)

 
Manufacturer Part Number

30220(1)

302742(1)

30210(1)

30200(1)

PB4141CT(1)

30400(1)

30800(1)

70400(1)

60000(1)

40300(1)

308042(1)

PB4141(1)

8784(1)

7792CT(1)

7993(1)

7792(1)

7746(1)

7732CT(1)

7994(1)

7995(1)

8087(1)

8007(1)

7999(1)

7996(1)

70500(1)

705024(1)

75412(1)

75413(1)

75411(1)

75410(1)

970(1)

75415(1)

75416(1)

04648CT(1)

04648(1)

75424(1)

75421(1)

4483(1)

4202(1)

1450(1)

2401(1)

0603(1)

0470(1)

0460(1)

2410(1)

2431(1)

2851(1)

2850(1)

2709(1)

2440(1)

7732(1)

7614(1)

6990(1)

6990CT(1)

6974(1)

6873(1)

6813(1)

6992(1)

6992CT(1)

6995CT(1)

6995(1)

6994CT(1)

6994(1)

6812(1)

6803CT(1)

6758CT(1)

6772(1)

6758(1)

6746(1)

6745(1)

6772CT(1)

6783(1)

6803(1)

6792CT(1)

6792(1)

6783CT(1)

6996(1)

6999(1)

7594(1)

7595(1)

7586(1)

7585(1)

7564(1)

7596(1)

7602(1)

7608(1)

7607(1)

7605(1)

7602CT(1)

7563(1)

7534CT(1)

7465(1)

71550(1)

7000(1)

6999CT(1)

7466(1)

7467(1)

7534(1)

7522CT(1)

7522(1)

7468(1)

04658(1)

390390(1)

11008131(1)

11015640(1)

11008130(1)

011068092CT(1)

011068092(1)

11017854(1)

11017860EA(1)

11018186(1)

11018185(1)

11018131(1)

11017871(1)

011067987CT(1)

011067987(1)

011067983(1)

011067983CT(1)

504918(1)

504917(1)

504916(1)

011067984(1)

011067984CT(1)

011067986CT(1)

011067986(1)

011067985CT(1)

011067985(1)

11018187(1)

11018190(1)

11008558(1)

11008560(1)

11008556(1)

11008554(1)

11075823(1)

1261330(1)

PB4137(1)

866550(1)

863070(1)

04707(1)

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

504915(1)

504914(1)

01084(1)

01096(1)

01027(1)

00058(1)

86073(1)

01101(1)

02059(1)

23002(1)

23001(1)

33000(1)

32410(1)

66488CT(1)

66488(1)

026160(1)

026190(1)

866350(1)

866150(1)

862400(1)

026260(1)

026480(1)

32486(1)

15782CT(1)

15782(1)

026530(1)

23003(1)

23004(1)

500350(1)

500689(1)

39002(1)

39000(1)

33750(1)

500705(1)

501487(1)

504913(1)

501677(1)

501619(1)

501546(1)

33700(1)

33300(1)

25184(1)

25183(1)

25181(1)

23005(1)

25185(1)

25186(1)

32006(1)

32003(1)

25188(1)

25187(1)

6744(1)

6743CT(1)

63101(1)

63102(1)

63100CT(1)

63100(1)

63006(1)

63103(1)

63104(1)

0040(1)

0038(1)

0037(1)

0036(1)

60518(1)

60517(1)

20672(1)

52320(1)

20540CT(1)

20540(1)

20527CT(1)

56375(1)

56376(1)

60516(1)

60515(1)

60514(1)

60513(1)

0162(1)

0448(1)

192719CT(1)

192919(1)

192719(1)

192619CT(1)

192619(1)

192919CT(1)

193019(1)

4051(1)

4050CT(1)

4050(1)

193019CT(1)

192519CT(1)

192519(1)

0847(1)

0848(1)

0846(1)

0845(1)

0570(1)

0849(1)

0995(1)

192419CT(1)

192419(1)

1281(1)

1279(1)

20527(1)

20513CT(1)

320840(1)

00016(1)

320820(1)

8599961590(1)

599961590(1)

00019(1)

00055(1)

01074(1)

01014(1)

00374EA(1)

00374CT(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)

01500(1)

01720(1)

06930(1)

06931(1)

06927(1)

06922(1)

06897(1)

10107(1)

10117(1)

20513(1)

20421PL(1)

20421EA(1)

20421CT(1)

06547(1)

06451(1)

06114(1)

0529CPL(1)

0529C(1)

01720CT(1)

06122(1)

06125(1)

06437(1)

06433(1)

06430(1)

06239(1)

4051CT(1)

4060(1)

6602(1)

6602CT(1)

6570CT(1)

6570(1)

6547(1)

6606(1)

6606CT(1)

6613(1)

6612(1)

6611CT(1)

6611(1)

6546(1)

6545(1)

6520CT(1)

6523(1)

6520(1)

6503CT(1)

6503(1)

6523CT(1)

6534(1)

6544(1)

6543(1)

6542(1)

6534CT(1)

6613CT(1)

6614(1)

6720CT(1)

6722(1)

6720(1)

6700CT(1)

6700(1)

6722CT(1)

6727(1)

6743(1)

6732CT(1)

6732(1)

6728(1)

6694CT(1)

6694(1)

6661(1)

6662(1)

6659(1)

6624(1)

6614CT(1)

6663(1)

6663CT(1)

6685CT(1)

6685(1)

6680(1)

6664(1)

6502CT(1)

6502(1)

5304(1)

5305(1)

5303(1)

5161(1)

4792(1)

5339(1)

5469(1)

5531(1)

5493(1)

5471(1)

5470(1)

4732(1)

4493(1)

4066(1)

4066CT(1)

4061CT(1)

4061(1)

4060CT(1)

4067(1)

4067CT(1)

4461(1)

4441(1)

4432(1)

4162(1)

5807(1)

5814(1)

6405CT(1)

6406(1)

6405(1)

6376(1)

6305(1)

6406CT(1)

6407(1)

6501CT(1)

6501(1)

6425(1)

6408(1)

6248(1)

6204(1)

6003(1)

6002(1)

6001(1)

6000(1)

6003CT(1)

6006(1)

6111(1)

6110(1)

6107(1)

6106(1)

008710(1)

 
Country of Origin

US(353)

CA(43)

IT(14)

AX(1)

 
For Use With

Keurig K-Cup System(211)

Commercial Coffee Brewers(22)

Drip Coffee Brewers(9)

Pod Brewers(9)

Single Cup Brewers(9)

Standard Coffee Brewers(4)

Keurig Brewing System(3)

Standard and Commercial Coffee Makers(2)

LavAzza Espresso Point Machine(2)

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

Any traditional coffee maker(1)

LavAzza Espresso Point Machine (sold separately)(1)

Lavazza 2312 BLUE Machine(1)

 
Capacity (Volume)

0.27 oz(3)

10 oz(2)

0(1)

25.1 oz(1)

8 oz(1)

 
Capacity (Weight)

2.5 oz(29)

1 lb(19)

0.3 oz(17)

1.5 oz(13)

2 oz(10)

2.2 oz(8)

0.9 oz(6)

0.35 oz(6)

12 oz(6)

0.4 oz(5)

1.4 oz(4)

2.25 oz(4)

2.2 lbs(4)

0.06 oz(4)

0.12 oz(4)

0.25 oz(3)

1.1 oz(3)

1.75 oz(3)

28 oz(3)

30.5 oz(3)

22.6 oz(2)

30.6 oz(2)

48 oz(2)

1.2 oz(2)

32 oz(2)

1.05 oz(2)

31.1 oz(2)

24.2 oz(2)

0.1 oz(2)

2.5 lbs(2)

25.4 oz(2)

45 oz(1)

33.9 oz(1)

26 oz(1)

31 oz(1)

34.5 oz(1)

1.25 oz(1)

5 lb(1)

16 oz(1)

0.8 oz(1)

0.6 oz(1)

36 oz(1)

0.33 oz(1)

8 oz(1)

8 g(1)

7 g(1)

10 oz(1)

29.3 oz(1)

 
Roast Type

Medium(128)

Dark(90)

Light(43)

Dark Roast(1)

 
 
 
 
 

© 2019-2020 Office 8, All Rights Reserved