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)

1850(16)

Tully's Coffee(16)

Day to Day Coffee(15)

Café Bustelo(14)

Caribou Coffee(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)

Distant Lands Coffee(6)

Gloria Jean's(6)

Donut House(6)

Newman's Own Organics(6)

Diedrich Coffee(6)

Seattle's Best(5)

Gevalia(4)

Coffee People(4)

Café Escapes(4)

McCafe(4)

Yuban(3)

revv(3)

Panera Bread at HOME(3)

Krispy Kreme Doughnuts(3)

Tim Hortons(3)

Laughing Man Coffee Company(3)

National Coffee Roasters(3)

BUSTELO cool(2)

Kahlúa(2)

Hills Bros.(2)

illy(2)

Emeril's(2)

Dunkin' Donuts®(1)

Peet's(1)

Office Snax(1)

Chase & Sanborn(1)

Cinnabon(1)

Chock full o'Nuts(1)

 
Quantity

24 per box(6)

42 per carton(6)

36 per carton(4)

96 per carton(2)

40 per box(2)

18 per carton(1)

24 per carton(1)

42 per box(1)

1 each(1)

12 per pack(1)

22 per box(1)

 
Packing Type

K-Cup(230)

Bag(57)

Fraction Pack(52)

Packet(29)

Pod(29)

Can(14)

Canister(13)

Capsule(11)

Filter Pack(8)

Stick(8)

Portion Pack(5)

Lavazza BLUE Capsule(3)

Cartridges(3)

Vacket Pack(3)

Jar(2)

Brick Pack(2)

Capsules(1)

Coffee Pod(1)

 
Flavor

French Roast(25)

Breakfast Blend(19)

House Blend(17)

Classic Roast(15)

Hazelnut(12)

Espresso(11)

French Vanilla(11)

Italian Roast(8)

Dark Roast(8)

Regular(7)

Original(7)

Assorted(6)

Original Blend(6)

Medium Roast(6)

100% Colombian(6)

Hazelnut Creme(6)

Pioneer Blend(5)

Veranda Blend(5)

Classic Roast Decaf(5)

Colombian(5)

Black Gold(5)

Breakfast Blend Decaf(5)

Caffe Verona(5)

House Blend Decaf(5)

Black Silk(5)

Decaffeinated(5)

Pike Place(4)

Morning Blend(4)

Major Dickason's Blend(4)

Decaf House Blend(4)

Pike Place Decaf(4)

Colombian Supremo(3)

Vermont Country Blend(3)

Pumpkin Spice(3)

Nantucket Blend(3)

Caribou Blend(3)

Dark Magic(3)

Vermont Country Blend Decaf(3)

Mocha(3)

Donut Shop Regular(3)

Decaf(3)

Lantern Glow(3)

Daybreak Morning Blend(3)

Caribou Blend Decaf(2)

Mahogany(2)

Caramel(2)

Half-Caff(2)

Dark and Intense(2)

Latte Macchiato(2)

Caramel Macchiato(2)

Colombian Decaf(2)

Lake & Lodge(2)

Single Origin Colombian Select(2)

Vanilla Hazelnut(2)

Brazil Minas Naturais(2)

Wild Mountain Blueberry(2)

Dark and Bold(2)

Southern Pecan(2)

Caramel Vanilla Cream(2)

Chocolate Glazed Donut(2)

Island Coconut(2)

Butter Toffee(2)

Decaf Italian Roast(2)

Café Domingo Blend(2)

Morning Edition(2)

Our Blend(2)

Hawaiian Blend(2)

Colombia(2)

Donut House(2)

Blonde Espresso Roast(2)

Special Roast(2)

Kahlúa Original(2)

Hazelnut Cream(2)

Special Blend Extra Bold(2)

French Roast Decaf(2)

Hawaiian Islands Blend(2)

Simply Smooth(2)

Espresso Decaf(2)

French Vanilla Decaf(2)

Big Easy Bold(2)

Half Caff(2)

Special Decaf(2)

Organic Sumatran Extra Bold(2)

Trailblazer(2)

Sumatra(2)

Donut House Decaf(2)

Double Black Diamond Extra Bold(2)

Dark Magic Decaf Extra Bold(2)

Dark Magic Extra Bold(2)

Ethiopian Supreme(1)

Rotondo/Dark Roast(1)

Kenya Highlands(1)

Decaffeinated Medium Roast(1)

