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®(83)

Folgers®(53)

Starbucks®(33)

Peet's Coffee & Tea®(18)

Tully's Coffee®(16)

1850(16)

Day to Day Coffee®(15)

Lavazza(15)

Caribou Coffee®(14)

Café Bustelo(14)

NESCAFÉ® Dolce Gusto®(13)

Maxwell House®(13)

Barista Prima Coffeehouse®(11)

PapaNicholas® Coffee(10)

The Original Donut Shop®(10)

Dunkin Donuts®(9)

New England® Coffee(9)

Eight O'Clock(9)

Melitta®(8)

Java One®(7)

Gloria Jean's®(6)

Nescafé®(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)

National Coffee Roasters(3)

Laughing Man® Coffee Company(3)

Panera Bread® at HOME(3)

Tim Hortons®(3)

Krispy Kreme Doughnuts®(3)

Chase & Sanborn®(2)

BUSTELO cool®(2)

Emeril's™(2)

Kahlúa®(2)

illy®(2)

Hills Bros.®(2)

Chock full o'Nuts(1)

Office Snax®(1)

Cinnabon®(1)

Peet's Coffee & Tea(1)

Peet's Coffee(1)

Nescafe Dolce Gusto(1)

 
Quantity

42 per carton(6)

36 per carton(5)

24 per box(4)

40 per box(2)

22 per box(1)

24 per carton(1)

12 per pack(1)

96 per carton(1)

1 each(1)

42 per box(1)

18 per carton(1)

 
Packing Type

K-Cup®(229)

Bag(55)

Fraction Pack(50)

Packet(30)

Pod(29)

Can(14)

Canister(13)

Capsule(12)

Filter Pack(8)

Stick(8)

Portion Pack(5)

Lavazza BLUE Capsule(3)

Vacket Pack(3)

Cartridges(3)

Jar(2)

K-Cup(2)

Brick Pack(2)

Coffee Pod(1)

Capsules(1)

 
Flavor

French Roast(25)

Breakfast Blend(19)

House Blend(17)

Classic Roast(15)

Hazelnut(12)

Espresso(11)

French Vanilla(11)

Dark Roast(8)

Italian Roast(8)

Regular(8)

Original(7)

Hazelnut Creme(6)

Medium Roast(6)

Assorted(6)

Original Blend(6)

Classic Roast Decaf(6)

100% Colombian(6)

Caffe Verona®(5)

Colombian(5)

Decaffeinated(5)

Black Silk(5)

Pioneer Blend(5)

House Blend Decaf(5)

Black Gold(5)

Breakfast Blend Decaf(5)

Pike Place(4)

Morning Blend(4)

Pike Place Decaf(4)

Pumpkin Spice(4)

Decaf House Blend(4)

Major Dickason's Blend(4)

Vermont Country Blend®(3)

Veranda Blend™(3)

Colombian Supremo(3)

Daybreak Morning Blend(3)

Dark Magic®(3)

Caribou Blend(3)

Vermont Country Blend® Decaf(3)

Decaf(3)

Lantern Glow(3)

Mocha(3)

Southern Pecan(2)

Chocolate Glazed Donut™(2)

Butter Toffee(2)

Latte Macchiato(2)

Vanilla Hazelnut(2)

Colombian Decaf(2)

Half-Caff(2)

Caribou Blend Decaf(2)

Single Origin Colombian Select(2)

Mahogany(2)

Wild Mountain Blueberry™(2)

Caramel(2)

Lake & Lodge®(2)

Trailblazer(2)

Donut House™(2)

Brazil Minas Naturais(2)

Café Domingo Blend(2)

Our Blend(2)

Hawaiian Blend(2)

Colombia(2)

Decaf Italian Roast(2)

Donut Shop™ Regular(2)

Nantucket Blend®(2)

Morning Edition(2)

Caramel Vanilla Cream(2)

Veranda Blend(2)

Island Coconut®(2)

Kahlúa® Original(2)

Espresso Decaf(2)

Hazelnut Cream(2)

Hawaiian Islands Blend(2)

Half Caff(2)

French Roast Decaf(2)

Special Roast(2)

Big Easy Bold™(2)

Sumatra(2)

Donut House™ Decaf(2)

French Vanilla Decaf(2)

Special Blend Extra Bold(2)

Special Decaf(2)

Organic Sumatran Extra Bold(2)

Dark Magic® Extra Bold(2)

Double Black Diamond™ Extra Bold(2)

Dark Magic® Decaf Extra Bold(2)

Blonde Espresso Roast(2)

Caramel Macchiato(2)

Simply Smooth(2)

Colombia Huila(1)

Decaffeinated Medium Roast(1)

Rotondo/Dark Roast(1)

Sumatra Reserve(1)

Chocolate(1)

Dukale's Blend(1)

100% Arabica Blend Decaf(1)

Ethiopian Supreme(1)

Kenya Highlands(1)

Aroma Club 100% Arabica Blend(1)

