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') 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`.`desc_short` LIKE 'Coffee%' THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`desc_long` LIKE 'Coffee%' THEN 1 ELSE 0 END DESC, 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(77)

Folgers(58)

Starbucks(29)

Lavazza(27)

Peet's Coffee & Tea(19)

Tully's Coffee(18)

Marley Coffee(17)

Day to Day Coffee(16)

Barista Prima Coffeehouse(10)

Mighty Leaf Tea(10)

PapaNicholas Coffee(10)

Maxwell House(9)

Eight O'Clock(9)

Java One(9)

The Original Donut Shop(8)

Melitta(8)

Caribou Coffee(8)

Gloria Jean's(8)

Café Bustelo(8)

Donut House(6)

Green Mountain Coffee Coffeehouse(6)

Timothy's World Coffee(6)

Distant Lands Coffee(6)

Dunkin Donuts(6)

Newman's Own Organics(5)

National Coffee Roasters(5)

New England Coffee(5)

Seattle's Best(5)

Nescafé(4)

Hills Bros.(4)

Café Escapes(4)

Coffee People(4)

Diedrich Coffee(4)

Gevalia(4)

Yuban(3)

Panera Bread(3)

Chase & Sanborn(3)

Coffee-mate(3)

VERSANTO(2)

BUSTELO cool(2)

Kahlúa(2)

Van Houtte(2)

Emeril's(2)

revv(2)

Office Snax(2)

Krispy Kreme Doughnuts(2)

GFIC(2)

Cinnabon(1)

Chock full o'Nuts(1)

 
Quantity

24 per box(114)

96 per carton(61)

1 each(57)

18 per box(35)

42 per carton(34)

15 per box(15)

100 per box(11)

22 per box(11)

14 per box(9)

12 per box(9)

18 per carton(9)

36 per carton(9)

6 per carton(8)

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

50 per carton(5)

16 per box(5)

40 per carton(5)

88 per carton(5)

100 per carton(4)

30 per carton(4)

42 per box(4)

24 per carton(3)

50 per box(3)

200 per carton(3)

24 per box.(3)

60 per carton(3)

9 per box(3)

8 per box(2)

40 per box(2)

12 per pack(2)

80 per box(2)

63 per carton(1)

18 per pack(1)

3 per pack(1)

108 per carton(1)

210 per pallet(1)

96 per box(1)

160 per carton(1)

4 per carton(1)

150 per carton(1)

294 per pallet(1)

1 bag(1)

 
Packing Type

K-Cup(198)

Fraction Pack(48)

Bag(47)

Pod(35)

Packet(32)

Can(14)

Canister(13)

Filter Pack(11)

Filterbag(10)

Bolt Pack(10)

Stick(8)

Lavazza BLUE Capsule(6)

Vue Pack(6)

Cartridges(6)

Portion Pack(5)

Pump Bottle(3)

Vacket Pack(3)

Vacuum Bag(3)

Brick Pack(2)

Pouch(1)

Coffee Pod(1)

Travel Mug Vue Pack(1)

Jar(1)

 
Flavor

French Roast(23)

Breakfast Blend(17)

House Blend(15)

Classic Roast(12)

French Vanilla(11)

Original Blend(10)

Hazelnut(10)

Regular(9)

Espresso(9)

Italian Roast(9)

Original(6)

Dark Roast(6)

Assorted(6)

Classic Roast Decaf(6)

Decaffeinated(5)

Medium Roast(5)

Black Silk(5)

Classic Roast Regular(4)

Decaf House Blend(4)

Colombian(4)

Breakfast Blend Decaf(4)

100% Colombian(4)

Pike Place Decaf(4)

Major Dickason's Blend(4)

Vermont Country Blend(4)

Colombian Decaf(3)

Morning Blend(3)

Arabica Blend(3)

House Blend Decaf(3)

French Roast Decaf(3)

Decaf(3)

Morning Café(3)

One Love(3)

Simmer Down Swiss Water Decaf(3)

