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_1` 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(73)

Folgers(50)

Starbucks(32)

Peet's Coffee & Tea(18)

Tully's Coffee(14)

Lavazza(14)

Maxwell House(11)

Caribou Coffee(10)

Café Bustelo(10)

1850(10)

PapaNicholas Coffee(9)

Eight O'Clock(9)

New England Coffee(8)

Dunkin Donuts(8)

The Original Donut Shop(8)

Barista Prima Coffeehouse(8)

Melitta(7)

Day to Day Coffee(7)

Java One(7)

Donut House(6)

Nescafé(6)

Newman's Own Organics(6)

Gloria Jean's(6)

NESCAFÉ Dolce Gusto(5)

Diedrich Coffee(5)

Coffee People(4)

Gevalia(4)

McCafe(4)

Café Escapes(4)

Seattle's Best(4)

Distant Lands Coffee(3)

revv(3)

Krispy Kreme Doughnuts(3)

Panera Bread at HOME(3)

Yuban(3)

Kahlúa(2)

Emeril's(2)

Laughing Man Coffee Company(2)

illy(2)

Chase & Sanborn(2)

Tim Hortons(2)

National Coffee Roasters(2)

Cinnabon(1)

Chock full o'Nuts(1)

BUSTELO cool(1)

 
Quantity

24 per box(3)

210 per pallet(1)

96 per carton(1)

42 per box(1)

 
Packing Type

K-Cup(218)

Fraction Pack(43)

Bag(30)

Pod(25)

Packet(22)

Canister(13)

Can(12)

Filter Pack(8)

Stick(8)

Capsule(5)

Portion Pack(4)

Vacket Pack(3)

Cartridges(3)

Brick Pack(2)

Lavazza BLUE Capsule(2)

Jar(1)

 
Flavor

French Roast(21)

Breakfast Blend(17)

House Blend(16)

Classic Roast(16)

Hazelnut(11)

French Vanilla(11)

Espresso(8)

Regular(8)

Hazelnut Creme(6)

Italian Roast(6)

Medium Roast(6)

Original(6)

100% Colombian(6)

Assorted(6)

Classic Roast Decaf(5)

Colombian(5)

Black Silk(5)

Pike Place Decaf(4)

Pike Place(4)

House Blend Decaf(4)

Major Dickason's Blend(4)

Dark Roast(4)

Decaffeinated(4)

Vermont Country Blend(3)

Veranda Blend(3)

Original Blend(3)

Decaf House Blend(3)

Nantucket Blend(3)

Vermont Country Blend Decaf(3)

Pumpkin Spice(3)

Donut Shop Regular(3)

Black Gold(3)

Pioneer Blend(3)

Caffe Verona(3)

Breakfast Blend Decaf(3)

Mocha(3)

Chocolate Glazed Donut(2)

Café Domingo Blend(2)

French Vanilla Decaf(2)

Donut House Decaf(2)

Single Origin Colombian Select(2)

Lake & Lodge(2)

Donut House(2)

Vanilla Hazelnut(2)

Half-Caff(2)

Caribou Blend(2)

Caribou Blend Decaf(2)

Daybreak Morning Blend(2)

Island Coconut(2)

Mahogany(2)

Our Blend(2)

Hawaiian Blend(2)

Colombia(2)

Big Easy Bold(2)

Kahlúa Original(2)

Wild Mountain Blueberry(2)

Caramel Vanilla Cream(2)

Southern Pecan(2)

Morning Edition(2)

Butter Toffee(2)

Morning Blend(2)

Dark Magic Extra Bold(2)

Lantern Glow(2)

Half Caff(2)

Colombian Supremo(2)

Hazelnut Cream(2)

Simply Smooth(2)

French Roast Decaf(2)

Hawaiian Islands Blend(2)

Special Decaf(2)

Organic Sumatran Extra Bold(2)

Special Blend Extra Bold(2)

Double Black Diamond Extra Bold(2)

Decaf(2)

Dark Magic Decaf Extra Bold(2)

Ethiopian Supreme(1)

Veranda(1)

Pike Place Roast(1)

Sumatra Mandheling(1)

Costa Rica Paraiso(1)

Sumatra Reserve(1)

Chocolate(1)

Colombia Huila(1)

Veranda Blend Blonde Roast(1)

Decaf Italian Roast(1)

Decaf Portside Blend(1)

Kenya Highlands(1)

Dukale's Blend(1)

Special Delivery(1)

Pier 70 Blend(1)

Crema Aroma Arabica/Robusta(1)

6th Avenue Bistro(1)

Portside Blend(1)

Decaf Pike Place Roast(1)

Dark Magic(1)

Aroma Club 100% Arabica Blend(1)

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

Colombian Blend(1)

Vanilla Latte Macchiato(1)

Chococino(1)

Cappuccino(1)

Lungo Decaf(1)

Eye Opener(1)

French Dark Roast(1)

Original Roast Decaf(1)

Breakfast Blend (Light Roast)(1)

Love at First Sip (Medium Roast)(1)

Colombia Medium(1)

Special House Blend(1)

Decaffeinated French Roast(1)

Sumatra(1)

Buzzworthy (Dark Roast)(1)

Parisian Vanilla(1)

Crema Dolce/Medium Roast(1)

Kona Blend(1)

Sumatran(1)

Rotondo/Dark Roast(1)

100% Arabica Blend Decaf(1)

Columbia Select Single Origin(1)

Caramel Drizzle(1)

Special Blend(1)

Donut Shop Blend(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)

Toasted Marshmallow Mocha(1)

Traditional Roast(1)

Trailblazer(1)

Pioneer Blend Decaf(1)

Country Roast(1)

Espresso Decaf(1)

Special Roast(1)

Gourmet Supreme(1)

Café con Leche(1)

Medium Decaf(1)

Vanilla(1)

Donut Shop(1)

Colombian Decaf(1)

Perfetto(1)

Dark(1)

Rio Blend(1)

Light Roast(1)

Dark Blend(1)

Round the Clock Blend(1)

Cinnamon(1)

Premium Roast Decaf(1)

Premium Roast(1)

Caramel Hideaway(1)

Bold 1937(1)

NO SURRENDER(1)

Caramel(1)

Cafe Vanilla(1)

Morning Edition Decaf(1)

Gran Aroma(1)

TURBOCHARGER(1)

AFTERBURNER(1)

Big Bang(1)

Vanilla Biscotti(1)

Lively Colombian(1)

Brazil Minas Naturais(1)

Original Decaf(1)

Cinnamon Roll(1)

Coconut Mocha(1)

Classic Decaf(1)

Classic(1)

Regular Roast(1)

 
Beverage Type

Coffee(328)

Decaffeinated Coffee(57)

Instant Coffee(6)

Half-caffeinated Coffee(4)

Latte(2)

Coffee Drink(1)

Hot Chocolate(1)

 
Manufacturer Part Number

60051-012(1)

7995(1)

8500(1)

8488(1)

8338(1)

8337(1)

8287(1)

8087(1)

8007(1)

7999(1)

7996(1)

7994(1)

8506(1)

7993(1)

7792CT(1)

7792(1)

7791(1)

7790(1)

7746(1)

7732CT(1)

7732(1)

7615(1)

7614(1)

8500CT(1)

8784(1)

7607(1)

70400(1)

4483(1)

4202(1)

2709(1)

1450(1)

0603(1)

0470(1)

0460(1)

705024(1)

70500(1)

60000(1)

8997(1)

40300(1)

308042(1)

30800(1)

302742(1)

30220(1)

30200(1)

PB4141CT(1)

PB1141(1)

PB1036CT(1)

PB1036(1)

7608(1)

7605(1)

970(1)

6792(1)

6990CT(1)

6990(1)

6974(1)

6873(1)

6813(1)

6812(1)

6803CT(1)

6803(1)

6792CT(1)

6783CT(1)

6992CT(1)

6783(1)

6772CT(1)

6772(1)

6758CT(1)

6758(1)

6746(1)

6745(1)

6744(1)

6743CT(1)

6743(1)

6992(1)

6994(1)

7602CT(1)

7522CT(1)

7602(1)

7595(1)

7594(1)

7586(1)

7585(1)

7564(1)

7563(1)

7534CT(1)

7534(1)

7522(1)

6994CT(1)

7468(1)

7467(1)

7466(1)

7465(1)

7000(1)

6999CT(1)

6999(1)

6996(1)

6995CT(1)

6995(1)

953(1)

75410(1)

6732(1)

011111157CT(1)

11008131(1)

11008130(1)

011111162(1)

011111161CT(1)

011111161(1)

011111159CT(1)

011111159(1)

011111158CT(1)

011111158(1)

011111157(1)

11017854(1)

011111156CT(1)

011111156(1)

504918(1)

504917(1)

504916(1)

504915(1)

504914(1)

504913(1)

501677(1)

501619(1)

11015640(1)

11017860EA(1)

501487(1)

11023061(1)

863070(1)

04707(1)

11008560(1)

11008558(1)

11008556(1)

11008554(1)

11029358(1)

11028510(1)

11028473(1)

11020676(1)

11017871(1)

11019631(1)

11018197(1)

11018194(1)

11018193(1)

11018192(1)

11018190(1)

11018187(1)

11018186(1)

11018185(1)

11018131(1)

501546(1)

500705(1)

75411(1)

866350(1)

32486(1)

27376(1)

27329(1)

15782CT(1)

15782(1)

026530(1)

026480(1)

026260(1)

026190(1)

866150(1)

66488CT(1)

862400(1)

390390(1)

04658(1)

04648CT(1)

04648(1)

75421(1)

75416(1)

75415(1)

75413(1)

75412(1)

66488(1)

69749(1)

500350(1)

25183(1)

33750(1)

33700(1)

32006(1)

32003(1)

25188(1)

25187(1)

25186(1)

25185(1)

25184(1)

25181(1)

77317(1)

23004(1)

23003(1)

23002(1)

23001(1)

21001(1)

33000(1)

32410(1)

01096(1)

87066(1)

86073(1)

6732CT(1)

6728(1)

60051012CT(1)

60514(1)

63102(1)

63101(1)

63100CT(1)

63100(1)

63006(1)

60518(1)

60517(1)

60516(1)

60515(1)

60513(1)

63104(1)

52320(1)

21513(1)

21512(1)

21511(1)

21510(1)

20672(1)

20540CT(1)

20540(1)

20527CT(1)

20527(1)

63103(1)

0036(1)

20513(1)

1279(1)

192719CT(1)

192719(1)

192619CT(1)

192619(1)

192519CT(1)

192519(1)

192419CT(1)

192419(1)

1281(1)

0995(1)

0037(1)

0849(1)

0848(1)

0847(1)

0846(1)

0845(1)

0570(1)

0448(1)

0162(1)

0040(1)

0038(1)

20513CT(1)

20421PL(1)

192919CT(1)

599961590(1)

00518X(1)

00374EA(1)

00374CT(1)

00055(1)

00050(1)

00019(1)

00016(1)

320840(1)

320820(1)

1099961590(1)

01500(1)

8179(1)

8177(1)

7401BX(1)

7401(1)

60052101CT(1)

60052-101(1)

60051052CT(1)

60051-052(1)

60051046CT(1)

60051-046(1)

01014(1)

01720(1)

20421EA(1)

06897(1)

20421CT(1)

11545(1)

11544(1)

10117(1)

10107(1)

06931(1)

06930(1)

06927(1)

06922(1)

06546(1)

01720CT(1)

06451(1)

06437(1)

06433(1)

06430(1)

06239(1)

06125(1)

06122(1)

06114(1)

0529CPL(1)

0529C(1)

192919(1)

193019(1)

6727(1)

6534CT(1)

6602(1)

6570CT(1)

6570(1)

6547(1)

6546(1)

6545(1)

6544(1)

6543(1)

6542(1)

6534(1)

6606(1)

6523CT(1)

6523(1)

6520CT(1)

6520(1)

6503CT(1)

6503(1)

6502CT(1)

6502(1)

6501CT(1)

6501(1)

6602CT(1)

6606CT(1)

6408(1)

6685(1)

6722CT(1)

6722(1)

6720CT(1)

6720(1)

6700CT(1)

6700(1)

6694CT(1)

6694(1)

6685CT(1)

6680(1)

6611(1)

6664(1)

6663CT(1)

6663(1)

6662(1)

6661(1)

6659(1)

6613CT(1)

6613(1)

6612(1)

6611CT(1)

6425(1)

6407(1)

193019CT(1)

4067CT(1)

5161(1)

4792(1)

4757(1)

4732(1)

4493(1)

4461(1)

4441(1)

4432(1)

4162(1)

4067(1)

5304(1)

4066CT(1)

4066(1)

4061CT(1)

4061(1)

4060CT(1)

4060(1)

4051CT(1)

4051(1)

4050CT(1)

4050(1)

5303(1)

5305(1)

6406CT(1)

6106(1)

6406(1)

6405CT(1)

6405(1)

6378(1)

6305(1)

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

5471(1)

5470(1)

5469(1)

866550(1)

 
Country of Origin

US(366)

CA(17)

IT(11)

GB(4)

ES(1)

 
For Use With

Keurig K-Cup System(209)

Commercial Coffee Brewers(26)

Pod Brewers(8)

Drip Coffee Brewers(7)

Single Cup Brewers(7)

NESCAFÉ Dolce Gusto Machines(5)

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

Keurig Brewing System(4)

Standard Coffee Brewers(4)

Single Cup Brewers Hamilton, Bunn and Newco(2)

LavAzza Espresso Point Machine(2)

Standard and Commercial Coffee Makers(1)

Any traditional coffee maker(1)

LavAzza Espresso Point Machine (sold separately)(1)

Lavazza 2312(1)

Lavazza 2312 BLUE Machine(1)

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

 
Capacity (Volume)

10 oz(2)

0.38 oz(2)

48 oz(1)

8 oz(1)

25.1 oz(1)

0(1)

 
Capacity (Weight)

2.5 oz(28)

1 lb(18)

0.3 oz(14)

1.5 oz(12)

2.2 oz(10)

2 oz(8)

12 oz(6)

0.35 oz(6)

0.9 oz(6)

0.4 oz(5)

1.4 oz(4)

0.06 oz(4)

1.75 oz(3)

0.25 oz(3)

30.5 oz(3)

0.1 oz(2)

1.2 oz(2)

31.1 oz(2)

24.2 oz(2)

25.4 oz(2)

30.6 oz(2)

1.05 oz(2)

32 oz(2)

28 oz(2)

48 oz(2)

22.6 oz(2)

0.12 oz(2)

10 oz(2)

1.1 oz(2)

34.5 oz(1)

1.25 oz(1)

2.5 lbs(1)

29.3 oz(1)

8 g(1)

9 g(1)

7 g(1)

2.2 lbs(1)

8 oz(1)

0.31 oz(1)

16 oz(1)

0.8 oz(1)

0.6 oz(1)

36 oz(1)

31 oz(1)

 
Roast Type

Medium(123)

Dark(88)

Light(43)

Mild(1)

 
 
 

© 2020-2021 Office Solutions & Innovations, Inc., All Rights Reserved