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

Folgers(52)

Starbucks(37)

Peet's Coffee & Tea(19)

1850(16)

Tully's Coffee(16)

Day to Day Coffee(15)

Lavazza(15)

Caribou Coffee(14)

Café Bustelo(13)

Maxwell House(12)

The Original Donut Shop(10)

PapaNicholas Coffee(10)

New England Coffee(9)

Eight O'Clock(9)

Java One(9)

Dunkin Donuts(9)

Melitta(8)

Nescafé(6)

Gloria Jean's(6)

Distant Lands Coffee(6)

Donut House(6)

Diedrich Coffee(6)

Newman's Own Organics(6)

Barista Prima Coffeehouse(5)

NESCAFÉ Dolce Gusto(5)

Starbucks®(5)

Seattle's Best(5)

Café Escapes(4)

McCafe(4)

Coffee People(4)

Gevalia(4)

Hills Bros.(3)

revv(3)

Kahlúa(3)

Emeril's(3)

Laughing Man Coffee Company(3)

Panera Bread at HOME(3)

Krispy Kreme Doughnuts(3)

Tim Hortons(3)

National Coffee Roasters(3)

Yuban(3)

illy(2)

Chase & Sanborn(2)

BUSTELO cool(2)

Green Mountain Coffee Roasters®(1)

Dunkin' Donuts®(1)

Chock full o'Nuts(1)

Cinnabon(1)

 
Quantity

24 per box(4)

42 per carton(4)

36 per carton(4)

40 per box(2)

24 per carton(1)

12 per pack(1)

96 per carton(1)

42 per box(1)

18 per carton(1)

8 per box(1)

 
Packing Type

K-Cup(223)

Bag(55)

Fraction Pack(50)

Pod(31)

Packet(31)

Can(14)

Canister(13)

Stick(9)

Filter Pack(8)

Capsule(5)

Portion Pack(5)

K-Cup®(5)

Cartridges(3)

Lavazza BLUE Capsule(3)

Vacket Pack(3)

Jar(2)

Brick Pack(2)

Coffee Pod(1)

 
Flavor

French Roast(26)

Breakfast Blend(20)

House Blend(17)

Classic Roast(15)

Hazelnut(12)

French Vanilla(11)

Espresso(11)

Dark Roast(8)

Regular(8)

Original(7)

Original Blend(7)

Assorted(6)

Medium Roast(6)

Hazelnut Creme(6)

100% Colombian(6)

Colombian(5)

Pike Place Decaf(5)

Pioneer Blend(5)

Black Gold(5)

Decaffeinated(5)

Breakfast Blend Decaf(5)

Pike Place(5)

Classic Roast Decaf(5)

Caffe Verona(5)

Black Silk(5)

House Blend Decaf(5)

Major Dickason's Blend(4)

Decaf House Blend(4)

Italian Roast(4)

Morning Blend(4)

Veranda Blend(3)

Caribou Blend(3)

Vermont Country Blend(3)

Nantucket Blend(3)

Vermont Country Blend Decaf(3)

Caramel(3)

Daybreak Morning Blend(3)

Dark Magic(3)

Kahlúa Original(3)

Colombian Decaf(3)

Pumpkin Spice(3)

Colombian Supremo(3)

Mocha(3)

Decaf(3)

Donut Shop Regular(3)

Lantern Glow(3)

Chocolate Glazed Donut(2)

Lake & Lodge(2)

Café Domingo Blend(2)

Our Blend(2)

Hawaiian Blend(2)

Colombia(2)

Donut Shop(2)

Caramel Vanilla Cream(2)

Island Coconut(2)

Southern Pecan(2)

Morning Edition(2)

Hawaiian Islands Blend(2)

Wild Mountain Blueberry(2)

Mahogany(2)

Caribou Blend Decaf(2)

Half-Caff(2)

Vanilla Hazelnut(2)

Butter Toffee(2)

Donut House Decaf(2)

Sumatra(2)

Big Easy Bold(2)

French Vanilla Decaf(2)

Single Origin Colombian Select(2)

Donut House(2)

Trailblazer(2)

Simply Smooth(2)

Half Caff(2)

Dark Magic Decaf Extra Bold(2)

Special Roast(2)

French Roast Decaf(2)

Double Black Diamond Extra Bold(2)

Dark Magic Extra Bold(2)

Organic Sumatran Extra Bold(2)

Special Decaf(2)

Hazelnut Cream(2)

Special Blend Extra Bold(2)

Espresso Decaf(2)

Veranda Blend Blonde Roast(1)

100% Arabica Blend Decaf(1)

Caffe Verona®(1)

