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

Folgers(48)

Starbucks(21)

Peet's Coffee & Tea(18)

Tully's Coffee(14)

1850(14)

Lavazza(12)

Maxwell House(12)

Caribou Coffee(10)

PapaNicholas Coffee(9)

Eight O'Clock(9)

Day to Day Coffee(8)

New England Coffee(8)

Melitta(8)

Dunkin Donuts(8)

Café Bustelo(7)

Java One(7)

Donut House(6)

Nescafé(6)

Gloria Jean's(6)

Diedrich Coffee(6)

Barista Prima Coffeehouse(5)

NESCAFÉ Dolce Gusto(5)

Newman's Own Organics(5)

The Original Donut Shop(4)

Seattle's Best(4)

Café Escapes(4)

McCafe(4)

Coffee People(4)

Gevalia(4)

Distant Lands Coffee(3)

Krispy Kreme Doughnuts(3)

revv(3)

Yuban(3)

illy(2)

Chase & Sanborn(2)

Tim Hortons(2)

National Coffee Roasters(2)

Kahlúa(1)

Cinnabon(1)

Chock full o'Nuts(1)

BUSTELO cool(1)

 
Quantity

24 per box(1)

 
Packing Type

K-Cup(184)

Bag(36)

Fraction Pack(32)

Pod(24)

Packet(22)

Canister(13)

Can(11)

Filter Pack(8)

Stick(8)

Capsule(5)

Portion Pack(4)

Vacket Pack(3)

Cartridges(3)

Brick Pack(2)

Jar(1)

 
Flavor

French Roast(18)

House Blend(15)

Classic Roast(14)

Breakfast Blend(13)

Hazelnut(10)

French Vanilla(8)

Espresso(7)

Regular(7)

Original(7)

Medium Roast(6)

100% Colombian(6)

Assorted(6)

Black Silk(5)

Classic Roast Decaf(5)

Decaffeinated(5)

Colombian(5)

Hazelnut Creme(5)

Dark Roast(5)

Black Gold(4)

Major Dickason's Blend(4)

House Blend Decaf(4)

Pioneer Blend(4)

Italian Roast(4)

Original Blend(3)

Decaf House Blend(3)

Caffe Verona(3)

Breakfast Blend Decaf(3)

Lantern Glow(3)

Vermont Country Blend(2)

Our Blend(2)

Hawaiian Blend(2)

Donut House(2)

Lake & Lodge(2)

Colombia(2)

Nantucket Blend(2)

Caramel(2)

Café Domingo Blend(2)

Butter Toffee(2)

Caramel Vanilla Cream(2)

Caribou Blend(2)

Vermont Country Blend Decaf(2)

Donut House Decaf(2)

Vanilla Hazelnut(2)

Half-Caff(2)

Caribou Blend Decaf(2)

Daybreak Morning Blend(2)

Mahogany(2)

Island Coconut(2)

Mocha(2)

Wild Mountain Blueberry(2)

Single Origin Colombian Select(2)

Pumpkin Spice(2)

Morning Edition(2)

Chocolate Glazed Donut(2)

Southern Pecan(2)

Hawaiian Islands Blend(2)

Colombian Supremo(2)

Dark Magic Extra Bold(2)

Pike Place Decaf(2)

Hazelnut Cream(2)

Trailblazer(2)

Pike Place(2)

Half Caff(2)

Simply Smooth(2)

French Roast Decaf(2)

Morning Blend(2)

Special Decaf(2)

Organic Sumatran Extra Bold(2)

Special Blend Extra Bold(2)

Double Black Diamond Extra Bold(2)

Dark Magic Decaf Extra Bold(2)

French Vanilla Decaf(2)

Donut Shop Regular(2)

Sumatra Mandheling(1)

Veranda Blend Blonde Roast(1)

Parisian Vanilla(1)

100% Arabica Blend Decaf(1)

Aroma Club 100% Arabica Blend(1)

Dark(1)

Decaf Portside Blend(1)

Special Delivery(1)

Pier 70 Blend(1)

6th Avenue Bistro(1)

Crema Aroma Arabica/Robusta(1)

Costa Rica Paraiso(1)

Kenya Highlands(1)

Portside Blend(1)

Kahlúa Original(1)

Kona Blend(1)

Breakfast Blend (Light Roast)(1)

Buzzworthy (Dark Roast)(1)

Colombia Medium(1)

Vanilla Latte Macchiato(1)

Special House Blend(1)

Chococino(1)

Cappuccino(1)

Decaffeinated French Roast(1)

Lungo Decaf(1)

Sumatra(1)

Eye Opener(1)

French Dark Roast(1)

