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

Folgers(55)

Starbucks(22)

Peet's Coffee & Tea(19)

1850(16)

Day to Day Coffee(15)

Lavazza(15)

Tully's Coffee(14)

Caribou Coffee(14)

Café Bustelo(14)

Maxwell House(12)

PapaNicholas Coffee(10)

Dunkin Donuts(10)

Java One(9)

New England Coffee(9)

Eight O'Clock(9)

Melitta(8)

Barista Prima Coffeehouse(7)

Nescafé(6)

Distant Lands Coffee(6)

Donut House(6)

Diedrich Coffee(6)

Gloria Jean's(6)

Newman's Own Organics(5)

The Original Donut Shop(5)

NESCAFÉ Dolce Gusto(5)

Seattle's Best(5)

Coffee People(4)

Gevalia(4)

Café Escapes(4)

McCafe(4)

National Coffee Roasters(3)

Hills Bros.(3)

Yuban(3)

Krispy Kreme Doughnuts(3)

revv(3)

Chase & Sanborn(2)

Tim Hortons(2)

illy(2)

BUSTELO cool(2)

Cinnabon(1)

Office Snax(1)

Kahlúa(1)

Chock full o'Nuts(1)

 
Quantity

36 per carton(4)

42 per carton(4)

24 per box(3)

40 per box(2)

18 per carton(1)

96 per carton(1)

12 per pack(1)

24 per carton(1)

 
Packing Type

K-Cup(192)

Bag(49)

Fraction Pack(37)

Packet(34)

Pod(31)

Can(14)

Canister(13)

Stick(8)

Filter Pack(8)

Capsule(5)

Portion Pack(5)

Lavazza BLUE Capsule(3)

Vacket Pack(3)

Cartridges(3)

Jar(2)

Brick Pack(2)

Coffee Pod(1)

 
Flavor

French Roast(21)

House Blend(15)

Classic Roast(15)

Breakfast Blend(14)

Espresso(11)

Hazelnut(9)

Original Blend(8)

French Vanilla(8)

Regular(8)

Original(7)

Dark Roast(7)

100% Colombian(6)

Classic Roast Decaf(6)

Italian Roast(6)

Assorted(6)

Medium Roast(6)

Pioneer Blend(5)

Decaffeinated(5)

Colombian(5)

Black Silk(5)

Black Gold(5)

Hazelnut Creme(4)

Morning Blend(4)

House Blend Decaf(4)

Major Dickason's Blend(4)

Breakfast Blend Decaf(4)

Decaf House Blend(4)

Caramel(3)

Caribou Blend(3)

Caffe Verona(3)

Colombian Supremo(3)

Pumpkin Spice(3)

Colombian Decaf(3)

Lantern Glow(3)

Daybreak Morning Blend(3)

Café Domingo Blend(2)

Our Blend(2)

Donut House(2)

Vanilla Hazelnut(2)

Vermont Country Blend Decaf(2)

French Vanilla Decaf(2)

Single Origin Colombian Select(2)

Hazelnut Decaf(2)

Lake & Lodge(2)

Vermont Country Blend(2)

Donut House Decaf(2)

Half-Caff(2)

Caramel Vanilla Cream(2)

Nantucket Blend(2)

Island Coconut(2)

Chocolate Glazed Donut(2)

Morning Edition(2)

Southern Pecan(2)

Wild Mountain Blueberry(2)

Colombia(2)

Caribou Blend Decaf(2)

Mahogany(2)

Mocha(2)

Hawaiian Blend(2)

Hawaiian Islands Blend(2)

Dark Magic Decaf Extra Bold(2)

Traditional Roast(2)

Pike Place(2)

Hazelnut Cream(2)

Special Blend Extra Bold(2)

French Roast Decaf(2)

Pike Place Decaf(2)

Half Caff(2)

Donut Shop(2)

Butter Toffee(2)

Special Roast(2)

Espresso Decaf(2)

Simply Smooth(2)

Special Decaf(2)

Trailblazer(2)

Dark Magic Extra Bold(2)

Double Black Diamond Extra Bold(2)