Vermont Country Blend Decaf(3)

Veranda Blend(3)

Get Up, Stand Up(3)

Nantucket Blend(3)

Colombia(3)

Donut House(2)

Café Domingo Blend(2)

Butter Toffee(2)

Lake & Lodge(2)

Light Roast(2)

Mocha(2)

Wild Mountain Blueberry(2)

Chocolate Glazed Donut(2)

Southern Pecan(2)

Our Blend(2)

Mahogany(2)

Caramel Vanilla Cream(2)

Mocha Nut Fudge(2)

Hawaiian Blend(2)

Donut House Decaf(2)

Kona Blend(2)

Buffalo Soldier(2)

Jamaica Blue Mountain Blend(2)

Filtro Classico Medium Roast(2)

Hawaiian Islands Blend(2)

High Octane Premium(2)

Emeril's Big Easy Bold(2)

Pike Place(2)

Caffè Verona(2)

Pikes Place(2)

Gran Filtro Dark Roast(2)

Gran Filtro Light Roast(2)

Colombian Fair Trade Select(2)

Half-Caff(2)

Caribou Blend Decaf(2)

Daybreak Morning Blend(2)

French Vanilla Decaf(2)

Hazelnut Decaf(2)

Hazelnut Créme(2)

Hazelnut Crème(2)

Colombian Supremo(2)

Kahlúa Original(2)

Caribou Blend(2)

Island Coconut(2)

Double Black Diamond Extra Bold(2)

Dark Magic Decaf Extra Bold(2)

Black Tiger Extra Bold(2)

Jet Fuel(2)

Donut Shop Decaf(2)

Newman's Own Special Blend Extra Bold(2)

Newman's Own Special Decaf(2)

Kenyan AA(2)

Organic Sumatran Extra Bold(2)

Dark Magic Extra Bold(2)

Simply Smooth(2)

Donut Shop(2)

Half Caff(2)

Salted Caramel Macchiato(2)

Mudslide(2)

Country Roast(2)

Vanilla Latte(2)

Cappuccino(2)

Organic Mint Melange(1)

Gourmet Supreme(1)

2 Get Up, Stand Up; 2 Buffalo Soldier; 2 Lively Up; 2 One Love; 2 Simmer Down Decaf; 2 Smile Jamaica(1)

Special Roast(1)

White Orchard(1)

Bombay Chai(1)

Cherry Lemon Green Tea(1)

Lively Up!(1)

Wild Berry Hibiscus(1)

Lively Up(1)

Organic Spring Jasmine(1)

Chamomile Citrus(1)

Parisian Vanilla(1)

Buzzworthy (Dark Roast)(1)

Hazelnut Cream (Hazelnut)(1)

Crema Dolce/Light Roast(1)

Ricco/Dark Roast(1)

Love at First Sip (Medium Roast)(1)

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

Green Tea Tropical(1)

Organic Breakfast(1)

Café con Leche Chocolate(1)

Parisian Café (Dark Roast)(1)

Breakfast Blend (Light Roast)(1)

Organic Earl Grey(1)

Colombian Blend(1)

Veranda(1)

Columbia(1)

Colombia Medium(1)

Café Verona(1)

Cafe Verona(1)

FT Vanilla(1)

Decaf Signature-Level 3(1)

Special Delivery(1)

Regular Roast(1)

Level 4(1)

Signature-Level 3(1)

Level 2(1)

Medium Decaf(1)

Sumatra(1)

Cafe Mocha(1)

Dark(1)

Eye Opener(1)

Original Roast Decaf(1)

Mystic Morning(1)

Medium(1)

Rotondo/Dark Roast(1)

Hazelnut Creme(1)

Cinnamon Coffee Cake(1)

Decaffeinated French Roast(1)

Special House Blend(1)

French Vanilla Cruller(1)

Café con Leche(1)

Traditional Roast(1)

Morning Edition Decaf(1)

Rio Blend(1)

Morning Edition(1)

Caramel Drizzle(1)

Lively Colombian(1)

