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`.`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(68)

Folgers(58)

Starbucks(29)

Lavazza(27)

Marley Coffee(20)

Peet's Coffee & Tea(19)

Tully's Coffee(18)

Day to Day Coffee(16)

PapaNicholas Coffee(14)

Mighty Leaf Tea(10)

Barista Prima Coffeehouse(9)

Maxwell House(9)

Eight O'Clock(9)

Green Mountain Coffee Roasters(9)

Java One(9)

Café Bustelo(8)

The Original Donut Shop(8)

Caribou Coffee(8)

Gloria Jean's(8)

Melitta(8)

Donut House(6)

Green Mountain Coffee Coffeehouse(6)

Dunkin Donuts(6)

Distant Lands Coffee(6)

Timothy's World Coffee(6)

Seattle's Best(5)

Newman's Own Organics(5)

New England Coffee(5)

National Coffee Roasters(5)

Nescafé(4)

Hills Bros.(4)

Coffee-mate(4)

Café Escapes(4)

Coffee People(4)

Diedrich Coffee(4)

Gevalia(4)

Chase & Sanborn(3)

Panera Bread(3)

Yuban(3)

Emeril's(2)

VERSANTO(2)

BUSTELO cool(2)

Van Houtte(2)

revv(2)

Kahlúa(2)

GFIC(2)

Krispy Kreme Doughnuts(2)

Office Snax(2)

Chock full o'Nuts(1)

Cinnabon(1)

PapaNicholas(1)

 
Quantity

24 per box(111)

96 per carton(61)

1 each(60)

42 per carton(34)

18 per box(29)

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)

40 per carton(6)

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

50 per carton(5)

16 per box(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)

9 per box(3)

24 per box.(3)

60 per carton(3)

8 per box(2)

40 per box(2)

12 per pack(2)

