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

Folgers(48)

Starbucks(21)

Lavazza(18)

Peet's Coffee & Tea(18)

1850(14)

Tully's Coffee(14)

Maxwell House(12)

Caribou Coffee(10)

Eight O'Clock(9)

PapaNicholas Coffee(9)

Day to Day Coffee(8)

Melitta(8)

Dunkin Donuts(8)

New England Coffee(8)

Café Bustelo(7)

Java One(7)

Diedrich Coffee(6)

Gloria Jean's(6)

Nescafé(6)

Donut House(6)

Barista Prima Coffeehouse(5)

Newman's Own Organics(5)

The Original Donut Shop(4)

Café Escapes(4)

Seattle's Best(4)

McCafe(4)

Coffee People(4)

NESCAFÉ Dolce Gusto(4)

Gevalia(4)

revv(3)

Distant Lands Coffee(3)

Krispy Kreme Doughnuts(3)

Yuban(3)

illy(2)

Tim Hortons(2)

National Coffee Roasters(2)

Kahlúa(1)

Green Mountain Coffee Roasters®(1)

Dunkin' Donuts®(1)

Chock full o'Nuts(1)

Chase & Sanborn(1)

BUSTELO cool(1)

Cinnabon(1)

 
Quantity

24 per box(3)

96 per carton(1)

 
Packing Type

K-Cup(184)

Bag(38)

Fraction Pack(35)

Pod(24)

Packet(21)

Canister(13)

Can(11)

Filter Pack(8)

Stick(8)

Portion Pack(4)

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

Original(7)

Espresso(7)

100% Colombian(6)

Assorted(6)

Medium Roast(6)

Regular(6)

Decaffeinated(5)

Classic Roast Decaf(5)

Hazelnut Creme(5)

Colombian(5)

Black Silk(5)

Dark Roast(5)

Black Gold(4)

Major Dickason's Blend(4)

Pioneer Blend(4)

House Blend Decaf(4)

Italian Roast(4)

Caffe Verona(3)

Original Blend(3)

Decaf House Blend(3)

Breakfast Blend Decaf(3)

Lantern Glow(3)

Dark and Bold(2)

Half-Caff(2)

Caramel(2)

Vermont Country Blend Decaf(2)

Lake & Lodge(2)

Donut House(2)

Donut House Decaf(2)

Café Domingo Blend(2)

Our Blend(2)

Vermont Country Blend(2)

Hawaiian Blend(2)

Colombia(2)

Vanilla Hazelnut(2)

Caribou Blend Decaf(2)

Nantucket Blend(2)

Mocha(2)

Daybreak Morning Blend(2)

Caramel Vanilla Cream(2)

Island Coconut(2)

Caribou Blend(2)

Mahogany(2)

Chocolate Glazed Donut(2)

Morning Edition(2)

Pumpkin Spice(2)

Dark and Intense(2)

Southern Pecan(2)

Wild Mountain Blueberry(2)

Single Origin Colombian Select(2)

Butter Toffee(2)

French Vanilla Decaf(2)

Morning Blend(2)

Dark Magic Extra Bold(2)

Hazelnut Cream(2)

Pike Place Decaf(2)

Trailblazer(2)

Pike Place(2)

Half Caff(2)

French Roast Decaf(2)

Simply Smooth(2)

Colombian Supremo(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)

Donut Shop Regular(2)

Hawaiian Islands Blend(2)

Kenya Highlands(1)

Kahlúa Original(1)

Veranda Blend Blonde Roast(1)

Gold Selection(1)

Decaf Portside Blend(1)

Sumatra Mandheling(1)

Pier 70 Blend(1)

Special Delivery(1)

Light and Aromatic(1)

6th Avenue Bistro(1)

Portside Blend(1)

100% Arabica Blend Decaf(1)

Crema Aroma Arabica/Robusta(1)

Aroma Club 100% Arabica Blend(1)

Colombian Blend(1)

Veranda(1)

Veranda Blend(1)

Original Roast Decaf(1)

Costa Rica Paraiso(1)

Cappuccino(1)

