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_27` 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(62)

Folgers(51)

Starbucks(25)

Peet's Coffee & Tea(17)

Lavazza(17)

1850(16)

Day to Day Coffee(15)

Caribou Coffee(13)

Café Bustelo(13)

NESCAFÉ Dolce Gusto(11)

Tully's Coffee(11)

Maxwell House(10)

PapaNicholas Coffee(10)

Eight O'Clock(8)

Melitta(8)

Java One(7)

Distant Lands Coffee(6)

Nescafé(6)

Dunkin Donuts(5)

Seattle's Best(5)

The Original Donut Shop(5)

New England Coffee(5)

Diedrich Coffee(5)

Donut House(4)

Barista Prima Coffeehouse(4)

Café Escapes(4)

McCafe(4)

Yuban(3)

Gevalia(3)

Gloria Jean's(3)

Newman's Own Organics(3)

National Coffee Roasters(3)

Krispy Kreme Doughnuts(2)

Hills Bros.(2)

BUSTELO cool(2)

revv(2)

Kahlúa(1)

Cinnabon(1)

Office Snax(1)

Chock full o'Nuts(1)

Chase & Sanborn(1)

Peet's(1)

 
Quantity

24 per box(20)

42 per carton(6)

22 per box(4)

36 per carton(4)

96 per carton(2)

40 per box(2)

24 per carton(1)

12 per pack(1)

24 per box.(1)

1 each(1)

42 per box(1)

18 per carton(1)

 
Packing Type

K-Cup(147)

Fraction Pack(50)

Bag(49)

Pod(29)

Packet(28)

Can(14)

Canister(13)

Capsule(10)

Filter Pack(8)

Stick(8)

Portion Pack(5)

Vacket Pack(3)

Cartridges(3)

Lavazza BLUE Capsule(2)

Jar(2)

Brick Pack(2)

Coffee Pod(1)

Capsules(1)

 
Flavor

French Roast(20)

Classic Roast(15)

Breakfast Blend(14)

House Blend(14)

Espresso(11)

Hazelnut(9)

French Vanilla(8)

Original(7)

Regular(7)

Assorted(6)

Pioneer Blend(5)

Original Blend(5)

Black Gold(5)

100% Colombian(5)

Dark Roast(5)

Black Silk(5)

Classic Roast Decaf(5)

Italian Roast(4)

Colombian(4)

Caffe Verona(4)

Veranda Blend(4)

Decaf House Blend(4)

Medium Roast(4)

Major Dickason's Blend(4)

Decaffeinated(4)

Hazelnut Creme(4)

Breakfast Blend Decaf(4)

Morning Blend(3)

Vermont Country Blend Decaf(3)

Vermont Country Blend(3)

Daybreak Morning Blend(3)

Pike Place(3)

Caribou Blend(3)

Nantucket Blend(3)

Pike Place Decaf(3)

Lantern Glow(3)

Morning Edition(2)

Caramel Macchiato(2)

Single Origin Colombian Select(2)

Latte Macchiato(2)

Donut House(2)

Café Domingo Blend(2)

Our Blend(2)

Hawaiian Blend(2)

Donut Shop Regular(2)

Caramel Vanilla Cream(2)

Southern Pecan(2)

Blonde Espresso Roast(2)

Wild Mountain Blueberry(2)

Mocha(2)

Dark and Bold(2)

Dark and Intense(2)

Mahogany(2)

Caribou Blend Decaf(2)

Half-Caff(2)

Donut House Decaf(2)

French Vanilla Decaf(2)

Colombian Decaf(2)

Lake & Lodge(2)

Colombian Supremo(2)

Dark Magic Decaf Extra Bold(2)

Hazelnut Cream(2)

Trailblazer(2)

French Roast Decaf(2)

House Blend Decaf(2)

Half Caff(2)

Hawaiian Islands Blend(2)

Organic Sumatran Extra Bold(2)

Dark Magic Extra Bold(2)

Double Black Diamond Extra Bold(2)

Special Blend Extra Bold(2)

Special Roast(2)

Espresso Decaf(2)

Simply Smooth(2)

FT Vanilla(1)

Light and Aromatic(1)

Costa Rican La Sonrisa(1)

Veranda Blend Blonde Roast(1)

Gold Selection(1)

Decaffeinated French Roast(1)

Sumatra(1)

100% Arabica Blend Decaf(1)

Decaf Pike Place Roast(1)

Pike Place Roast(1)

Aroma Club 100% Arabica Blend(1)

Crema Aroma Arabica/Robusta(1)

6th Avenue Bistro(1)

Special Delivery(1)

Sumatra Mandheling(1)

Special House Blend(1)

Decaffeinated Medium Roast(1)

Veranda(1)

Cappuccino(1)

Original Roast Decaf(1)

French Dark Roast(1)

Decaf Portside Blend(1)

Pier 70 Blend(1)

Eye Opener(1)

Lungo Decaf(1)

Portside Blend(1)

Parisian Café (Dark Roast)(1)

Colombia Medium(1)

Breakfast Blend (Light Roast)(1)

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

Kona Blend(1)

Love at First Sip (Medium Roast)(1)

Buzzworthy (Dark Roast)(1)

Parisian Vanilla(1)

Rotondo/Dark Roast(1)

Colombian Blend(1)

Decaf Italian Roast(1)

Colombian De Jardin(1)

100% Colombian Decaf(1)

Dark Royal(1)

Original Roast(1)

Signature Blend(1)

Special Decaf(1)

Extra Bold Breakfast Blend(1)

Dunkin' Dark(1)

Dunkin' Decaf(1)

Lively Colombian Decaf(1)

Morning Café(1)

Traditional Roast(1)

Gran Aroma(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)

Donut Shop Decaf(1)

Butter Toffee(1)

Decaf Caribou Blend(1)

Perfetto(1)

Classic(1)

Kahlúa Original(1)

Rio Blend(1)

Premium Roast Decaf(1)

Premium Roast(1)

Peppermint Bark(1)

Dark Magic(1)

Caramel Hideaway(1)

NO SURRENDER(1)

Caramel(1)

Cafe Vanilla(1)

Pumpkin Spice(1)

Morning Edition Decaf(1)

Classic Decaf(1)

TURBOCHARGER(1)

Island Coconut(1)

Caramel Drizzle(1)

Vanilla Biscotti(1)

Lively Colombian(1)

Colombia(1)

Decaf Original(1)

Cinnamon Roll(1)

Coconut Mocha(1)

Holiday Blend(1)

Regular Roast(1)

 
Beverage Type

Coffee(313)

Decaffeinated Coffee(49)

Instant Coffee(6)

Half-caffeinated Coffee(4)

Coffee Drink(2)

Instant Decaffeinated Coffee(1)

 
Manufacturer Part Number

008710(1)

0470(1)

3451(1)

3446(1)

3445(1)

3427(1)

3425(1)

2709(1)

1450(1)

0603(1)

0460(1)

4202(1)

705024(1)

70500(1)

70400(1)

60000(1)

40300(1)

39930404021(1)

39930274021(1)

308042(1)

30800(1)

3454(1)

4483(1)

30220(1)

04648CT(1)

026260(1)

026190(1)

026160(1)

866350(1)

866150(1)

862400(1)

390390(1)

04658(1)

04648PLT(1)

04648(1)

910(1)

75424(1)

75421(1)

75416(1)

75415(1)

75413(1)

75412(1)

75411(1)

75410(1)

953(1)

302742(1)

302142(1)

026530(1)

6803(1)

6992CT(1)

6992(1)

6990CT(1)

6990(1)

6873(1)

6813(1)

6812(1)

6803CT(1)

6792CT(1)

6994CT(1)

6792(1)

6783CT(1)

6783(1)

6772CT(1)

6772(1)

6758(1)

6746(1)

6745(1)

6744(1)

6994(1)

6995(1)

30200(1)

7522CT(1)

PB1141(1)

7792CT(1)

7792(1)

7732CT(1)

7732(1)

7602CT(1)

7602(1)

7534CT(1)

7534(1)

7522(1)

6995CT(1)

7468(1)

7467(1)

7466(1)

7465(1)

7428(1)

7134(1)

6999CT(1)

6999(1)

6996(1)

026480(1)

15782(1)

6743(1)

504918(1)

11017854(1)

11015640(1)

11008131(1)

11008130(1)

011111161(1)

011111160(1)

011111159(1)

011111156(1)

504917(1)

11017871(1)

504916(1)

504915(1)

504914(1)

504913(1)

504874(1)

501677(1)

501619(1)

501546(1)

501487(1)

11017860EA(1)

11018131(1)

500350(1)

11028473(1)

863070(1)

04707(1)

11008560(1)

11008558(1)

11008556(1)

11008554(1)

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

500705(1)

39003(1)

15782CT(1)

94245BX(1)

01101(1)

01096(1)

01027(1)

00058(1)

94333BX(1)

94333(1)

94273BX(1)

94273(1)

94245(1)

21001(1)

94142BX(1)

94142(1)

86073(1)

77317(1)

66488CT(1)

66488(1)

32486(1)

27376(1)

27329(1)

33000(1)

22002(1)

39002(1)

25186(1)

39001(1)

39000(1)

33750(1)

33700(1)

33300(1)

32006(1)

32003(1)

25188(1)

25187(1)

25185(1)

22005(1)

25184(1)

25183(1)

25182(1)

25181(1)

23005(1)

23004(1)

23003(1)

23002(1)

23001(1)

6743CT(1)

6732CT(1)

008711(1)

20540CT(1)

60513(1)

52320(1)

21513(1)

21512(1)

21511(1)

21510(1)

20672(1)

20630(1)

20540(1)

60514(1)

20527CT(1)

20527(1)

20513CT(1)

20513(1)

20421PL(1)

20421EA(1)

20421CT(1)

11545BX(1)

11545(1)

60513EA(1)

60514EA(1)

11544(1)

63101(1)

0847(1)

0846(1)

0845(1)

0570(1)

0448(1)

0162(1)

63104(1)

63103(1)

63102(1)

63100CT(1)

60515(1)

63100(1)

63006(1)

60518EA(1)

60518(1)

60517EA(1)

60517(1)

60516EA(1)

60516(1)

60515EA(1)

11544BX(1)

11248(1)

0849(1)

8599961590(1)

00374CT(1)

00055(1)

00050CT(1)

00050(1)

00019(1)

00016(1)

320840(1)

320820(1)

599961590(1)

00518X(1)

1099961590(1)

60224-101(1)

60052101CT(1)

60052-101(1)

60051-052(1)

60051-046(1)

60051-012(1)

008715(1)

008712(1)

00374EA(1)

01014(1)

10117(1)

06437(1)

10107(1)

06931(1)

06930(1)

06927(1)

06922(1)

06898(1)

06897(1)

06546(1)

06451(1)

06433(1)

01500(1)

06430(1)

06239(1)

06125(1)

06122(1)

06114(1)

0529C(1)

01720CT(1)

01720(1)

01501(1)

0848(1)

192419(1)

6732(1)

6523(1)

6547(1)

6546(1)

6545(1)

6544(1)

6543(1)

6534CT(1)

6534(1)

6523CT(1)

6520CT(1)

6570CT(1)

6520(1)

6503CT(1)

6503(1)

6502CT(1)

6502(1)

6501CT(1)

6501(1)

6425(1)

6408(1)

6570(1)

6602(1)

6406(1)

6663CT(1)

6728(1)

6720(1)

6700CT(1)

6700(1)

6694CT(1)

6694(1)

6685CT(1)

6685(1)

6680(1)

6663(1)

6602CT(1)

6662(1)

6661(1)

6659(1)

6624(1)

6614(1)

6613(1)

6611(1)

6606CT(1)

6606(1)

6407(1)

6405CT(1)

192419CT(1)

4060(1)

4432(1)

4162(1)

4067CT(1)

4067(1)

4066CT(1)

4066(1)

4061CT(1)

4061(1)

4060CT(1)

4051(1)

4461(1)

4050CT(1)

4050(1)

193019(1)

192919(1)

192719CT(1)

192719(1)

192619CT(1)

192619(1)

192519(1)

4441(1)

4493(1)

6405(1)

6002(1)

6305(1)

6248(1)

6204(1)

6111(1)

6110(1)

6107(1)

6106(1)

6003CT(1)

6003(1)

6000(1)

4732(1)

5531(1)

5493(1)

5470(1)

5469(1)

5305(1)

5304(1)

5303(1)

5161(1)

4792(1)

866550(1)

 
Country of Origin

US(335)

IT(15)

CA(13)

GB(10)

CO(1)

ES(1)

United States(1)

 
For Use With

Keurig K-Cup System(117)

Keurig Brewing System(27)

Commercial Coffee Brewers(27)

Drip Coffee Brewers(14)

Pod Brewers(9)

Dolce Gusto Coffee Machine(8)

Single Cup Brewers(7)

Standard Coffee Brewers(5)

Single Cup Brewers Hamilton, Bunn and Newco(4)

Coffee Brewer(3)

Grinder; Coffee Brewer(3)

NESCAFÉ Dolce Gusto Machines(3)

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

Standard and Commercial Coffee Makers(2)

LavAzza Espresso Point Machine(2)

Lavazza 2312(2)

Any traditional coffee maker(1)

Pod Espresso Brewer(1)

LavAzza Espresso Point Machine (sold separately)(1)

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

1.5 oz(17)

0.3 oz(15)

2 oz(14)

12 oz(12)

2.2 oz(9)

0.9 oz(6)

0.35 oz(6)

0.06 oz(4)

1.4 oz(4)

30.5 oz(3)

2.2 lb(3)

8 oz(3)

30.6 oz(3)

1.1 oz(3)

10 oz(3)

0.25 oz(3)

28 oz(3)

1.75 oz(3)

0.4 oz(3)

1.2 oz(2)

0.1 oz(2)

32 oz(2)

0.12 oz(2)

22.6 oz(2)

31.1 oz(2)

1.05 oz(2)

2.5 lbs(2)

24.2 oz(2)

25.4 oz(2)

7 g(2)

2 oz.(1)

0.6 oz(1)

0.8 oz(1)

0.8(1)

16 oz(1)

34.5 oz(1)

33.9 oz(1)

18 oz(1)

48 oz(1)

29.3 oz(1)

9 g(1)

8 g(1)

2.2 lbs(1)

36 oz(1)

2.25 oz(1)

31 oz(1)

 
Coffee Type

Regular(1)

 
Roast Type

Medium(100)

Dark(80)

Light(39)

Dark Roast(4)

Medium Roast(1)

 
Coffee Weight

16 oz(1)

 
Product Type

Coffee(1)

 
Packaged Quantity

1 Each(1)

 
Flavor/Blend

Cafe Domingo(1)

 
Coffee Roast Level

Medium(1)

 
 
 

© 2020-2021 Hi Tech Office Products, All Rights Reserved