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

Folgers(56)

Starbucks(37)

Lavazza(20)

Peet's Coffee & Tea(20)

Day to Day Coffee(15)

Tully's Coffee(14)

Maxwell House(11)

Caribou Coffee(11)

PapaNicholas Coffee(10)

Dunkin Donuts(10)

Café Bustelo(10)

Java One(9)

Eight O'Clock(9)

New England Coffee(9)

Melitta(8)

Barista Prima Coffeehouse(8)

Donut House(6)

Gloria Jean's(6)

1850(6)

Distant Lands Coffee(6)

NESCAFÉ Dolce Gusto(5)

Diedrich Coffee(5)

Newman's Own Organics(5)

The Original Donut Shop(5)

Seattle's Best(5)

Hills Bros.(4)

Gevalia(4)

Nescafé(4)

Coffee People(4)

Café Escapes(4)

McCafe(4)

Yuban(3)

revv(3)

Krispy Kreme Doughnuts(3)

National Coffee Roasters(3)

Tim Hortons(2)

Emeril's(2)

BUSTELO cool(2)

Chase & Sanborn(2)

Kahlúa(2)

illy(2)

GFIC(1)

Cinnabon(1)

Office Snax(1)

Dolce Gusto(1)

Chock full o'Nuts(1)

 
Quantity

24 per box(129)

96 per carton(62)

1 each(42)

42 per carton(31)

18 per box(22)

22 per box(15)

6 per carton(12)

14 per box(9)

18 per carton(9)

50 per carton(7)

36 per carton(6)

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

40 per carton(6)

48 per carton(5)

100 per box(5)

100 per carton(4)

24 per carton(4)

30 per carton(4)

50 per box(3)

42 per box(3)

15 per box(3)

88 per carton(3)

200 per carton(3)

24 per box.(3)

60 per carton(2)

80 per box(2)

40 per box(2)

8 per box(2)

20 per box(2)

12 per pack(2)

1 bag(1)

160 per carton(1)

3 per pack(1)

294 per pallet(1)

18 per pack(1)

4 per carton(1)

2 per carton(1)

210 per pallet(1)

150 per carton(1)

16 per box(1)

108 per carton(1)

 
Packing Type

K-Cup(211)

Bag(46)

Fraction Pack(44)

Packet(34)

Pod(27)

Can(15)

Canister(12)

Filter Pack(9)

Stick(8)

Capsule(6)

Portion Pack(5)

Lavazza BLUE Capsule(3)

Vacket Pack(3)

Cartridges(3)

Jar(2)

Brick Pack(2)

Coffee Pod(1)

 
Flavor

French Roast(23)

Breakfast Blend(17)

House Blend(14)

Classic Roast(11)

Hazelnut(11)

Original Blend(10)

French Vanilla(10)

Regular(9)

Espresso(9)

Dark Roast(8)

Italian Roast(7)

Original(6)

Classic Roast Decaf(6)

Assorted(6)

Medium Roast(5)

100% Colombian(5)

House Blend Decaf(5)

Colombian(5)

Classic Roast Regular(5)

Black Silk(5)

Breakfast Blend Decaf(4)

Colombian Decaf(4)

Major Dickason's Blend(4)

Morning Blend(4)

Decaffeinated(4)

Pike Place(4)

Decaf House Blend(4)

Pike Place Decaf(4)

Veranda Blend(3)

Pumpkin Spice(3)

Vermont Country Blend Decaf(3)

Colombia(3)

Colombian Supremo(3)

Nantucket Blend(3)

Vermont Country Blend(3)

Caramel(3)

Café Domingo Blend(2)

Donut House(2)

Colombian Fair Trade Select(2)

Island Coconut(2)

Our Blend(2)

Hawaiian Blend(2)

Lake & Lodge(2)

Daybreak Morning Blend(2)

Hazelnut Créme(2)

Kahlúa Original(2)

Hazelnut Decaf(2)

French Vanilla Decaf(2)

Gran Filtro Light Roast(2)

Gran Filtro Dark Roast(2)

Emeril's Big Easy Bold(2)

Caffè Verona(2)

Hawaiian Islands Blend(2)

Donut House Decaf(2)

Vanilla Hazelnut(2)

Wild Mountain Blueberry(2)

Southern Pecan(2)

Morning Edition(2)

Mocha(2)

Mahogany(2)

Half-Caff(2)

Caribou Blend Decaf(2)

Caribou Blend(2)

Chocolate Glazed Donut(2)

Caramel Vanilla Cream(2)

