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

Folgers(52)

Starbucks(34)

Peet's Coffee & Tea(18)

1850(16)

Tully's Coffee(16)

Day to Day Coffee(15)

Lavazza(15)

Caribou Coffee(14)

Maxwell House(13)

Café Bustelo(13)

NESCAFÉ Dolce Gusto(13)

Dunkin Donuts(10)

PapaNicholas Coffee(10)

New England Coffee(9)

The Original Donut Shop(9)

Eight O'Clock(9)

Barista Prima Coffeehouse(8)

Melitta(8)

Java One(7)

Nescafé(6)

Diedrich Coffee(6)

Gloria Jean's(6)

Donut House(6)

Newman's Own Organics(6)

Distant Lands Coffee(6)

Seattle's Best(5)

Café Escapes(4)

McCafe(4)

Gevalia(4)

Coffee People(4)

National Coffee Roasters(3)

Panera Bread at HOME(3)

Laughing Man Coffee Company(3)

revv(3)

Krispy Kreme Doughnuts(3)

Tim Hortons(3)

Yuban(3)

Kahlúa(2)

Emeril's(2)

illy(2)

Chase & Sanborn(2)

BUSTELO cool(2)

Chock full o'Nuts(1)

Cinnabon(1)

 
Quantity

36 per carton(4)

42 per carton(4)

40 per box(2)

24 per carton(1)

12 per pack(1)

24 per box(1)

18 per carton(1)

 
Packing Type

K-Cup(226)

Bag(55)

Fraction Pack(50)

Pod(29)

Packet(28)

Can(14)

Canister(13)

Capsule(12)

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

Breakfast Blend(20)

House Blend(17)

Classic Roast(15)

Hazelnut(12)

French Vanilla(11)

Espresso(11)

Dark Roast(8)

Regular(8)

Original(7)

Assorted(6)

Italian Roast(6)

Medium Roast(6)

100% Colombian(6)

Hazelnut Creme(6)

Caffe Verona(5)

House Blend Decaf(5)

Breakfast Blend Decaf(5)

Black Gold(5)

Decaffeinated(5)

Classic Roast Decaf(5)

Colombian(5)

Pioneer Blend(5)

Black Silk(5)

Veranda Blend(5)

Morning Blend(4)

Decaf House Blend(4)

Pike Place Decaf(4)

Major Dickason's Blend(4)

Original Blend(4)

Pike Place(4)

Pumpkin Spice(4)

Colombian Supremo(3)

Dark Magic(3)

Vermont Country Blend(3)

Nantucket Blend(3)

Colombian Decaf(3)

Daybreak Morning Blend(3)

Vermont Country Blend Decaf(3)

Caribou Blend(3)

Mocha(3)

Donut Shop Regular(3)

Lantern Glow(3)

Decaf(3)

Island Coconut(2)

Caramel(2)

Chocolate Glazed Donut(2)

Latte Macchiato(2)

Butter Toffee(2)

Vanilla Hazelnut(2)

Half-Caff(2)

Single Origin Colombian Select(2)

Caribou Blend Decaf(2)

Mahogany(2)

Southern Pecan(2)

Wild Mountain Blueberry(2)

Kahlúa Original(2)

Lake & Lodge(2)

Donut House(2)

Café Domingo Blend(2)

Our Blend(2)

Hawaiian Blend(2)

Colombia(2)

Morning Edition(2)

Caramel Vanilla Cream(2)

Blonde Espresso Roast(2)

Caramel Macchiato(2)

Big Easy Bold(2)

Special Decaf(2)

Trailblazer(2)

French Vanilla Decaf(2)

Hazelnut Cream(2)

Hawaiian Islands Blend(2)

French Roast Decaf(2)

Half Caff(2)

Simply Smooth(2)

Special Blend Extra Bold(2)

Espresso Decaf(2)

Organic Sumatran Extra Bold(2)

Double Black Diamond Extra Bold(2)

Donut House Decaf(2)

Special Roast(2)

Dark Magic Decaf Extra Bold(2)

Sumatra(2)

Dark Magic Extra Bold(2)

Kenya Highlands(1)

Special Delivery(1)

Aroma Club 100% Arabica Blend(1)

100% Arabica Blend Decaf(1)

Costa Rican La Sonrisa(1)

Decaf Italian Roast(1)

Ethiopian Supreme(1)

Dukale's Blend(1)

Colombia Huila(1)

Crema Aroma Arabica/Robusta(1)

Decaffeinated Medium Roast(1)

Sumatra Mandheling(1)

Rotondo/Dark Roast(1)

Colombian De Jardin(1)

Sumatran(1)

6th Avenue Bistro(1)

Crema Dolce/Medium Roast(1)

Portside Blend(1)

Decaf Pike Place Roast(1)

Pike Place Roast(1)

Veranda(1)

Decaffeinated French Roast(1)

Special House Blend(1)

Kona Blend(1)

Colombian Blend(1)

Veranda Blend Blonde Roast(1)

