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

Folgers(52)

Starbucks(33)

Lavazza(21)

Peet's Coffee & Tea(19)

Tully's Coffee(16)

1850(16)

Day to Day Coffee(15)

Caribou Coffee(14)

Café Bustelo(14)

Maxwell House(13)

NESCAFÉ Dolce Gusto(12)

Barista Prima Coffeehouse(11)

PapaNicholas Coffee(10)

The Original Donut Shop(10)

New England Coffee(9)

Eight O'Clock(9)

Melitta(8)

Dunkin Donuts(8)

Java One(7)

Nescafé(6)

Gloria Jean's(6)

Donut House(6)

Newman's Own Organics(6)

Diedrich Coffee(6)

Distant Lands Coffee(6)

Seattle's Best(5)

Café Escapes(4)

McCafe(4)

Gevalia(4)

Coffee People(4)

revv(3)

Yuban(3)

Krispy Kreme Doughnuts(3)

National Coffee Roasters(3)

Laughing Man Coffee Company(3)

Panera Bread at HOME(3)

Tim Hortons(3)

BUSTELO cool(2)

Emeril's(2)

Kahlúa(2)

illy(2)

Hills Bros.(2)

Chock full o'Nuts(1)

Chase & Sanborn(1)

Office Snax(1)

Cinnabon(1)

Peet's(1)

Dunkin' Donuts®(1)

 
Quantity

24 per box(6)

42 per carton(6)

36 per carton(4)

96 per carton(2)

40 per box(2)

22 per box(1)

24 per carton(1)

12 per pack(1)

1 each(1)

42 per box(1)

18 per carton(1)

 
Packing Type

K-Cup(230)

Bag(57)

Fraction Pack(52)

Pod(29)

Packet(29)

Can(14)

Canister(13)

Capsule(11)

Filter Pack(8)

Stick(8)

Portion Pack(5)

Lavazza BLUE Capsule(3)

Vacket Pack(3)

Cartridges(3)

Jar(2)

Brick Pack(2)

Coffee Pod(1)

Capsules(1)

 
Flavor

French Roast(25)

Breakfast Blend(19)

House Blend(17)

Classic Roast(15)

Hazelnut(12)

French Vanilla(11)

Espresso(11)

Italian Roast(8)

Dark Roast(8)

Original(7)

Regular(7)

Original Blend(6)

Assorted(6)

100% Colombian(6)

Medium Roast(6)

Hazelnut Creme(6)

House Blend Decaf(5)

Classic Roast Decaf(5)

Black Silk(5)

Colombian(5)

Caffe Verona(5)

Veranda Blend(5)

Pioneer Blend(5)

Black Gold(5)

Breakfast Blend Decaf(5)

Decaffeinated(5)

Pike Place(4)

Morning Blend(4)

Pike Place Decaf(4)

Decaf House Blend(4)

Major Dickason's Blend(4)

Vermont Country Blend(3)

Nantucket Blend(3)

Pumpkin Spice(3)

Colombian Supremo(3)

Daybreak Morning Blend(3)

Dark Magic(3)

Caribou Blend(3)

Vermont Country Blend Decaf(3)

Mocha(3)

Lantern Glow(3)

Donut Shop Regular(3)

Decaf(3)

Trailblazer(2)

Latte Macchiato(2)

Colombian Decaf(2)

Butter Toffee(2)

Vanilla Hazelnut(2)

Half-Caff(2)

Single Origin Colombian Select(2)

Caribou Blend Decaf(2)

Mahogany(2)

Caramel(2)

Dark and Intense(2)

Lake & Lodge(2)

Donut House(2)

Morning Edition(2)

Café Domingo Blend(2)

Wild Mountain Blueberry(2)

Our Blend(2)

Hawaiian Blend(2)

Colombia(2)

Decaf Italian Roast(2)

Southern Pecan(2)

Dark and Bold(2)

Caramel Vanilla Cream(2)

Island Coconut(2)

Brazil Minas Naturais(2)

Caramel Macchiato(2)

Chocolate Glazed Donut(2)

Simply Smooth(2)

Hawaiian Islands Blend(2)

Kahlúa Original(2)

French Roast Decaf(2)

Espresso Decaf(2)

Special Roast(2)

Blonde Espresso Roast(2)

Special Blend Extra Bold(2)

Special Decaf(2)

Half Caff(2)

Hazelnut Cream(2)

Organic Sumatran Extra Bold(2)

Dark Magic Extra Bold(2)

French Vanilla Decaf(2)

Double Black Diamond Extra Bold(2)

Dark Magic Decaf Extra Bold(2)

Sumatra(2)

Donut House Decaf(2)

Big Easy Bold(2)

Chocolate(1)

Decaffeinated Medium Roast(1)

Kenya Highlands(1)

Ethiopian Supreme(1)

Crema Aroma Arabica/Robusta(1)

Colombian De Jardin(1)

Gold Selection(1)

Light and Aromatic(1)

100% Arabica Blend Decaf(1)

Special Delivery(1)

