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

Starbucks(33)

Peet's Coffee & Tea(19)

Tully's Coffee(16)

1850(16)

Lavazza(15)

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)

Gloria Jean's(6)

Newman's Own Organics(6)

Donut House(6)

Diedrich Coffee(6)

Nescafé(6)

Distant Lands Coffee(6)

Seattle's Best(5)

Café Escapes(4)

Coffee People(4)

McCafe(4)

Gevalia(4)

National Coffee Roasters(3)

Tim Hortons(3)

revv(3)

Krispy Kreme Doughnuts(3)

Panera Bread at HOME(3)

Laughing Man Coffee Company(3)

Yuban(3)

Kahlúa(2)

Hills Bros.(2)

Emeril's(2)

illy(2)

BUSTELO cool(2)

Nescafe Dolce Gusto(1)

Cinnabon(1)

Dunkin' Donuts®(1)

Office Snax(1)

Chock full o'Nuts(1)

Chase & Sanborn(1)

Peet's(1)

 
Quantity

42 per carton(6)

24 per box(6)

36 per carton(5)

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

Fraction Pack(49)

Pod(29)

Packet(29)

Can(14)

Canister(13)

Capsule(11)

Filter Pack(8)

Stick(8)

Portion Pack(5)

Vacket Pack(3)

Cartridges(3)

Lavazza BLUE Capsule(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)

Dark Roast(8)

Italian Roast(8)

Regular(7)

Original(7)

Original Blend(6)

Assorted(6)

Medium Roast(6)

100% Colombian(6)

Hazelnut Creme(6)

Classic Roast Decaf(6)

Breakfast Blend Decaf(5)

Black Gold(5)

Decaffeinated(5)

Colombian(5)

Veranda Blend(5)

Caffe Verona(5)

House Blend Decaf(5)

Black Silk(5)

Pioneer Blend(5)

Pike Place Decaf(4)

Morning Blend(4)

Major Dickason's Blend(4)

Pike Place(4)

Decaf House Blend(4)

Colombian Supremo(3)

Caribou Blend(3)

Lantern Glow(3)

Pumpkin Spice(3)

Donut Shop Regular(3)

Decaf(3)

Mocha(3)

Vermont Country Blend Decaf(3)

Dark Magic(3)

Daybreak Morning Blend(3)

Nantucket Blend(3)

Vermont Country Blend(3)

Our Blend(2)

Café Domingo Blend(2)

Brazil Minas Naturais(2)

Caramel(2)

Hawaiian Blend(2)

Donut House(2)

Lake & Lodge(2)

Colombia(2)

Vanilla Hazelnut(2)

Caramel Vanilla Cream(2)

Sumatra(2)

Hawaiian Islands Blend(2)

Blonde Espresso Roast(2)

Caramel Macchiato(2)

Latte Macchiato(2)

Kahlúa Original(2)

Big Easy Bold(2)

French Vanilla Decaf(2)

Donut House Decaf(2)

Island Coconut(2)

Colombian Decaf(2)

Half-Caff(2)

Caribou Blend Decaf(2)

Mahogany(2)

Wild Mountain Blueberry(2)

Southern Pecan(2)

Morning Edition(2)

Chocolate Glazed Donut(2)

Single Origin Colombian Select(2)

Decaf Italian Roast(2)

Hazelnut Cream(2)

Dark Magic Decaf Extra Bold(2)

Trailblazer(2)

Butter Toffee(2)

Half Caff(2)

French Roast Decaf(2)

Simply Smooth(2)

Special Blend Extra Bold(2)

Organic Sumatran Extra Bold(2)

Dark Magic Extra Bold(2)

Double Black Diamond Extra Bold(2)

Special Decaf(2)

Special Roast(2)

Espresso Decaf(2)

Decaffeinated Medium Roast(1)

Parisian Vanilla(1)

French Dark Roast(1)

Original Roast Decaf(1)

Parisian Café (Dark Roast)(1)

Breakfast Blend (Light Roast)(1)

Chocolate(1)

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

Love at First Sip (Medium Roast)(1)

Buzzworthy (Dark Roast)(1)

Rotondo/Dark Roast(1)

Crema Dolce/Medium Roast(1)

100% Arabica Blend Decaf(1)

Gourmet Supreme(1)

Colombian De Jardin(1)

Costa Rican La Sonrisa(1)

Eye Opener(1)

Sumatra Mandheling(1)

Crema Aroma Arabica/Robusta(1)

Aroma Club 100% Arabica Blend(1)