Chocolate(1)

Dukale's Blend(1)

Colombian De Jardin(1)

100% Arabica Blend Decaf(1)

Sumatra Mandheling(1)

Crema Aroma Arabica/Robusta(1)

Regular Roast(1)

Light and Aromatic(1)

Costa Rican La Sonrisa(1)

Gold Selection(1)

Aroma Club 100% Arabica Blend(1)

Special Delivery(1)

FT Vanilla(1)

Veranda Blend Blonde Roast(1)

Decaf Portside Blend(1)

Pier 70 Blend(1)

Portside Blend(1)

Colombia Huila(1)

Kona Blend(1)

Special House Blend(1)

Decaf Pike Place Roast(1)

Sumatran(1)

Pike Place Roast(1)

Veranda(1)

Decaffeinated French Roast(1)

Colombian Blend(1)

6th Avenue Bistro(1)

Colombia Medium(1)

Breakfast Blend (Light Roast)(1)

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

Love at First Sip (Medium Roast)(1)

Parisian Vanilla(1)

Buzzworthy (Dark Roast)(1)

Parisian Café (Dark Roast)(1)

Original Roast Decaf(1)

Cappuccino(1)

Vanilla Latte Macchiato(1)

Lungo Decaf(1)

Eye Opener(1)

French Dark Roast(1)

Crema Dolce/Medium Roast(1)

Lively Colombian(1)

Caramel Coffee Cake(1)

Extra Bold Breakfast Blend(1)

Dunkin' Dark(1)

Dunkin' Decaf(1)

Morning Café(1)

Lively Colombian Decaf(1)

Signature Blend(1)

Original Roast(1)

Perfetto(1)

Gran Aroma(1)

Toasted Marshmallow Mocha(1)

Signature Blend Decaf(1)

Dark Royal(1)

Donut Shop Blend(1)

100% Colombian Decaf(1)

Vanilla(1)

Medium Decaf(1)

Donut Shop(1)

Donut Shop Decaf(1)

Decaf Caribou Blend(1)

Café con Leche(1)

Café con Leche Chocolate(1)

Pioneer Blend Decaf(1)

Traditional Roast(1)

Country Roast(1)

Decaf Classic(1)

Gourmet Supreme(1)

Classic(1)

Classic Decaf(1)

Cinnamon(1)

Round the Clock Blend(1)

Premium Roast Decaf(1)

Premium Roast(1)

Caramel Hideaway(1)

Peppermint Bark(1)

Dark Blend(1)

Light Roast(1)

Columbia Select Single Origin(1)

Costa Rica Paraiso(1)

Special Blend(1)

Dark(1)

Colombian Huila(1)

Bold 1937(1)

NO SURRENDER(1)

Original Decaf(1)

Vanilla Biscotti(1)

Cinnamon Roll(1)

Coconut Mocha(1)

Holiday Blend(1)

Big Bang(1)

Caramel Drizzle(1)

Rio Blend(1)

Cafe Vanilla(1)

Morning Edition Decaf(1)

TURBOCHARGER(1)

AFTERBURNER(1)

Sumatra Reserve(1)

 
Beverage Type

Coffee(390)

Decaffeinated Coffee(66)

Instant Coffee(6)

Half-caffeinated Coffee(4)

Coffee Drink(2)

Latte(2)

Instant Decaffeinated Coffee(1)

 
Manufacturer Part Number

8997(1)

PB1036(1)

8784(1)

8506(1)

8500(1)

8500CT(1)

PB1036CT(1)

PB1141(1)

30220(1)

302742(1)

302142(1)

30200(1)

PB4141CT(1)

8488(1)

8338(1)

7993(1)

7994(1)

7792CT(1)

7792(1)

7790(1)

7791(1)

7995(1)

7996(1)

8287(1)

8337(1)

8087(1)

8007(1)

7999(1)

30800(1)

308042(1)

4483(1)

910(1)

4202(1)

3454(1)

3446(1)

3451(1)

953(1)

970(1)

75413(1)

75415(1)

75412(1)

75411(1)

75410(1)

3445(1)

3427(1)

70400(1)

70500(1)

60000(1)

40300(1)

39930274021(1)

39930404021(1)

705024(1)

0460(1)

2709(1)

3425(1)

1450(1)

0603(1)

0470(1)

7746(1)

7732CT(1)

6995CT(1)

6996(1)