Lungo Decaf(1)

Eye Opener(1)

Special House Blend(1)

Decaffeinated French Roast(1)

Sumatra(1)

French Dark Roast(1)

Parisian Café (Dark Roast)(1)

Parisian Vanilla(1)

Colombia Medium(1)

Breakfast Blend (Light Roast)(1)

Decaf Pike Place Roast(1)

Pike Place Roast(1)

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

Love at First Sip (Medium Roast)(1)

Vanilla Latte Macchiato(1)

Buzzworthy (Dark Roast)(1)

Kona Blend(1)

Caramel Drizzle(1)

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

Decaf(1)

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

Coconut Mocha(1)

Morning Edition Decaf(1)

TURBOCHARGER(1)

AFTERBURNER(1)

Big Bang(1)

Vanilla Biscotti(1)

Lively Colombian(1)

Brazil Minas Naturais(1)

Original Decaf(1)

Cinnamon Roll(1)

Regular Roast(1)

 
Beverage Type

Coffee(299)

Decaffeinated Coffee(49)

Instant Coffee(6)

Half-caffeinated Coffee(4)

Coffee Drink(1)

 
Manufacturer Part Number

60051-012(1)

7608(1)

7792CT(1)

7792(1)

7791(1)

7790(1)

7746(1)

7732CT(1)

7732(1)

7674(1)

7607(1)

8784(1)

7605(1)

7602CT(1)

7602(1)

7596(1)

7595(1)

7594(1)

7586(1)

7564(1)

8087(1)

PB4141CT(1)

7534CT(1)

0470(1)

3451(1)

3446(1)

3445(1)

3427(1)

3425(1)

2709(1)

1450(1)

0603(1)

0460(1)

30200(1)

705024(1)

70500(1)

70400(1)

60000(1)

40300(1)

308042(1)

30800(1)

302742(1)

30220(1)

7563(1)

7534(1)

4202(1)

6758(1)

6803(1)

6792CT(1)

6792(1)

6783CT(1)

6783(1)

6772CT(1)

6772(1)

6758CT(1)

6746(1)

6812(1)

6745(1)

6744(1)

6743CT(1)

6743(1)

6732CT(1)

6732(1)

6728(1)

6727(1)

6803CT(1)

6813(1)

7522CT(1)

6999(1)

7522(1)

7468(1)

7467(1)

7466(1)

7465(1)

7428(1)

7000(1)

6999CT(1)

6996(1)

6873(1)

6995CT(1)

6995(1)

6994CT(1)

6994(1)

6992CT(1)

6992(1)

6990CT(1)

6990(1)

6974(1)

3454(1)

4483(1)

6722(1)

504914(1)

11017854(1)

11015640(1)

11008131(1)

11008130(1)

504918(1)

504917(1)

504916(1)

504915(1)

504913(1)

11017871(1)

501677(1)

501619(1)

501546(1)

501487(1)

500705(1)

500350(1)

33750(1)

33700(1)

11017860EA(1)

11018131(1)

32006(1)

11028473(1)

863070(1)

04707(1)

11008560(1)

11008558(1)

11008556(1)

11008554(1)

11029358(1)

11028510(1)

11023061(1)

11018185(1)

11020676(1)

11019631(1)

11018197(1)

11018194(1)

11018193(1)

11018192(1)

11018190(1)

11018187(1)

11018186(1)

33300(1)

32003(1)

75410(1)

04658(1)

026530(1)

026480(1)

026260(1)

026190(1)

866350(1)

866150(1)

862400(1)

390390(1)

04648PLT(1)

15782CT(1)

04648CT(1)

04648(1)

75424(1)

75421(1)

75416(1)

75415(1)

75413(1)

75412(1)

75411(1)

15782(1)

27329(1)

25188(1)

23002(1)

25187(1)

25186(1)

25185(1)

25184(1)

25183(1)

25181(1)

23004(1)

23003(1)

23001(1)

27376(1)

21001(1)

33000(1)

01096(1)

87066(1)

86073(1)

77317(1)

66488CT(1)

66488(1)

32486(1)

