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 `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 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` WHERE (`category_name` LIKE "Coffee") 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 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(64)

Starbucks(29)

Lavazza(26)

Peet's Coffee & Tea(19)

Tully's Coffee(16)

Day to Day Coffee(16)

PapaNicholas Coffee(14)

Maxwell House(9)

Eight O'Clock(9)

Barista Prima Coffeehouse(9)

Java One(9)

Melitta(8)

Gloria Jean's(8)

Caribou Coffee(8)

Café Bustelo(8)

The Original Donut Shop(8)

Wolfgang Puck(7)

Nescafé(6)

Timothy's World Coffee(6)

Marley Coffee(6)

Donut House(6)

Newman's Own Organics(5)

Distant Lands Coffee(5)

New England Coffee(5)

Gevalia(4)

Hills Bros.(4)

Seattle's Best(4)

Coffee People(4)

Coffee-mate(4)

Café Escapes(4)

Diedrich Coffee(4)

Yuban(3)

National Coffee Roasters(3)

Chase & Sanborn(3)

Panera Bread(3)

Krispy Kreme Doughnuts(2)

GFIC(2)

Green Mountain Coffee Coffeehouse(2)

VERSANTO(2)

Emeril's(2)

Van Houtte(2)

Office Snax(2)

BUSTELO cool(2)

Kahlúa(2)

revv(2)

Dunkin Donuts(1)

Cinnabon(1)

Chock full o'Nuts(1)

Quantity

24 per box(115)

96 per carton(61)

1 each(59)

18 per box(38)

42 per carton(34)

22 per box(11)

100 per box(10)

6 per carton(10)

14 per box(9)

18 per carton(9)

36 per carton(6)

40 per carton(6)

18 (Each box contains 18 packs weighing 2.5 ounces)(6)

16 per box(5)

88 per carton(5)

50 per carton(5)

100 per carton(4)

30 per carton(4)

42 per box(4)

50 per box(3)

24 per box.(3)

60 per carton(3)

24 per carton(3)

15 per box(3)

80 per box(2)

8 per box(2)

9 per box(2)

12 per pack(2)

90 per carton(1)

96 per box(1)

3 per pack(1)

63 per carton(1)

18 per pack(1)

150 per carton(1)

200 per carton(1)

4 per carton(1)

294 per pallet(1)

12 per box(1)

160 per carton(1)

108 per carton(1)

210 per pallet(1)

40 per box(1)

1 bag(1)

Packing Type

K-Cup(195)

Bag(50)

Fraction Pack(45)

Pod(38)

Packet(30)

Can(16)

Canister(13)

Filter Pack(11)

Stick(8)

Lavazza BLUE Capsule(6)

Vue Pack(5)

Cartridges(5)

Portion Pack(5)

Pump Bottle(4)

Vacuum Bag(3)

Vacket Pack(3)

Bolt Pack(3)

Jar(2)

Brick Pack(2)

Pouch(1)

Coffee Pod(1)

Travel Mug Vue Pack(1)

Flavor

French Roast(23)

Breakfast Blend(17)

House Blend(15)

Classic Roast(12)

French Vanilla(11)

Hazelnut(11)

Regular(10)

Original Blend(10)

Espresso(9)

Italian Roast(7)

Medium Roast(6)

Classic Roast Decaf(6)

Assorted(6)

Original(6)

Dark Roast(6)

Decaffeinated(5)

100% Colombian(5)

Black Silk(5)

Decaf(5)

Decaf House Blend(5)

Pike Place Decaf(4)

Breakfast Blend Decaf(4)

Major Dickason's Blend(4)

Colombian(4)

Morning Blend(3)

Nantucket Blend(3)

Veranda Blend(3)

Vermont Country Blend Decaf(3)

Vermont Country Blend(3)

Arabica Blend(3)

French Roast Decaf(3)

Colombia(3)

Vanilla Biscotti(3)

Morning Café(3)

Classic Roast Regular(3)

Daybreak Morning Blend(2)