Decaffeinated Medium Roast(1)

Columbia(1)

Rotondo/Dark Roast(1)

Special House Blend(1)

Aroma Club 100% Arabica Blend(1)

Crema Aroma Arabica/Robusta(1)

Sumatra Mandheling(1)

Veranda(1)

Sumatran(1)

Colombia Medium(1)

Costa Rican La Sonrisa(1)

Colombian De Jardin(1)

Estate Costa Rican(1)

Special Delivery(1)

Pike Place Roast(1)

Kenya Highlands(1)

Dukale's Blend(1)

Crema Dolce/Medium Roast(1)

Love at First Sip (Medium Roast)(1)

FT Vanilla(1)

Eye Opener(1)

Portside Blend(1)

Kona Blend(1)

Colombian Blend(1)

Pier 70 Blend(1)

Vanilla Latte Macchiato(1)

6th Avenue Bistro(1)

Chococino(1)

Cappuccino(1)

Lungo Decaf(1)

Decaf Portside Blend(1)

Emeril's Big Easy Bold(1)

Parisian Vanilla(1)

Decaf Pike Place Roast(1)

French Dark Roast(1)

Sumatra Reserve(1)

Veranda Blend™(1)

Original Roast Decaf(1)

Parisian Café (Dark Roast)(1)

Breakfast Blend (Light Roast)(1)

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

Decaffeinated French Roast(1)

Buzzworthy (Dark Roast)(1)

Colombia Huila(1)

Vanilla Biscotti(1)

Costa Rica Paraiso(1)

Morning Café(1)

Perfetto(1)

Signature Blend Decaf(1)

Dark Royal(1)

Original Roast(1)

Signature Blend(1)

Colombia Select(1)

Extra Bold Breakfast Blend(1)

Caramel Coffee Cake(1)

Dunkin' Dark(1)

Dunkin' Decaf(1)

Lively Colombian Decaf(1)

Donut Shop Blend(1)

Classic(1)

100% Colombian Decaf(1)

Traditional Roast(1)

Pioneer Blend Decaf(1)

Country Roast(1)

Decaf Classic(1)

Gourmet Supreme(1)

Café con Leche Chocolate(1)

Café con Leche(1)

Medium Decaf(1)

Vanilla(1)

Decaf Caribou Blend(1)

Gran Aroma(1)

Classic Decaf(1)

Columbia Select Single Origin(1)

Bold 1937(1)

Special Blend(1)

Dark(1)

Colombian Huila(1)

Light Roast(1)

Dark Blend(1)

Round the Clock Blend(1)

Cinnamon(1)

Premium Roast Decaf(1)

Premium Roast(1)

Peppermint Bark(1)

Caramel Hideaway(1)

NO SURRENDER(1)

Holiday Blend(1)

Cafe Vanilla(1)

Rio Blend(1)

Morning Edition Decaf(1)

TURBOCHARGER(1)

AFTERBURNER(1)

Caramel Drizzle(1)

Big Bang(1)

Lively Colombian(1)

Brazil Minas Naturais(1)

Original Decaf(1)

Cinnamon Roll(1)

Coconut Mocha(1)

Regular Roast(1)

 
Beverage Type

Coffee(379)

Decaffeinated Coffee(68)

Instant Coffee(6)

Half-caffeinated Coffee(4)

Latte(2)

Coffee Drink(2)

Instant Decaffeinated Coffee(1)

Hot Chocolate(1)

 
Manufacturer Part Number

008710(1)

8784(1)

30400(1)

302742(1)

30220(1)

302142(1)

30210(1)

30200(1)

PB4141CT(1)

PB4141(1)

PB1141(1)

PB1036CT(1)

PB1036(1)

8338(1)

308042(1)

8337(1)

8287(1)

8087(1)

8007(1)

7999(1)

7996(1)

7995(1)

7994(1)

7993(1)

7792CT(1)

7792(1)

7791(1)

30800(1)

39930274021(1)

7746(1)

953(1)

04648CT(1)

04648(1)

75424(1)

75421(1)

75416(1)

75415(1)

75413(1)

75412(1)

75411(1)

75410(1)

970(1)

910(1)

39930404021(1)

4483(1)

4202(1)

2709(1)

1450(1)

0603(1)

0470(1)

0460(1)

705024(1)

70500(1)

70400(1)

60000(1)

40300(1)

7790(1)

7732CT(1)

04658(1)

6994(1)

7428(1)

7139(1)

7134(1)

7120(1)

7000(1)

6999CT(1)

6999(1)

6996(1)

6995CT(1)

6995(1)

6994CT(1)

6992CT(1)

7466(1)