Crema Aroma Arabica/Robusta(1)

Sumatra Mandheling(1)

Costa Rican La Sonrisa(1)

Special Delivery(1)

Colombian De Jardin(1)

Sumatran(1)

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

Columbia Select Single Origin(1)

Portside Blend(1)

Parisian Vanilla(1)

Vanilla Latte Macchiato(1)

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

Costa Rica Paraiso(1)

Lively Colombian(1)

Donut Shop Regular(1)

Donut Shop Blend(1)

Dark Royal(1)

Original Roast(1)

Signature Blend(1)

Nantucket Blend(1)

Colombia Select(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)

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

Signature Blend Decaf(1)

Perfetto(1)

Special Blend(1)

Cafe Vanilla(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)

Bold 1937(1)

NO SURRENDER™(1)

Rio Blend(1)

Gran Aroma(1)

Morning Edition Decaf(1)

TURBOCHARGER™(1)

AFTERBURNER™(1)

Caramel Drizzle(1)

Big Bang™(1)

Vanilla Biscotti(1)

Original Decaf(1)

Cinnamon Roll(1)

Coconut Mocha(1)

Holiday Blend(1)

Classic Decaf(1)

Classic(1)

Regular Roast(1)

 
Beverage Type

Coffee(387)

Decaffeinated Coffee(67)

Instant Coffee(6)

Half-caffeinated Coffee(4)

Latte(2)

Coffee Drink(2)

Instant Decaffeinated Coffee(1)

Hot Chocolate(1)

 
Manufacturer Part Number

008710(1)

8337(1)

PB4141CT(1)

PB1141(1)

PB1036CT(1)

PB1036(1)

8997(1)

8784(1)

8506(1)

8500CT(1)

8500(1)

8488(1)

8338(1)

8287(1)

302142(1)

8087(1)

8007(1)

7999(1)

7996(1)

7995(1)

7994(1)

7993(1)

7792CT(1)

7792(1)

7791(1)

7790(1)

7746(1)

30200(1)

30220(1)

7732(1)

2709(1)

75421(1)

75416(1)

75415(1)

75413(1)

75412(1)

75411(1)

75410(1)

970(1)

953(1)

910(1)

4483(1)

4202(1)

1450(1)

302742(1)

0603(1)

0470(1)

0460(1)

705024(1)

70500(1)

70400(1)

60000(1)

40300(1)

39930404021(1)

39930274021(1)

308042(1)

30800(1)

7732CT(1)

7677(1)

04648(1)

6990(1)

7000(1)

6999CT(1)

6999(1)

6996(1)

6995CT(1)

6995(1)

6994CT(1)

6994(1)

6992CT(1)

6992(1)

6990CT(1)

6974(1)

7134(1)

6873(1)

6813(1)

6812(1)

6803CT(1)

6803(1)

6792CT(1)

6792(1)

6783CT(1)

6783(1)

6772CT(1)

6772(1)

6758CT(1)

7120(1)

7139(1)

7615(1)

7571(1)

7614(1)

7608(1)

7607(1)

7605(1)

7602CT(1)

7602(1)

7596(1)

7595(1)

7594(1)

7586(1)

7585(1)

7573(1)

7569(1)

7428(1)

7568(1)

7567(1)

7564(1)

7563(1)

7534CT(1)

7534(1)

7522CT(1)

7522(1)

7468(1)

7467(1)

7466(1)

7465(1)

75424(1)

04648CT(1)

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

04648PLT(1)

27329(1)

94245(1)

94142BX(1)

94142(1)

87066(1)

86073(1)

77317(1)

69749(1)

66488CT(1)

66488(1)

32486(1)

27376(1)

15782CT(1)

94273(1)

15782(1)

02430(1)

026530(1)

026480(1)

026260(1)

026190(1)

026160(1)

866350(1)

866150(1)

862400(1)

390390(1)

04658(1)

94245BX(1)

94273BX(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)

94333(1)

23002(1)

23001(1)

22005(1)

22002(1)

21001(1)

33000(1)

32410(1)

01101(1)

01096(1)

01027(1)

00058(1)

94333BX(1)

6758(1)

6745(1)

008711(1)

21513(1)

60517EA(1)

60517(1)

60516EA(1)

60516(1)

60515EA(1)

60515(1)

60514EA(1)

60514(1)

60513EA(1)

60513(1)

52320(1)

21512(1)

60518EA(1)

21511(1)

21510(1)

20672(1)

20630(1)

20540CT(1)

20540(1)

20527CT(1)

20527(1)

20513CT(1)

20513(1)

20421PL(1)

20421EA(1)

60518(1)

63006(1)

11545BX(1)

0846(1)

192619(1)

192519CT(1)

192519(1)

192419CT(1)

192419(1)

1281(1)

1280(1)

1279(1)

0995(1)

0849(1)

0848(1)

0847(1)

0845(1)

63100(1)

0570(1)

0448(1)

