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') 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(84)

Folgers(55)

Starbucks(37)

Peet's Coffee & Tea(19)

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)

PapaNicholas Coffee(10)

The Original Donut Shop(10)

Dunkin Donuts(9)

New England Coffee(9)

Java One(9)

Eight O'Clock(9)

Melitta(8)

Barista Prima Coffeehouse(8)

Nescafé(6)

Gloria Jean's(6)

Distant Lands Coffee(6)

Donut House(6)

Diedrich Coffee(6)

Newman's Own Organics(6)

Seattle's Best(5)

Café Escapes(4)

McCafe(4)

Coffee People(4)

Gevalia(4)

Hills Bros.(3)

revv(3)

Panera Bread at HOME(3)

Laughing Man Coffee Company(3)

Krispy Kreme Doughnuts(3)

Tim Hortons(3)

National Coffee Roasters(3)

Yuban(3)

Kahlúa(2)

Emeril's(2)

illy(2)

Chase & Sanborn(2)

BUSTELO cool(2)

Nescafe Dolce Gusto(1)

Dunkin' Donuts®(1)

Office Snax(1)

Cinnabon(1)

Chock full o'Nuts(1)

 
Quantity

36 per carton(5)

42 per carton(4)

24 per box(2)

40 per box(2)

8 per box(2)

24 per carton(1)

12 per pack(1)

96 per carton(1)

42 per box(1)

18 per carton(1)

 
Packing Type

K-Cup(225)

Bag(57)

Fraction Pack(51)

Packet(34)

Pod(31)

Can(14)

Canister(13)

Capsule(12)

Stick(10)

Filter Pack(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)

Espresso(11)

French Vanilla(11)

Dark Roast(8)

Regular(8)

Original Blend(8)

Original(7)

Italian Roast(7)

Hazelnut Creme(6)

100% Colombian(6)

Medium Roast(6)

Classic Roast Decaf(6)

Assorted(6)

Pioneer Blend(5)

House Blend Decaf(5)

Breakfast Blend Decaf(5)

Decaffeinated(5)

Colombian(5)

Black Gold(5)

Black Silk(5)

Veranda Blend(5)

Caffe Verona(5)

Pike Place Decaf(4)

Morning Blend(4)

Pike Place(4)

Major Dickason's Blend(4)

Colombian Decaf(4)

Decaf House Blend(4)

Decaf(3)

Donut Shop Regular(3)

Colombian Supremo(3)

Mocha(3)

Caribou Blend(3)

Daybreak Morning Blend(3)

Caramel(3)

Lantern Glow(3)

Dark Magic(3)

Vermont Country Blend(3)

Nantucket Blend(3)

Pumpkin Spice(3)

Vermont Country Blend Decaf(3)

Lake & Lodge(2)

Donut House(2)

Café Domingo Blend(2)

Single Origin Colombian Select(2)

Our Blend(2)

Hawaiian Blend(2)

Kahlúa Original(2)

Caramel Vanilla Cream(2)

Vanilla Hazelnut(2)

Caramel Macchiato(2)

Big Easy Bold(2)

French Vanilla Decaf(2)

Sumatra(2)

Donut House Decaf(2)

Blonde Espresso Roast(2)

Half-Caff(2)

Island Coconut(2)

Caribou Blend Decaf(2)

Mahogany(2)

Wild Mountain Blueberry(2)

Southern Pecan(2)

Hawaiian Islands Blend(2)

Latte Macchiato(2)

Chocolate Glazed Donut(2)

Morning Edition(2)

Colombia(2)

Espresso Decaf(2)

Double Black Diamond Extra Bold(2)

Hazelnut Cream(2)

Trailblazer(2)

Traditional Roast(2)

Donut Shop(2)

Butter Toffee(2)

French Roast Decaf(2)

Special Blend Extra Bold(2)

Special Decaf(2)

Organic Sumatran Extra Bold(2)

Dark Magic Extra Bold(2)

Simply Smooth(2)

Half Caff(2)

Dark Magic Decaf Extra Bold(2)

Special Roast(2)

Colombia Select(2)

Decaffeinated Medium Roast(1)

Buzzworthy (Dark Roast)(1)

French Dark Roast(1)

Original Roast Decaf(1)

Gourmet Supreme(1)

Parisian Café (Dark Roast)(1)

Breakfast Blend (Light Roast)(1)

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

Love at First Sip (Medium Roast)(1)

Parisian Vanilla(1)

100% Arabica Blend Decaf(1)

Estate Costa Rican(1)

Colombian De Jardin(1)

Crema Dolce/Medium Roast(1)

Costa Rican La Sonrisa(1)

Rotondo/Dark Roast(1)

Lungo Decaf(1)

Sumatra Mandheling(1)

Crema Aroma Arabica/Robusta(1)

Aroma Club 100% Arabica Blend(1)

Eye Opener(1)

Café con Leche(1)

Cappuccino(1)

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

Columbia(1)

Veranda(1)

Pike Place Roast(1)

Decaf Pike Place Roast(1)

Sumatran(1)

Chococino(1)