Organic Sumatran Extra Bold(2)

FT Vanilla(1)

Sumatra Mandheling(1)

Decaf Portside Blend(1)

Pier 70 Blend(1)

Vanilla Latte Macchiato(1)

Chococino(1)

Aroma Club 100% Arabica Blend(1)

Crema Aroma Arabica/Robusta(1)

Portside Blend(1)

Colombian Blend(1)

Costa Rican La Sonrisa(1)

Kenya Highlands(1)

Costa Rica Paraiso(1)

Dark(1)

Regular Roast(1)

Kona Blend(1)

Kahlúa Original(1)

Colombian De Jardin(1)

Estate Costa Rican(1)

6th Avenue Bistro(1)

Special Delivery(1)

Veranda Blend Blonde Roast(1)

100% Arabica Blend Decaf(1)

Colombia Medium(1)

Decaf Pike Place Roast(1)

Pike Place Roast(1)

Love at First Sip (Medium Roast)(1)

Sumatra(1)

Decaffeinated French Roast(1)

Parisian Café (Dark Roast)(1)

Special House Blend(1)

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

Original Roast Decaf(1)

French Dark Roast(1)

Eye Opener(1)

Rotondo/Dark Roast(1)

Veranda Blend(1)

Decaffeinated Medium Roast(1)

Breakfast Blend (Light Roast)(1)

Crema Dolce/Medium Roast(1)

Veranda(1)

Buzzworthy (Dark Roast)(1)

Parisian Vanilla(1)

Lungo Decaf(1)

Cappuccino(1)

Vanilla Biscotti(1)

Dunkin' Dark(1)

Caramel Coffee Cake(1)

Dunkin' Decaf(1)

Lively Colombian Decaf(1)

Morning Café(1)

Extra Bold Breakfast Blend(1)

Signature Blend(1)

Cinnamon Sugar Cookie(1)

Perfetto(1)

Signature Blend Decaf(1)

Dark Royal(1)

Original Roast(1)

Donut Shop Blend(1)

100% Colombian Decaf(1)

Estilo Espresso(1)

Café con Leche(1)

Medium Decaf(1)

Donut Shop Decaf(1)

Decaf Caribou Blend(1)

Café con Leche Chocolate(1)

Gourmet Supreme(1)

Traditional Roast Decaf(1)

Pioneer Blend Decaf(1)

Country Roast(1)

Decaf Classic(1)

Gran Aroma(1)

Classic(1)

Caramel Hideaway(1)

Peppermint Bark(1)

Bold 1937(1)

NO SURRENDER(1)

Cafe Vanilla(1)

Premium Roast(1)

Premium Roast Decaf(1)

Maple Pecan(1)

Dark Blend(1)

Round the Clock Blend(1)

Cinnamon(1)

Rio Blend(1)

Morning Edition Decaf(1)

Cinnamon Roll(1)

Original Decaf(1)

Coconut Mocha(1)

Holiday Blend(1)

Classic Decaf(1)

Brazil Minas Naturais(1)

Lively Colombian(1)

TURBOCHARGER(1)

AFTERBURNER(1)

Caramel Drizzle(1)

Big Bang(1)

Decaf(1)

 
Beverage Type

Coffee(335)

Decaffeinated Coffee(61)

Instant Coffee(6)

Half-caffeinated Coffee(4)

Coffee Drink(2)

Hot Chocolate(1)

Instant Decaffeinated Coffee(1)

 
Manufacturer Part Number

7792CT(1)

8087(1)

7792(1)

7791(1)

7790(1)

8784(1)

PB4141CT(1)

30220(1)

302142(1)

30210(1)

30200(1)

7746(1)

7732CT(1)

7596(1)

7602(1)

7595(1)

7594(1)

7586(1)

7602CT(1)

7605(1)

7732(1)

7674(1)

7608(1)

7607(1)

302742(1)

30400(1)

910(1)

953(1)

4483(1)

4202(1)

2709(1)

970(1)

75410(1)

75415(1)

75413(1)

75412(1)

75411(1)

1450(1)

0603(1)