Costa Rica Paraiso(1)

FT Vanilla(1)

Decaf Portside Blend(1)

Pier 70 Blend(1)

Vanilla Latte Macchiato(1)

Parisian Vanilla(1)

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

Colombia Medium(1)

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

Love at First Sip (Medium Roast)(1)

Buzzworthy (Dark Roast)(1)

Sumatra Reserve(1)

Lively Colombian(1)

Columbia Select Single Origin(1)

Morning Café(1)

Toasted Marshmallow Mocha(1)

Signature Blend Decaf(1)

Dark Royal(1)

Original Roast(1)

Signature Blend(1)

Colombia Select(1)

Extra Bold Breakfast Blend(1)

Caramel Coffee Cake(1)

Dunkin' Dark(1)

Dunkin' Decaf(1)

Lively Colombian Decaf(1)

Donut Shop Blend(1)

Gran Aroma(1)

100% Colombian 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)

Perfetto(1)

Classic(1)

Special Blend(1)

NO SURRENDER(1)

Dark(1)

Colombian Huila(1)

Light Roast(1)

Dark Blend(1)

Round the Clock Blend(1)

Cinnamon(1)

Premium Roast Decaf(1)

Premium Roast(1)

Peppermint Bark(1)

Caramel Hideaway(1)

Bold 1937(1)

Cafe Vanilla(1)

Classic Decaf(1)

Rio Blend(1)

Morning Edition Decaf(1)

TURBOCHARGER(1)

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

Regular Roast(1)

 
Beverage Type

Coffee(380)

Decaffeinated Coffee(67)

Instant Coffee(6)

Half-caffeinated Coffee(4)

Latte(2)

Coffee Drink(2)

Instant Decaffeinated Coffee(1)

Hot Chocolate(1)

 
Manufacturer Part Number

008710(1)

8287(1)

PB4141CT(1)

PB1141(1)

PB1036CT(1)

PB1036(1)

8784(1)

8506(1)

8500CT(1)

8500(1)

8488(1)

8338(1)

8337(1)

8087(1)

302142(1)

8007(1)

7999(1)

7996(1)

7995(1)

7994(1)

7993(1)

7792CT(1)

7792(1)

7791(1)

7790(1)

7746(1)

7732CT(1)

30200(1)

30220(1)

7677(1)

2709(1)

75416(1)

75415(1)

75413(1)

75412(1)

75411(1)

75410(1)

970(1)

953(1)

910(1)

4483(1)

4202(1)

1450(1)

302742(1)

0603(1)

0470(1)

0460(1)

705024(1)

70500(1)

70400(1)

60000(1)

40300(1)

39930404021(1)

39930274021(1)

308042(1)

30800(1)

7732(1)

7615(1)

75424(1)

6990CT(1)

7120(1)

7000(1)

6999CT(1)

6999(1)

6996(1)

6995CT(1)

6995(1)

6994CT(1)

6994(1)

6992CT(1)

6992(1)

6990(1)

7139(1)

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

71550(1)

7614(1)

7571(1)

7608(1)

7607(1)

7605(1)

7602CT(1)

7602(1)

7596(1)

7595(1)

7594(1)

7586(1)

7585(1)

7573(1)

7569(1)

7428(1)

7568(1)

7567(1)

7564(1)

7563(1)

7534CT(1)

7534(1)

7522CT(1)

7522(1)

7468(1)

7467(1)

7466(1)

7465(1)

75421(1)

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

500350(1)

11008130(1)

11015640(1)

39002(1)

11023061(1)

863070(1)

04707(1)

1261330(1)

11008560(1)

11008558(1)

11008556(1)

11008554(1)

1092836(1)

11029358(1)

11028510(1)

11028473(1)

11020676(1)

11017854(1)

11019631(1)

11018197(1)

11018194(1)

11018193(1)

11018192(1)

11018190(1)

11018187(1)

11018186(1)

11018185(1)

11018131(1)

11017871(1)

11017860EA(1)

39003(1)

39001(1)

04648CT(1)

27329(1)

94245(1)

94142BX(1)

94142(1)

87066(1)

86073(1)

77317(1)

69749(1)

66488CT(1)

66488(1)

32486(1)

27376(1)

15782CT(1)

94273(1)

15782(1)

026530(1)

026480(1)

026260(1)

026190(1)

026160(1)

866350(1)

866150(1)

862400(1)

390390(1)

04658(1)

04648PLT(1)

94245BX(1)

94273BX(1)

39000(1)

25182(1)

33750(1)

33700(1)

33300(1)

32006(1)

32003(1)

25188(1)

25187(1)

25186(1)

25185(1)

25184(1)

25183(1)

25181(1)

94333(1)

23005(1)

23004(1)

23003(1)

23002(1)

23001(1)

22005(1)

22002(1)

21001(1)

33000(1)

32410(1)

01096(1)

94333BX(1)

6758CT(1)

6746(1)

008711(1)

52320(1)

60518(1)

60517EA(1)