French Roast Decaf(2)

Decaf(2)

Newman's Own Special Blend Extra Bold(2)

Newman's Own Special Decaf(2)

Organic Sumatran Extra Bold(2)

Hazelnut Cream(2)

Traditional Roast(2)

Donut Shop(2)

Butter Toffee(2)

Medium(2)

Special Roast(2)

Simply Smooth(2)

Dark Magic Extra Bold(2)

Half Caff(2)

Dark Magic Decaf Extra Bold(2)

Double Black Diamond Extra Bold(2)

Hazelnut Crème(1)

Caramel Latte Macchiato(1)

French Dark Roast(1)

Original Roast Decaf(1)

Lungo Decaf(1)

Eye Opener(1)

Cappuccino(1)

Colombian Blend(1)

Kona Blend(1)

Vanilla Latte Macchiato(1)

Café con Leche(1)

Chococino(1)

Parisian Café (Dark Roast)(1)

Breakfast Blend (Light Roast)(1)

Café con Leche Chocolate(1)

Filtro Classico Medium Roast(1)

Gourmet Supreme(1)

100% Arabica Blend Decaf(1)

Aroma Club 100% Arabica Blend(1)

Decaffeinated Medium Roast(1)

Rotondo/Dark Roast(1)

Love at First Sip (Medium Roast)(1)

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

Buzzworthy (Dark Roast)(1)

Parisian Vanilla(1)

Crema Dolce/Light Roast(1)

Estilo Espresso(1)

Decaffeinated French Roast(1)

Sumatran(1)

FT Vanilla(1)

Veranda Blend Blonde Roast(1)

Veranda(1)

Signature Blend Decaf(1)

Decaf Portside Blend(1)

Pier 70 Blend(1)

Special Delivery(1)

Regular Roast(1)

Dark Royal(1)

6th Avenue Bistro(1)

Portside Blend(1)

Caffe Verona(1)

Pike Place Roast(1)

Sumatra(1)

Signature Blend(1)

Cafe Domingo(1)

Hazelnut Creme(1)

Crema Aroma Arabica/Robusta(1)

Medium Decaf(1)

Cafe Verona(1)

Decaf Pike Place Roast(1)

Colombia Medium(1)

Donut Shop Decaf(1)

Café Verona(1)

Special House Blend(1)

Sumatra Mandheling(1)

AFTERBURNER(1)

TURBOCHARGER(1)

Morning Café(1)

Lively Colombian Decaf(1)

Decaf Caribou Blend(1)

Morning Edition Decaf(1)

Rio Blend(1)

Black Gold Dark Roast Whole Bean(1)

Vanilla(1)

100% Colombian Regular(1)

100% Colombian Decaf(1)

Donut Shop Blend(1)

Caramel Drizzle(1)

Big Bang(1)

Holiday Blend(1)

Extra Bold Breakfast Blend(1)

Brazil Minas Naturais(1)

Coconut Mocha(1)

Cinnamon Roll(1)

Classic Decaf(1)

Caramel Coffee Cake(1)

Vanilla Biscotti(1)

Lively Colombian(1)

Decaf Italian Roast(1)

Classic(1)

NO SURRENDER(1)

Bold 1937(1)

Dark(1)

Original Roast(1)

Decaf Classic(1)

Dark Blend(1)

Round the Clock Blend(1)

Costa Rica Paraiso(1)

Kenya Highlands(1)

Costa Rican La Sonrisa(1)

Original Decaf(1)

Colombian De Jardin(1)

Estate Costa Rican(1)

Espresso Roast(1)

Cinnamon(1)

Country Roast(1)

Pioneer Blend Medium Roast Ground(1)

Caramel Hideaway(1)

Trailblazer Medium-Dark Roast Ground(1)

Black Gold Dark Roast Ground(1)

Pioneer Blend Medium Roast Whole Bean(1)

Lantern Glow Light Roast Ground(1)

Traditional Roast Decaf(1)

Colombia Select(1)

Premium Roast Decaf(1)

Premium Roast(1)

Peppermint Bark(1)

Cinnamon Sugar Cookie(1)

 
Beverage Type

Coffee(354)

Decaffeinated Coffee(65)

Instant Coffee(4)

Half-caffeinated Coffee(4)

Coffee Drink(2)

Hot Chocolate(1)

Instant Decaffeinated Coffee(1)

 
Manufacturer Part Number

70400(1)

70500(1)

60000(1)

40300(1)

39930404021(1)

705024(1)

0460(1)