6992(1)

6990CT(1)

6990(1)

6974(1)

6873(1)

6813(1)

6812(1)

6803CT(1)

6803(1)

6792CT(1)

6792(1)

6783CT(1)

7465(1)

7467(1)

7732(1)

7594(1)

7677(1)

7674(1)

7615(1)

7614(1)

7608(1)

7607(1)

7605(1)

7602CT(1)

7602(1)

7596(1)

7595(1)

7586(1)

7468(1)

7585(1)

7573(1)

7571(1)

7569(1)

7568(1)

7567(1)

7564(1)

7563(1)

7534CT(1)

7534(1)

7522CT(1)

7522(1)

04648PLT(1)

390390(1)

6772CT(1)

011111158CT(1)

11017854(1)

11015640(1)

11008131(1)

11008130(1)

011111162(1)

011111161CT(1)

011111161(1)

011111160CT(1)

011111160(1)

011111159CT(1)

011111159(1)

011111158(1)

11017871(1)

011111157CT(1)

011111157(1)

011111156CT(1)

011111156(1)

011068092(1)

011067987(1)

011067986(1)

011067985(1)

011067983(1)

504918(1)

504917(1)

504916(1)

11017860EA(1)

11018131(1)

504914(1)

11029358(1)

863070(1)

04707(1)

PB4137(1)

1261330(1)

11008560(1)

11008558(1)

11008556(1)

11008554(1)

1092836(1)

11075823(1)

11075822(1)

11028510(1)

11018185(1)

11028473(1)

11023061(1)

11020676(1)

11019881(1)

11019631(1)

11018197(1)

11018194(1)

11018193(1)

11018192(1)

11018190(1)

11018187(1)

11018186(1)

504915(1)

504913(1)

862400(1)

66488CT(1)

21001(1)

33000(1)

32410(1)

01101(1)

01096(1)

01084(1)

01027(1)

87066(1)

86073(1)

77317(1)

69749(1)

66488(1)

22005(1)

32486(1)

27376(1)

27329(1)

15782CT(1)

15782(1)

026530(1)

026480(1)

026260(1)

026190(1)

026160(1)

866350(1)

866150(1)

22002(1)

23001(1)

501677(1)

33300(1)

501619(1)

501546(1)

501487(1)

500705(1)

500689(1)

500350(1)

39003(1)

39002(1)

39001(1)

39000(1)

33750(1)

33700(1)

32006(1)

23002(1)

32003(1)

25188(1)

25187(1)

25186(1)

25185(1)

25184(1)

25183(1)

25182(1)

25181(1)

23005(1)

23004(1)

23003(1)

6783(1)

6772(1)

008711(1)

52320(1)

60518(1)

60517EA(1)

60517(1)

60516EA(1)

60516(1)

60515EA(1)

60515(1)

60514EA(1)

60514(1)

60513EA(1)

60513(1)

21513(1)

63006(1)

21512(1)

21511(1)

21510(1)

20672(1)

20630(1)

20540CT(1)

20540(1)

20527CT(1)

20527(1)

20513CT(1)

20513(1)

20421PL(1)

60518EA(1)

63100(1)

20421CT(1)

0847(1)

192619(1)

192519CT(1)

192519(1)

192419CT(1)

192419(1)

1281(1)

1280(1)

1279(1)

0995(1)

0849(1)

0848(1)

0846(1)

63100CT(1)

0845(1)

0570(1)

0448(1)

0162(1)

0040(1)

0038(1)

0037(1)

0036(1)

63104(1)

63103(1)

63102(1)

63101(1)

20421EA(1)

11545BX(1)

192719(1)

8177(1)

00055(1)

00050CT(1)

00050(1)

00019(1)

00016(1)

320840(1)

320820(1)

8599961590(1)

599961590(1)

1099961590(1)

8179(1)

7401BX(1)

00374EA(1)

7401(1)

60224-101(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)

11545(1)

06546(1)

11544BX(1)

11544(1)

11248(1)

10117(1)

10107(1)

06931(1)

06930(1)

06927(1)

06922(1)

06898(1)

06897(1)

06547(1)

06451(1)

01014(1)

06437(1)

06433(1)

06430(1)

06239(1)

06125(1)

06122(1)

06114(1)

0529C(1)

01720CT(1)

01720(1)

01501(1)

01500(1)

192619CT(1)

192719CT(1)

6758CT(1)

6545(1)

6612(1)

6611CT(1)

6611(1)

6606CT(1)

6606(1)

6602CT(1)

6602(1)

6570CT(1)

6570(1)

6547(1)

6546(1)

6544(1)

6613CT(1)

