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

Folgers(55)

Starbucks(35)

Peet's Coffee & Tea(18)

Tully's Coffee(16)

Lavazza(15)

1850(15)

Day to Day Coffee(15)

Caribou Coffee(14)

Café Bustelo(14)

NESCAFÉ Dolce Gusto(13)

Maxwell House(12)

The Original Donut Shop(10)

PapaNicholas Coffee(10)

New England Coffee(9)

Dunkin Donuts(9)

Eight O'Clock(9)

Java One(9)

Melitta(8)

Barista Prima Coffeehouse(8)

Diedrich Coffee(6)

Distant Lands Coffee(6)

Gloria Jean's(6)

Newman's Own Organics(6)

Nescafé(6)

Donut House(6)

Seattle's Best(5)

Café Escapes(4)

McCafe(4)

Coffee People(4)

Gevalia(4)

National Coffee Roasters(3)

Tim Hortons(3)

Hills Bros.(3)

Krispy Kreme Doughnuts(3)

Laughing Man Coffee Company(3)

Panera Bread at HOME(3)

revv(3)

Yuban(3)

Kahlúa(2)

Emeril's(2)

illy(2)

Chase & Sanborn(2)

BUSTELO cool(2)

Office Snax(1)

Chock full o'Nuts(1)

Cinnabon(1)

 
Quantity

36 per carton(5)

42 per carton(4)

24 per box(2)

40 per box(2)

24 per carton(1)

12 per pack(1)

96 per carton(1)

42 per box(1)

18 per carton(1)

 
Packing Type

K-Cup(225)

Bag(56)

Fraction Pack(51)

Packet(34)

Pod(31)

Can(14)

Canister(13)

Capsule(12)

Filter Pack(8)

Stick(8)

Portion Pack(5)

Vacket Pack(3)

Cartridges(3)

Lavazza BLUE Capsule(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 Blend(8)

Original(7)

Medium Roast(6)

Assorted(6)

Italian Roast(6)

Hazelnut Creme(6)

100% Colombian(6)

Classic Roast Decaf(6)

Colombian(5)

House Blend Decaf(5)

Veranda Blend(5)

Black Silk(5)

Pioneer Blend(5)

Black Gold(5)

Caffe Verona(5)

Breakfast Blend Decaf(5)

Decaffeinated(5)

Pike Place(4)

Morning Blend(4)

Pike Place Decaf(4)

Colombian Decaf(4)

Major Dickason's Blend(4)

Vermont Country Blend(3)

Pumpkin Spice(3)

Vermont Country Blend Decaf(3)

Decaf House Blend(3)

Caramel(3)

Daybreak Morning Blend(3)

Colombian Supremo(3)

Dark Magic(3)

Caribou Blend(3)

Nantucket Blend(3)

Decaf(3)

Lantern Glow(3)

Donut Shop Regular(3)

Mocha(3)

Wild Mountain Blueberry(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)

Lake & Lodge(2)

Southern Pecan(2)

Kahlúa Original(2)

Donut House(2)

Café Domingo Blend(2)

Donut Shop(2)

Our Blend(2)

Hawaiian Blend(2)

Colombia(2)

Morning Edition(2)

Caramel Vanilla Cream(2)

Blonde Espresso Roast(2)

Caramel Macchiato(2)

Island Coconut(2)

Special Blend Extra Bold(2)

Sumatra(2)

Donut House Decaf(2)

Big Easy Bold(2)

French Vanilla Decaf(2)

Simply Smooth(2)

Espresso Decaf(2)

Hazelnut Cream(2)

Special Decaf(2)

French Roast Decaf(2)

Organic Sumatran Extra Bold(2)

Dark Magic Extra Bold(2)

Double Black Diamond Extra Bold(2)

Dark Magic Decaf Extra Bold(2)

Hawaiian Islands Blend(2)

Colombia Select(2)

Special Roast(2)

Traditional Roast(2)

Half Caff(2)

Rotondo/Dark Roast(1)

Decaffeinated Medium Roast(1)

Colombia Huila(1)

Crema Dolce/Medium Roast(1)

Sumatra Reserve(1)

Special Delivery(1)

Dukale's Blend(1)

Kenya Highlands(1)

100% Arabica Blend Decaf(1)

Crema Aroma Arabica/Robusta(1)

Sumatra Mandheling(1)

Costa Rican La Sonrisa(1)

Colombian De Jardin(1)

Estate Costa Rican(1)

Aroma Club 100% Arabica Blend(1)

Sumatran(1)

Parisian Vanilla(1)

Portside Blend(1)

Decaf Pike Place Roast(1)

Pike Place Roast(1)

Decaffeinated French Roast(1)

Veranda(1)

Special House Blend(1)

Kona Blend(1)

Colombian Blend(1)

Columbia Select Single Origin(1)

Veranda Blend Blonde Roast(1)

FT Vanilla(1)

Decaf Portside Blend(1)

Pier 70 Blend(1)

Vanilla Latte Macchiato(1)

Buzzworthy (Dark Roast)(1)

Chococino(1)

Cappuccino(1)

Lungo Decaf(1)

Eye Opener(1)

French Dark Roast(1)

Original Roast Decaf(1)

6th Avenue Bistro(1)

Parisian Café (Dark Roast)(1)

Colombia Medium(1)

Breakfast Blend (Light Roast)(1)

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

Love at First Sip (Medium Roast)(1)

Costa Rica Paraiso(1)

Decaf Italian Roast(1)

Special Blend(1)

Donut Shop Blend(1)

Cinnamon Sugar Cookie(1)

Signature Blend Decaf(1)

Dark Royal(1)

Original Roast(1)

Signature Blend(1)

Extra Bold Breakfast Blend(1)

Caramel Coffee Cake(1)

Dunkin' Dark(1)

Dunkin' Decaf(1)

Lively Colombian Decaf(1)

Morning Café(1)

100% Colombian Decaf(1)

Gran Aroma(1)

Trailblazer(1)

Traditional Roast Decaf(1)

Pioneer Blend Decaf(1)

Country Roast(1)

Decaf Classic(1)

Gourmet Supreme(1)

Café con Leche Chocolate(1)

Café con Leche(1)

Estilo Espresso(1)

Medium Decaf(1)

Vanilla(1)

Decaf Caribou Blend(1)

Perfetto(1)

Classic(1)

Dark(1)

Cafe Vanilla(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)

NO SURRENDER(1)

Rio Blend(1)

Classic Decaf(1)

Morning Edition Decaf(1)

TURBOCHARGER(1)

AFTERBURNER(1)

Caramel Drizzle(1)

Big Bang(1)

Vanilla Biscotti(1)

Lively Colombian(1)

Brazil Minas Naturais(1)

Original Decaf(1)

Cinnamon Roll(1)

Coconut Mocha(1)

Holiday Blend(1)

Regular Roast(1)

 
Beverage Type

Coffee(387)

Decaffeinated Coffee(69)

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)