2401(1)

2410(1)

1450(1)

0603(1)

0470(1)

39930274021(1)

308042(1)

PB4141CT(1)

30200(1)

PB4141(1)

8784(1)

8087(1)

30210(1)

302142(1)

30800(1)

30400(1)

302742(1)

30220(1)

2431(1)

2440(1)

04648CT(1)

04658(1)

04648(1)

75424(1)

75421(1)

390390(1)

395640(1)

026160(1)

026190(1)

866350(1)

866150(1)

862400(1)

75416(1)

75415(1)

4483(1)

910(1)

4202(1)

2851(1)

2709(1)

953(1)

970(1)

75413(1)

75412(1)

75411(1)

75410(1)

7792CT(1)

7792(1)

6992(1)

6992CT(1)

6990CT(1)

6990(1)

6974(1)

6994(1)

6994CT(1)

6999(1)

6999CT(1)

6996(1)

6995CT(1)

6995(1)

6873(1)

6813(1)

6772CT(1)

6783(1)

6772(1)

6758CT(1)

6758(1)

6783CT(1)

6792(1)

6812(1)

6803CT(1)

6803(1)

6792CT(1)

7000(1)

71550(1)

7602CT(1)

7605(1)

7602(1)

7596(1)

7595(1)

7607(1)

7608(1)

7790(1)

7791(1)

7746(1)

7732CT(1)

7732(1)

7594(1)

7586(1)

7467(1)

7468(1)

7466(1)

7465(1)

7428(1)

7522(1)

7522CT(1)

7564(1)

7563(1)

7534CT(1)

7534(1)

026260(1)

026480(1)

11008130(1)

11008131(1)

011068092CT(1)

011068092(1)

011067987CT(1)

11015640(1)

11017854(1)

11018185(1)

11018186(1)

11018131(1)

11017871(1)

11017860EA(1)

011067987(1)

011067986CT(1)

504918(1)

011067983(1)

504917(1)

504916(1)

504915(1)

011067983CT(1)

011067984(1)

011067986(1)

011067985CT(1)

011067985(1)

011067984CT(1)

11018187(1)

11018190(1)

11008556(1)

11008558(1)

11008554(1)

1092836(1)

11075823(1)

11008560(1)

1261330(1)

863070(1)

866550(1)

04707(1)

PB4137CT(1)

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

504914(1)

504913(1)

02059(1)

32410(1)

01101(1)

01096(1)

01084(1)

33000(1)

21001(1)

23002(1)

23003(1)

23001(1)

22005(1)

22002(1)

01027(1)

00058(1)

27329(1)

27376(1)

15782(1)

02430(1)

026530(1)

32486(1)

66488(1)

87066(1)

86073(1)

77317(1)

69749(1)

23004(1)

23005(1)

39003(1)

500350(1)

39002(1)

39001(1)

39000(1)

500689(1)

500705(1)

501677(1)

504874(1)

501619(1)

501546(1)

501487(1)

33750(1)

33700(1)

25184(1)

25185(1)

25183(1)

25182(1)

25181(1)

25186(1)

25187(1)

33300(1)

32006(1)

32003(1)

25188(1)

6746(1)

6745(1)

63006(1)

63100(1)

60518(1)

60517(1)

60516(1)

63100CT(1)

63101(1)

0036(1)

0037(1)

63104(1)

63103(1)

63102(1)

60515(1)

60514(1)

20540(1)

20540CT(1)

20527CT(1)

20527(1)

20513CT(1)

20630(1)

20672(1)

60513(1)

56376(1)

56375(1)

52320(1)

0038(1)

0040(1)

192619CT(1)

192719(1)

192619(1)

192519CT(1)

192519(1)

192719CT(1)

192919(1)

4050(1)

4050CT(1)

193019CT(1)

193019(1)

192919CT(1)

192419CT(1)

192419(1)

0845(1)

0846(1)

0570(1)

0448(1)

0162(1)

0847(1)

0848(1)

1281(1)

1279(1)

0995(1)

0849(1)

20513(1)

20421PL(1)

00050(1)

00050CT(1)

00019(1)

00016(1)

320840(1)

00055(1)

00374CT(1)

01074(1)

01500(1)

01014(1)

006546(1)

00374EA(1)

320820(1)

8599961590(1)

60051046CT(1)

60051-052(1)

60051-046(1)

60051012CT(1)

60051-012(1)

60051052CT(1)

60052-101(1)

599961590(1)

1099961590(1)

60224-101(1)

60052101CT(1)