Decaf Caribou Blend(1)

Decaffeinated French Roast(1)

Special House Blend(1)

Vanilla(1)

Kona Blend(1)

Colombian Blend(1)

Medium Decaf(1)

Estilo Espresso(1)

Dukale's Blend(1)

Café con Leche Chocolate(1)

Vanilla Latte Macchiato(1)

Kenya Highlands(1)

Signature Blend(1)

Colombia Huila(1)

Extra Bold Breakfast Blend(1)

Morning Café(1)

Lively Colombian Decaf(1)

Dunkin' Decaf(1)

Caramel Drizzle(1)

Big Bang(1)

Vanilla Biscotti(1)

Lively Colombian(1)

Decaf Italian Roast(1)

Dunkin' Dark(1)

Caramel Coffee Cake(1)

Brazil Minas Naturais(1)

TURBOCHARGER(1)

Original Decaf(1)

Cinnamon Roll(1)

Coconut Mocha(1)

Holiday Blend(1)

Classic Decaf(1)

Classic(1)

Gran Aroma(1)

Perfetto(1)

Toasted Marshmallow Mocha(1)

Signature Blend Decaf(1)

Dark Royal(1)

AFTERBURNER(1)

Morning Edition Decaf(1)

Sumatra Reserve(1)

Decaf Classic(1)

Costa Rica Paraiso(1)

Columbia Select Single Origin(1)

Special Blend(1)

Dark(1)

Original Roast(1)

Colombian Huila(1)

Light Roast(1)

Dark Blend(1)

Round the Clock Blend(1)

Cinnamon(1)

Premium Roast Decaf(1)

Rio Blend(1)

Premium Roast(1)

Peppermint Bark(1)

Country Roast(1)

Pioneer Blend Decaf(1)

Caramel Hideaway(1)

Traditional Roast Decaf(1)

Bold 1937(1)

NO SURRENDER(1)

Cafe Vanilla(1)

100% Colombian Decaf(1)

Donut Shop Blend(1)

Regular Roast(1)

 
Beverage Type

Coffee(389)

Decaffeinated Coffee(70)

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)

30400(1)

302742(1)

30220(1)

302142(1)

30210(1)

30200(1)

PB4141CT(1)

PB1141(1)

PB1036CT(1)

PB1036(1)

8784(1)

8338(1)

8287(1)

308042(1)

8087(1)

8007(1)

7999(1)

7996(1)

7995(1)

7994(1)

7993(1)

7843(1)

7792CT(1)

7792(1)

7791(1)

7790(1)

30800(1)

39930274021(1)

7732CT(1)

953(1)

04648PLT(1)

04648CT(1)

04648(1)

75424(1)

75421(1)

75416(1)

75415(1)

75413(1)

75412(1)

75411(1)

75410(1)

970(1)

910(1)

39930404021(1)

4483(1)

4202(1)

2709(1)

1450(1)

0603(1)

0470(1)

0460(1)

705024(1)

70500(1)

70400(1)

60000(1)

40300(1)

7746(1)

7732(1)

390390(1)

6990CT(1)

7134(1)

7120(1)

7000(1)

6999CT(1)

6999(1)

6996(1)

6995CT(1)

6995(1)

6994CT(1)

6994(1)

6992CT(1)

6992(1)

6990(1)

71550(1)

6974(1)

6873(1)

6813(1)

6812(1)

6803CT(1)

6803(1)

6792CT(1)

6792(1)

6783CT(1)

6783(1)

6772CT(1)

6772(1)

7139(1)

7428(1)

7677(1)

7573(1)

7615(1)

7614(1)

7608(1)

7607(1)

7605(1)

7602CT(1)

7602(1)

7596(1)

7595(1)

7594(1)

7586(1)

7585(1)

7571(1)

7465(1)

7569(1)

7568(1)

7567(1)

7564(1)

7563(1)

7534CT(1)

7534(1)

7522CT(1)

7522(1)

7468(1)

7467(1)

7466(1)

04658(1)

862400(1)

6758(1)

011111157CT(1)

11015640(1)

11008131(1)

11008130(1)

011111162(1)

011111161CT(1)

011111161(1)

011111160CT(1)

011111160(1)

011111159CT(1)

011111159(1)

011111158CT(1)

011111158(1)

011111156CT(1)

11017860EA(1)

011111156(1)

504918(1)

504917(1)

504916(1)

504915(1)

504914(1)

504913(1)

504874(1)

501677(1)

501619(1)

501546(1)

501487(1)

11017854(1)

11017871(1)

500350(1)

11028473(1)

863070(1)

04707(1)

1261330(1)

11008560(1)

11008558(1)

11008556(1)

11008554(1)

1092836(1)

11075823(1)

11075822(1)

11029358(1)

11028510(1)

11023061(1)

11018131(1)

11020676(1)

11019881(1)

11019880(1)

11019631(1)

11018197(1)

11018194(1)

11018193(1)

11018192(1)

11018190(1)

11018187(1)

11018186(1)

11018185(1)

500705(1)

39003(1)

866150(1)