Jet Fuel(2)

Caribou Blend Decaf(2)

Half-Caff(2)

Donut House Decaf(2)

Colombian Fair Trade Select(2)

High Octane Premium(2)

Mocha Nut Fudge(2)

Mudslide(2)

Hazelnut Decaf(2)

Donut Shop(2)

French Vanilla Decaf(2)

Pikes Place(2)

Hawaiian Islands Blend(2)

Kona Blend(2)

Café Domingo Blend(2)

Mocha(2)

Donut Shop Decaf(2)

Black Tiger Extra Bold(2)

Hawaiian Blend(2)

Our Blend(2)

Donut House(2)

Lake & Lodge(2)

Cafe Mocha(2)

Caramel Vanilla Cream(2)

Mahogany(2)

Simmer Down Swiss Water Decaf(2)

Lively Up(2)

Wild Mountain Blueberry(2)

Caribou Blend(2)

Dark Magic Decaf Extra Bold(2)

Caramel Drizzle(2)

Simply Smooth(2)

100% Colombian Decaf(2)

Emeril's Big Easy Bold(2)

Colombian Decaf(2)

Southern Pecan(2)

Filtro Classico Medium Roast(2)

Hazelnut Crème(2)

Gran Filtro Light Roast(2)

Country Roast(2)

Half Caff(2)

Hazelnut Créme(2)

Gran Filtro Dark Roast(2)

Caffè Verona(2)

Colombian Supremo(2)

Kenyan AA(2)

Newman's Own Special Decaf(2)

Organic Sumatran Extra Bold(2)

Dark Magic Extra Bold(2)

Butter Toffee(2)

Double Black Diamond Extra Bold(2)

Kahlúa Original(2)

Newman's Own Special Blend Extra Bold(2)

Chocolate Glazed Donut(2)

Pike Place(2)

Island Coconut(2)

Special Roast(2)

House Blend Decaf(2)

Hazelnut Cream (Hazelnut)(1)

Parisian Vanilla(1)

Rotondo/Dark Roast(1)

Espresso Roast(1)

100% Arabica Blend Decaf(1)

Decaffeinated Medium Roast(1)

Intenso/Medium Roast(1)

Ricco/Dark Roast(1)

Rotondo/Dark Roast Double(1)

Crema Dolce/Light Roast(1)

Eye Opener(1)

Decaf Signature-Level 3(1)

Level 2(1)

Columbia(1)

Veranda(1)

Café Verona(1)

Colombia Medium(1)

Signature-Level 3(1)

Level 4(1)

Special Delivery(1)

Regular Roast(1)

Jamaica Me Crazy(1)

Sorrento(1)

Vienna(1)

Chef's Reserve(1)

Cafe Verona(1)

Sumatra(1)

Jamaica Blue Mountain Blend(1)

Jamaica Blue Mountain(1)

Parisian Café (Dark Roast)(1)

Breakfast Blend (Light Roast)(1)

Love at First Sip (Medium Roast)(1)

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

Original Roast Decaf(1)

Tierra 100% Arabica Blend(1)

Donut Blend(1)

Decaf Colombian(1)

Hazelnut Creme(1)

Decaffeinated French Roast(1)

Colombian Blend(1)

Special House Blend(1)

Buzzworthy (Dark Roast)(1)

Caramel(1)

Medium(1)

Signature Blend(1)

Dark(1)

Café con Leche(1)

Café con Leche Chocolate(1)

Fair Trade Organic Breakfast Blend(1)

Original Roast(1)

Dark Royal(1)

Cinnamon Sugar Cookie(1)

Vanilla Hazelnut Decaf(1)

Cappuccino(1)

Vanilla Latte(1)

Signature Blend Decaf(1)

Gourmet Supreme(1)

Extra Bold Breakfast Blend(1)

Raspberry Chocolate Truffle(1)

Mocha Swirl(1)

Hazelnut Cream(1)

100% Colombian Regular(1)

Traditional Roast Decaf(1)

Lively Colombian Decaf(1)