Signature Blend Decaf(1)

Café con Leche(1)

Lungo Decaf(1)

Sumatran(1)

Special Delivery(1)

6th Avenue Bistro(1)

Portside Blend(1)

Pier 70 Blend(1)

Decaf Portside Blend(1)

FT Vanilla(1)

Veranda Blend Blonde Roast(1)

Veranda(1)

Pike Place Roast(1)

Decaf Pike Place Roast(1)

Colombia Medium(1)

Decaf Caribou Blend(1)

Cappuccino(1)

Donut Shop Decaf(1)

Decaffeinated French Roast(1)

Special House Blend(1)

Donut Shop(1)

Kona Blend(1)

Colombian Blend(1)

Vanilla(1)

Medium Decaf(1)

Ethiopian Supreme(1)

Café con Leche Chocolate(1)

Vanilla Latte Macchiato(1)

Kenya Highlands(1)

Dark(1)

Dukale's Blend(1)

Extra Bold Breakfast Blend(1)

TURBOCHARGER(1)

AFTERBURNER(1)

Lively Colombian Decaf(1)

Dunkin' Decaf(1)

Dunkin' Dark(1)

Caramel Drizzle(1)

Big Bang(1)

Vanilla Biscotti(1)

Lively Colombian(1)

Caramel Coffee Cake(1)

Signature Blend(1)

Morning Edition Decaf(1)

Original Decaf(1)

Original Roast(1)

Cinnamon Roll(1)

Coconut Mocha(1)

Holiday Blend(1)

Classic Decaf(1)

Classic(1)

Dark Royal(1)

Gran Aroma(1)

Perfetto(1)

Morning Café(1)

Rio Blend(1)

Colombia Huila(1)

Decaf Classic(1)

Sumatra Reserve(1)

Costa Rica Paraiso(1)

Columbia Select Single Origin(1)

Special Blend(1)

Toasted Marshmallow Mocha(1)

Colombian Huila(1)

Light Roast(1)

Dark Blend(1)

Round the Clock Blend(1)

Cinnamon(1)

Premium Roast Decaf(1)

Donut Shop Blend(1)

Premium Roast(1)

Peppermint Bark(1)

Country Roast(1)

Pioneer Blend Decaf(1)

Caramel Hideaway(1)

Traditional Roast(1)

100% Colombian Decaf(1)

Bold 1937(1)

NO SURRENDER(1)

Cafe Vanilla(1)

Regular Roast(1)

 
Beverage Type

Coffee(385)

Decaffeinated Coffee(66)

Instant Coffee(6)

Half-caffeinated Coffee(4)

Latte(2)

Coffee Drink(2)

Instant Decaffeinated Coffee(1)

 
Manufacturer Part Number

008710(1)

8287(1)

PB1141(1)

PB1036CT(1)

PB1036(1)

8997(1)

8784(1)

8506(1)

8500CT(1)

8500(1)

8488(1)

8338(1)

8337(1)

8087(1)

30200(1)

8007(1)

7999(1)

7996(1)

7995(1)

7994(1)

7993(1)

7792CT(1)

7792(1)

7791(1)

7790(1)

7746(1)

7732CT(1)

PB4141CT(1)

302142(1)

7677(1)

1450(1)

75415(1)

75413(1)

75412(1)

75411(1)

75410(1)

970(1)

953(1)

910(1)

4483(1)

4202(1)

2709(1)

0603(1)

30220(1)

0470(1)

0460(1)

705024(1)

70500(1)

70400(1)

60000(1)

40300(1)

39930404021(1)

39930274021(1)

308042(1)

30800(1)

302742(1)

7732(1)

7615(1)

75421(1)

6974(1)

6999CT(1)

6999(1)

6996(1)

6995CT(1)

6995(1)

6994CT(1)

6994(1)

6992CT(1)

6992(1)

6990CT(1)

6990(1)

6873(1)

7120(1)

6813(1)

6812(1)

6803CT(1)

6803(1)

6792CT(1)

6792(1)

6783CT(1)

6783(1)

6772CT(1)

6772(1)

6758CT(1)

6758(1)

7000(1)

7134(1)

7614(1)

7569(1)

7608(1)

7607(1)

7605(1)

7602CT(1)

7602(1)

7596(1)

7595(1)

7594(1)

7586(1)

7585(1)

7573(1)

7571(1)

7568(1)

7139(1)

7567(1)

7564(1)

7563(1)

7534CT(1)

7534(1)

7522CT(1)

7522(1)

7468(1)

7467(1)