0162(1)

0040(1)

0038(1)

0037(1)

0036(1)

63104(1)

63103(1)

63102(1)

63101(1)

63100CT(1)

20421CT(1)

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

11544BX(1)

06451(1)

11544(1)

11248(1)

10117(1)

10107(1)

06931(1)

06930(1)

06927(1)

06922(1)

06898(1)

06897(1)

06547(1)

06546(1)

06437(1)

01014(1)

06433(1)

06430(1)

06239(1)

06125(1)

06122(1)

06119(1)

06114(1)

0529C(1)

01720CT(1)

01720(1)

01501(1)

01500(1)

192619CT(1)

192719CT(1)

6744(1)

6543(1)

6611(1)

6606CT(1)

6606(1)

6602CT(1)

6602(1)

6570CT(1)

6570(1)

6547(1)

6546(1)

6545(1)

6544(1)

6542CT(1)

6612(1)

6542(1)

6534CT(1)

6534(1)

6523CT(1)

6523(1)

6520CT(1)

6520(1)

6503CT(1)

6503(1)

6502CT(1)

6502(1)

6501CT(1)

6611CT(1)

6613(1)

6425(1)

6694CT(1)

6743CT(1)

6743(1)

6732CT(1)

6732(1)

6728(1)

6727(1)

6722CT(1)

6722(1)

6720CT(1)

6720(1)

6700CT(1)

6700(1)

6694(1)

6613CT(1)

6685CT(1)

6685(1)

6680(1)

6664(1)

6663CT(1)

6663(1)

6662(1)

6661(1)

6659(1)

6624(1)

6614CT(1)

6614(1)

6501(1)

6408(1)

192919(1)

4067(1)

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

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

5304(1)

5339(1)

6407(1)

6107(1)

6406CT(1)

6406(1)

6405CT(1)

6405(1)

6378(1)

6377(1)

6376(1)

6305(1)

6248(1)

6204(1)

6111(1)

6110(1)

6106(1)

5462CT(1)

6006(1)

6003CT(1)

6003(1)

6002(1)

6001(1)

6000(1)

5807(1)

5531(1)

5493(1)

5471(1)

5470(1)

5469(1)

866550(1)

 
Country of Origin

US(390)

CA(55)

GB(12)

IT(10)

AX(1)

CO(1)

Spain(1)

ES(1)

United States(1)

 
For Use With

Keurig® K-Cup® System(219)

Commercial Coffee Brewers(27)

Drip Coffee Brewers(14)

Pod Brewers(9)

Dolce Gusto Coffee Machine(8)

Single Cup Brewers(7)

Standard Coffee Brewers(7)

NESCAFÉ® Dolce Gusto® Machines(5)

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

Keurig® Brewing System(5)

Single Cup Brewers Hamilton, Bunn and Newco(4)

Keurig K-Cup System(2)

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

LavAzza Espresso Point Machine(2)

Lavazza 2312(2)

Standard and Commercial Coffee Makers(2)

Any traditional coffee maker(1)

Pod Espresso Brewer(1)

LavAzza Espresso Point Machine (sold separately)(1)

Lavazza 2312 BLUE Machine(1)

1/2-Gallon Brewers(1)

 
Capacity (Volume)

0.38 oz(4)

8 oz(2)

10 oz(2)

48 oz(1)

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

0.9 oz(6)

0.4 oz(6)

0.06 oz(4)

1.4 oz(4)

28 oz(3)

30.5 oz(3)

1.1 oz(3)

30.6 oz(3)

0.25 oz(3)

1.75 oz(3)

10 oz(3)

32 oz(2)

0.1 oz(2)

0.31 oz(2)

1.2 oz(2)

8 g(2)

0.12 oz(2)

22.6 oz(2)

7 g(2)

2.5 lbs(2)

0.6 oz(2)

8 oz(2)

24.2 oz(2)

25.4 oz(2)

31.1 oz(2)

1.05 oz(2)

34.5 oz(1)

2 oz.(1)

0.8 oz(1)

0.8(1)

16 oz(1)

0.33 oz(1)

1.25 oz(1)

33.9 oz(1)

48 oz(1)

29.3 oz(1)

9 g(1)

2.2 lbs(1)

36 oz(1)

31 oz(1)

 
Serve Type

Pod(1)

 
Coffee Type

Regular(1)

 
Roast Type

Medium(140)

Dark(107)

Light(56)

Dark Roast(4)

Medium Roast(1)

 
Coffee Weight

16 oz(1)

 
Compatible Brewer

Majesto Automatic Coffee Machine(1)

 
Coffee Quantity

8 Capsule(1)

 
Product Type

Coffee(2)

 
Packaged Quantity

16 / Box(1)

1 Each(1)

 
Flavor/Blend

Latte Macchiato(1)

Espresso(1)

Creamy(1)

Caramel(1)

Cafe Domingo(1)

 
Coffee Roast Level

Medium(1)

 
 
 

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