39930404021(1)

40300(1)

39930274021(1)

308042(1)

30800(1)

60000(1)

70400(1)

0470(1)

0460(1)

705024(1)

70500(1)

7564(1)

7563(1)

6772CT(1)

6783(1)

6772(1)

6758CT(1)

6758(1)

6783CT(1)

6792(1)

6812(1)

6803CT(1)

6803(1)

6792CT(1)

6746(1)

6745(1)

6722CT(1)

6727(1)

6722(1)

6720CT(1)

6720(1)

6728(1)

6732(1)

6744(1)

6743CT(1)

6743(1)

6732CT(1)

6813(1)

6873(1)

7465(1)

7466(1)

7428(1)

71550(1)

7000(1)

7467(1)

7468(1)

7534CT(1)

7534(1)

7522CT(1)

7522(1)

6999CT(1)

6999(1)

6992(1)

6990CT(1)

6990(1)

6974(1)

6992CT(1)

6994(1)

6996(1)

6995CT(1)

6995(1)

6994CT(1)

75416(1)

75421(1)

504916(1)

504917(1)

504915(1)

504914(1)

504913(1)

504918(1)

11008130(1)

11017860EA(1)

11017854(1)

11015640(1)

11008131(1)

501677(1)

501619(1)

39001(1)

39002(1)

39000(1)

33750(1)

33700(1)

39003(1)

500350(1)

501546(1)

501487(1)

500705(1)

500689(1)

11017871(1)

11018131(1)

11008554(1)

11008556(1)

1092836(1)

11075823(1)

11029358(1)

11008558(1)

11008560(1)

866550(1)

863070(1)

04707(1)

1261330(1)

11028510(1)

11028473(1)

11018190(1)

11018192(1)

11018187(1)

11018186(1)

11018185(1)

11018193(1)

11018194(1)

11023061(1)

11020676(1)

11019631(1)

11018197(1)

33300(1)

32006(1)

27329(1)

27376(1)

15782CT(1)

15782(1)

026530(1)

32486(1)

66488(1)

86073(1)

77317(1)

69749(1)

66488CT(1)

026480(1)

026260(1)

04648PLT(1)

04658(1)

04648CT(1)

04648(1)

75424(1)

390390(1)

862400(1)

026190(1)

026160(1)

866350(1)

866150(1)

87066(1)

00058(1)

25182(1)

25183(1)

25181(1)

23005(1)

23004(1)

25184(1)

25185(1)

32003(1)

25188(1)

25187(1)

25186(1)

23003(1)

23002(1)

01101(1)

01096(1)

01084(1)

01027(1)

32410(1)

33000(1)

23001(1)

22005(1)

22002(1)

21001(1)

6700CT(1)

6700(1)

21510(1)

21511(1)

20672(1)

20630(1)

20540CT(1)

21512(1)

21513(1)

60513(1)

56376(1)

56375(1)

52320(1)

20540(1)

20527CT(1)

11545(1)

11545BX(1)

11544BX(1)

11544(1)

11248(1)

20421CT(1)

20421EA(1)

20527(1)

20513CT(1)

20513(1)

20421PL(1)

60513EA(1)

60514(1)

0036(1)

0037(1)

63104(1)

63103(1)

63102(1)

0038(1)

0040(1)

0845(1)

0570(1)

0448(1)

0162(1)

63101(1)

63100CT(1)

60516(1)

60516EA(1)

60515EA(1)

60515(1)

60514EA(1)

60517(1)

60517EA(1)

63100(1)

63006(1)

60518EA(1)

60518(1)

10117(1)

10107(1)

320840(1)

00016(1)

320820(1)

8599961590(1)

599961590(1)

00019(1)

00050(1)

00374EA(1)

00374CT(1)

00055(1)

00050CT(1)

1099961590(1)

60224-101(1)

60051-012(1)

60051012CT(1)

008715(1)

008712(1)

008711(1)

60051-046(1)

60051046CT(1)

60052101CT(1)

60052-101(1)

60051052CT(1)

60051-052(1)

01014(1)

01074(1)

06546(1)