Italian Blend(1)

Cinnamon Pastry(1)

100% Columbian(1)

Rainforest Espresso(1)

German Chocolate Cake(1)

Decaffeinated Colombian(1)

Light Roast(1)

Summer Sunrise(1)

Regular Extra Bold(1)

Decaf Extra Bold(1)

Traditional Roast(1)

Vanilla(1)

Pumpkin Spice(1)

Spicy Egg Nog(1)

Decaf Italian(1)

Sumatran Reserve(1)

Aroma Point Blue Arabica/Robusta(1)

Crema Aroma Arabica/Robusta(1)

Sumatra Mandheling(1)

Colombian De Jardin(1)

Estate Costa Rican(1)

Rio Blend(1)

Morning Edition Decaf(1)

Coconut Mocha(1)

Cinnamon Roll(1)

Autumn Harvest Blend(1)

Wicked Winter Blend(1)

Holiday Blend(1)

Toasted Marshmallow Mocha(1)

Decaf Original(1)

Lively Colombian(1)

Morning Edition(1)

Decaf Italian Roast(1)

Brazil Minas Naturais(1)

Medium Decaf(1)

Aroma Club 100% Arabica Blend(1)

Beverage Type

Coffee(390)

Decaffeinated Coffee(43)

Instant Coffee(3)

Coffee Pod(3)

Coffee, Instant(2)

Coffee Drink(2)

Half-caffeinated Coffee(2)

Decaffeinated Instant Coffee(1)

Cocoa(1)

Manufacturer Part Number

4066(2)

7510(1)

7509(1)

4483(1)

3302(1)

4202(1)

7511(1)

910(1)

960(1)

970(1)

953(1)

950(1)

940(1)

7512(1)

2851(1)

0490(1)

0603(1)

0470(1)

0460(1)

0427(1)

1450(1)

2401(1)

2709(1)

2850(1)

2440(1)

2431(1)

2410(1)

75410(1)

75411(1)

395640(1)

395680(1)

390390(1)

04658(1)

04648CT(1)

862400(1)

866150(1)

026260(1)

026480(1)

026190(1)

026160(1)

866350(1)

04648(1)

02967(1)

75416(1)

75421(1)

75415(1)

75413(1)

75412(1)

75424(1)

01810(1)

02424(1)

02394(1)

02236(1)

02127(1)

705024(1)

70500(1)

6994CT(1)

6995(1)

6994(1)

6992CT(1)

6992(1)

6995CT(1)

6999(1)

7534(1)

7534CT(1)

7522CT(1)

7522(1)

6999CT(1)

6990CT(1)

6990(1)

6774(1)

6783(1)

6772CT(1)

6772(1)

6758(1)

6783CT(1)

6792(1)

6812(1)

6813(1)

6803CT(1)

6803(1)

6792CT(1)

7602(1)

7602CT(1)

30400(1)

30800(1)

302742(1)

30220(1)

302142(1)

308042(1)

39930274021(1)

60000(1)

70400(1)

4097(1)

4073(1)

40300(1)

30210(1)

30200(1)

7792CT(1)

9300(1)

7792(1)

7732CT(1)

7732(1)

9319(1)

9335(1)

PB4141(1)

PB4141CT(1)

9373(1)

9371(1)

9341(1)

026530(1)

11062(1)

011067987CT(1)

011068092(1)

011067987(1)

011067986CT(1)

011067986(1)

011068092CT(1)

11008130(1)

11018186(1)

11018187(1)

11018185(1)

11018131(1)

11008131(1)

011067985CT(1)

011067985(1)

504914(1)

504915(1)

504913(1)

501677(1)

501619(1)

504916(1)

504917(1)

011067984(1)

011067984CT(1)

011067983CT(1)

011067983(1)

504918(1)

11018190(1)

11018192(1)

016429(1)

016430(1)

012663(1)

PB4137CT(1)

PB4137(1)

016431(1)

016434(1)

863070(1)

866550(1)

04707(1)