6995(1)

6994CT(1)

6992CT(1)

6994(1)

6999(1)

6999CT(1)

7139(1)

7428(1)

7134(1)

7120(1)

7000(1)

6992(1)

6990CT(1)

6792(1)

6792CT(1)

6783CT(1)

6783(1)

6772(1)

6772CT(1)

6803(1)

6803CT(1)

6974(1)

6990(1)

6873(1)

6813(1)

6812(1)

7465(1)

7466(1)

7602(1)

7602CT(1)

7596(1)

7595(1)

7586(1)

7594(1)

7605(1)

7607(1)

7677(1)

7732(1)

7615(1)

7614(1)

7608(1)

7585(1)

7573(1)

7522CT(1)

7534(1)

7522(1)

7468(1)

7467(1)

7534CT(1)

7563(1)

7569(1)

7571(1)

7568(1)

7567(1)

7564(1)

75416(1)

75421(1)

011111158(1)

011111158CT(1)

011111157CT(1)

011111156CT(1)

504918(1)

011111156(1)

011111159(1)

011111159CT(1)

011111161CT(1)

011111162(1)

011111161(1)

011111160CT(1)

011111160(1)

504917(1)

504916(1)

500705(1)

501487(1)

500350(1)

39003(1)

39001(1)

39002(1)

501546(1)

501619(1)

504914(1)

504915(1)

504913(1)

504874(1)

501677(1)

11008130(1)

11008131(1)

11029358(1)

1092836(1)

11028510(1)

11028473(1)

11020676(1)

11023061(1)

11008554(1)

11008556(1)

863070(1)

866550(1)

04707(1)

11008560(1)

11008558(1)

11019631(1)

11018197(1)

11017871(1)

11018131(1)

11017860EA(1)

11017854(1)

11015640(1)

11018185(1)

11018186(1)

11018193(1)

11018194(1)

11018192(1)

11018190(1)

11018187(1)

39000(1)

33750(1)

66488(1)

66488CT(1)

32486(1)

27376(1)

15782CT(1)

27329(1)

77317(1)

86073(1)

94245(1)

94245BX(1)

94142BX(1)

94142(1)

87066(1)

15782(1)

026530(1)

04658(1)

390390(1)

04648PLT(1)

04648CT(1)

75424(1)

04648(1)

862400(1)

866150(1)

026260(1)

026480(1)

026190(1)

026160(1)

866350(1)

94273(1)

94273BX(1)

25184(1)

25185(1)

25183(1)

25182(1)

23005(1)

25181(1)

25186(1)

25187(1)

33300(1)

33700(1)

32006(1)

32003(1)

25188(1)

23004(1)

23003(1)

01027(1)

01096(1)

00058(1)

94333BX(1)

94333(1)

01101(1)

33000(1)

23001(1)

23002(1)

22005(1)

22002(1)

21001(1)

6758CT(1)

6758(1)

60515(1)

60515EA(1)

60514EA(1)

60514(1)

60513(1)

60513EA(1)

60516(1)

60516EA(1)

60518EA(1)

63006(1)

60518(1)

60517EA(1)

60517(1)

52320(1)

21513(1)

20527(1)

20527CT(1)

20513CT(1)

20513(1)

20421EA(1)

20421PL(1)

20540(1)

20540CT(1)

21511(1)

21512(1)

21510(1)

20672(1)

20630(1)

63100(1)

63100CT(1)

1281(1)

192419(1)

1280(1)

1279(1)

0849(1)

0995(1)

192419CT(1)

192519(1)

192719(1)

192719CT(1)

192619CT(1)

192619(1)

192519CT(1)

0848(1)

0847(1)

0036(1)

0037(1)

63104(1)

63103(1)

63101(1)

63102(1)

0038(1)

0040(1)

0845(1)

0846(1)

0570(1)

0448(1)

0162(1)

20421CT(1)

11545BX(1)

320820(1)

320840(1)

8599961590(1)

599961590(1)

8179(1)

1099961590(1)

00016(1)

00019(1)

00374CT(1)

00374EA(1)

00055(1)

00050CT(1)

00050(1)

8177(1)

7401BX(1)

60051012CT(1)

60051-046(1)

60051-012(1)

008715(1)

008711(1)

008712(1)

60051046CT(1)

60051-052(1)

60224-101(1)

7401(1)

60052101CT(1)

60052-101(1)