Sumatra Mandheling(1)

Aroma Club 100% Arabica Blend(1)

Costa Rican La Sonrisa(1)

Sumatran(1)

Rotondo/Dark Roast(1)

Pier 70 Blend(1)

Colombia Medium(1)

Decaf Pike Place Roast(1)

Pike Place Roast(1)

Decaffeinated French Roast(1)

Special House Blend(1)

Kona Blend(1)

Colombian Blend(1)

Veranda(1)

Veranda Blend Blonde Roast(1)

FT Vanilla(1)

Decaf Portside Blend(1)

Colombia Huila(1)

Portside Blend(1)

Crema Dolce/Medium Roast(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)

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

6th Avenue Bistro(1)

Love at First Sip (Medium Roast)(1)

Buzzworthy (Dark Roast)(1)

Parisian Vanilla(1)

Dukale's Blend(1)

Vanilla Biscotti(1)

Sumatra Reserve(1)

Donut Shop Blend(1)

Toasted Marshmallow Mocha(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)

Dunkin' Decaf(1)

Lively Colombian Decaf(1)

Morning Café(1)

100% Colombian Decaf(1)

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

Donut Shop(1)

Donut Shop Decaf(1)

Decaf Caribou Blend(1)

Perfetto(1)

Classic(1)

Costa Rica Paraiso(1)

Bold 1937(1)

Columbia Select Single Origin(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)

Classic Decaf(1)

Cafe Vanilla(1)

Rio Blend(1)

Morning Edition Decaf(1)

TURBOCHARGER(1)

AFTERBURNER(1)

Caramel Drizzle(1)

Big Bang(1)

Lively Colombian(1)

Original Decaf(1)

Cinnamon Roll(1)

Coconut Mocha(1)

Holiday Blend(1)

Regular Roast(1)

 
Beverage Type

Coffee(390)

Decaffeinated Coffee(66)

Instant Coffee(6)

Half-caffeinated Coffee(4)

Latte(2)

Coffee Drink(2)

Instant Decaffeinated Coffee(1)

 
Manufacturer Part Number

008710(1)

8488(1)

302142(1)

30200(1)

PB4141CT(1)

PB1141(1)

PB1036CT(1)

PB1036(1)

8997(1)

8784(1)

8506(1)

8500CT(1)

8500(1)

8338(1)

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

30220(1)

30800(1)

7746(1)

3427(1)

75412(1)

75411(1)

75410(1)

970(1)

953(1)

910(1)

4483(1)

4202(1)

3454(1)

3451(1)

3446(1)

3445(1)

3425(1)

308042(1)

2709(1)

1450(1)

0603(1)

0470(1)

0460(1)

705024(1)

70500(1)

70400(1)

60000(1)

40300(1)

39930404021(1)

39930274021(1)

7790(1)

7732CT(1)

75415(1)

6992(1)

7134(1)

7120(1)

7000(1)

6999CT(1)

6999(1)

6996(1)

6995CT(1)

6995(1)

6994CT(1)

6994(1)

6992CT(1)

6990CT(1)

7428(1)

6990(1)

6974(1)

6873(1)

6813(1)

6812(1)

6803CT(1)

6803(1)

6792CT(1)

6792(1)

6783CT(1)

6783(1)

6772CT(1)

7139(1)

7465(1)

7732(1)

7585(1)

7677(1)

7615(1)

7614(1)

7608(1)

7607(1)

7605(1)

7602CT(1)

7602(1)

7596(1)

7595(1)

7594(1)

7586(1)

7573(1)

7466(1)

7571(1)

7569(1)

7568(1)

7567(1)

7564(1)

7563(1)

7534CT(1)

7534(1)

7522CT(1)

7522(1)

7468(1)

7467(1)

75413(1)

75416(1)

6758CT(1)

504917(1)

011111161(1)

011111160CT(1)

011111160(1)

011111159CT(1)

011111159(1)

011111158CT(1)

011111158(1)

011111157CT(1)

011111156CT(1)

011111156(1)

504918(1)

504916(1)

011111162(1)

504915(1)

504914(1)

504913(1)

504874(1)

501677(1)

501619(1)

501546(1)

501487(1)

500705(1)

500350(1)

39003(1)

39002(1)

011111161CT(1)

11008130(1)

39000(1)

11019631(1)

863070(1)

04707(1)

11008560(1)

11008558(1)

11008556(1)

11008554(1)

1092836(1)

11029358(1)

11028510(1)

11028473(1)

11023061(1)

11020676(1)

11018197(1)

11008131(1)

11018194(1)

11018193(1)

11018192(1)

11018190(1)

11018187(1)

11018186(1)

11018185(1)

11018131(1)

11017871(1)

11017860EA(1)

11017854(1)

11015640(1)

39001(1)

33750(1)

75421(1)

026530(1)

94142BX(1)

94142(1)

87066(1)

86073(1)

77317(1)

66488CT(1)

66488(1)

32486(1)

27376(1)

27329(1)

15782CT(1)

15782(1)