016447(1)

016443(1)

1014962(1)

11008560(1)

11019631(1)

11019880(1)

11018197(1)

11018194(1)

11018193(1)

11019881(1)

11020676(1)

11008556(1)

11008558(1)

11008554(1)

11029358(1)

11023061(1)

501546(1)

501487(1)

32420(1)

33000(1)

32410(1)

02059(1)

01101(1)

21001(1)

22002(1)

23002(1)

23003(1)

23001(1)

22005(1)

22003(1)

01096(1)

01084(1)

32486(1)

47337(1)

15782(1)

11386EA(1)

11386(1)

50930(1)

66488(1)

00058(1)

01027(1)

00034(1)

86073(1)

83426(1)

23004(1)

23005(1)

85104(1)

85106(1)

39003(1)

39002(1)

39001(1)

85107(1)

85108(1)

500689(1)

500705(1)

500350(1)

93251(1)

93110(1)

39000(1)

33750(1)

25183(1)

25184(1)

25182(1)

25181(1)

24001(1)

25185(1)

25186(1)

32006(1)

33700(1)

32003(1)

25188(1)

25187(1)

6752CT(1)

6746(1)

63018(1)

63100(1)

63014(1)

63006(1)

52320(1)

63100CT(1)

63101(1)

72909(1)

80018(1)

63104(1)

63103(1)

63102(1)

20631CT(1)

20631(1)

20421CT(1)

20421EA(1)

20145(1)

20136CT(1)

20136(1)

20421PL(1)

20513(1)

20540(1)

20540CT(1)

20527CT(1)

20527(1)

20513CT(1)

0162(1)

0243(1)

192419(1)

192419CT(1)

1135(1)

1120(1)

1113(1)

192519(1)

192519CT(1)

192719CT(1)

192919(1)

192719(1)

192619CT(1)

192619(1)

1109(1)

1102(1)

0845(1)

0846(1)

0570(1)

0448(1)

0316(1)

0847(1)

0848(1)

11008(1)

1101(1)

11006(1)

11001(1)

0849(1)

20121CT(1)

20121(1)

8599961590(1)

320820(1)

599961590(1)

1099961590(1)

60224101CT(1)

320840(1)

00016(1)

00374CT(1)

00374EA(1)

00055(1)

00050(1)

00019(1)

60224-101(1)

60052107CT(1)

60051-052(1)

60051052CT(1)

60051046CT(1)

60051-046(1)

60051012CT(1)

60051-056(1)

60051056CT(1)

60052103CT(1)

60052-107(1)

60052-103(1)

60052101CT(1)

60052-101(1)

01014(1)

01500(1)

06927(1)

06930(1)

06922(1)

06898(1)

06897(1)

06931(1)

10107(1)

20088CT(1)

20091(1)

20088(1)

11248(1)

10117(1)

06547(1)

06451(1)

0529CPL(1)

06114(1)

01720CT(1)

01720(1)

01501(1)

06119(1)

06122(1)

06433(1)

06437(1)

06430(1)

06239(1)

06125(1)

192919CT(1)

193019(1)

6547(1)

6570(1)

6546(1)

6545(1)

6544(1)

6570CT(1)

6602(1)

6611(1)

6611CT(1)

6606CT(1)

6606(1)

6602CT(1)

6543(1)

6542(1)

6502CT(1)

6503(1)

6502(1)

6501CT(1)

6501(1)

6503CT(1)

6520(1)

6534(1)

6534CT(1)

6523CT(1)

6523(1)

6520CT(1)

6612(1)

6613(1)

6720CT(1)

6722(1)

6720(1)

6700CT(1)

6700(1)

6722CT(1)

6732(1)

6745(1)

60051-012(1)

6744(1)

6743(1)

6732CT(1)

6694CT(1)

6694(1)

6624(1)

6659(1)

6614CT(1)

6614(1)

6613CT(1)

6661(1)

6662(1)

6685(1)

6685CT(1)

6680(1)

6663CT(1)

6663(1)