Love at First Sip (Medium Roast)(1)

Original Roast Decaf(1)

Decaf Pike Place Roast(1)

Pike Place Roast(1)

Parisian Café (Dark Roast)(1)

Veranda(1)

Colombian Blend(1)

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

Veranda Blend(1)

Decaf(1)

Big Bang(1)

Dark Blend(1)

Dunkin' Decaf(1)

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

Lively Colombian Decaf(1)

Classic(1)

Morning Café(1)

Donut Shop Blend(1)

100% Colombian Decaf(1)

Traditional Roast(1)

Pioneer Blend Decaf(1)

Country Roast(1)

Special Roast(1)

Gourmet Supreme(1)

Café con Leche(1)

Gran Aroma(1)

Classic Decaf(1)

Round the Clock Blend(1)

Cafe Vanilla(1)

Cinnamon(1)

Premium Roast Decaf(1)

Premium Roast(1)

Peppermint Bark(1)

Colombian Decaf(1)

Caramel Hideaway(1)

Bold 1937(1)

NO SURRENDER(1)

Rio Blend(1)

Coconut Mocha(1)

Morning Edition Decaf(1)

TURBOCHARGER(1)

AFTERBURNER(1)

Caramel Drizzle(1)

Vanilla Biscotti(1)

Lively Colombian(1)

Brazil Minas Naturais(1)

Original Decaf(1)

Cinnamon Roll(1)

Regular Roast(1)

 
Beverage Type

Coffee(293)

Decaffeinated Coffee(51)

Instant Coffee(6)

Half-caffeinated Coffee(4)

Coffee Drink(1)

Hot Chocolate(1)

 
Manufacturer Part Number

60051-012(1)

7605(1)

7792(1)

7791(1)

7790(1)

7746(1)

7732CT(1)

7732(1)

7608(1)

7607(1)

7602CT(1)

8087(1)

7602(1)

7595(1)

7594(1)

7586(1)

7564(1)

7563(1)

7534CT(1)

7534(1)

7792CT(1)

8784(1)

7522(1)

705024(1)

75410(1)

4483(1)

4202(1)

2709(1)

1450(1)

0603(1)

0470(1)

0460(1)

70500(1)

PB4141CT(1)

70400(1)

60000(1)

40300(1)

308042(1)

30800(1)

302742(1)

30220(1)

30200(1)

7522CT(1)

7468(1)

75412(1)

6745(1)

6792(1)

6783CT(1)

6783(1)

6772CT(1)

6772(1)

6758CT(1)

6758(1)

6746(1)

6744(1)

6803(1)

6743CT(1)

6743(1)

6732CT(1)

6732(1)

6728(1)

6727(1)

6722CT(1)

6722(1)

6792CT(1)

6803CT(1)

7467(1)

6995CT(1)

7466(1)

7465(1)

7428(1)

71550(1)

7000(1)

6999CT(1)

6999(1)

6996(1)

6995(1)

6812(1)

6994CT(1)

6994(1)

6992CT(1)

6992(1)

6990CT(1)

6990(1)

6974(1)

6873(1)

6813(1)

75411(1)

75413(1)

6720(1)

504915(1)

11017860EA(1)

11017854(1)

11015640(1)

11008131(1)

11008130(1)

504918(1)

504917(1)

504916(1)

504914(1)

11018131(1)

504913(1)

501677(1)

501619(1)

501546(1)

501487(1)

500705(1)

500350(1)

33750(1)

11017871(1)

11018185(1)

33300(1)

11028473(1)

863070(1)

04707(1)

11008560(1)

11008558(1)

11008556(1)

11008554(1)

11029358(1)

11028510(1)

11023061(1)

11018186(1)

11020676(1)

11019631(1)

11018197(1)

11018194(1)

11018193(1)

11018192(1)

11018190(1)

11018187(1)

33700(1)

32006(1)

75415(1)

866150(1)

27329(1)

15782CT(1)

15782(1)

026530(1)

026480(1)

026260(1)

026190(1)

866350(1)

862400(1)

32486(1)

390390(1)

04658(1)

04648PLT(1)

04648CT(1)

04648(1)

75424(1)

75421(1)

75416(1)

27376(1)

66488(1)

32003(1)

23003(1)

25188(1)

25187(1)

25186(1)

25185(1)

25184(1)

25183(1)

25181(1)

23004(1)

23002(1)

66488CT(1)

23001(1)

21001(1)

33000(1)

32410(1)

01096(1)

87066(1)

86073(1)

77317(1)

69749(1)

6720CT(1)

6700CT(1)

60051012CT(1)

60514(1)

63006(1)

60518(1)

60517(1)

60516EA(1)