30220(1)

302142(1)

30210(1)

30200(1)

PB4141CT(1)

PB1141(1)

PB1036CT(1)

PB1036(1)

8784(1)

8338(1)

8337(1)

8087(1)

30400(1)

8007(1)

7999(1)

7996(1)

7995(1)

7994(1)

7993(1)

7843(1)

7792CT(1)

7792(1)

7791(1)

7790(1)

7746(1)

302742(1)

30800(1)

7732(1)

4483(1)

04648(1)

75424(1)

75421(1)

75416(1)

75415(1)

75413(1)

75412(1)

75411(1)

75410(1)

970(1)

953(1)

910(1)

4202(1)

308042(1)

2709(1)

1450(1)

0603(1)

0470(1)

0460(1)

705024(1)

70500(1)

70400(1)

60000(1)

40300(1)

39930404021(1)

39930274021(1)

7732CT(1)

7677(1)

04648PLT(1)

6990(1)

7000(1)

6999CT(1)

6999(1)

6996(1)

6995CT(1)

6995(1)

6994CT(1)

6994(1)

6992CT(1)

6992(1)

6990CT(1)

6974(1)

7134(1)

6873(1)

6813(1)

6812(1)

6803CT(1)

6803(1)

6792CT(1)

6792(1)

6783CT(1)

6783(1)

6772CT(1)

6772(1)

6758CT(1)

7120(1)

7139(1)

7615(1)

7569(1)

7614(1)

7608(1)

7607(1)

7605(1)

7602CT(1)

7602(1)

7595(1)

7594(1)

7586(1)

7585(1)

7573(1)

7571(1)

7568(1)

71550(1)

7567(1)

7564(1)

7563(1)

7534CT(1)

7534(1)

7522CT(1)

7522(1)

7468(1)

7467(1)

7466(1)

7465(1)

7428(1)

04648CT(1)

04658(1)

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

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

390390(1)

66488(1)

94273BX(1)

94273(1)

94245BX(1)

94245(1)

94142BX(1)

94142(1)

87066(1)

86073(1)

77317(1)

69749(1)

66488CT(1)

32486(1)

94333BX(1)

27376(1)

27329(1)

15782CT(1)

15782(1)

026530(1)

026480(1)

026260(1)

026190(1)

026160(1)

866350(1)

866150(1)

862400(1)

94333(1)

00058(1)

39000(1)

25181(1)

33750(1)

33700(1)

33300(1)

32006(1)

32003(1)

25188(1)

25187(1)

25186(1)

25185(1)

25184(1)

25183(1)

25182(1)

23005(1)

01027(1)

23004(1)

23003(1)

23002(1)

23001(1)

22005(1)

22002(1)

21001(1)

33000(1)

32410(1)

01101(1)

01096(1)

01084(1)

6758(1)

6745(1)

008711(1)

21512(1)

60516EA(1)

60516(1)

60515(1)

60514EA(1)

60514(1)

60513EA(1)

60513(1)

56376(1)

56375(1)

52320(1)

21513(1)

21511(1)

60517EA(1)

21510(1)

20672(1)

20630(1)

20540CT(1)

20540(1)

20527CT(1)

20527(1)

20513CT(1)

20513(1)

20421PL(1)

20421EA(1)

20421CT(1)

60517(1)

60518(1)