06547(1)

06451(1)

06437(1)

06433(1)

06897(1)

06898(1)

06931(1)

06930(1)

06927(1)

06922(1)

06430(1)

06239(1)

01720CT(1)

01720(1)

01501(1)

01500(1)

0529C(1)

0529CPL(1)

06125(1)

06122(1)

06119(1)

06114(1)

0846(1)

0847(1)

6523CT(1)

6534(1)

6523(1)

6520CT(1)

6520(1)

6534CT(1)

6542(1)

6546(1)

6545(1)

6544(1)

6543(1)

6503CT(1)

6503(1)

6406CT(1)

6407(1)

6406(1)

6405CT(1)

6405(1)

6408(1)

6425(1)

6502CT(1)

6502(1)

6501CT(1)

6501(1)

6547(1)

6570(1)

6663(1)

6663CT(1)

6662(1)

6661(1)

6659(1)

6664(1)

6680(1)

6694CT(1)

6694(1)

6685CT(1)

6685(1)

6614CT(1)

6614(1)

6606(1)

6602CT(1)

6602(1)

6570CT(1)

6606CT(1)

6611(1)

6613CT(1)

6613(1)

6612(1)

6611CT(1)

6376(1)

6305(1)

193019CT(1)

4050(1)

193019(1)

192919CT(1)

192919(1)

4050CT(1)

4051(1)

4061(1)

4060CT(1)

4060(1)

4051CT(1)

192719CT(1)

192719(1)

1279(1)

1281(1)

0995(1)

0849(1)

0848(1)

192419(1)

192419CT(1)

192619CT(1)

192619(1)

192519CT(1)

192519(1)

4061CT(1)

4066(1)

6003CT(1)

6006(1)

6003(1)

6002(1)

6001(1)

6106(1)

6107(1)

6248(1)

6204(1)

6111(1)

6110(1)

6000(1)

5814(1)

5303(1)

4067CT(1)

4067(1)

4066CT(1)

5304(1)

5305(1)

5471(1)

5470(1)

5469(1)

5339(1)

008710(1)

 
Country of Origin

US(363)

CA(31)

IT(10)

GB(4)

ES(1)

AX(1)

 
For Use With

Keurig K-Cup System(189)

Commercial Coffee Brewers(20)

Drip Coffee Brewers(14)

Single Cup Brewers(9)

Pod Brewers(9)

NESCAFÉ Dolce Gusto Machines(5)

Single Cup Brewers Hamilton, Bunn and Newco(4)

Standard Coffee Brewers(4)

Lavazza 2312 BLUE Machine(3)

Keurig Brewing System(3)

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

10 oz(2)

8 oz(2)

0(1)

0.9 oz(1)

25.1 oz(1)

 
Capacity (Weight)

2.5 oz(34)

1 lb(19)

0.3 oz(17)

1.5 oz(17)

2 oz(14)

12 oz(12)

0.9 oz(6)

0.35 oz(6)

1.4 oz(4)

0.06 oz(4)

0.4 oz(3)

10 oz(3)

30.6 oz(3)

1.1 oz(3)

30.5 oz(3)

28 oz(3)

0.25 oz(3)

1.75 oz(3)

8 g(2)

22.6 oz(2)

32 oz(2)

7 g(2)

0.1 oz(2)

0.6 oz(2)

1.2 oz(2)

0.12 oz(2)

48 oz(2)

25.4 oz(2)

31.1 oz(2)

24.2 oz(2)

8 oz(2)

1.05 oz(2)

2 oz.(1)

1.25 oz(1)

45 oz(1)

31 oz(1)

34.5 oz(1)

2.25 oz(1)

29.3 oz(1)

5 lb(1)

0.33 oz(1)

36 oz(1)

16 oz(1)

2.2 lbs(1)

0.8 oz(1)

0.8(1)

9 g(1)

33.9 oz(1)

 
Roast Type

Medium(120)

Dark(87)

Light(36)

Dark Roast(3)

Medium Roast(1)

 
 
 

© 2019-2020 Meadows Office Supply, All Rights Reserved