200 per carton(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(195)

Bag(49)

Fraction Pack(48)

Pod(40)

Packet(32)

Can(14)

Canister(13)

Filter Pack(11)

Filterbag(10)

Stick(8)

Cartridges(6)

Lavazza BLUE Capsule(6)

Vue Pack(5)

Portion Pack(5)

Pump Bottle(4)

Vacket Pack(3)

Vacuum Bag(3)

Brick Pack(2)

Jar(1)

Pouch(1)

Coffee Pod(1)

Travel Mug Vue Pack(1)

 
Flavor

French Roast(23)

Breakfast Blend(16)

House Blend(15)

Classic Roast(12)

Original Blend(10)

French Vanilla(10)

Hazelnut(10)

Espresso(9)

Regular(8)

Italian Roast(7)

Dark Roast(6)

Original(6)

Classic Roast Decaf(6)

Assorted(6)

Decaffeinated(5)

Black Silk(5)

Colombian(4)

Breakfast Blend Decaf(4)

Pike Place Decaf(4)

100% Colombian(4)

Major Dickason's Blend(4)

Classic Roast Regular(4)

Medium Roast(4)

Decaf House Blend(4)

Veranda Blend(3)

Colombia(3)

Morning Blend(3)

Decaf(3)

Vermont Country Blend Decaf(3)

Vermont Country Blend(3)

Arabica Blend(3)

Colombian Decaf(3)

Nantucket Blend(3)

House Blend Decaf(3)

Simmer Down Swiss Water Decaf(3)

Get Up, Stand Up(3)

Jamaica Blue Mountain Blend(3)

Morning Café(3)

One Love(3)

French Vanilla Decaf(2)

Mahogany(2)

Light Roast(2)

Cafe Mocha(2)

Kahlúa Original(2)

Colombian Supremo(2)

Colombian Fair Trade Select(2)

Caribou Blend(2)

Cappuccino(2)

Vanilla Latte(2)

Half-Caff(2)

Caribou Blend Decaf(2)

Kona Blend(2)

Daybreak Morning Blend(2)

Buffalo Soldier(2)

Wild Mountain Blueberry(2)

Lively Up(2)

Butter Toffee(2)

Chocolate Glazed Donut(2)

Island Coconut(2)

Hawaiian Blend(2)

Caramel Vanilla Cream(2)

Our Blend(2)

Mocha Nut Fudge(2)

Salted Caramel Macchiato(2)

Mocha(2)

Southern Pecan(2)

Lake & Lodge(2)

Café Domingo Blend(2)

Donut House(2)

Hazelnut Decaf(2)

Kenyan AA(2)

Emeril's Big Easy Bold(2)

Caffè Verona(2)

Pikes Place(2)

High Octane Premium(2)

Special Roast(2)

Donut Shop Decaf(2)

Pike Place(2)

Filtro Classico Medium Roast(2)

Gran Filtro Dark Roast(2)

Simply Smooth(2)

Half Caff(2)

Country Roast(2)

Gran Filtro Light Roast(2)

French Roast Decaf(2)

Hazelnut Créme(2)

Organic Sumatran Extra Bold(2)

Black Tiger Extra Bold(2)

Dark Magic Extra Bold(2)

Double Black Diamond Extra Bold(2)

Dark Magic Decaf Extra Bold(2)

Donut Shop(2)

Donut House Decaf(2)

Jet Fuel(2)

Newman's Own Special Blend Extra Bold(2)

Hawaiian Islands Blend(2)

Newman's Own Special Decaf(2)

Mudslide(2)

Hazelnut Crème(2)

Parisian Vanilla(1)

Ricco/Dark Roast(1)

Crema Dolce/Light Roast(1)

Hazelnut Cream (Hazelnut)(1)

Love at First Sip (Medium Roast)(1)

Chamomile Citrus(1)

Organic Mint Melange(1)

Bombay Chai(1)

Green Tea Tropical(1)

Organic Breakfast(1)

Parisian Café (Dark Roast)(1)

Breakfast Blend (Light Roast)(1)

Buzzworthy (Dark Roast)(1)

Organic Spring Jasmine(1)

Organic Earl Grey(1)

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

White Orchard(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)

Sumatra(1)

Decaf Colombian(1)

Talkin' Blues Jamaica Blue Mountain(1)

Mystic Morning(1)

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

Lively Up!(1)

Cherry Lemon Green Tea(1)

Original Roast Decaf(1)

Eye Opener(1)

Hazelnut Creme(1)

Donut Blend(1)

Decaffeinated French Roast(1)

Special House Blend(1)

Rotondo/Dark Roast(1)

Wild Berry Hibiscus(1)

Rio Blend(1)

Rainforest Espresso(1)

Cinnamon Pastry(1)

German Chocolate Cake(1)

Italian Blend(1)

Mocha Swirl(1)

Lively Colombian Decaf(1)

Extra Bold Breakfast Blend(1)

Fair Trade Organic Breakfast Blend(1)

Cinnamon Sugar Cookie(1)

Vanilla Hazelnut Decaf(1)

Signature Blend Decaf(1)

Dark Royal(1)

Signature Blend(1)

Original Roast(1)

Raspberry Chocolate Truffle(1)

Hazelnut Cream(1)

Dark(1)

Café con Leche(1)

Medium(1)

French Vanilla Cruller(1)

Medium Decaf(1)

Cinnamon Coffee Cake(1)

Café con Leche Chocolate(1)

Gourmet Supreme(1)

100% Colombian Regular(1)

100% Colombian Decaf(1)

Traditional Roast Decaf(1)

Regular Traditional Roast(1)

Traditional Roast(1)

Summer Sunrise(1)

Coconut Mocha(1)

Costa Rican La Sonrisa(1)

Sumatra Mandheling(1)

Colombian De Jardin(1)

Estate Costa Rican(1)

Decaf Italian(1)

Sumatran Reserve(1)

Aroma Point Blue Arabica/Robusta(1)

Crema Aroma Arabica/Robusta(1)

Decaffeinated Medium Roast(1)

Intenso/Medium Roast(1)

Espresso Roast(1)

100% Arabica Blend Decaf(1)

Aroma Club 100% Arabica Blend(1)

Tierra 100% Arabica Blend(1)

Decaf Extra Bold(1)

Regular Extra Bold(1)

Decaf Italian Roast(1)

Lively Colombian(1)

Brazil Minas Naturais(1)

Original Decaf(1)

Cinnamon Roll(1)

Toasted Marshmallow Mocha(1)

Vanilla Biscotti(1)

Caramel Drizzle(1)

Vanilla(1)

Caramel(1)

Pumpkin Spice(1)

Morning Edition Decaf(1)

Morning Edition(1)

Rotondo/Dark Roast Double(1)

 
Beverage Type

Coffee(386)

Decaffeinated Coffee(51)

Tea(10)

Instant Coffee(3)

Coffee Pod(3)

Coffee Drink(2)

Half-caffeinated Coffee(2)

Decaffeinated Instant Coffee(1)

 
Manufacturer Part Number

4066(2)

970(1)

75410(1)

960(1)

950(1)

953(1)

75411(1)

75412(1)

75424(1)

40001(1)

75421(1)

75416(1)

75413(1)

75415(1)

940(1)

7512(1)

2850(1)

2851(1)

2709(1)

2440(1)

2410(1)

2431(1)

3302(1)

4202(1)

7511(1)

40002(1)

7510(1)

7509(1)

4483(1)

910(1)

40003(1)

02448(1)

02561(1)

02424(1)

02400(1)

02370(1)

02394(1)

02592(1)

02875(1)

02967(1)

20031(1)

02943(1)

02905(1)

02882(1)

02363(1)

02233(1)

40016(1)

40018(1)

40008(1)

40005(1)

40004(1)

40027(1)

40028(1)

02141(1)

02226(1)

02127(1)

02103(1)

02097(1)

2401(1)

1450(1)

7534CT(1)

7602(1)

7534(1)

7522CT(1)

6999CT(1)

7522(1)

7602CT(1)

7732(1)

9300(1)

9319(1)

7792CT(1)

7792(1)

7732CT(1)

6999(1)

6995CT(1)

6812(1)

6813(1)

6803CT(1)

6803(1)

6792(1)

6792CT(1)

6990(1)

6990CT(1)

6994CT(1)

6995(1)

6994(1)

6992CT(1)

6992(1)

9335(1)

9341(1)

70400(1)

70500(1)

60000(1)

4097(1)

40300(1)

4073(1)

705024(1)

0425(1)

0490(1)

0603(1)

0470(1)

0460(1)

0427(1)

39930404021(1)

39930274021(1)

PB4141CT(1)

30200(1)

PB4141(1)

9373(1)

9371(1)

30210(1)

302142(1)

30800(1)

308042(1)

30400(1)

302742(1)

30220(1)

04648(1)

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

85107(1)

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

85106(1)

85105(1)

86073(1)

00034(1)

83426(1)

66488(1)

47337(1)

50930(1)

00058(1)

01027(1)

02059(1)

32410(1)

01101(1)

01096(1)

01084(1)

32486(1)

15782(1)

862400(1)

866150(1)

395680(1)

395640(1)

04658(1)

390390(1)

866350(1)

026160(1)

026530(1)

11062(1)

026480(1)

026260(1)

026190(1)

32420(1)

33000(1)

32003(1)

32006(1)

25188(1)

25187(1)

25185(1)

25186(1)

33700(1)

33750(1)

39003(1)

85104(1)

39002(1)

39001(1)

39000(1)

25184(1)

25183(1)

22005(1)

23001(1)

22003(1)

22002(1)

21001(1)

23002(1)

23003(1)

25181(1)

25182(1)

24001(1)

23005(1)

23004(1)

6783CT(1)

6783(1)

0162(1)

0243(1)

72909(1)

63104(1)

63102(1)

63103(1)

0316(1)

0448(1)

0847(1)

0848(1)

0846(1)

0845(1)

0570(1)

63101(1)

63100CT(1)

20540(1)

20540CT(1)

20527CT(1)

20527(1)

20513(1)

20513CT(1)

20631(1)

20631CT(1)

63018(1)

63100(1)

63015(1)

63006(1)

52320(1)

0849(1)

T11000(1)

192519CT(1)

192619(1)

192519(1)

192419CT(1)

1135(1)

192419(1)

192619CT(1)

192719(1)

193019(1)

193019CT(1)

192919CT(1)

192919(1)

192719CT(1)

1120(1)

1113(1)

T11004(1)

T11005(1)

T11003(1)

T11002(1)

T11001(1)

T11006(1)

T11007(1)

1102(1)

1109(1)

1101(1)

T11009(1)

T11008(1)

20421PL(1)

20421EA(1)

8599961590(1)

320820(1)

599961590(1)

2299961590(1)

1099961590(1)

22499961590(1)

320840(1)

00016(1)

00374CT(1)

00374EA(1)

00055(1)

00050(1)

00019(1)

60224101CT(1)

60224-101(1)

60051052CT(1)

60051-056(1)

60051-052(1)

60051046CT(1)

60051012CT(1)

60051-046(1)

60051056CT(1)

60052-101(1)

60052-107(1)

60052107CT(1)

60052103CT(1)

60052-103(1)

60052101CT(1)

006546(1)

01014(1)

06927(1)

06930(1)

06922(1)

06898(1)

06547(1)

06897(1)

06931(1)

10107(1)

20121CT(1)

20421CT(1)

20121(1)

11248(1)

10117(1)

06451(1)

06437(1)

01720CT(1)

0529CPL(1)

01720(1)

01501(1)

01500(1)

06114(1)

06119(1)

06430(1)

06433(1)

06239(1)

06125(1)

06122(1)

4050(1)

4050CT(1)

6606(1)

6606CT(1)

6602CT(1)

6602(1)

6570(1)

6570CT(1)

6611(1)

6611CT(1)

6614(1)

6614CT(1)

6613CT(1)

6613(1)

6612(1)

6547(1)

6546(1)

6520CT(1)

6523(1)

6520(1)

6503CT(1)

6502CT(1)

6503(1)

6523CT(1)

6534(1)

6544(1)

6545(1)

6543(1)

6542(1)

6534CT(1)

6624(1)

6659(1)

6744(1)

6745(1)

6743(1)

6732CT(1)

6722CT(1)

6732(1)

6746(1)

6752(1)

6772CT(1)

T6774(1)

6772(1)

6758(1)

6752CT(1)

6722(1)

6720CT(1)

6663CT(1)

6680(1)

6663(1)

6662(1)

6661(1)

6685(1)

6685CT(1)

6700CT(1)

6720(1)

6700(1)

6694CT(1)

6694(1)

6502(1)

6501CT(1)

4493(1)

4792(1)

4461(1)

4441(1)

4426(1)

4432(1)

5161(1)

5303(1)

5469(1)

5470(1)

5339(1)

5305(1)

5304(1)

4162(1)

4067CT(1)

4057CT(1)

4060(1)

4057(1)

4051CT(1)

4051(1)

4060CT(1)

4061(1)

4066CT(1)

4067(1)

4062CT(1)

4062(1)

4061CT(1)

5471(1)

5475(1)

6336(1)

6405(1)

6305(1)

6248(1)

T6204(1)

T6205(1)

6405CT(1)

6406(1)

6425(1)

6501(1)

6408(1)

6407(1)

6406CT(1)

6115(1)

6111(1)

5477(1)

5477CT(1)

5476CT(1)

5476(1)

5475CT(1)

5814(1)

6003(1)

6107(1)

6110(1)

6106(1)

6024(1)

6003CT(1)

60051-012(1)

 
Country of Origin

US(235)

CA(182)

IT(27)

CN(6)

CO(3)

EG(2)

United States(1)

JM(1)

MA(1)

IN(1)

 
For Use With

Keurig Brewing System(195)

Drip Coffee Brewers(16)

Commercial Coffee Brewers(14)

Commercial Brewers(10)

Single Cup Brewers(9)

Pod Brewers(6)

Keurig Vue Brewing System(6)

LavAzza Espresso Point Machine (sold separately)(6)

Single Serve Pod Brewing Systems(5)

Lavazza 2312 BLUE Machine(4)

Standard Coffee Brewers(4)

Soft Pod Coffee Brewers(4)

Drip Coffee Maker; French Press(4)

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)