01501(1)

01720(1)

06922(1)

06927(1)

06898(1)

06897(1)

06547(1)

06930(1)

06931(1)

20421CT(1)

20421EA(1)

11248(1)

10117(1)

10107(1)

06546(1)

06451(1)

06114(1)

06119(1)

0529CPL(1)

0529C(1)

01720CT(1)

06122(1)

06125(1)

06437(1)

06433(1)

06430(1)

06239(1)

4051(1)

4051CT(1)

6602(1)

6602CT(1)

6570CT(1)

6570(1)

6547(1)

6606(1)

6606CT(1)

6613(1)

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

6614(1)

6614CT(1)

6722(1)

6722CT(1)

6720CT(1)

6720(1)

6700CT(1)

6727(1)

6728(1)

6743CT(1)

6744(1)

6743(1)

6732CT(1)

6732(1)

6700(1)

6694CT(1)

6662(1)

6663(1)

6661(1)

6659(1)

6624(1)

6663CT(1)

6664(1)

6694(1)

6685CT(1)

6685(1)

6680(1)

6502CT(1)

6502(1)

5161(1)

5303(1)

4792(1)

4732(1)

4493(1)

5304(1)

5305(1)

5471(1)

5493(1)

5470(1)

5469(1)

5339(1)

4461(1)

4441(1)

4061CT(1)

4066(1)

4061(1)

4060CT(1)

4060(1)

4066CT(1)

4067(1)

4432(1)

4162(1)

4092(1)

4067CT(1)

5531(1)

5814(1)

6405(1)

6405CT(1)

6378(1)

6377(1)

6376(1)

6406(1)

6406CT(1)

6501(1)

6501CT(1)

6425(1)

6408(1)

6407(1)

6305(1)

6248(1)

6003(1)

6003CT(1)

6002(1)

6001(1)

6000(1)

6006(1)

6106(1)

6204(1)

6111(1)

6110(1)

6107(1)

008715(1)

 
Country of Origin

US(365)

CA(45)

IT(15)

GB(4)

ES(1)

AX(1)

 
For Use With

Keurig Brewing System(175)

K-Cup Brewer(34)

Drip Coffee Brewers(15)

Commercial Brewers(12)

Commercial Coffee Brewers(12)

Single Cup Brewers(9)

Pod Brewers(6)

NESCAFÉ Dolce Gusto Machines(5)

LavAzza Espresso Point Machine (sold separately)(3)

Single Serve Pod Brewing Systems(3)

Standard Coffee Brewers(3)

Lavazza 2312 BLUE Machine(2)

Standard and Commercial Coffee Makers(2)

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

Keurig Brewers(2)

Any traditional coffee maker(1)

1/2-Gallon Brewers(1)

Pod Espresso Brewer(1)

Lavazza BLUE Single-Cup Brewing System(1)

 
Capacity (Volume)

0.27 oz(3)

8 oz(2)

10 oz(2)

8 g(1)

25.1 oz(1)

0.9 oz(1)

6 oz(1)

 
Capacity (Weight)

2.5 oz(27)

1 lb(19)

0.3 oz(17)

1.5 oz(14)

2 oz(14)

2.2 oz(8)

0.9 oz(7)

12 oz(6)

0.35 oz(6)

0.4 oz(5)

2.25 oz(4)

0.12 oz(4)

1.4 oz(4)

2.2 lbs(3)

30.5 oz(3)

0.25 oz(3)

1.5 oz.(3)

1.1 oz(3)

1.75 oz(3)

28 oz(3)

10 oz(3)

32 oz(2)

0.1 oz(2)

30.6 oz(2)

1.2 oz(2)

0.06 oz(2)

0.31 oz(2)

22.6 oz(2)

48 oz(2)

0.6 oz(2)

16 oz(2)

7 g(2)

31.1 oz(2)

8 oz(2)

2.5 lbs(2)

25.4 oz(2)

24.2 oz(2)

0.8 oz(1)

34.5 oz(1)

31 oz(1)

2 oz.(1)

45 oz(1)

1.25 oz(1)

36 oz(1)

1.93 oz(1)

29.3 oz(1)

9 g(1)

8 g(1)

5 lb(1)

0.7 oz(1)

1.05 oz(1)

33.9 oz(1)

0.08 oz(1)

0.33 oz(1)

26 oz(1)

 
Roast Type

Medium(117)

Dark(67)

Light(38)

Dark Roast(4)

Medium Roast(1)

Decaf(1)

Light Roast(1)

 
 
 

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