6722CT(1)

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

0846(1)

192419CT(1)

192419(1)

1281(1)

1279(1)

0995(1)

0849(1)

0848(1)

0847(1)

0845(1)

63102(1)

0570(1)

0448(1)

0162(1)

0040(1)

0038(1)

0037(1)

0036(1)

63104(1)

63103(1)

20540(1)

20527(1)

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

192519(1)

192619(1)

6720(1)

6534(1)

6570(1)

6547(1)

6546(1)

6545(1)

6544(1)

6543(1)

6542(1)

6534CT(1)

6523CT(1)

6602(1)

6523(1)

6520CT(1)

6520(1)

6503CT(1)

6503(1)

6502CT(1)

6502(1)

6501CT(1)

6570CT(1)

6602CT(1)

6425(1)

6663CT(1)

6700CT(1)

6700(1)

6694CT(1)

6694(1)

6685CT(1)

6685(1)

6680(1)

6664(1)

6663(1)

6606(1)

6662(1)

6661(1)

6659(1)

6613CT(1)

6613(1)

6612(1)

6611CT(1)

6611(1)

6606CT(1)

6501(1)

6408(1)

192619CT(1)

4060(1)

5303(1)

4067CT(1)

4067(1)

4066CT(1)

4066(1)

4061CT(1)

4061(1)

4060CT(1)

4051CT(1)

5305(1)

4051(1)

4050CT(1)

4050(1)

193019CT(1)

193019(1)

192919CT(1)

192919(1)

192719CT(1)

192719(1)

5304(1)

5339(1)

6407(1)

6110(1)

6406CT(1)

6406(1)

6405CT(1)

6405(1)

6376(1)

6305(1)

6248(1)

6111(1)

6107(1)

5469(1)

6106(1)

6006(1)

6003CT(1)

6003(1)

6002(1)

6001(1)

6000(1)

5471(1)

5470(1)

866550(1)

 
Country of Origin

US(337)

IT(15)

CA(3)

GB(3)

United States(1)

ES(1)

 
Weight (Approximate)

11.90 oz(1)

 
For Use With

Keurig K-Cup System(175)

Commercial Coffee Brewers(19)

Pod Brewers(8)

Single Cup Brewers(7)

Drip Coffee Brewers(7)

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

Keurig Brewing System(4)

NESCAFÉ Dolce Gusto Machines(4)

Standard Coffee Brewers(4)

Coffee Brewer(3)

Grinder; Coffee Brewer(3)

LavAzza Espresso Point Machine(2)

In-Room Lodging Standard 4-Cup Brewers(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.9 oz(6)

0.35 oz(6)

0.06 oz(4)

1.4 oz(4)

1.75 oz(3)

28 oz(3)

2.2 lb(3)

30.5 oz(3)

0.25 oz(3)

30.6 oz(3)

0.1 oz(2)

8 oz(2)

1.2 oz(2)

0.4 oz(2)

24.2 oz(2)

1.1 oz(2)

31.1 oz(2)

1.05 oz(2)

32 oz(2)

22.6 oz(2)

0.12 oz(2)

10 oz(2)

25.4 oz(2)

34.5 oz(1)

0.33 oz(1)

29.3 oz(1)

7 g(1)

2.2 lbs(1)

2.2 oz(1)

2.25 oz(1)

16 oz(1)

0.8 oz(1)

0.6 oz(1)

36 oz(1)

31 oz(1)

 
Serve Type

K-Cup(2)

 
Coffee Type

Caffeinated(2)

 
Roast Type

Medium(105)

Dark(79)

Light(34)

Mild(1)

 
Compatible Brewer

K-Cup Brewer(2)

 
Product Type

Coffee(2)

 
Packaged Quantity

24 / Box(2)

 
Flavor/Blend

Pumpkin Spice(1)

Nutmeg(1)

Cinnamon(1)

Arabica(1)

Buttery Pecan(1)

Maple(1)

 
Coffee Roast Level

Medium(1)

Light(1)

 
 
 

© 2020-2021 Meadows Office Supply, All Rights Reserved