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

Folgers(55)

Starbucks(22)

Peet's Coffee & Tea(18)

1850(15)

Day to Day Coffee(15)

Lavazza(15)

Tully's Coffee(14)

Caribou Coffee(14)

Café Bustelo(14)

Maxwell House(12)

PapaNicholas Coffee(10)

New England Coffee(9)

Java One(9)

Eight O'Clock(9)

Dunkin Donuts(9)

Melitta(8)

Barista Prima Coffeehouse(7)

Nescafé(6)

Diedrich Coffee(6)

Donut House(6)

Gloria Jean's(6)

Distant Lands Coffee(6)

Newman's Own Organics(5)

The Original Donut Shop(5)

Seattle's Best(5)

NESCAFÉ Dolce Gusto(5)

McCafe(4)

Coffee People(4)

Café Escapes(4)

Gevalia(4)

revv(3)

Krispy Kreme Doughnuts(3)

Hills Bros.(3)

National Coffee Roasters(3)

Yuban(3)

illy(2)

Chase & Sanborn(2)

BUSTELO cool(2)

Tim Hortons(2)

Kahlúa(1)

Cinnabon(1)

Office Snax(1)

Chock full o'Nuts(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(190)

Bag(47)

Fraction Pack(37)

Packet(34)

Pod(31)

Can(14)

Canister(13)

Filter Pack(8)

Stick(8)

Portion Pack(5)

Capsule(5)

Vacket Pack(3)

Cartridges(3)

Lavazza BLUE Capsule(3)

Brick Pack(2)

Jar(2)

Coffee Pod(1)

 
Flavor

French Roast(21)

Classic Roast(15)

House Blend(15)

Breakfast Blend(14)

Espresso(11)

Hazelnut(10)

Original Blend(8)

French Vanilla(8)

Regular(8)

Original(7)

Dark Roast(7)

100% Colombian(6)

Classic Roast Decaf(6)

Medium Roast(6)

Assorted(6)

Italian Roast(6)

Hazelnut Creme(5)

Decaffeinated(5)

Colombian(5)

Pioneer Blend(5)

Black Silk(5)

Black Gold(5)

House Blend Decaf(4)

Major Dickason's Blend(4)

Breakfast Blend Decaf(4)

Morning Blend(4)

Caramel(3)

Colombian Supremo(3)

Decaf House Blend(3)

Caffe Verona(3)

Daybreak Morning Blend(3)

Caribou Blend(3)

Lantern Glow(3)

Colombian Decaf(3)

Mahogany(2)

Vermont Country Blend Decaf(2)

Single Origin Colombian Select(2)

Donut House Decaf(2)

Vanilla Hazelnut(2)

Half-Caff(2)

Caribou Blend Decaf(2)

Lake & Lodge(2)

Donut House(2)

Café Domingo Blend(2)

Mocha(2)

Caramel Vanilla Cream(2)

Our Blend(2)

Vermont Country Blend(2)

Wild Mountain Blueberry(2)

Hawaiian Blend(2)

Southern Pecan(2)

Pumpkin Spice(2)

Morning Edition(2)

Colombia(2)

Chocolate Glazed Donut(2)

French Vanilla Decaf(2)

Nantucket Blend(2)

Island Coconut(2)

Dark Magic Decaf Extra Bold(2)

Double Black Diamond Extra Bold(2)

Pike Place(2)

Hawaiian Islands Blend(2)

French Roast Decaf(2)

Pike Place Decaf(2)

Special Roast(2)

Hazelnut Cream(2)

Espresso Decaf(2)

Simply Smooth(2)

Special Blend Extra Bold(2)

Traditional Roast(2)

Dark Magic Extra Bold(2)

Donut Shop Regular(2)

Butter Toffee(2)

Special Decaf(2)

Half Caff(2)

Organic Sumatran Extra Bold(2)

Sumatra Mandheling(1)

Crema Aroma Arabica/Robusta(1)

Aroma Club 100% Arabica Blend(1)

Veranda Blend Blonde Roast(1)

FT Vanilla(1)

Costa Rican La Sonrisa(1)

Colombian De Jardin(1)

Decaf Portside Blend(1)

Estate Costa Rican(1)

Pier 70 Blend(1)

Portside Blend(1)

6th Avenue Bistro(1)

Kahlúa Original(1)

Kenya Highlands(1)

Costa Rica Paraiso(1)

Dark(1)

Special Delivery(1)

100% Arabica Blend Decaf(1)

Crema Dolce/Medium Roast(1)

Decaffeinated Medium Roast(1)

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

Colombian Blend(1)

Vanilla Latte Macchiato(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)

Kona Blend(1)

Veranda Blend(1)

Love at First Sip (Medium Roast)(1)

