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','out_of_stock') 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(82)

Folgers(51)

Starbucks(34)

Peet's Coffee & Tea(19)

1850(16)

Lavazza(15)

Day to Day Coffee(15)

Café Bustelo(14)

Tully's Coffee(14)

Caribou Coffee(13)

NESCAFÉ Dolce Gusto(12)

Maxwell House(12)

PapaNicholas Coffee(10)

Eight O'Clock(9)

New England Coffee(9)

The Original Donut Shop(9)

Melitta(8)

Barista Prima Coffeehouse(8)

Java One(7)

Diedrich Coffee(6)

Gloria Jean's(6)

Nescafé(6)

Distant Lands Coffee(6)

Seattle's Best(5)

Dunkin Donuts(5)

Newman's Own Organics(5)

Café Escapes(4)

McCafe(4)

Krispy Kreme Doughnuts(3)

National Coffee Roasters(3)

Tim Hortons(3)

Yuban(3)

Laughing Man Coffee Company(3)

Coffee People(3)

Panera Bread at HOME(3)

revv(3)

Gevalia(3)

Donut House(3)

Kahlúa(2)

illy(2)

BUSTELO cool(2)

Emeril's(2)

Cinnabon(1)

Dunkin' Donuts®(1)

Chock full o'Nuts(1)

Chase & Sanborn(1)

 
Quantity

42 per carton(5)

36 per carton(4)

24 per box(3)

40 per box(2)

24 per carton(1)

12 per pack(1)

96 per carton(1)

18 per carton(1)

 
Packing Type

K-Cup(214)

Bag(53)

Fraction Pack(49)

Pod(29)

Packet(27)

Can(13)

Canister(13)

Capsule(11)

Filter Pack(8)

Stick(8)

Portion Pack(5)

Lavazza BLUE Capsule(3)

Vacket Pack(3)

Cartridges(3)

Jar(2)

Brick Pack(2)

Coffee Pod(1)

Capsules(1)

 
Flavor

French Roast(24)

Breakfast Blend(20)

House Blend(15)

Classic Roast(14)

Hazelnut(12)

Espresso(11)

French Vanilla(11)

Dark Roast(8)

Original(7)

Regular(7)

Hazelnut Creme(6)

Assorted(6)

Italian Roast(6)

Medium Roast(6)

House Blend Decaf(5)

Pioneer Blend(5)

Decaffeinated(5)

100% Colombian(5)

Black Gold(5)

Breakfast Blend Decaf(5)

Classic Roast Decaf(5)

Caffe Verona(5)

Black Silk(5)

Veranda Blend(5)

Pike Place Decaf(4)

Morning Blend(4)

Colombian(4)

Decaf House Blend(4)

Major Dickason's Blend(4)

Pike Place(4)

Colombian Supremo(3)

Dark Magic(3)

Original Blend(3)

Vermont Country Blend(3)

Nantucket Blend(3)

Vermont Country Blend Decaf(3)

Daybreak Morning Blend(3)

Caribou Blend(3)

Pumpkin Spice(3)

Donut Shop Regular(3)

Mocha(3)

Lantern Glow(3)

Decaf(3)

Blonde Espresso Roast(2)

Latte Macchiato(2)

Colombia(2)

Morning Edition(2)

Colombian Decaf(2)

Caramel Macchiato(2)

Hawaiian Blend(2)

Butter Toffee(2)

Single Origin Colombian Select(2)

Sumatra(2)

Half-Caff(2)

Our Blend(2)

Caribou Blend Decaf(2)

Mahogany(2)

Caramel(2)

Café Domingo Blend(2)

Lake & Lodge(2)

Wild Mountain Blueberry(2)

Kahlúa Original(2)

Brazil Minas Naturais(2)

Simply Smooth(2)

Trailblazer(2)

Hazelnut Cream(2)

Island Coconut(2)

French Vanilla Decaf(2)

Half Caff(2)

Caramel Vanilla Cream(2)

Southern Pecan(2)

French Roast Decaf(2)

Hawaiian Islands Blend(2)

Big Easy Bold(2)

Espresso Decaf(2)

Special Blend Extra Bold(2)

Special Decaf(2)

Organic Sumatran Extra Bold(2)

Dark Magic Extra Bold(2)

Double Black Diamond Extra Bold(2)

Dark Magic Decaf Extra Bold(2)

Special Roast(2)

Donut House(2)

Rotondo/Dark Roast(1)