60516(1)

60515EA(1)

60515(1)

60514EA(1)

60513EA(1)

63100CT(1)

60513(1)

52320(1)

21513(1)

21512(1)

21511(1)

21510(1)

20672(1)

20540CT(1)

63100(1)

63101(1)

20527CT(1)

0845(1)

192419(1)

1281(1)

1279(1)

0995(1)

0849(1)

0848(1)

0847(1)

0846(1)

0570(1)

63102(1)

0448(1)

0162(1)

0040(1)

0038(1)

0037(1)

0036(1)

63104(1)

63103(1)

20540(1)

20527(1)

192519(1)

320840(1)

01014(1)

00518X(1)

00374EA(1)

00374CT(1)

00055(1)

00050(1)

00019(1)

00016(1)

320820(1)

01720(1)

8599961590(1)

599961590(1)

60052101CT(1)

60052-101(1)

60051052CT(1)

60051-052(1)

60051046CT(1)

60051-046(1)

01500(1)

01720CT(1)

20513CT(1)

06927(1)

20513(1)

20421PL(1)

20421EA(1)

20421CT(1)

10117(1)

10107(1)

06931(1)

06930(1)

06922(1)

06114(1)

06897(1)

06547(1)

06451(1)

06437(1)

06433(1)

06430(1)

06239(1)

06125(1)

06122(1)

192419CT(1)

192519CT(1)

6700(1)

6523(1)

6546(1)

6545(1)

6544(1)

6543(1)

6542(1)

6534CT(1)

6534(1)

6523CT(1)

6520CT(1)

6570(1)

6520(1)

6503CT(1)

6503(1)

6502CT(1)

6502(1)

6501CT(1)

6501(1)

6425(1)

6547(1)

6570CT(1)

6407(1)

6662(1)

6694CT(1)

6694(1)

6685CT(1)

6685(1)

6680(1)

6664(1)

6663CT(1)

6663(1)

6661(1)

6602(1)

6659(1)

6613CT(1)

6613(1)

6612(1)

6611CT(1)

6611(1)

6606CT(1)

6606(1)

6602CT(1)

6408(1)

6406CT(1)

192619(1)

4051(1)

4067(1)

4066CT(1)

4066(1)

4061CT(1)

4061(1)

4060CT(1)

4060(1)

4051CT(1)

4050CT(1)

5303(1)

4050(1)

193019CT(1)

193019(1)

192919CT(1)

192919(1)

192719CT(1)

192719(1)

192619CT(1)

4067CT(1)

5304(1)

6406(1)

6106(1)

6405CT(1)

6405(1)

6376(1)

6305(1)

6248(1)

6111(1)

6110(1)

6107(1)

6006(1)

5305(1)

6003CT(1)

6003(1)

6002(1)

6001(1)

6000(1)

5471(1)

5470(1)

5469(1)

5339(1)

866550(1)

 
Country of Origin

US(313)

CA(31)

IT(7)

GB(4)

ES(1)

 
For Use With

Keurig K-Cup System(178)

Commercial Coffee Brewers(19)

Pod Brewers(8)

Single Cup Brewers(7)

Drip Coffee Brewers(7)

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

NESCAFÉ Dolce Gusto Machines(5)

Standard Coffee Brewers(4)

LavAzza Espresso Point Machine(2)

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

Keurig Brewing System(1)

LavAzza Espresso Point Machine (sold separately)(1)

 
Capacity (Volume)

10 oz(2)

48 oz(1)

8 oz(1)

25.1 oz(1)

0(1)

 
Capacity (Weight)

2.5 oz(28)

1 lb(18)

0.3 oz(15)

1.5 oz(12)

12 oz(10)

2 oz(8)

0.35 oz(6)

0.9 oz(6)

1.4 oz(4)

0.06 oz(4)

30.5 oz(3)

1.75 oz(3)

0.25 oz(3)

28 oz(3)

30.6 oz(3)

0.1 oz(2)

0.4 oz(2)

31.1 oz(2)

24.2 oz(2)

25.4 oz(2)

1.1 oz(2)

1.05 oz(2)

32 oz(2)

22.6 oz(2)

0.12 oz(2)

10 oz(2)

1.2 oz(2)

34.5 oz(1)

1.25 oz(1)

0.33 oz(1)

29.3 oz(1)

7 g(1)

2.2 lbs(1)

8 oz(1)

5 lb(1)

16 oz(1)

0.8 oz(1)

0.6 oz(1)

36 oz(1)

31 oz(1)

 
Roast Type

Medium(106)

Dark(75)

Light(34)

 
 
 

© 2020-2021 Meadows Office Supply, All Rights Reserved