11545(1)

0570(1)

192519(1)

192419CT(1)

192419(1)

1281(1)

1280(1)

1279(1)

0995(1)

0849(1)

0848(1)

0847(1)

0846(1)

0845(1)

0448(1)

60518EA(1)

0162(1)

0040(1)

0038(1)

0037(1)

0036(1)

63104(1)

63103(1)

63102(1)

63101(1)

63100CT(1)

63100(1)

63006(1)

11545BX(1)

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

60224-101(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)

11544(1)

06437(1)

11248(1)

10117(1)

10107(1)

06931(1)

06930(1)

06927(1)

06922(1)

06898(1)

06897(1)

06547(1)

06546(1)

06451(1)

06433(1)

01014(1)

06430(1)

06239(1)

06125(1)

06122(1)

06119(1)

06114(1)

0529C(1)

01720CT(1)

01720(1)

01501(1)

01500(1)

01074(1)

192519CT(1)

192619CT(1)

6744(1)

6543(1)

6611(1)

6606CT(1)

6606(1)

6602CT(1)

6602(1)

6570CT(1)

6570(1)

6547(1)

6546(1)

6545(1)

6544(1)

6542(1)

6612(1)

6534CT(1)

6534(1)

6523CT(1)

6523(1)

6520CT(1)

6520(1)

6503CT(1)

6503(1)

6502CT(1)

6502(1)

6501CT(1)

6501(1)

6611CT(1)

6613(1)

6408(1)

6694CT(1)

6743CT(1)

6743(1)

6732CT(1)

6732(1)

6728(1)

6727(1)

6722CT(1)

6722(1)

6720CT(1)

6720(1)

6700CT(1)

6700(1)

6694(1)

6613CT(1)

6685CT(1)

6685(1)

6680(1)

6664(1)

6663CT(1)

6663(1)

6662(1)

6661(1)

6659(1)

6624(1)

6614CT(1)

6614(1)

6425(1)

6407(1)

192719(1)

4066(1)

4792(1)

4757(1)

4732(1)

4493(1)

4461(1)

4441(1)

4432(1)

4162(1)

4092(1)

4067CT(1)

4067(1)

4066CT(1)

4061CT(1)

5303(1)

4061(1)

4060CT(1)

4060(1)

4051CT(1)

4051(1)

4050CT(1)

4050(1)

193019CT(1)

193019(1)

192919CT(1)

192919(1)

192719CT(1)

5161(1)

5304(1)

6406CT(1)

6106(1)

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

5305(1)

6003CT(1)

6003(1)

6002(1)

6001(1)

6000(1)

5814(1)

5531(1)

5493(1)

5471(1)

5470(1)

5469(1)

5339(1)

866550(1)

 
Country of Origin

US(391)

CA(57)

GB(12)

IT(10)

AX(1)

ES(1)

 
For Use With

Keurig K-Cup System(223)

Commercial Coffee Brewers(27)

Drip Coffee Brewers(14)

Single Cup Brewers(9)

Pod Brewers(9)

Dolce Gusto Coffee Machine(8)

Standard Coffee Brewers(8)

NESCAFÉ Dolce Gusto Machines(5)

Single Cup Brewers Hamilton, Bunn and Newco(4)

Lavazza 2312 BLUE Machine(3)

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

Standard and Commercial Coffee Makers(2)

Keurig Brewing System(2)

LavAzza Espresso Point Machine(2)

1/2-Gallon Brewers(1)

Pod Espresso Brewer(1)

Any traditional coffee maker(1)

LavAzza Espresso Point Machine (sold separately)(1)

 
Capacity (Volume)

0.38 oz(4)

0.27 oz(3)

8 oz(2)

10 oz(2)

48 oz(1)

0.9 oz(1)

25.1 oz(1)

0(1)

 
Capacity (Weight)

2.5 oz(34)

1 lb(18)

1.5 oz(17)

0.3 oz(17)

2 oz(14)

2.2 oz(12)

12 oz(11)

18 oz(9)

0.4 oz(6)

0.35 oz(6)

0.9 oz(6)

0.06 oz(4)

1.4 oz(4)

28 oz(3)

1.1 oz(3)

30.5 oz(3)

30.6 oz(3)

0.25 oz(3)

1.75 oz(3)

10 oz(3)

0.12 oz(2)

0.31 oz(2)

1.2 oz(2)

8 g(2)

32 oz(2)

24.2 oz(2)

0.6 oz(2)

2.5 lbs(2)

22.6 oz(2)

8 oz(2)

0.1 oz(2)

25.4 oz(2)

31.1 oz(2)

7 g(2)

1.05 oz(2)

2 oz.(1)

34.5 oz(1)

1.25 oz(1)

2.25 oz(1)

45 oz(1)

0.33 oz(1)

33.9 oz(1)

29.3 oz(1)

9 g(1)

2.2 lbs(1)

5 lb(1)

16 oz(1)

0.8(1)

0.8 oz(1)

48 oz(1)

36 oz(1)

31 oz(1)

 
Roast Type

Medium(141)

Dark(106)

Light(56)

Dark Roast(3)

Medium Roast(1)

 
 
 

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