Vanilla Biscotti(1)

Pumpkin Spice(1)

Spicy Egg Nog(1)

Caramel(1)

Rainforest Espresso(1)

Vanilla(1)

Cinnamon Pastry(1)

Extra Bold Breakfast Blend(1)

Decaf Italian Roast(1)

Fair Trade Organic Breakfast Blend(1)

Coconut Mocha(1)

Cinnamon Roll(1)

Autumn Harvest Blend(1)

Wicked Winter Blend(1)

Vanilla Hazelnut Decaf(1)

Holiday Blend(1)

Toasted Marshmallow Mocha(1)

Original Decaf(1)

Original Roast(1)

Signature Blend(1)

Brazil Minas Naturais(1)

Dark Royal(1)

Signature Blend Decaf(1)

German Chocolate Cake(1)

Italian Blend(1)

Aroma Point Blue Arabica/Robusta(1)

Crema Aroma Arabica/Robusta(1)

Regular Traditional Roast(1)

Sumatra Mandheling(1)

Costa Rican La Sonrisa(1)

Traditional Roast Decaf(1)

Aroma Club 100% Arabica Blend(1)

Tierra 100% Arabica Blend(1)

Decaffeinated Medium Roast(1)

Intenso/Medium Roast(1)

Espresso Roast(1)

Cinnamon Sugar Cookie(1)

100% Arabica Blend Decaf(1)

Colombian De Jardin(1)

Estate Costa Rican(1)

Mocha Swirl(1)

Raspberry Chocolate Truffle(1)

Lively Colombian Decaf(1)

Dark Magic(1)

Colombian Decaf Fair Trade Select(1)

Hazelnut Cream(1)

Regular Extra Bold(1)

100% Colombian Decaf(1)

100% Colombian Regular(1)

Sumatran Reserve(1)

Decaf Italian(1)

Decaf Extra Bold(1)

Rotondo/Dark Roast Double(1)

 
Beverage Type

Coffee(391)

Decaffeinated Coffee(52)

Tea(10)

Instant Coffee(3)

Coffee Pod(3)

Coffee Drink(2)

Half-caffeinated Coffee(2)

Decaffeinated Instant Coffee(1)

 
Manufacturer Part Number

4066(2)

910(1)

940(1)

7512(1)

7511(1)

7509(1)

7510(1)

950(1)

953(1)

75411(1)

75412(1)

75410(1)

970(1)

960(1)

4483(1)

75413(1)

2401(1)

2410(1)

1450(1)

0603(1)

0490(1)

2431(1)

2440(1)

3302(1)

4202(1)

2851(1)

2850(1)

2709(1)

0470(1)

75416(1)

02363(1)

02370(1)

02226(1)

02141(1)

02103(1)

02127(1)

02400(1)

02424(1)

02882(1)

02905(1)

02875(1)

02592(1)

02448(1)

02097(1)

40028(1)

40001(1)

40002(1)

75424(1)

75421(1)

0460(1)

40003(1)

40004(1)

40018(1)

40027(1)

40016(1)

40008(1)

40005(1)

75415(1)

0427(1)

6999CT(1)

7522(1)

6999(1)

6995CT(1)

6994CT(1)

6995(1)

7522CT(1)

7534(1)

7732(1)

7732CT(1)

7602CT(1)

7602(1)

7534CT(1)

6994(1)

6992CT(1)

6792(1)

6792CT(1)

6783CT(1)

6783(1)

6772CT(1)

6774(1)

6803(1)

6803CT(1)

6990CT(1)

6992(1)

6990(1)

6813(1)

6812(1)

7792(1)

7792CT(1)

39930404021(1)

40300(1)

39930274021(1)

308042(1)

30400(1)

30800(1)

4073(1)

4097(1)

705024(1)

0425(1)

70500(1)

70400(1)

60000(1)

302742(1)

30220(1)

9335(1)

9341(1)

9319(1)

9315(1)

9300(1)

9371(1)

9373(1)

30210(1)

302142(1)