Special House Blend(1)

Buzzworthy (Dark Roast)(1)

Decaffeinated French Roast(1)

Sumatra(1)

Colombia Medium(1)

Decaf Pike Place Roast(1)

Pike Place Roast(1)

Parisian Vanilla(1)

Rotondo/Dark Roast(1)

Veranda(1)

Decaf(1)

Lively Colombian(1)

Dark Blend(1)

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

Donut Shop Blend(1)

100% Colombian Decaf(1)

Traditional Roast Decaf(1)

Signature Blend 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)

Donut Shop(1)

Decaf Caribou Blend(1)

Dark Royal(1)

Cinnamon Sugar Cookie(1)

Round the Clock Blend(1)

TURBOCHARGER(1)

Cinnamon(1)

Premium Roast Decaf(1)

Premium Roast(1)

Peppermint Bark(1)

Caramel Hideaway(1)

Bold 1937(1)

NO SURRENDER(1)

Cafe Vanilla(1)

Rio Blend(1)

Morning Edition Decaf(1)

AFTERBURNER(1)

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

Classic Decaf(1)

Classic(1)

Gran Aroma(1)

Regular Roast(1)

 
Beverage Type

Coffee(333)

Decaffeinated Coffee(59)

Instant Coffee(6)

Half-caffeinated Coffee(4)

Coffee Drink(2)

Instant Decaffeinated Coffee(1)

Hot Chocolate(1)

 
Manufacturer Part Number

008710(1)

7791(1)

30220(1)

302142(1)

30210(1)

30200(1)

PB4141CT(1)

8784(1)

8087(1)

7792CT(1)

7792(1)

7790(1)

30400(1)

7746(1)

7732CT(1)

7732(1)

7608(1)

7607(1)

7605(1)

7602CT(1)

7602(1)

7595(1)

7594(1)

302742(1)

30800(1)

7564(1)

2709(1)

75413(1)

75412(1)

75411(1)

75410(1)

970(1)

953(1)

910(1)

4483(1)

4202(1)

1450(1)

308042(1)

0603(1)

0470(1)

0460(1)

705024(1)

70500(1)

70400(1)

60000(1)

40300(1)

39930404021(1)

39930274021(1)

7586(1)

7563(1)

75416(1)

6746(1)

6803(1)

6792CT(1)

6792(1)

6783CT(1)

6783(1)

6772CT(1)

6772(1)

6758CT(1)

6758(1)

6745(1)

6812(1)

6744(1)

6743CT(1)

6743(1)

6732CT(1)

6732(1)

6728(1)

6727(1)

6722CT(1)

6722(1)

6720CT(1)

6803CT(1)

6813(1)

7534CT(1)

6999CT(1)

7534(1)

7522CT(1)

7522(1)

7468(1)

7467(1)

7466(1)

7465(1)

7428(1)

71550(1)

7000(1)

6999(1)

6873(1)

6996(1)

6995CT(1)

6995(1)

6994CT(1)

6994(1)

6992CT(1)

6992(1)

6990CT(1)

6990(1)

6974(1)

75415(1)

75421(1)

6700CT(1)

504913(1)

11017854(1)

11015640(1)

11008131(1)

11008130(1)

504918(1)

504917(1)

504916(1)

504915(1)

504914(1)

501677(1)

11017871(1)

501619(1)

501546(1)

501487(1)

500705(1)

500350(1)

39003(1)

39002(1)

39001(1)

39000(1)

33750(1)

11017860EA(1)

11018131(1)

33300(1)

11028510(1)

863070(1)

04707(1)

1261330(1)

11008560(1)

11008558(1)

11008556(1)

11008554(1)

1092836(1)

11075823(1)

11029358(1)

11028473(1)

11018185(1)

11023061(1)

11020676(1)

11019631(1)

11018197(1)

11018194(1)

11018193(1)

11018192(1)

11018190(1)

11018187(1)

11018186(1)

33700(1)

32006(1)

75424(1)

026480(1)

69749(1)

66488CT(1)

66488(1)

32486(1)

27376(1)

27329(1)

15782CT(1)

15782(1)

026530(1)

026260(1)

86073(1)

026190(1)

026160(1)

866350(1)

866150(1)

862400(1)

390390(1)

04658(1)

04648PLT(1)

04648CT(1)

04648(1)

77317(1)

87066(1)

32003(1)

23003(1)

25188(1)

25187(1)

25186(1)

25185(1)

25184(1)

25183(1)

25182(1)

25181(1)

23005(1)

23004(1)

23002(1)

00058(1)

23001(1)

22005(1)

22002(1)

21001(1)

33000(1)

32410(1)

01101(1)

01096(1)

01084(1)

01027(1)