6543(1)

6542(1)

6534CT(1)

6534(1)

6523CT(1)

6523(1)

6520CT(1)

6520(1)

6503CT(1)

6503(1)

6502CT(1)

6502(1)

6613(1)

6659(1)

6501(1)

6722(1)

6758(1)

6746(1)

6745(1)

6744(1)

6743CT(1)

6743(1)

6732CT(1)

6732(1)

6728(1)

6727(1)

6722CT(1)

6720CT(1)

6661(1)

6720(1)

6700CT(1)

6700(1)

6694CT(1)

6694(1)

6685CT(1)

6685(1)

6680(1)

6664(1)

6663CT(1)

6663(1)

6662(1)

6501CT(1)

6425(1)

192919(1)

4067(1)

5161(1)

4792(1)

4757(1)

4732(1)

4493(1)

4461(1)

4441(1)

4432(1)

4162(1)

4092(1)

4067CT(1)

4066CT(1)

5304(1)

4066(1)

4061CT(1)

4061(1)

4060CT(1)

4060(1)

4051CT(1)

4051(1)

4050CT(1)

4050(1)

193019CT(1)

193019(1)

192919CT(1)

5303(1)

5305(1)

6408(1)

6110(1)

6407(1)

6406CT(1)

6406(1)

6405CT(1)

6405(1)

6378(1)

6377(1)

6376(1)

6305(1)

6248(1)

6204(1)

6111(1)

6107(1)

5339(1)

6106(1)

6006(1)

6003CT(1)

6003(1)

6002(1)

6001(1)

6000(1)

5531(1)

5493(1)

5471(1)

5470(1)

5469(1)

866550(1)

 
Country of Origin

US(390)

CA(57)

IT(10)

GB(4)

AX(1)

United States(1)

ES(1)

 
Weight (Approximate)

11.90 oz(1)

 
For Use With

Keurig K-Cup System(219)

Commercial Coffee Brewers(27)

Drip Coffee Brewers(14)

Pod Brewers(9)

Single Cup Brewers(9)

Standard Coffee Brewers(7)

Keurig® K-Cup® System(5)

NESCAFÉ Dolce Gusto Machines(5)

Single Cup Brewers Hamilton, Bunn and Newco(4)

Keurig Brewing System(4)

Lavazza 2312 BLUE Machine(3)

Standard and Commercial Coffee Makers(2)

LavAzza Espresso Point Machine(2)

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

Any traditional coffee maker(1)

Pod Espresso Brewer(1)

LavAzza Espresso Point Machine (sold separately)(1)

 
Capacity (Volume)

0.38 oz(4)

8 oz(2)

10 oz(2)

48 oz(1)

25.1 oz(1)

0(1)

 
Capacity (Weight)

2.5 oz(34)

1 lb(19)

0.3 oz(17)

1.5 oz(17)

2 oz(14)

12 oz(12)

2.2 oz(11)

18 oz(9)

0.4 oz(7)

0.9 oz(6)

0.35 oz(6)

1.4 oz(4)

0.06 oz(4)

1.1 oz(3)

30.6 oz(3)

1.75 oz(3)

0.25 oz(3)

28 oz(3)

0.12 oz(3)

10 oz(3)

30.5 oz(3)

0.31 oz(2)

1.2 oz(2)

8 g(2)

0.1 oz(2)

32 oz(2)

2.5 lbs(2)

24.2 oz(2)

25.4 oz(2)

31.1 oz(2)

7 g(2)

1.05 oz(2)

22.6 oz(2)

8 oz(2)

0.6 oz(2)

0.33 oz(1)

34.5 oz(1)

45 oz(1)

2 oz.(1)

36 oz(1)

48 oz(1)

0.8(1)

1.25 oz(1)

2.25 oz(1)

0.8 oz(1)

16 oz(1)

29.3 oz(1)

9 g(1)

2.2 lbs(1)

31 oz(1)

 
Serve Type

K-Cup(3)

 
Coffee Type

Caffeinated(2)

 
Roast Type

Medium(138)

Dark(104)

Light(52)

Dark Roast(3)

Medium Roast(1)

 
Compatible Brewer

K-Cup Brewer(2)

 
Product Type

Coffee(3)

 
Packaged Quantity

24 / Box(3)

 
Flavor/Blend

Pumpkin Spice(1)

Nutmeg(1)

Cinnamon(1)

Arabica(1)

Buttery Pecan(1)

Maple(1)

Sumatra(1)

 
Coffee Roast Level

Medium(1)

Light(1)

Dark(1)

 
 
 

© 2020-2021 Office Industries Corporation, All Rights Reserved