Crema Dolce/Medium Roast(1)

Sumatran(1)

Decaffeinated Medium Roast(1)

100% Arabica Blend Decaf(1)

Aroma Club 100% Arabica Blend(1)

Crema Aroma Arabica/Robusta(1)

Sumatra Mandheling(1)

Costa Rican La Sonrisa(1)

Special Delivery(1)

Colombian De Jardin(1)

Chocolate(1)

Kenya Highlands(1)

Decaf Italian Roast(1)

Ethiopian Supreme(1)

Parisian Vanilla(1)

6th Avenue Bistro(1)

Buzzworthy (Dark Roast)(1)

Kona Blend(1)

Decaf Pike Place Roast(1)

Pike Place Roast(1)

Veranda(1)

Decaffeinated French Roast(1)

Special House Blend(1)

Veranda Blend Blonde Roast(1)

FT Vanilla(1)

Colombia Huila(1)

Decaf Portside Blend(1)

Pier 70 Blend(1)

Colombian Blend(1)

Love at First Sip (Medium Roast)(1)

Portside Blend(1)

Vanilla Latte Macchiato(1)

Cappuccino(1)

Lungo Decaf(1)

Eye Opener(1)

French Dark Roast(1)

Original Roast Decaf(1)

Colombia Medium(1)

Parisian Café (Dark Roast)(1)

Breakfast Blend (Light Roast)(1)

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

Dukale's Blend(1)

Lively Colombian(1)

Sumatra Reserve(1)

Donut Shop Blend(1)

Gran Aroma(1)

Perfetto(1)

Toasted Marshmallow Mocha(1)

Dark Royal(1)

Original Roast(1)

Signature Blend(1)

Extra Bold Breakfast Blend(1)

Dunkin' Dark(1)

Dunkin' Decaf(1)

Lively Colombian Decaf(1)

Morning Café(1)

100% Colombian Decaf(1)

Classic Decaf(1)

Traditional Roast(1)

Pioneer Blend Decaf(1)

Country Roast(1)

Decaf Classic(1)

Gourmet Supreme(1)

Café con Leche Chocolate(1)

Café con Leche(1)

Medium Decaf(1)

Vanilla(1)

Donut Shop(1)

Decaf Caribou Blend(1)

Classic(1)

Holiday Blend(1)

Costa Rica Paraiso(1)

Caramel Hideaway(1)

Columbia Select Single Origin(1)

Special Blend(1)

Dark(1)

Colombian Huila(1)

Light Roast(1)

Dark Blend(1)

Round the Clock Blend(1)

Donut House Decaf(1)

Premium Roast Decaf(1)

Premium Roast(1)

Peppermint Bark(1)

Bold 1937(1)

Coconut Mocha(1)

NO SURRENDER(1)

Cafe Vanilla(1)

Rio Blend(1)

Morning Edition Decaf(1)

TURBOCHARGER(1)

AFTERBURNER(1)

Caramel Drizzle(1)

Big Bang(1)

Vanilla Biscotti(1)

Original Decaf(1)

Cinnamon Roll(1)

Regular Roast(1)

 
Beverage Type

Coffee(366)

Decaffeinated Coffee(64)

Instant Coffee(6)

Half-caffeinated Coffee(4)

Latte(2)

Coffee Drink(2)

Instant Decaffeinated Coffee(1)

 
Manufacturer Part Number

008710(1)

8500(1)

302142(1)

30200(1)

PB4141CT(1)

PB1141(1)

PB1036CT(1)

PB1036(1)

8997(1)

8784(1)

8506(1)

8500CT(1)

8488(1)

302742(1)

8338(1)

8337(1)

8287(1)

8087(1)

8007(1)

7999(1)

7996(1)

7995(1)

7994(1)

7993(1)

7792CT(1)

30220(1)

30800(1)

7791(1)

4202(1)

75421(1)

75416(1)

75415(1)

75413(1)

75412(1)

75411(1)

75410(1)

970(1)

953(1)

910(1)

4483(1)

2709(1)

308042(1)

1450(1)

0603(1)

0470(1)

0460(1)

705024(1)

70500(1)

70400(1)

60000(1)

40300(1)

39930404021(1)

39930274021(1)

7792(1)

7790(1)

04648(1)

6990(1)

7120(1)

6999CT(1)

6999(1)

6996(1)

6995CT(1)

6995(1)

6994CT(1)

6994(1)

6992CT(1)

6992(1)

6990CT(1)