6720(1)

6700(1)

008711(1)

20540(1)

56375(1)

52320(1)

21513(1)

21512(1)

21511(1)

21510(1)

20672(1)

20630(1)

20540CT(1)

20527CT(1)

60513(1)

20527(1)

20513CT(1)

20513(1)

20421PL(1)

20421EA(1)

20421CT(1)

11545BX(1)

11545(1)

11544BX(1)

11544(1)

56376(1)

60513EA(1)

10117(1)

63101(1)

0570(1)

0448(1)

0162(1)

0040(1)

0038(1)

0037(1)

0036(1)

63104(1)

63103(1)

63102(1)

63100CT(1)

60514(1)

63100(1)

63006(1)

60518EA(1)

60518(1)

60517EA(1)

60517(1)

60516EA(1)

60516(1)

60515(1)

60514EA(1)

11248(1)

10107(1)

0846(1)

1099961590(1)

00055(1)

00050CT(1)

00050(1)

00019(1)

00016(1)

320840(1)

320820(1)

8599961590(1)

599961590(1)

60224-101(1)

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

06931(1)

06430(1)

06930(1)

06927(1)

06922(1)

06898(1)

06897(1)

06547(1)

06546(1)

06451(1)

06437(1)

06433(1)

06239(1)

01014(1)

06125(1)

06122(1)

06119(1)

06114(1)

0529C(1)

01720CT(1)

01720(1)

01501(1)

01500(1)

01074(1)

0845(1)

0847(1)

6694CT(1)

6503CT(1)

6544(1)

6543(1)

6542(1)

6534CT(1)

6534(1)

6523CT(1)

6523(1)

6520CT(1)

6520(1)

6503(1)

6546(1)

6502CT(1)

6502(1)

6501CT(1)

6501(1)

6425(1)

6408(1)

6407(1)

6406CT(1)

6406(1)

6405CT(1)

6545(1)

6547(1)

6376(1)

6614CT(1)

6694(1)

6685CT(1)

6685(1)

6680(1)

6664(1)

6663CT(1)

6663(1)

6662(1)

6661(1)

6659(1)

6614(1)

6570(1)

6613CT(1)

6613(1)

6612(1)

6611CT(1)

6611(1)

6606CT(1)

6606(1)

6602CT(1)

6602(1)

6570CT(1)

6405(1)

6305(1)

0848(1)

192719CT(1)

4060(1)

4051CT(1)

4051(1)

4050CT(1)

4050(1)

193019CT(1)

193019(1)

192919CT(1)

192919(1)

192719(1)

4061(1)

192619CT(1)

192619(1)

192519CT(1)

192519(1)

192419CT(1)

192419(1)

1281(1)

1279(1)

0995(1)

0849(1)

4060CT(1)

4061CT(1)

6248(1)

6000(1)

6204(1)

6111(1)

6110(1)

6107(1)

6106(1)

6006(1)

6003CT(1)

6003(1)

6002(1)

6001(1)

5814(1)

4066(1)

5471(1)

5470(1)

5469(1)

5339(1)

5305(1)

5304(1)

5303(1)

4067CT(1)

4067(1)

4066CT(1)

866550(1)

 
Country of Origin

US(359)

CA(31)

IT(10)

GB(4)

AX(1)

ES(1)

 
For Use With

Keurig K-Cup System(188)

Commercial Coffee Brewers(20)

Drip Coffee Brewers(14)

Pod Brewers(9)

Single Cup Brewers(9)

NESCAFÉ Dolce Gusto Machines(5)

Single Cup Brewers Hamilton, Bunn and Newco(4)

Standard Coffee Brewers(4)

Lavazza 2312 BLUE Machine(3)

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

Keurig Brewing System(2)

LavAzza Espresso Point Machine(2)

1/2-Gallon Brewers(1)

Pod Espresso Brewer(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)

12 oz(11)

0.9 oz(6)

0.35 oz(6)

0.06 oz(4)

1.4 oz(4)

1.1 oz(3)

1.75 oz(3)

0.25 oz(3)

28 oz(3)

30.5 oz(3)

0.4 oz(3)

10 oz(3)

30.6 oz(3)

8 g(2)

1.2 oz(2)

32 oz(2)

31.1 oz(2)

8 oz(2)

25.4 oz(2)

0.1 oz(2)

7 g(2)

1.05 oz(2)

22.6 oz(2)

0.12 oz(2)

0.6 oz(2)

24.2 oz(2)

2 oz.(1)

2.25 oz(1)

1.25 oz(1)

34.5 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(117)

Dark(86)

Light(36)

Dark Roast(3)

Medium Roast(1)

 
 
 

© 2020-2021 Meadows Office Supply, All Rights Reserved