1.5 L(4)

12 oz(3)

10 oz(2)

8 oz(2)

8 g(1)

0.9 oz(1)

6 oz(1)

 
Capacity (Weight)

2.5 oz(32)

2 oz(17)

0.3 oz(17)

1.5 oz(16)

1 lb(13)

0.4 oz(10)

8 oz(9)

1.32 oz(9)

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)

0.75 oz(4)

12 oz(4)

0.12 oz(4)

1.4 oz(4)

2.2 lbs(4)

31.1 oz(4)

30.5 oz(3)

8 g(3)

1.1 oz(3)

1.75 oz(3)

1.5 oz.(3)

30.6 oz(2)

28 oz(2)

32 oz(2)

0.7 oz(2)

0.06 oz(2)

1.2 oz(2)

7 g(2)

1.25 oz(2)

22.6 oz(2)

25.4 oz(2)

2.5 lbs(2)

0.1 oz(2)

24.2 oz(2)

2 oz.(1)

40 oz(1)

34.5 oz(1)

26 oz(1)

33.9 oz(1)

31 oz(1)

8.8 oz(1)

0.8 oz(1)

0.08 oz(1)

0.6 oz(1)

48 oz(1)

36 oz(1)

16 oz(1)

1.05 oz(1)

1.59 oz(1)

0.32 oz(1)

9 g(1)

11.5 g(1)

0.634 oz(1)

29.3 oz(1)

 
Serve Type

K-Cup(3)

Pod(1)

 
Coffee Type

Regular(12)

Decaffeinated(2)

 
Roast Type

Medium(91)

Dark(57)

Light(38)

Dark Roast(5)

Light Roast(3)

Medium Roast(1)

 
Number of Serving Cups

1(2)

4(1)

 
Compatible Brewer

Keurig Brewer(11)

 
Coffee Quantity

18 Pod(1)

 
Product Type

Coffee(14)

 
Packaged Quantity

18 / Box(9)

24 / Box(3)

108 / Carton(1)

18 / Carton(1)

 
Flavor/Blend

Arabica(1)

Breakfast Blend(1)

Spicy Eggnog(1)

Wicked Winter Blend(1)

Holiday Blend(1)

 
Packing

Pod(1)

 
Coffee Roast Level

Medium(5)

Dark(4)

Light(3)

Regular(1)

 
 
 

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