026480(1)

94245BX(1)

026260(1)

026190(1)

026160(1)

866350(1)

866150(1)

862400(1)

390390(1)

04658(1)

04648PLT(1)

04648CT(1)

04648(1)

75424(1)

94245(1)

94273(1)

33700(1)

23004(1)

33300(1)

32006(1)

32003(1)

25188(1)

25187(1)

25186(1)

25185(1)

25184(1)

25183(1)

25182(1)

25181(1)

23005(1)

23003(1)

94273BX(1)

23002(1)

23001(1)

22005(1)

22002(1)

21001(1)

33000(1)

01101(1)

01096(1)

01027(1)

00058(1)

94333BX(1)

94333(1)

6772(1)

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

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

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

192719(1)

192919(1)

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

6542CT(1)

6542(1)

6534CT(1)

6534(1)

6523CT(1)

6523(1)

6520CT(1)

6520(1)

6503CT(1)

6503(1)

6502CT(1)

6613(1)

6614(1)

6501CT(1)

6700CT(1)

6745(1)

6744(1)

6743CT(1)

6743(1)

6732CT(1)

6732(1)

6728(1)

6727(1)

6722CT(1)

6722(1)

6720CT(1)

6720(1)

6700(1)

6614CT(1)

6694CT(1)

6694(1)

6685CT(1)

6685(1)

6680(1)

6664(1)

6663CT(1)

6663(1)

6662(1)

6661(1)

6659(1)

6624(1)

6502(1)

6501(1)

192919CT(1)

4067CT(1)

5305(1)

5304(1)

5303(1)

5161(1)

4792(1)

4757(1)

4732(1)

4493(1)

4461(1)

4441(1)

4432(1)

4162(1)

4067(1)

5462CT(1)

4066CT(1)

4066(1)

4061CT(1)

4061(1)

4060CT(1)

4060(1)

4051CT(1)

4051(1)

4050CT(1)

4050(1)

193019CT(1)

193019(1)

5339(1)

5469(1)

6425(1)

6111(1)

6408(1)

6407(1)

6406CT(1)

6406(1)

6405CT(1)

6405(1)

6378(1)

6377(1)

6376(1)

6305(1)

6248(1)

6204(1)

6110(1)

5470(1)

6107(1)

6106(1)

6006(1)

6003CT(1)

6003(1)

6002(1)

6001(1)

6000(1)

5807(1)

5531(1)

5493(1)

5471(1)

866550(1)

 
Country of Origin

US(412)

CA(28)

IT(18)

GB(11)

United States(2)

CO(1)

ES(1)

 
Weight (Approximate)

11.90 oz(1)

 
For Use With

Keurig K-Cup System(217)

Commercial Coffee Brewers(27)

Drip Coffee Brewers(14)

Pod Brewers(9)

Keurig Brewing System(8)

Dolce Gusto Coffee Machine(8)

Single Cup Brewers(7)

Standard Coffee Brewers(7)

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

NESCAFÉ Dolce Gusto Machines(4)

Single Cup Brewers Hamilton, Bunn and Newco(4)

Coffee Brewer(3)

Grinder; Coffee Brewer(3)

Standard and Commercial Coffee Makers(2)

LavAzza Espresso Point Machine(2)

Lavazza 2312(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)

Lavazza 2312 BLUE Machine(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(11)

18 oz(9)

0.4 oz(6)

0.9 oz(6)

0.35 oz(6)

1.4 oz(4)

0.06 oz(4)

10 oz(3)

30.6 oz(3)

30.5 oz(3)

2.2 lb(3)

0.25 oz(3)

8 oz(3)

1.75 oz(3)

28 oz(3)

1.1 oz(3)

0.1 oz(2)

1.2 oz(2)

8 g(2)

32 oz(2)

0.12 oz(2)

2.5 lbs(2)

0.31 oz(2)

24.2 oz(2)

25.4 oz(2)

31.1 oz(2)

22.6 oz(2)

7 g(2)

1.05 oz(2)

0.6 oz(2)

33.9 oz(1)

2 oz.(1)

36 oz(1)

48 oz(1)

34.5 oz(1)

16 oz(1)

0.8 oz(1)

0.8(1)

0.33 oz(1)

29.3 oz(1)

9 g(1)

2.2 lbs(1)

2.25 oz(1)

31 oz(1)

 
Serve Type

K-Cup(1)

 
Coffee Type

Caffeinated(1)

Regular(1)

 
Roast Type

Medium(138)

Dark(111)

Light(56)

Dark Roast(4)

Mild(1)

Medium Roast(1)

 
Coffee Weight

16 oz(1)

 
Compatible Brewer

K-Cup Brewer(1)

 
Product Type

Coffee(2)

 
Packaged Quantity

24 / Box(1)

1 Each(1)

 
Flavor/Blend

Pumpkin Spice(1)

Nutmeg(1)

Cinnamon(1)

Arabica(1)

Cafe Domingo(1)

 
Coffee Roast Level

Medium(2)

 
 
 

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