6974(1)

7139(1)

6873(1)

6813(1)

6812(1)

6803CT(1)

6803(1)

6792CT(1)

6792(1)

6783CT(1)

6783(1)

6772CT(1)

6772(1)

7134(1)

7428(1)

7746(1)

7585(1)

7732CT(1)

7732(1)

7677(1)

7615(1)

7614(1)

7608(1)

7607(1)

7605(1)

7602CT(1)

7602(1)

7596(1)

7573(1)

7465(1)

7571(1)

7569(1)

7568(1)

7567(1)

7563(1)

7534(1)

7522CT(1)

7522(1)

7468(1)

7467(1)

7466(1)

75424(1)

04648CT(1)

6758(1)

011111156CT(1)

011111162(1)

011111161CT(1)

011111161(1)

011111160CT(1)

011111160(1)

011111159CT(1)

011111159(1)

011111158CT(1)

011111158(1)

011111157CT(1)

011111157(1)

011111156(1)

11008131(1)

504918(1)

504917(1)

504916(1)

504915(1)

504914(1)

504913(1)

501677(1)

501619(1)

501546(1)

501487(1)

500705(1)

11008130(1)

11015640(1)

39003(1)

11020676(1)

863070(1)

04707(1)

11008560(1)

11008558(1)

11008556(1)

11008554(1)

1092836(1)

11029358(1)

11028510(1)

11028473(1)

11023061(1)

11019631(1)

11017854(1)

11018197(1)

11018194(1)

11018193(1)

11018192(1)

11018190(1)

11018187(1)

11018186(1)

11018185(1)

11018131(1)

11017871(1)

11017860EA(1)

500350(1)

39002(1)

04648PLT(1)

27329(1)

94245BX(1)

94245(1)

94142BX(1)

94142(1)

87066(1)

86073(1)

77317(1)

66488CT(1)

66488(1)

32486(1)

27376(1)

15782CT(1)

94273BX(1)

15782(1)

026530(1)

026480(1)

026260(1)

026190(1)

026160(1)

866350(1)

866150(1)

862400(1)

390390(1)

04658(1)

94273(1)

94333(1)

39001(1)

25183(1)

39000(1)

33750(1)

33700(1)

33300(1)

32006(1)

32003(1)

25188(1)

25187(1)

25186(1)

25185(1)

25184(1)

25182(1)

94333BX(1)

25181(1)

23005(1)

23004(1)

23003(1)

23002(1)

23001(1)

22005(1)

22002(1)

21001(1)

33000(1)

01096(1)

6758CT(1)

6746(1)

008711(1)

21512(1)

60517(1)

60516EA(1)

60516(1)

60515EA(1)

60515(1)

60514EA(1)

60514(1)

60513EA(1)

60513(1)

52320(1)

21513(1)

21511(1)

60518(1)

21510(1)

20672(1)

20630(1)

20540CT(1)

20540(1)

20527CT(1)

20527(1)

20513CT(1)

20513(1)

20421PL(1)

20421EA(1)

60517EA(1)

60518EA(1)

11545BX(1)

0570(1)

192519(1)

192419CT(1)

192419(1)

1281(1)

1280(1)

1279(1)

0849(1)

0848(1)

0847(1)

0846(1)

0845(1)

0448(1)

63006(1)

0162(1)

0040(1)

0038(1)

0037(1)

0036(1)

63104(1)

63103(1)

63102(1)

63101(1)

63100CT(1)

63100(1)

20421CT(1)

11545(1)

192619(1)

8177(1)

00055(1)

00050CT(1)

00050(1)

00019(1)

00016(1)

320840(1)

320820(1)

8599961590(1)

599961590(1)

1099961590(1)

8179(1)

7401BX(1)

00374EA(1)

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

11544BX(1)

06546(1)

11544(1)

11248(1)

10117(1)

10107(1)

06931(1)

06930(1)

06927(1)

06922(1)

06898(1)

06897(1)

06547(1)

06451(1)

01014(1)

06437(1)

06433(1)

06430(1)

06239(1)

06125(1)

06122(1)

06114(1)

01720CT(1)

01720(1)

01501(1)

01500(1)

192519CT(1)

192619CT(1)

6745(1)

6542(1)

6606(1)

6602CT(1)

6602(1)

6570CT(1)

6570(1)

6547(1)

6546(1)

6545(1)

6544(1)

6543(1)

6542CT(1)

6534CT(1)

6611(1)