30200(1)

PB4141CT(1)

PB4141(1)

02943(1)

02967(1)

011067984(1)

011067984CT(1)

011067983CT(1)

011067983(1)

504917(1)

504918(1)

011067985(1)

011067985CT(1)

011067987CT(1)

011068092(1)

011067987(1)

011067986CT(1)

011067986(1)

504916(1)

504915(1)

500350(1)

500689(1)

93251(1)

93110(1)

39002(1)

39003(1)

500705(1)

501487(1)

504913(1)

504914(1)

501677(1)

501619(1)

501546(1)

011068092CT(1)

11008130(1)

11008556(1)

11008558(1)

11008554(1)

1092836(1)

11023061(1)

11029358(1)

11008560(1)

1014962(1)

863070(1)

866550(1)

04707(1)

PB4137CT(1)

PB4137(1)

11020676(1)

11019881(1)

11018186(1)

11018187(1)

11018185(1)

11018131(1)

11008131(1)

11018190(1)

11018192(1)

11019631(1)

11019880(1)

11018197(1)

11018194(1)

11018193(1)

39001(1)

39000(1)

50930(1)

66488(1)

32486(1)

15782(1)

026530(1)

11062(1)

83426(1)

86073(1)

00058(1)

01027(1)

00034(1)

NST3082(1)

NST3072(1)

026480(1)

026260(1)

04658(1)

390390(1)

04648CT(1)

04648(1)

20031(1)

395640(1)

395680(1)

026160(1)

026190(1)

866350(1)

866150(1)

862400(1)

01084(1)

01096(1)

25184(1)

25185(1)

25183(1)

25182(1)

24001(1)

25181(1)

25186(1)

25187(1)

33700(1)

33750(1)

32006(1)

32003(1)

25188(1)

23005(1)

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

6772(1)

6758(1)

63103(1)

63104(1)

63102(1)

63101(1)

63100(1)

63100CT(1)

72909(1)

0162(1)

0570(1)

0845(1)

0448(1)

0316(1)

0243(1)

63018(1)

63015(1)

20513CT(1)

20527(1)

20513(1)

20421PL(1)

20421CT(1)

20421EA(1)

20527CT(1)

20540(1)

52320(1)

63006(1)

20631CT(1)

20631(1)

20540CT(1)

0846(1)

0847(1)

192419(1)

192419CT(1)

1135(1)

1120(1)

1109(1)

1113(1)

192519(1)

192519CT(1)

192719CT(1)

192919(1)

192719(1)

192619CT(1)

192619(1)

1102(1)

1101(1)

11001(1)

11002(1)

11000(1)

0849(1)

0848(1)

11003(1)

11004(1)

11008(1)

11009(1)

11007(1)

11006(1)

11005(1)

20121CT(1)

20121(1)

22499961590(1)

2299961590(1)

1099961590(1)

60224101CT(1)

60052107CT(1)

60224-101(1)

599961590(1)

8599961590(1)

00019(1)

00050(1)

00016(1)

320840(1)

320820(1)

60052-107(1)

60052103CT(1)

60051-046(1)

60051046CT(1)

60051012CT(1)

60051-012(1)

CTP7054(1)

60051-052(1)

60051052CT(1)

60052101CT(1)

60052-103(1)

60052-101(1)

60051056CT(1)

60051-056(1)

00055(1)

00374CT(1)

06547(1)

06897(1)

06546(1)

06451(1)

06433(1)

06437(1)

06922(1)

06927(1)

10117(1)

11248(1)

10107(1)

06931(1)

06930(1)

06430(1)

06239(1)

01500(1)

01501(1)

01014(1)

006546(1)

00374EA(1)

01720(1)

01720CT(1)

06122(1)

06125(1)

06119(1)

06114(1)

0529CPL(1)

192919CT(1)

193019(1)

6570(1)

6570CT(1)

6547(1)

6546(1)

6544(1)

6545(1)

6602(1)

6602CT(1)

6611CT(1)

6612(1)

6611(1)