6425(1)

6408(1)

4426(1)

4432(1)

4162(1)

4067CT(1)

4067(1)

4441(1)

4461(1)

5303(1)

5304(1)

5161(1)

4792(1)

4493(1)

4066CT(1)

4062CT(1)

4051(1)

4051CT(1)

4050CT(1)

4050(1)

193019CT(1)

4057(1)

4057CT(1)

4061CT(1)

4062(1)

4061(1)

4060CT(1)

4060(1)

5305(1)

5339(1)

6206(1)

6248(1)

6205(1)

6204(1)

6115(1)

6305(1)

6336(1)

6406CT(1)

6407(1)

6406(1)

6405CT(1)

6405(1)

6111(1)

6110(1)

5476(1)

5477(1)

5471(1)

5470(1)

5469(1)

5814(1)

6003(1)

6107(1)

6106(1)

6024(1)

6003CT(1)

6752(1)

Country of Origin

US(403)

IT(26)

CO(12)

CA(3)

JP(2)

UM(1)

For Use With

Keurig Brewing System(195)

Drip Coffee Brewers(16)

Commercial Coffee Brewers(13)

Standard Coffee Brewers(10)

Commercial Brewers(10)

Single Cup Brewers(9)

Keurig Vue Brewing System(6)

Pod Brewers(6)

LavAzza Espresso Point Machine (sold separately)(5)

Soft Pod Coffee Brewers(4)

Lavazza 2312 BLUE Machine(4)

Drip Coffee Maker; French Press(4)

Keurig Bolt Brewers(3)

Single Serve Pod Brewing Systems(3)

Nescafé Alegria 510 Machine(2)

Lavazza BLUE 2312 and 910 Machines(1)

Lavazza BLUE Single-Cup Brewing System(1)

Any traditional coffee maker(1)

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

1/2-Gallon Brewers(1)

Pod Espresso Brewer(1)

Home Brewers(1)

Standard and Commercial Coffee Makers(1)

Electric Espresso Machines(1)

Capacity (Volume)

0.34 oz(6)

1.5 L(4)

12 oz(3)

8 oz(2)

10 oz(2)

1.5 oz(1)

0.9 oz(1)

8 g(1)

Capacity (Weight)

2.5 oz(30)

0.3 oz(17)

1.5 oz(16)

2 oz(15)

1 lb(13)

10 oz(11)

0.4 oz(10)

0.9 oz(7)

0.35 oz(6)

2.2 oz(5)

0.25 oz(5)

8 oz(4)

12 oz(4)

0.75 oz(4)

0.12 oz(4)

31.1 oz(4)

2.25 oz(4)

2.2 lbs(4)

1.4 oz(4)

8 g(3)

1.1 oz(3)

1.5 oz.(3)

1.75 oz(3)

30.5 oz(3)

2.5 lbs(2)

32 oz(2)

0.7 oz(2)

1.25 oz(2)

25.4 oz(2)

30.6 oz(2)

1.2 oz(2)

4.05 oz(2)

7 g(2)

0.1 oz(2)

0.06 oz(2)

22.6 oz(2)

28 oz(2)

24.2 oz(2)

2 lb(1)

40 oz(1)

36 oz(1)

26 oz(1)

31 oz(1)

34.5 oz(1)

29.3 oz(1)

0.08 oz(1)

0.8 oz(1)

16 oz(1)

1.05 oz(1)

0.634 oz(1)

0.6 oz(1)

8.8 oz(1)

0.32 oz(1)

48 oz(1)

9 g(1)

11.5 g(1)

33.9 oz(1)

Roast Type

Medium(90)

Dark(54)

Light(31)

Dark Roast(6)

Light Roast(3)

Medium Roast(1)

Mild(1)

Price Range

$0-$499.99(445)

$3000-$3499.99(1)

$4500-$4999.99(1)

To  GO

 
 
1%
Searching for your Best Results.....
 

© 2017-2018 Office Solutions & Innovations, Inc., All Rights Reserved