6534(1)

6523CT(1)

6523(1)

6520CT(1)

6520(1)

6503CT(1)

6503(1)

6502CT(1)

6502(1)

6501CT(1)

6501(1)

6606CT(1)

6611CT(1)

6408(1)

6694CT(1)

6744(1)

6743CT(1)

6743(1)

6732CT(1)

6732(1)

6728(1)

6727(1)

6720CT(1)

6720(1)

6700CT(1)

6700(1)

6694(1)

6612(1)

6685CT(1)

6685(1)

6680(1)

6664(1)

6663CT(1)

6663(1)

6662(1)

6661(1)

6659(1)

6613CT(1)

6613(1)

6425(1)

6407(1)

192719(1)

4066CT(1)

5161(1)

4792(1)

4757(1)

4732(1)

4493(1)

4461(1)

4441(1)

4432(1)

4162(1)

4067CT(1)

4067(1)

4066(1)

5304(1)

4061CT(1)

4061(1)

4060CT(1)

4060(1)

4051CT(1)

4051(1)

4050CT(1)

4050(1)

193019CT(1)

193019(1)

192719CT(1)

5303(1)

5305(1)

6406CT(1)

6107(1)

6406(1)

6405CT(1)

6405(1)

6378(1)

6377(1)

6376(1)

6305(1)

6248(1)

6204(1)

6111(1)

6110(1)

6106(1)

5462CT(1)

6006(1)

6003CT(1)

6003(1)

6002(1)

6001(1)

6000(1)

5807(1)

5531(1)

5493(1)

5470(1)

5469(1)

866550(1)

 
Country of Origin

US(393)

CA(28)

IT(12)

GB(11)

United States(1)

ES(1)

 
Weight (Approximate)

11.90 oz(1)

 
For Use With

Keurig K-Cup System(206)

Commercial Coffee Brewers(27)

Drip Coffee Brewers(14)

Pod Brewers(9)

Dolce Gusto Coffee Machine(8)

Single Cup Brewers(7)

Standard Coffee Brewers(7)

B-40; B-60; B-70; B-100(5)

Single Cup Brewers Hamilton, Bunn and Newco(4)

NESCAFÉ Dolce Gusto Machines(4)

Keurig Brewing System(3)

Standard and Commercial Coffee Makers(2)

LavAzza Espresso Point Machine(2)

Lavazza 2312(2)

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

Any traditional coffee maker(1)

Pod Espresso Brewer(1)

LavAzza Espresso Point Machine (sold separately)(1)

Lavazza 2312 BLUE Machine(1)

 
Capacity (Volume)

0.38 oz(4)

8 oz(2)

10 oz(2)

48 oz(1)

25.1 oz(1)

0(1)

 
Capacity (Weight)

2.5 oz(34)

1 lb(18)

1.5 oz(16)

0.3 oz(15)

2 oz(14)

12 oz(12)

2.2 oz(10)

18 oz(9)

0.9 oz(6)

0.35 oz(6)

0.4 oz(5)

1.4 oz(4)

0.06 oz(4)

10 oz(3)

0.25 oz(3)

30.6 oz(3)

30.5 oz(3)

28 oz(3)

1.75 oz(3)

1.2 oz(2)

1.1 oz(2)

0.1 oz(2)

8 g(2)

32 oz(2)

0.12 oz(2)

22.6 oz(2)

0.31 oz(2)

31.1 oz(2)

0.6 oz(2)

8 oz(2)

24.2 oz(2)

25.4 oz(2)

2.5 lbs(2)

7 g(2)

1.05 oz(2)

16 oz(1)

2 oz.(1)

0.8 oz(1)

0.8(1)

0.33 oz(1)

34.5 oz(1)

29.3 oz(1)

9 g(1)

2.2 lbs(1)

36 oz(1)

31 oz(1)

 
Serve Type

K-Cup(1)

 
Coffee Type

Caffeinated(1)

 
Roast Type

Medium(129)

Dark(102)

Light(55)

Dark Roast(4)

Medium Roast(1)

 
Compatible Brewer

K-Cup Brewer(1)

 
Product Type

Coffee(1)

 
Packaged Quantity

24 / Box(1)

 
Flavor/Blend

Pumpkin Spice(1)

Nutmeg(1)

Cinnamon(1)

Arabica(1)

 
Coffee Roast Level

Medium(1)

 
 
 

© 2020-2021 Desert West Office Supply, All Rights Reserved