66488CT(1)

94333BX(1)

94333(1)

94273BX(1)

94273(1)

94245BX(1)

94245(1)

94142BX(1)

94142(1)

87066(1)

86073(1)

77317(1)

69749(1)

66488(1)

01027(1)

32486(1)

27376(1)

27329(1)

15782CT(1)

15782(1)

02430(1)

026530(1)

026480(1)

026260(1)

026190(1)

026160(1)

866350(1)

00058(1)

01084(1)

39002(1)

25183(1)

39001(1)

39000(1)

33750(1)

33700(1)

33300(1)

32006(1)

32003(1)

25188(1)

25187(1)

25186(1)

25185(1)

25184(1)

25182(1)

01096(1)

25181(1)

23005(1)

23004(1)

23003(1)

23002(1)

23001(1)

22005(1)

22002(1)

21001(1)

33000(1)

32410(1)

01101(1)

6758CT(1)

6746(1)

008711(1)

21513(1)

60517(1)

60516EA(1)

60516(1)

60515EA(1)

60515(1)

60514EA(1)

60514(1)

60513EA(1)

60513(1)

56376(1)

56375(1)

52320(1)

21512(1)

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

60517EA(1)

60518EA(1)

11545BX(1)

0845(1)

192519CT(1)

192519(1)

192419CT(1)

192419(1)

1281(1)

1280(1)

1279(1)

0995(1)

0849(1)

0848(1)

0847(1)

0846(1)

0570(1)

63006(1)

0448(1)

0162(1)

0040(1)

0038(1)

0037(1)

0036(1)

63104(1)

63103(1)

63102(1)

63101(1)

63100CT(1)

63100(1)

20421CT(1)

11545(1)

192619CT(1)

8177(1)

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

00518X(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)

00374EA(1)

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

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

6745(1)

6543(1)

6611CT(1)

6611(1)

6606CT(1)

6606(1)

6602CT(1)

6602(1)

6570CT(1)

6570(1)

6547(1)

6546(1)

6545(1)

6544(1)

6542(1)

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

6612(1)

6613CT(1)

6408(1)

6700(1)

6744(1)

6743CT(1)

6743(1)

6732CT(1)

6732(1)

6728(1)

6727(1)

6722CT(1)

6722(1)

6720CT(1)

6720(1)

6700CT(1)

6694CT(1)

6614(1)

6694(1)

6685CT(1)

6685(1)

6680(1)

6664(1)

6663CT(1)

6663(1)

6662(1)

6661(1)

6659(1)

6624(1)

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

4092(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(394)

CA(57)

GB(12)

IT(10)

United States(2)

AX(1)

Spain(1)

ES(1)

 
Weight (Approximate)

11.90 oz(1)

 
For Use With

Keurig K-Cup System(223)

Commercial Coffee Brewers(27)

Drip Coffee Brewers(14)

Single Cup Brewers(9)

Pod Brewers(9)

Dolce Gusto Coffee Machine(8)

Standard Coffee Brewers(8)

NESCAFÉ Dolce Gusto Machines(5)

Single Cup Brewers Hamilton, Bunn and Newco(4)

Lavazza 2312 BLUE Machine(3)

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

Standard and Commercial Coffee Makers(2)

Keurig Brewing System(2)

LavAzza Espresso Point Machine(2)

1/2-Gallon Brewers(1)

Pod Espresso Brewer(1)

Any traditional coffee maker(1)

LavAzza Espresso Point Machine (sold separately)(1)

 
Capacity (Volume)

0.38 oz(4)

0.27 oz(3)

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

2 oz(14)

2.2 oz(12)

12 oz(12)

18 oz(9)

0.4 oz(6)

0.35 oz(6)

0.9 oz(6)

0.06 oz(4)

0.12 oz(4)

1.4 oz(4)

28 oz(3)

1.1 oz(3)

30.5 oz(3)

30.6 oz(3)

0.25 oz(3)

1.75 oz(3)

10 oz(3)

0.31 oz(2)

1.2 oz(2)

8 g(2)

32 oz(2)

24.2 oz(2)

0.6 oz(2)

2.5 lbs(2)

22.6 oz(2)

8 oz(2)

0.1 oz(2)

25.4 oz(2)

31.1 oz(2)

7 g(2)

1.05 oz(2)

2 oz.(1)

34.5 oz(1)

1.25 oz(1)

2.25 oz(1)

45 oz(1)

0.33 oz(1)

33.9 oz(1)

29.3 oz(1)

9 g(1)

2.2 lbs(1)

5 lb(1)

16 oz(1)

0.8(1)

0.8 oz(1)

48 oz(1)

36 oz(1)

31 oz(1)

 
Serve Type

K-Cup(2)

Pod(1)

 
Coffee Type

Caffeinated(1)

Regular(1)

 
Roast Type

Medium(143)

Dark(106)

Light(55)

Dark Roast(3)

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

 
Packaged Quantity

24 / Box(2)

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)

Sumatra(1)

 
Coffee Roast Level

Medium(2)

Dark(1)

 
 
 

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