7466(1)

7465(1)

7428(1)

75416(1)

75424(1)

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

04648(1)

15782(1)

94142BX(1)

94142(1)

87066(1)

86073(1)

77317(1)

66488CT(1)

66488(1)

32486(1)

27376(1)

27329(1)

15782CT(1)

02430(1)

94245BX(1)

026530(1)

026480(1)

026260(1)

026190(1)

026160(1)

866350(1)

866150(1)

862400(1)

390390(1)

04658(1)

04648PLT(1)

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

6746(1)

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

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)

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

192619(1)

192719(1)

6743CT(1)

6542CT(1)

6606CT(1)

6606(1)

6602CT(1)

6602(1)

6570CT(1)

6570(1)

6547(1)

6546(1)

6545(1)

6544(1)

6543(1)

6542(1)

6611CT(1)

6534CT(1)

6534(1)

6523CT(1)

6523(1)

6520CT(1)

6520(1)

6503CT(1)

6503(1)

6502CT(1)

6502(1)

6501CT(1)

6501(1)

6611(1)

6612(1)

6408(1)

6694(1)

6743(1)

6732CT(1)

6732(1)

6728(1)

6727(1)

6722CT(1)

6722(1)

6720CT(1)

6720(1)

6700CT(1)

6700(1)

6694CT(1)

6685CT(1)

6613(1)

6685(1)

6680(1)

6664(1)

6663CT(1)

6663(1)

6662(1)

6661(1)

6659(1)

6624(1)

6614CT(1)

6614(1)

6613CT(1)

6425(1)

6407(1)

192719CT(1)

4066CT(1)

5161(1)

4792(1)

4757(1)

4732(1)

4493(1)

4461(1)

4441(1)

4432(1)

4162(1)

4067CT(1)

4067(1)

4066(1)

5304(1)

4061CT(1)

4061(1)

4060CT(1)

4060(1)

4051CT(1)

4051(1)

4050CT(1)

4050(1)

193019CT(1)

193019(1)

192919CT(1)

192919(1)

5303(1)

5305(1)

6406CT(1)

6106(1)

6406(1)

6405CT(1)

6405(1)

6378(1)

6377(1)

6376(1)

6305(1)

6248(1)

6204(1)

6111(1)

6110(1)

6107(1)

6006(1)

5339(1)

6003CT(1)

6003(1)

6002(1)

6001(1)

6000(1)

5807(1)

5531(1)

5493(1)

5471(1)

5470(1)

5469(1)

5462CT(1)

866550(1)

 
Country of Origin

US(413)

CA(28)

IT(12)

GB(11)

United States(2)

CO(1)

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

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

18 oz(9)

0.9 oz(6)

0.4 oz(6)

0.35 oz(6)

0.06 oz(4)

1.4 oz(4)

0.25 oz(3)

30.6 oz(3)

1.1 oz(3)

10 oz(3)

30.5 oz(3)

28 oz(3)

1.75 oz(3)

1.2 oz(2)

0.1 oz(2)

32 oz(2)

8 g(2)

0.12 oz(2)

22.6 oz(2)

0.31 oz(2)

31.1 oz(2)

2.5 lbs(2)

0.6 oz(2)

8 oz(2)

24.2 oz(2)

25.4 oz(2)

7 g(2)

1.05 oz(2)

34.5 oz(1)

2 oz.(1)

0.8 oz(1)

0.8(1)

16 oz(1)

48 oz(1)

33.9 oz(1)

0.33 oz(1)

29.3 oz(1)

9 g(1)

2.2 lbs(1)

36 oz(1)

31 oz(1)

 
Serve Type

K-Cup(1)

Pod(1)

 
Coffee Type

Caffeinated(1)

Regular(1)

 
Roast Type

Medium(138)

Dark(107)

Light(54)

Dark Roast(4)

Mild(1)

Medium Roast(1)

 
Coffee Weight

16 oz(1)

 
Compatible Brewer

K-Cup Brewer(1)

Majesto Automatic Coffee Machine(1)

 
Coffee Quantity

8 Capsule(1)

 
Product Type

Coffee(3)

 
Packaged Quantity

24 / Box(1)

16 / Box(1)

1 Each(1)

 
Flavor/Blend

Pumpkin Spice(1)

Nutmeg(1)

Cinnamon(1)

Arabica(1)

Latte Macchiato(1)

Espresso(1)

Creamy(1)

Caramel(1)

Cafe Domingo(1)

 
Coffee Roast Level

Medium(2)

 
 
 

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