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_36` 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

Folgers(56)

Lavazza(27)

Starbucks(19)

Day to Day Coffee(18)

PapaNicholas Coffee(15)

Peet's Coffee & Tea(15)

Marley Coffee(14)

Wolfgang Puck(10)

Java One(9)

Melitta(8)

Maxwell House(7)

Café Bustelo(7)

Dunkin Donuts(6)

Nescafé(6)

New England Coffee(5)

Distant Lands Coffee(5)

Seattle's Best(4)

Hills Bros.(4)

Coffee-mate(4)

Millstone(4)

Yuban(3)

Folgers Simply Gourmet(3)

Chase & Sanborn(3)

Panera Bread(3)

National Coffee Roasters(3)

GFIC(2)

VERSANTO(2)

Eight O'Clock(2)

BUSTELO cool(2)

Office Snax(1)

Chock full o'Nuts(1)

 
Quantity

1 each(68)

18 per box(40)

42 per carton(33)

100 per box(11)

6 per carton(10)

14 per box(9)

40 per carton(8)

18 per carton(8)

24 per box(7)

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

24 per carton(6)

36 per carton(6)

42 per box(4)

30 per carton(4)

12 per box(3)

15 per box(3)

50 per box(3)

60 per carton(3)

40 per box(2)

100 per carton(2)

80 per box(2)

3 per pack(2)

8 per box(2)

12 per pack(2)

160 per carton(1)

210 per pallet(1)

90 per carton(1)

150 per carton(1)

36 per Carton(1)

1 bag(1)

18 per pack(1)

108 per carton(1)

4 per carton(1)

 
Packing Type

Bag(60)

Pod(46)

Fraction Pack(42)

Packet(30)

Can(18)

Canister(13)

Filter Pack(12)

Stick(8)

Cartridges(6)

Lavazza BLUE Capsule(6)

Portion Pack(5)

Pump Bottle(4)

Jar(3)

Vacuum Bag(3)

Vacket Pack(3)

K-Cup(2)

Brick Pack(2)

 
Flavor

Regular(11)

French Roast(11)

Classic Roast(10)

Espresso(10)

Breakfast Blend(10)

House Blend(10)

Original Blend(8)

French Vanilla(6)

100% Colombian(6)

Classic Roast Decaf(6)

Dark Roast(5)

Medium Roast(5)

Decaf(4)

Classic Roast Regular(4)

Decaf House Blend(4)

Original(4)

One Love(4)

Decaffeinated(4)

Black Silk(4)

Hazelnut Créme(3)

Country Roast(3)

Jamaica Blue Mountain Blend(3)

Major Dickason's Blend(3)

Morning Blend(3)

Hazelnut Crème(2)

100% Colombian Decaf(2)

Colombia(2)

Chef's Reserve(2)

Italian Roast(2)

Cafe Mocha(2)

Colombian(2)

High Octane Premium(2)

Gran Filtro Dark Roast(2)

Filtro Classico Medium Roast(2)

Gran Filtro Light Roast(2)

Hawaiian Islands Blend(2)

Kona Blend(2)

Colombian Supremo(2)

Breakfast Blend Decaf(2)

Simply Smooth(2)

Caffè Verona(2)

Pike Place(2)

Half Caff(2)

Special Roast(2)

Pike Place Decaf(2)

Vanilla Biscotti(2)

Simmer Down Swiss Water Decaf(2)

Hazelnut(2)

Regular Roast(1)

Special House Blend(1)

Colombian Blend(1)

Special Delivery(1)

Jamaica Me Crazy(1)

Decaffeinated French Roast(1)

French Dark Roast(1)

Eye Opener(1)

Hawaiian Hazelnut(1)

Sorrento(1)

Original Roast Decaf(1)

Buffalo Soldier(1)

Talkin' Blues Jamaica Blue Mountain(1)

Gaia Organic Blend(1)

Level 2(1)

Lively Up(1)

Signature-Level 3(1)

Veranda(1)

Decaf Signature-Level 3(1)

Sumatran(1)

Caramel(1)

Veranda Blend(1)

Colombia Medium(1)

Level 4(1)

Decaf Colombian(1)

Donut Blend(1)

Decaffeinated Reserve(1)

Vienna(1)

Sumatra(1)

Colombia Luminosa(1)

Café Domingo Blend(1)

Hazelnut Creme(1)

Intenso/Medium Roast(1)

Traditional Roast(1)

Caramel Drizzle(1)

Morning Café(1)

100% Columbian(1)

Regular Traditional Roast(1)

Traditional Roast Decaf(1)

Colombian De Jardin(1)

Estate Costa Rican(1)

Colombian Decaf(1)

100% Colombian Regular(1)

Gourmet Supreme(1)

Café con Leche Chocolate(1)

Natural Cinnamon(1)

Natural Caramel(1)

Natural Vanilla(1)

Medium(1)

Dunkin Original(1)

Dunkin Decaf(1)

Café con Leche(1)

Dunkin WB Original(1)

Dunkin Dark Roast(1)

Dunkin French Vanilla(1)

Costa Rican La Sonrisa(1)

Sumatra Mandheling(1)

Parisian Vanilla(1)

Hazelnut Cream(1)

Crema Dolce/Light Roast(1)

Ricco/Dark Roast(1)

Buzzworthy (Dark Roast)(1)

Love at First Sip (Medium Roast)(1)

Lively Up!(1)

Parisian Café (Dark Roast)(1)

Breakfast Blend (Light Roast)(1)

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

Rotondo/Dark Roast(1)

Rotondo/Dark Roast Double(1)

Tierra 100% Arabica Blend(1)

Aroma Club 100% Arabica Blend(1)

Crema Aroma Arabica/Robusta(1)

Aroma Point Blue Arabica/Robusta(1)

100% Arabica Blend Decaf(1)

Arabica Blend(1)

Medium Decaf(1)

Decaffeinated Medium Roast(1)

Espresso Roast(1)

Lions Blend(1)

 
Beverage Type

Coffee(242)

Decaffeinated Coffee(15)

Coffee Pod(3)

Instant Coffee(3)

Coffee Drink(2)

Coffee, Instant(2)

Decaffeinated Instant Coffee(1)

 
Manufacturer Part Number

32420(1)

32410(1)

02059(1)

33000(1)

21001(1)

22003(1)

22002(1)

01101(1)

01096(1)

83426(1)

66488(1)

86073(1)

00058(1)

01084(1)

01027(1)

22005(1)

23001(1)

25187(1)

25186(1)

25185(1)

25188(1)

32003(1)

33100(1)

32006(1)

25184(1)

25183(1)

23003(1)

23002(1)

23004(1)

23005(1)

25181(1)

24001(1)

50930(1)

47337(1)

02561(1)

02424(1)

02400(1)

02882(1)

02967(1)

04648CT(1)

04648(1)

02394(1)

02363(1)

02141(1)

02103(1)

02226(1)

02229(1)

02325(1)

02233(1)

04658(1)

390390(1)

11062(1)

026530(1)

026480(1)

11386(1)

11386EA(1)

32486(1)

15782(1)

026260(1)

026190(1)

395680(1)

395640(1)

862400(1)

866150(1)

026160(1)

866350(1)

33150(1)

33700(1)

11023061(1)

11020676(1)

11019881(1)

11029358(1)

11075822(1)

11008554(1)

11075823(1)

11019880(1)

11019631(1)

11018190(1)

11018187(1)

11018192(1)

11018193(1)

11018197(1)

11018194(1)

11008556(1)

11008558(1)

016445(1)

016443(1)

016434(1)

016447(1)

04707(1)

866550(1)

863070(1)

016432(1)

016431(1)

1014962(1)

11008560(1)

012661(1)

012663(1)

016430(1)

016429(1)

11018186(1)

11018185(1)

85109(1)

85108(1)

85107(1)

93110(1)

93251(1)

500689(1)

500350(1)

85106(1)

85105(1)

39000(1)

33750(1)

39001(1)

39002(1)

85104(1)

39003(1)

500705(1)

501487(1)

504918(1)

504917(1)

508572(1)

11008130(1)

11018131(1)

11008131(1)

504916(1)

504915(1)

501619(1)

501546(1)

501677(1)

504909(1)

504914(1)

504913(1)

01810(1)

75424(1)

10117(1)

10107(1)

06931(1)

11248(1)

20088(1)

20091(1)

20088CT(1)

06930(1)

06927(1)

06437(1)

06433(1)

06451(1)

06897(1)

06922(1)

06898(1)

20121(1)

20136(1)

20631(1)

20540CT(1)

20540(1)

20631CT(1)

20672(1)

63006(1)

52320(1)

20527CT(1)

20527(1)

20145(1)

20136CT(1)

20421CT(1)

20421EA(1)

20513CT(1)

20513(1)

06430(1)

06239(1)

00050CT(1)

00050(1)

00019(1)

00055(1)

00283(1)

00374EA(1)

00374CT(1)

00016(1)

0000128(1)

8599961590(1)

599961590(1)

320820(1)

320840(1)

0000126(1)

0000125(1)

00678(1)

00679(1)

0529CPL(1)

0529C(1)

06114(1)

06119(1)

06125(1)

06122(1)

01720CT(1)

01720(1)

00681(1)

00680(1)

00690(1)

01014(1)

01501(1)

01500(1)

63014(1)

63015(1)

2850(1)

2709(1)

2440(1)

2851(1)

3302(1)

4483(1)

4202(1)

2431(1)

2410(1)

0470(1)

0460(1)

0490(1)

0603(1)

2401(1)

1450(1)

7509(1)

7510(1)

75412(1)

75411(1)

75410(1)

75413(1)

75415(1)

75421(1)

75416(1)

970(1)

960(1)

7512(1)

7511(1)

910(1)

940(1)

953(1)

950(1)

0427(1)

0425(1)

80018(1)

80013(1)

72909(1)

827395(1)

99900(1)

30200(1)

99906(1)

64102(1)

63104(1)

63100(1)

63018(1)

63100CT(1)

63101(1)

63103(1)

63102(1)

30210(1)

30220(1)

4097(1)

4073(1)

60000(1)

70400(1)

705024(1)

70500(1)

4066(1)

40300(1)

30400(1)

302742(1)

30800(1)

308042(1)

39930404021(1)

39930274021(1)

1099961590(1)

 
Country of Origin

US(235)

IT(27)

CO(3)

JP(2)

JM(1)

 
For Use With

Drip Coffee Brewers(17)

Commercial Coffee Brewers(14)

Single Cup Brewers(9)

Standard Coffee Brewers(9)

Soft Pod Coffee Brewers(6)

Pod Brewers(6)

LavAzza Espresso Point Machine (sold separately)(6)

Commercial Brewers(5)

Lavazza 2312 BLUE Machine(4)

Drip Coffee Maker; French Press(4)

Single Serve Pod Brewing Systems(3)

Keurig Brewers(2)

Nescafé Alegria 510 Machine(2)

1/2-Gallon Brewers(1)

Standard/Commercial Coffee Brewers(1)

Lavazza BLUE 2312 and 910 Machines(1)

Pod Espresso Brewer(1)

Electric Espresso Machines(1)

Home Brewers(1)

Lavazza BLUE Single-Cup Brewing System(1)

 
Capacity (Volume)

0.34 oz(8)

1.5 L(4)

12 oz(3)

8 oz(2)

10 oz(2)

8 g(1)

1.5 oz(1)

0.9 oz(1)

25.1 oz(1)

.9 oz(1)

 
Capacity (Weight)

2.5 oz(31)

0.3 oz(17)

2 oz(17)

1 lb(14)

1.5 oz(14)

10 oz(14)

8 oz(9)

0.9 oz(7)

1.75 oz(7)

0.75 oz(6)

0.35 oz(6)

0.25 oz(5)

31.1 oz(4)

2.25 oz(4)

12 oz(4)

0.12 oz(4)

2.2 lbs(4)

1.4 oz(4)

1.5 oz.(3)

1.1 oz(3)

20 oz(3)

8 g(3)

4.05 oz(2)

0.06 oz(2)

0.1 oz(2)

1.2 oz(2)

0.7 oz(2)

0.32 oz(2)

1.25 oz(2)

30.6 oz(2)

0.34 oz(2)

32 oz(2)

22.6 oz(2)

28 oz(2)

48 oz(2)

33 oz(2)

30.5 oz(2)

24.2 oz(2)

25.4 oz(2)

2 lb(2)

31 oz(1)

26 oz(1)

33.9 oz(1)

34.5 oz(1)

40 oz(1)

7 g(1)

0.8 oz(1)

0.08 oz(1)

18.4 oz(1)

20.8 oz(1)

36 oz(1)

16 oz(1)

1.05 oz(1)

11.5 g(1)

9 g(1)

8.8 oz(1)

0.634 oz(1)

0.25 oz.(1)

29.3 oz(1)

 
Roast Type

Medium(22)

Dark(7)

Dark Roast(5)

Light Roast(4)

Light(2)

Medium Roast(1)

 
 
 

© 2018-2019 Horizon Business Products, All Rights Reserved