60051052CT(1)

00518X(1)

01014(1)

06927(1)

06930(1)

06922(1)

06898(1)

06547(1)

06897(1)

06931(1)

10107(1)

11544BX(1)

11545(1)

11544(1)

11248(1)

10117(1)

06546(1)

06451(1)

01720CT(1)

0529C(1)

01720(1)

01501(1)

01500(1)

06114(1)

06122(1)

06433(1)

06437(1)

06430(1)

06239(1)

06125(1)

192919(1)

192919CT(1)

6602(1)

6602CT(1)

6570CT(1)

6570(1)

6546(1)

6547(1)

6606(1)

6606CT(1)

6613(1)

6613CT(1)

6612(1)

6611CT(1)

6611(1)

6545(1)

6544(1)

6520(1)

6520CT(1)

6503CT(1)

6503(1)

6502(1)

6502CT(1)

6523(1)

6523CT(1)

6542CT(1)

6543(1)

6542(1)

6534CT(1)

6534(1)

6614(1)

6614CT(1)

6727(1)

6728(1)

6722CT(1)

6722(1)

6720(1)

6720CT(1)

6732(1)

6732CT(1)

6745(1)

6746(1)

6744(1)

6743CT(1)

6743(1)

6700CT(1)

6700(1)

6662(1)

6663(1)

6661(1)

6659(1)

6624(1)

6663CT(1)

6664(1)

6694(1)

6694CT(1)

6685CT(1)

6685(1)

6680(1)

6501CT(1)

6501(1)

4732(1)

4757(1)

4493(1)

4461(1)

4432(1)

4441(1)

4792(1)

5161(1)

5339(1)

5462CT(1)

5305(1)

5304(1)

5303(1)

4162(1)

4067CT(1)

4051(1)

4051CT(1)

4050CT(1)

4050(1)

193019(1)

193019CT(1)

4060(1)

4060CT(1)

4066CT(1)

4067(1)

4066(1)

4061CT(1)

4061(1)

5469(1)

5470(1)

6377(1)

6378(1)

6376(1)

6305(1)

6204(1)

6248(1)

6405(1)

6405CT(1)

6408(1)

6425(1)

6407(1)

6406CT(1)

6406(1)

6111(1)

6110(1)

5807(1)

6000(1)

5531(1)

5493(1)

5471(1)

6001(1)

6002(1)

6106(1)

6107(1)

6006(1)

6003CT(1)

6003(1)

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

Dolce Gusto Coffee Machine(8)

Keurig Brewing System(8)

Single Cup Brewers(7)

Standard Coffee Brewers(7)

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

Single Cup Brewers Hamilton, Bunn and Newco(4)

NESCAFÉ Dolce Gusto Machines(4)

Grinder; Coffee Brewer(3)

Coffee Brewer(3)

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

Standard and Commercial Coffee Makers(2)

Lavazza 2312(2)

LavAzza Espresso Point Machine(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)

10 oz(2)

8 oz(2)

0(1)

25.1 oz(1)

48 oz(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.35 oz(6)

0.9 oz(6)

0.4 oz(6)

0.06 oz(4)

1.4 oz(4)

30.6 oz(3)

8 oz(3)

10 oz(3)

0.25 oz(3)

2.2 lb(3)

1.1 oz(3)

30.5 oz(3)

28 oz(3)

1.75 oz(3)

0.12 oz(2)

32 oz(2)

0.1 oz(2)

8 g(2)

1.2 oz(2)

22.6 oz(2)

31.1 oz(2)

7 g(2)

1.05 oz(2)

0.6 oz(2)

24.2 oz(2)

25.4 oz(2)

2.5 lbs(2)

0.31 oz(2)

0.8(1)

16 oz(1)

31 oz(1)

0.8 oz(1)

34.5 oz(1)

2 oz.(1)

0.33 oz(1)

2.2 lbs(1)

9 g(1)

29.3 oz(1)

48 oz(1)

36 oz(1)

2.25 oz(1)

33.9 oz(1)

 
Serve Type

K-Cup(1)

 
Coffee Type

Regular(1)

Caffeinated(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

1 Each(1)

24 / Box(1)

 
Flavor/Blend

Cafe Domingo(1)

Arabica(1)

Cinnamon(1)

Nutmeg(1)

Pumpkin Spice(1)

 
Coffee Roast Level

Medium(2)

 
 
 

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