Banner1 Banner1
 
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_12` 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

Folgers(43)

Starbucks(19)

Lavazza(17)

Day to Day Coffee(13)

Peet's Coffee & Tea(13)

PapaNicholas Coffee(10)

Java One(9)

Maxwell House(7)

Melitta(7)

Dunkin Donuts(6)

Café Bustelo(6)

Distant Lands Coffee(6)

New England Coffee(5)

Hills Bros.(4)

Seattle's Best(4)

Nescafé(4)

Yuban(3)

Folgers Simply Gourmet(3)

Panera Bread(3)

Chase & Sanborn(3)

Eight O'Clock(2)

BUSTELO cool(2)

National Coffee Roasters(2)

GFIC(1)

Coffee-mate(1)

Office Snax(1)

Chock full o'Nuts(1)

 
Quantity

1 each(44)

42 per carton(32)

18 per box(21)

14 per box(9)

18 per carton(8)

24 per box(7)

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

6 per carton(6)

40 per carton(6)

100 per box(5)

42 per box(4)

36 per carton(4)

24 per carton(4)

30 per carton(4)

50 per box(3)

60 per carton(2)

80 per box(2)

8 per box(2)

40 per box(2)

12 per pack(2)

15 per box(2)

3 per pack(1)

108 per carton(1)

200 per carton(1)

160 per carton(1)

210 per pallet(1)

4 per carton(1)

294 per pallet(1)

18 per pack(1)

150 per carton(1)

100 per carton(1)

 
Packing Type

Bag(34)

Fraction Pack(33)

Packet(30)

Pod(25)

Can(16)

Canister(12)

Filter Pack(9)

Stick(8)

Portion Pack(5)

Lavazza BLUE Capsule(3)

Cartridges(3)

Vacuum Bag(3)

Vacket Pack(3)

K-Cup(2)

Brick Pack(2)

Jar(1)

Pump Bottle(1)

 
Flavor

Classic Roast(9)

Regular(9)

House Blend(8)

Original Blend(8)

French Roast(8)

Breakfast Blend(8)

Espresso(7)

Classic Roast Decaf(6)

Black Silk(4)

100% Colombian(4)

Original(4)

Decaf House Blend(4)

Classic Roast Regular(4)

Major Dickason's Blend(3)

Morning Blend(3)

Decaffeinated(3)

French Vanilla(3)

Medium Roast(3)

Hawaiian Islands Blend(2)

Italian Roast(2)

Caffè Verona(2)

Pike Place(2)

Colombian Decaf(2)

Filtro Classico Medium Roast(2)

Colombia(2)

Dark Roast(2)

Gran Filtro Light Roast(2)

Hazelnut Créme(2)

Gran Filtro Dark Roast(2)

Hazelnut Crème(2)

Colombian Supremo(2)

Kona Blend(2)

Decaf(2)

Special Roast(2)

Half Caff(2)

Breakfast Blend Decaf(2)

Pike Place Decaf(2)

Simply Smooth(2)

Eye Opener(1)

French Dark Roast(1)

Cafe Mocha(1)

Colombian Blend(1)

Colombian(1)

Natural Vanilla(1)

Special House Blend(1)

Natural Caramel(1)

Café Domingo Blend(1)

Level 2(1)

Decaf Signature-Level 3(1)

Signature-Level 3(1)

Level 4(1)

Regular Roast(1)

Special Delivery(1)

Caramel(1)

Sumatran(1)

Sumatra(1)

Hazelnut Creme(1)

Original Roast Decaf(1)

Colombia Medium(1)

Veranda Blend(1)

Veranda(1)

Decaffeinated French Roast(1)

Parisian Vanilla(1)

Dunkin French Vanilla(1)

Dunkin Dark Roast(1)

Hazelnut(1)

Estate Costa Rican(1)

Dunkin Decaf(1)

Costa Rican La Sonrisa(1)

Colombian De Jardin(1)

Dunkin WB Original(1)

100% Colombian Decaf(1)

Café con Leche(1)

Café con Leche Chocolate(1)

Country Roast(1)

Traditional Roast(1)

100% Colombian Regular(1)

Traditional Roast Decaf(1)

Dunkin Original(1)

Sumatra Mandheling(1)

Gourmet Supreme(1)

Hazelnut Cream(1)

Buzzworthy (Dark Roast)(1)

Love at First Sip (Medium Roast)(1)

Breakfast Blend (Light Roast)(1)

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

Crema Dolce/Light Roast(1)

Rotondo/Dark Roast(1)

Aroma Club 100% Arabica Blend(1)

Crema Aroma Arabica/Robusta(1)

100% Arabica Blend Decaf(1)

Medium(1)

Decaffeinated Medium Roast(1)

Arabica Blend(1)

Natural Cinnamon(1)

 
Beverage Type

Coffee(173)

Decaffeinated Coffee(14)

Instant Coffee(3)

Coffee Drink(2)

Coffee Pod(2)

Decaffeinated Instant Coffee(1)

 
Manufacturer Part Number

32420(1)

32410(1)

33000(1)

21001(1)

22002(1)

02059(1)

01101(1)

00058(1)

01027(1)

01084(1)

01096(1)

22003(1)

23001(1)

25182(1)

25183(1)

25184(1)

25185(1)

25181(1)

24001(1)

23002(1)

23003(1)

23004(1)

23005(1)

86073(1)

83426(1)

04648(1)

04648CT(1)

04658(1)

390390(1)

75421(1)

75416(1)

75411(1)

75412(1)

75413(1)

75415(1)

395640(1)

862400(1)

026530(1)

15782(1)

32486(1)

66488(1)

026480(1)

026260(1)

866150(1)

866350(1)

026160(1)

026190(1)

25186(1)

25187(1)

11019631(1)

11018197(1)

11019880(1)

11019881(1)

11020676(1)

11018194(1)

11018193(1)

11018186(1)

11018187(1)

11018190(1)

11018192(1)

11023061(1)

11029358(1)

1014962(1)

04707(1)

863070(1)

866550(1)

11008560(1)

11008558(1)

11075822(1)

11075823(1)

11008554(1)

11008556(1)

11018185(1)

11018131(1)

39001(1)

500350(1)

500689(1)

500705(1)

39000(1)

33750(1)

25188(1)

32003(1)

32006(1)

33700(1)

501487(1)

501546(1)

504917(1)

504918(1)

11008130(1)

11008131(1)

504916(1)

504915(1)

501619(1)

501677(1)

504913(1)

504914(1)

75410(1)

970(1)

06433(1)

06430(1)

06437(1)

06451(1)

06546(1)

06239(1)

06125(1)

0529CPL(1)

06114(1)

06119(1)

06122(1)

06897(1)

06898(1)

20421CT(1)

20421EA(1)

20421PL(1)

20513(1)

10117(1)

10107(1)

06922(1)

06927(1)

06930(1)

06931(1)

0529C(1)

01720CT(1)

00016(1)

00019(1)

00050(1)

00050CT(1)

0000128(1)

0000126(1)

8599961590(1)

320820(1)

320840(1)

0000125(1)

00055(1)

00374CT(1)

01014(1)

01500(1)

01501(1)

01720(1)

00690(1)

00681(1)

00374EA(1)

00678(1)

00679(1)

00680(1)

20513CT(1)

20527(1)

0460(1)

705024(1)

0470(1)

0603(1)

1450(1)

70500(1)

70400(1)

4066(1)

4073(1)

4097(1)

60000(1)

2401(1)

2410(1)

4202(1)

4483(1)

910(1)

953(1)

3302(1)

2851(1)

2431(1)

2440(1)

2709(1)

2850(1)

40300(1)

39930404021(1)

63018(1)

63100(1)

63100CT(1)

63101(1)

63006(1)

52320(1)

20527CT(1)

20540(1)

20540CT(1)

20672(1)

63102(1)

63103(1)

30400(1)

30800(1)

308042(1)

39930274021(1)

302742(1)

30220(1)

63104(1)

30200(1)

30210(1)

302142(1)

599961590(1)

 
Country of Origin

US(175)

IT(17)

CO(3)

 
For Use With

Drip Coffee Brewers(13)

Commercial Coffee Brewers(12)

Single Cup Brewers(9)

Pod Brewers(6)

Commercial Brewers(5)

LavAzza Espresso Point Machine (sold separately)(3)

Lavazza 2312 BLUE Machine(2)

Standard Coffee Brewers(2)

Single Serve Pod Brewing Systems(2)

Keurig Brewers(2)

1/2-Gallon Brewers(1)

Electric Espresso Machines(1)

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

Lavazza BLUE Single-Cup Brewing System(1)

 
Capacity (Volume)

12 oz(3)

10 oz(2)

8 oz(2)

1.5 L(1)

8 g(1)

25.1 oz(1)

0.9 oz(1)

 
Capacity (Weight)

2.5 oz(26)

0.3 oz(16)

2 oz(15)

1 lb(13)

1.5 oz(13)

0.9 oz(7)

0.35 oz(6)

10 oz(6)

2.25 oz(4)

2.2 lbs(4)

0.12 oz(4)

1.4 oz(4)

1.1 oz(3)

0.25 oz(3)

1.5 oz.(3)

30.5 oz(3)

20 oz(3)

1.75 oz(3)

1.25 oz(2)

1.2 oz(2)

22.6 oz(2)

0.06 oz(2)

0.1 oz(2)

31.1 oz(2)

48 oz(2)

24.2 oz(2)

25.4 oz(2)

32 oz(2)

28 oz(2)

30.6 oz(2)

31 oz(1)

40 oz(1)

34.5 oz(1)

26 oz(1)

33.9 oz(1)

8 oz(1)

0.8 oz(1)

0.08 oz(1)

0.6 oz(1)

18.4 oz(1)

36 oz(1)

20.8 oz(1)

16 oz(1)

1.05 oz(1)

9 g(1)

29.3 oz(1)

8 g(1)

7 g(1)

8.8 oz(1)

0.7 oz(1)

 
Roast Type

Medium(22)

Dark(7)

Light Roast(3)

Dark Roast(1)

Medium Roast(1)