60517(1)

60516EA(1)

60516(1)

60515EA(1)

60515(1)

60514EA(1)

60514(1)

60513EA(1)

60513(1)

21513(1)

63006(1)

21512(1)

21511(1)

21510(1)

20672(1)

20630(1)

20540CT(1)

20540(1)

20527CT(1)

20527(1)

20513CT(1)

20513(1)

20421PL(1)

60518EA(1)

63100(1)

20421CT(1)

0847(1)

192619(1)

192519CT(1)

192519(1)

192419CT(1)

192419(1)

1281(1)

1280(1)

1279(1)

0995(1)

0849(1)

0848(1)

0846(1)

63100CT(1)

0845(1)

0570(1)

0448(1)

0162(1)

0040(1)

0038(1)

0037(1)

0036(1)

63104(1)

63103(1)

63102(1)

63101(1)

20421EA(1)

11545BX(1)

192719(1)

8179(1)

00374CT(1)

00055(1)

00050CT(1)

00050(1)

00019(1)

00016(1)

320840(1)

320820(1)

8599961590(1)

599961590(1)

1099961590(1)

8177(1)

00518X(1)

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

00374EA(1)

01014(1)

11545(1)

06547(1)

11544BX(1)

11544(1)

11248(1)

10117(1)

10107(1)

06931(1)

06930(1)

06927(1)

06922(1)

06898(1)

06897(1)

06546(1)

01500(1)

06451(1)

06437(1)

06433(1)

06430(1)

06239(1)

06125(1)

06122(1)

06114(1)

0529C(1)

01720CT(1)

01720(1)

01501(1)

192619CT(1)

192719CT(1)

6745(1)

6542(1)

6606CT(1)

6606(1)

6602CT(1)

6602(1)

6570CT(1)

6570(1)

6547(1)

6546(1)

6545(1)

6544(1)

6543(1)

6534CT(1)

6611CT(1)

6534(1)

6523CT(1)

6523(1)

6520CT(1)

6520(1)

6503CT(1)

6503(1)

6502CT(1)

6502(1)

6501CT(1)

6501(1)

6425(1)

6611(1)

6612(1)

6407(1)

6700CT(1)

6744(1)

6743CT(1)

6743(1)

6732CT(1)

6732(1)

6728(1)

6727(1)

6722CT(1)

6722(1)

6720CT(1)

6720(1)

6700(1)

6613(1)

6694CT(1)

6694(1)

6685CT(1)

6685(1)

6680(1)

6664(1)

6663CT(1)

6663(1)

6662(1)

6661(1)

6659(1)

6613CT(1)

6408(1)

6406CT(1)

192919(1)

4067(1)

5161(1)

4792(1)

4757(1)

4732(1)

4493(1)

4461(1)

4441(1)

4432(1)

4162(1)

4092(1)

4067CT(1)

4066CT(1)

5304(1)

4066(1)

4061CT(1)

4061(1)

4060CT(1)

4060(1)

4051CT(1)

4051(1)

4050CT(1)

4050(1)

193019CT(1)

193019(1)

192919CT(1)

5303(1)

5305(1)

6406(1)

6106(1)

6405CT(1)

6405(1)

6378(1)

6377(1)

6376(1)

6305(1)

6248(1)

6204(1)

6111(1)

6110(1)

6107(1)

6006(1)

5339(1)

6003CT(1)

6003(1)

6002(1)

6001(1)

6000(1)

5807(1)

5531(1)

5493(1)

5471(1)

5470(1)

5469(1)

5462CT(1)

866550(1)

 
Country of Origin

US(383)

CA(56)

GB(12)

IT(10)

AX(1)

ES(1)

 
For Use With

Keurig K-Cup System(221)

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)

NESCAFÉ Dolce Gusto Machines(5)

Single Cup Brewers Hamilton, Bunn and Newco(4)

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

18 oz(9)

0.35 oz(6)

0.9 oz(6)

0.4 oz(5)

0.06 oz(4)

1.4 oz(4)

30.5 oz(3)

30.6 oz(3)

0.25 oz(3)

1.75 oz(3)

28 oz(3)

10 oz(3)

32 oz(2)

0.1 oz(2)

0.31 oz(2)

1.2 oz(2)

1.1 oz(2)

8 g(2)

0.12 oz(2)

2.5 lbs(2)

24.2 oz(2)

25.4 oz(2)

31.1 oz(2)

7 g(2)

22.6 oz(2)

1.05 oz(2)

8 oz(2)

0.6 oz(2)

0.33 oz(1)

34.5 oz(1)

45 oz(1)

2 oz.(1)

36 oz(1)

48 oz(1)

16 oz(1)

1.25 oz(1)

0.8 oz(1)

0.8(1)

29.3 oz(1)

9 g(1)

2.2 lbs(1)

5 lb(1)

31 oz(1)

 
Roast Type

Medium(138)

Dark(105)

Light(58)

Dark Roast(3)

Medium Roast(1)

 
 
 

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