6606CT(1)

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

6613(1)

6613CT(1)

6722CT(1)

6732(1)

6722(1)

6720CT(1)

6700CT(1)

6720(1)

6732CT(1)

6743(1)

6752(1)

6752CT(1)

6746(1)

6745(1)

6744(1)

6700(1)

6694CT(1)

6659(1)

6661(1)

6624(1)

6614CT(1)

6614(1)

6662(1)

6663(1)

6685CT(1)

6694(1)

6685(1)

6680(1)

6663CT(1)

6425(1)

6408(1)

4432(1)

4441(1)

4426(1)

4162(1)

4067(1)

4067CT(1)

4461(1)

4493(1)

5304(1)

5305(1)

5303(1)

5161(1)

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

5339(1)

5469(1)

6206(1)

6248(1)

6205(1)

6204(1)

6110(1)

6111(1)

6305(1)

6336(1)

6406CT(1)

6407(1)

6406(1)

6405CT(1)

6405(1)

6107(1)

6106(1)

5475CT(1)

5476(1)

5475(1)

5471(1)

5470(1)

5476CT(1)

5477(1)

6003CT(1)

6024(1)

6003(1)

5814(1)

5477CT(1)

CTP6978(1)

 
Country of Origin

US(378)

CA(44)

IT(27)

CN(6)

CO(5)

EG(2)

MA(1)

IN(1)

 
For Use With

Keurig Brewing System(198)

Drip Coffee Brewers(16)

Commercial Coffee Brewers(14)

Keurig Bolt Brewers(10)

Single Cup Brewers(9)

Commercial Brewers(9)

Keurig Vue Brewing System(7)

LavAzza Espresso Point Machine (sold separately)(6)

Pod Brewers(6)

Single Serve Pod Brewing Systems(5)

Drip Coffee Maker; French Press(4)

Lavazza 2312 BLUE Machine(4)

Standard Coffee Brewers(4)

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

Lavazza BLUE Single-Cup Brewing System(1)

Lavazza BLUE 2312 and 910 Machines(1)

Standard and Commercial Coffee Makers(1)

Pod Espresso Brewer(1)

Home Brewers(1)

1/2-Gallon Brewers(1)

Any traditional coffee maker(1)

Electric Espresso Machines(1)

 
Capacity (Volume)

12 oz(3)

1.5 L(3)

10 oz(2)

8 oz(2)

8 g(1)

0.9 oz(1)

6 oz(1)

 
Capacity (Weight)

2.5 oz(32)

0.3 oz(17)

2 oz(17)

1.5 oz(16)

1 lb(13)

0.4 oz(10)

1.32 oz(9)

8 oz(7)

0.9 oz(7)

0.34 oz(6)

0.35 oz(6)

0.25 oz(5)

2.2 oz(5)

10 oz(5)

2.25 oz(4)

2.2 lbs(4)

0.12 oz(4)

12 oz(4)

1.4 oz(4)

31.1 oz(4)

8 g(3)

30.5 oz(3)

1.5 oz.(3)

1.1 oz(3)

1.75 oz(3)

30.6 oz(2)

0.06 oz(2)

0.7 oz(2)

1.2 oz(2)

1.25 oz(2)

22.6 oz(2)

32 oz(2)

24.2 oz(2)

25.4 oz(2)

28 oz(2)

2.5 lbs(2)

0.1 oz(2)

0.6 oz(2)

34.5 oz(1)

31 oz(1)

2 oz.(1)

26 oz(1)

33.9 oz(1)

40 oz(1)

8.8 oz(1)

16 oz(1)

1.05 oz(1)

0.8 oz(1)

48 oz(1)

36 oz(1)

0.25 oz.(1)

0.634 oz(1)

1.59 oz(1)

9 g(1)

11.5 g(1)

7 g(1)

29.3 oz(1)

 
Roast Type

Medium(94)

Dark(62)

Light(39)

Dark Roast(5)

Light Roast(3)

Medium Roast(1)

 
 
 

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