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_19` 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(71)

Folgers(49)

Starbucks(34)

Peet's Coffee & Tea(18)

Tully's Coffee(14)

Lavazza(14)

1850(14)

Maxwell House(11)

Caribou Coffee(10)

Dunkin Donuts(9)

PapaNicholas Coffee(9)

Eight O'Clock(9)

New England Coffee(8)

Day to Day Coffee(8)

The Original Donut Shop(8)

Melitta(8)

Café Bustelo(7)

Java One(7)

Donut House(6)

Gloria Jean's(6)

Nescafé(6)

Newman's Own Organics(6)

Barista Prima Coffeehouse(5)

Diedrich Coffee(5)

Coffee People(4)

McCafe(4)

Gevalia(4)

Café Escapes(4)

NESCAFÉ Dolce Gusto(4)

Seattle's Best(4)

Distant Lands Coffee(3)

revv(3)

Krispy Kreme Doughnuts(3)

Panera Bread at HOME(3)

Yuban(3)

Emeril's(2)

Kahlúa(2)

Laughing Man Coffee Company(2)

illy(2)

Tim Hortons(2)

National Coffee Roasters(2)

Cinnabon(1)

Chock full o'Nuts(1)

Chase & Sanborn(1)

Green Mountain Coffee®(1)

Starbucks®(1)

BUSTELO cool(1)

 
Quantity

24 per box(1)

96 per carton(1)

 
Packing Type

K-Cup(214)

Fraction Pack(43)

Bag(36)

Pod(24)

Packet(22)

Can(12)

Canister(11)

Filter Pack(8)

Stick(8)

Portion Pack(4)

Capsule(4)

Cartridges(3)

Vacket Pack(3)

K-Cup®(2)

Lavazza BLUE Capsule(2)

Brick Pack(2)

Jar(1)

 
Flavor

French Roast(22)

Breakfast Blend(17)

House Blend(16)

Classic Roast(14)

Hazelnut(11)

French Vanilla(10)

Espresso(7)

Regular(7)

Hazelnut Creme(6)

Assorted(6)

100% Colombian(6)

Medium Roast(6)

Original(6)

Black Silk(5)

Classic Roast Decaf(5)

Dark Roast(5)

Colombian(5)

Caffe Verona(5)

Original Blend(4)

Pike Place(4)

Italian Roast(4)

House Blend Decaf(4)

Major Dickason's Blend(4)

Decaffeinated(4)

Pioneer Blend(4)

Black Gold(4)

Pike Place Decaf(4)

Pumpkin Spice(3)

Veranda Blend(3)

Vermont Country Blend Decaf(3)

Decaf House Blend(3)

Nantucket Blend(3)

Breakfast Blend Decaf(3)

Donut Shop Regular(3)

Vermont Country Blend(3)

Lantern Glow(3)

Mocha(3)

Wild Mountain Blueberry(2)

Hawaiian Blend(2)

Caramel Vanilla Cream(2)

Morning Edition(2)

Caribou Blend Decaf(2)

Colombia(2)

Caribou Blend(2)

Daybreak Morning Blend(2)

Our Blend(2)

Southern Pecan(2)

Café Domingo Blend(2)

Lake & Lodge(2)

Hawaiian Islands Blend(2)

Mahogany(2)

Single Origin Colombian Select(2)

Donut House(2)

Butter Toffee(2)

Dark Magic Decaf Extra Bold(2)

Kahlúa Original(2)

Decaf(2)

French Vanilla Decaf(2)

Special Roast(2)

Simply Smooth(2)

Half Caff(2)

Donut House Decaf(2)

Trailblazer(2)

Big Easy Bold(2)

Morning Blend(2)

Double Black Diamond Extra Bold(2)

Colombian Supremo(2)

Hazelnut Cream(2)

French Roast Decaf(2)

Dark Magic Extra Bold(2)

Organic Sumatran Extra Bold(2)

Special Decaf(2)

Chocolate Glazed Donut(2)

Special Blend Extra Bold(2)

Half-Caff(2)

Vanilla Hazelnut(2)

Island Coconut(2)

Crema Dolce/Medium Roast(1)

Kenya Highlands(1)

Aroma Club 100% Arabica Blend(1)

Sumatra Mandheling(1)

Crema Aroma Arabica/Robusta(1)

Dukale's Blend(1)

Colombia Huila(1)

Parisian Vanilla(1)

Sumatra Reserve(1)

Rotondo/Dark Roast(1)

Buzzworthy (Dark Roast)(1)

100% Arabica Blend Decaf(1)

Caffe Verona®(1)

Love at First Sip (Medium Roast)(1)

Columbia Select Single Origin(1)

Special Delivery(1)

6th Avenue Bistro(1)

Portside Blend(1)

Pier 70 Blend(1)

Decaf Portside Blend(1)

Veranda Blend Blonde Roast(1)

Veranda(1)

Pike Place Roast(1)

Decaf Pike Place Roast(1)

Colombia Medium(1)

Sumatran(1)

Sumatra(1)

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

Decaffeinated French Roast(1)

Special House Blend(1)

Kona Blend(1)

Colombian Blend(1)

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

Costa Rica Paraiso(1)

Big Bang(1)

Dark Magic(1)

Dunkin' Decaf(1)

Perfetto(1)

Toasted Marshmallow Mocha(1)

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

Gourmet Supreme(1)

Café con Leche(1)

Vanilla(1)

Donut Shop(1)

Gran Aroma(1)

Classic Decaf(1)

Special Blend(1)

Caramel(1)

Dark(1)

Light Roast(1)

Dark Blend(1)

Round the Clock Blend(1)

Cinnamon(1)

Premium Roast Decaf(1)

Premium Roast(1)

Caramel Hideaway(1)

Bold 1937(1)

NO SURRENDER(1)

Cafe Vanilla(1)

Holiday Blend(1)

Rio Blend(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)

Coconut Mocha(1)

Regular Roast(1)

 
Beverage Type

Coffee(331)

Decaffeinated Coffee(55)

Instant Coffee(6)

Half-caffeinated Coffee(4)

Latte(2)

Coffee Drink(1)

 
Manufacturer Part Number

60051-012(1)

7994(1)

8784(1)

8338(1)

8337(1)

8287(1)

8087(1)

8007(1)

7999(1)

7996(1)

7995(1)

7993(1)

PB1036CT(1)

7792CT(1)

7792(1)

7791(1)

7790(1)

7746(1)

7732CT(1)

7732(1)

7615(1)

7614(1)

7608(1)

PB1036(1)

PB1141(1)

7605(1)

0470(1)

75411(1)

75410(1)

970(1)

953(1)

4483(1)

4202(1)

2709(1)

1450(1)

0603(1)

0460(1)

PB4141CT(1)

705024(1)

70500(1)

70400(1)

60000(1)

40300(1)

308042(1)

30800(1)

302742(1)

30220(1)

30200(1)

7607(1)

7602CT(1)

75413(1)

6783CT(1)

6990(1)

6974(1)

6873(1)

6813(1)

6812(1)

6803CT(1)

6803(1)

6792CT(1)

6792(1)

6783(1)

6992(1)

6772CT(1)

6772(1)

6758CT(1)

6758(1)

6746(1)

6745(1)

6744(1)

6743CT(1)

6743(1)

6732CT(1)

6990CT(1)

6992CT(1)

7602(1)

7522(1)

7595(1)

7594(1)

7586(1)

7585(1)

7564(1)

7563(1)

7534CT(1)

7534(1)

7522CT(1)

7468(1)

6994(1)

7467(1)

7466(1)

7465(1)

7000(1)

6999CT(1)

6999(1)

6996(1)

6995CT(1)

6995(1)

6994CT(1)

75412(1)

75415(1)

6728(1)

011111159(1)

11015640(1)

11008131(1)

11008130(1)

011111162(1)

011111161CT(1)

011111161(1)

011111160CT(1)

011111160(1)

011111159CT(1)

011111158CT(1)

11017860EA(1)

011111158(1)

011111157CT(1)

011111157(1)

011111156CT(1)

011111156(1)

011067987(1)

504918(1)

504917(1)

504916(1)

504915(1)

11017854(1)

11017871(1)

504913(1)

11028473(1)

863070(1)

04707(1)

1261330(1)

11008560(1)

11008558(1)

11008556(1)

11008554(1)

11029358(1)

11028510(1)

11023061(1)

11018131(1)

11020676(1)

11019631(1)

11018197(1)

11018194(1)

11018193(1)

11018192(1)

11018190(1)

11018187(1)

11018186(1)

11018185(1)

504914(1)

501677(1)

75416(1)

026480(1)

77317(1)

66488CT(1)

66488(1)

32486(1)

27376(1)

27329(1)

15782CT(1)

15782(1)

026530(1)

026260(1)

87066(1)

026190(1)

866350(1)

866150(1)

862400(1)

390390(1)

04658(1)

04648CT(1)

04648(1)

75424(1)

75421(1)

86073(1)

01096(1)

501619(1)

25187(1)

501546(1)

501487(1)

500705(1)

500350(1)

33750(1)

33700(1)

32006(1)

32003(1)

25188(1)

25186(1)

33000(1)

25185(1)

25184(1)

25183(1)

25181(1)

23005(1)

23004(1)

23003(1)

23002(1)

23001(1)

21001(1)

6732(1)

6727(1)

60051012CT(1)

60515(1)

63101(1)

63100CT(1)

63100(1)

63006(1)

60518(1)

60517(1)

60516EA(1)

60516(1)

60515EA(1)

60514EA(1)

63103(1)

60514(1)

60513EA(1)

60513(1)

52320(1)

21513(1)

21512(1)

21511(1)

21510(1)

20672(1)

20540CT(1)

63102(1)

63104(1)

20527CT(1)

0995(1)

192719(1)

192619CT(1)

192619(1)

192519CT(1)

192519(1)

192419CT(1)

192419(1)

1281(1)

1279(1)

0849(1)

0036(1)

0848(1)

0847(1)

0846(1)

0845(1)

0570(1)

0448(1)

0162(1)

0040(1)

0038(1)

0037(1)

20540(1)

20527(1)

192919(1)

8599961590(1)

00518X(1)

00374EA(1)

00374CT(1)

00055(1)

00050(1)

00019(1)

00016(1)

320840(1)

320820(1)

599961590(1)

01500(1)

8179(1)

8177(1)

7401BX(1)

7401(1)

60052101CT(1)

60052-101(1)

60051052CT(1)

60051-052(1)

60051046CT(1)

60051-046(1)

01014(1)

01720(1)

20513CT(1)

06898(1)

20513(1)

20421EA(1)

20421CT(1)

10117(1)

10107(1)

06931(1)

06930(1)

06927(1)

06922(1)

06897(1)

01720CT(1)

06546(1)

06451(1)

06437(1)

06433(1)

06430(1)

06239(1)

06125(1)

06122(1)

06114(1)

0529C(1)

192719CT(1)

192919CT(1)

6722CT(1)

6534(1)

6570CT(1)

6570(1)

6547(1)

6546(1)

6545(1)

6544(1)

6543(1)

6542(1)

6534CT(1)

6523CT(1)

6602CT(1)

6523(1)

6520CT(1)

6520(1)

6503CT(1)

6503(1)

6502CT(1)

6502(1)

6501CT(1)

6501(1)

6425(1)

6602(1)

6606(1)

6407(1)

6680(1)

6722(1)

6720CT(1)

6720(1)

6700CT(1)

6700(1)

6694CT(1)

6694(1)

6685CT(1)

6685(1)

6664(1)

6606CT(1)

6663CT(1)

6663(1)

6662(1)

6661(1)

6659(1)

6613CT(1)

6613(1)

6612(1)

6611CT(1)

6611(1)

6408(1)

6406CT(1)

193019(1)

4067(1)

4792(1)

4757(1)

4732(1)

4493(1)

4461(1)

4441(1)

4432(1)

4162(1)

4067CT(1)

4066CT(1)

5303(1)

4066(1)

4061CT(1)

4061(1)

4060CT(1)

4060(1)

4051CT(1)

4051(1)

4050CT(1)

4050(1)

193019CT(1)

5161(1)

5304(1)

6406(1)

6006(1)

6405CT(1)

6405(1)

6305(1)

6248(1)

6204(1)

6111(1)

6110(1)

6107(1)

6106(1)

6003CT(1)

5305(1)

6003(1)

6002(1)

6001(1)

6000(1)

5807(1)

5531(1)

5471(1)

5470(1)

5469(1)

5339(1)

866550(1)

 
Country of Origin

US(344)

CA(42)

IT(9)

GB(3)

ES(1)

 
For Use With

Keurig K-Cup System(212)

Commercial Coffee Brewers(27)

Pod Brewers(8)

Drip Coffee Brewers(8)

Single Cup Brewers(7)

Standard Coffee Brewers(4)

NESCAFÉ Dolce Gusto Machines(4)

Keurig® K-Cup® System(2)

Keurig Brewing System(2)

LavAzza Espresso Point Machine(2)

Lavazza 2312 BLUE Machine(2)

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

Any traditional coffee maker(1)

Standard and Commercial Coffee Makers(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)

2.2 oz(10)

12 oz(10)

2 oz(9)

0.35 oz(6)

0.9 oz(6)

0.4 oz(5)

1.4 oz(4)

0.06 oz(4)

0.25 oz(3)

1.75 oz(3)

22.6 oz(2)

1.2 oz(2)

0.1 oz(2)

10 oz(2)

32 oz(2)

28 oz(2)

1.1 oz(2)

30.6 oz(2)

24.2 oz(2)

25.4 oz(2)

31.1 oz(2)

30.5 oz(2)

1.05 oz(2)

0.12 oz(2)

34.5 oz(1)

45 oz(1)

0.6 oz(1)

2.2 lbs(1)

29.3 oz(1)

8 g(1)

9 g(1)

7 g(1)

0.8 oz(1)

8 oz(1)

2.5 lbs(1)

36 oz(1)

48 oz(1)

16 oz(1)

0.8(1)

31 oz(1)

 
Roast Type

Medium(124)

Dark(89)

Light(44)

 
 
 

© 2020-2021 Office Industries Corporation, All Rights Reserved