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

Lavazza(25)

Starbucks(19)

Day to Day Coffee(18)

PapaNicholas Coffee(16)

Peet's Coffee & Tea(15)

Marley Coffee(11)

Wolfgang Puck(10)

Java One(9)

Melitta(8)

Maxwell House(7)

Café Bustelo(7)

Distant Lands Coffee(6)

Nescafé(6)

Dunkin Donuts(6)

New England Coffee(5)

Hills Bros.(4)

Millstone(4)

Coffee-mate(4)

Seattle's Best(4)

Panera Bread(3)

Yuban(3)

Chase & Sanborn(3)

Folgers Simply Gourmet(3)

National Coffee Roasters(3)

Eight O'Clock(2)

Office Snax(2)

VERSANTO(2)

GFIC(1)

BUSTELO cool(1)

Chock full o'Nuts(1)

 
Quantity

1 each(67)

18 per box(39)

42 per carton(34)

100 per box(10)

18 per carton(9)

14 per box(9)

6 per carton(9)

40 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)

15 per box(3)

50 per box(3)

60 per carton(3)

3 per pack(2)

12 per box(2)

80 per box(2)

8 per box(2)

40 per box(2)

63 per carton(1)

160 per carton(1)

12 per pack(1)

210 per pallet(1)

100 per carton(1)

150 per carton(1)

108 per carton(1)

18 per pack(1)

90 per carton(1)

36 per Carton(1)

4 per carton(1)

 
Packing Type

Bag(58)

Pod(45)

Fraction Pack(42)

Packet(32)

Can(17)

Canister(12)

Filter Pack(11)

Stick(8)

Lavazza BLUE Capsule(6)

Portion Pack(5)

Cartridges(5)

Pump Bottle(4)

Jar(3)

Vacuum Bag(3)

Vacket Pack(3)

K-Cup(2)

Brick Pack(2)

 
Flavor

French Roast(12)

Regular(11)

Classic Roast(10)

Espresso(10)

Breakfast Blend(10)

House Blend(10)

Original Blend(9)

Classic Roast Decaf(6)

French Vanilla(6)

100% Colombian(6)

Dark Roast(5)

Decaf(4)

Classic Roast Regular(4)

Decaf House Blend(4)

Original(4)

Medium Roast(4)

Black Silk(4)

Decaffeinated(3)

One Love(3)

Jamaica Blue Mountain Blend(3)

Hazelnut Créme(3)

Major Dickason's Blend(3)

Colombian Supremo(3)

Morning Blend(3)

Hazelnut Crème(2)

Breakfast Blend Decaf(2)

Colombia(2)

Chef's Reserve(2)

Cafe Mocha(2)

Italian Roast(2)

Colombian(2)

Kona Blend(2)

Filtro Classico Medium Roast(2)

High Octane Premium(2)

Hawaiian Islands Blend(2)

Gran Filtro Dark Roast(2)

Gran Filtro Light Roast(2)

Colombian Decaf(2)

Caffè Verona(2)

Half Caff(2)

Simply Smooth(2)

Country Roast(2)

Pike Place Decaf(2)

100% Colombian Decaf(2)

Pike Place(2)

Special Roast(2)

Simmer Down Swiss Water Decaf(2)

Hazelnut(2)

Vanilla Biscotti(2)

Decaffeinated French Roast(1)

Talkin' Blues Jamaica Blue Mountain(1)

Special House Blend(1)

Colombian Blend(1)

Regular Roast(1)

Hazelnut Creme(1)

Eye Opener(1)

Hawaiian Hazelnut(1)

Jamaica Me Crazy(1)

Original Roast Decaf(1)

Special Delivery(1)

Sorrento(1)

Café Domingo Blend(1)

Level 2(1)

Signature-Level 3(1)

Level 4(1)

Veranda(1)

Veranda Blend(1)

Sumatran(1)

Decaf Signature-Level 3(1)

Colombia Medium(1)

Colombia Luminosa(1)

Decaffeinated Reserve(1)

Decaf Colombian(1)

Vienna(1)

Gaia Organic Blend(1)

Caramel(1)

Sumatra(1)

Donut Blend(1)

Decaffeinated 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)

100% Colombian Regular(1)

Gourmet Supreme(1)

Café con Leche(1)

Natural Cinnamon(1)

Natural Caramel(1)

Natural Vanilla(1)

Medium(1)

Dunkin Original(1)

Dunkin Decaf(1)

Dunkin WB Original(1)

Dunkin Dark Roast(1)

Dunkin French Vanilla(1)

Costa Rican La Sonrisa(1)

Sumatra Mandheling(1)

Buzzworthy (Dark Roast)(1)

Parisian Vanilla(1)

Hazelnut Cream(1)

Crema Dolce/Light Roast(1)

Love at First Sip (Medium Roast)(1)

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

Lions Blend(1)

Parisian Café (Dark Roast)(1)

Breakfast Blend (Light Roast)(1)

Ricco/Dark Roast(1)

Rotondo/Dark Roast(1)

100% Arabica Blend Decaf(1)

Tierra 100% Arabica Blend(1)

Aroma Club 100% Arabica Blend(1)

Crema Aroma Arabica/Robusta(1)

Arabica Blend(1)

Espresso Roast(1)

Rotondo/Dark Roast Double(1)

Intenso/Medium Roast(1)

Medium Decaf(1)

Lively Up(1)

 
Beverage Type

Coffee(238)

Decaffeinated Coffee(15)

Instant Coffee(3)

Coffee Pod(3)

Coffee, Instant(2)

Decaffeinated Instant Coffee(1)

Coffee Drink(1)

 
Manufacturer Part Number

22002(1)

21001(1)

33000(1)

22003(1)

22005(1)

23002(1)

23001(1)

32420(1)

32410(1)

01027(1)

00058(1)

01084(1)

01096(1)

02059(1)

01101(1)

23003(1)

23004(1)

25188(1)

25187(1)

32003(1)

32006(1)

33150(1)

33100(1)

25186(1)

25185(1)

24001(1)

23005(1)

25181(1)

25182(1)

25184(1)

25183(1)

00034(1)

86073(1)

04648CT(1)

04648(1)

02967(1)

04658(1)

390390(1)

862400(1)

395640(1)

02561(1)

02424(1)

02229(1)

02226(1)

02233(1)

02325(1)

02400(1)

02394(1)

866150(1)

866350(1)

32486(1)

15782(1)

47337(1)

50930(1)

83426(1)

66488(1)

11386EA(1)

11386(1)

026190(1)

026160(1)

026260(1)

026480(1)

11062(1)

026530(1)

33700(1)

33750(1)

11029358(1)

11023061(1)

11020676(1)

11075822(1)

11075823(1)

11008556(1)

11008554(1)

11019881(1)

11019880(1)

11018192(1)

11018190(1)

11018193(1)

11018194(1)

11019631(1)

11018197(1)

11008558(1)

11008560(1)

016445(1)

016443(1)

016447(1)

04707(1)

866550(1)

863070(1)

016434(1)

016432(1)

012661(1)

1014962(1)

012663(1)

016429(1)

016431(1)

016430(1)

11018187(1)

11018186(1)

93110(1)

85109(1)

85108(1)

93251(1)

500350(1)

500705(1)

500689(1)

85107(1)

85106(1)

39001(1)

39000(1)

39002(1)

39003(1)

85105(1)

85104(1)

501487(1)

501546(1)

508572(1)

504918(1)

11008130(1)

11008131(1)

11018185(1)

11018131(1)

504917(1)

504916(1)

501677(1)

501619(1)

504909(1)

504913(1)

504915(1)

504914(1)

02141(1)

01810(1)

11248(1)

10117(1)

10107(1)

20088(1)

20088CT(1)

20121(1)

20091(1)

06931(1)

06930(1)

06451(1)

06437(1)

06897(1)

06898(1)

06927(1)

06922(1)

20136(1)

20136CT(1)

20631(1)

20540CT(1)

20631CT(1)

52320(1)

63014(1)

63006(1)

20540(1)

20527CT(1)

20421CT(1)

20145(1)

20421EA(1)

20513(1)

20527(1)

20513CT(1)

06433(1)

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

06114(1)

0529CPL(1)

06119(1)

06122(1)

06239(1)

06125(1)

0529C(1)

01720CT(1)

00681(1)

00680(1)

00690(1)

01014(1)

01720(1)

01500(1)

63015(1)

63018(1)

2851(1)

2850(1)

2709(1)

3302(1)

4202(1)

7509(1)

4483(1)

2440(1)

2431(1)

0490(1)

0470(1)

0603(1)

1450(1)

2410(1)

2401(1)

7510(1)

7511(1)

75413(1)

75412(1)

75415(1)

75416(1)

75424(1)

75421(1)

75411(1)

75410(1)

940(1)

910(1)

950(1)

953(1)

970(1)

960(1)

0460(1)

0425(1)

827395(1)

80018(1)

80013(1)

99900(1)

99906(1)

30210(1)

30200(1)

72909(1)

64102(1)

63100CT(1)

63100(1)

63101(1)

63102(1)

63104(1)

63103(1)

302142(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(232)

IT(25)

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

Commercial Brewers(5)

Lavazza 2312 BLUE Machine(4)

Drip Coffee Maker; French Press(3)

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)

10 oz(2)

8 g(1)

.9 oz(1)

0.9 oz(1)

1.5 oz(1)

8 oz(1)

 
Capacity (Weight)

2.5 oz(31)

0.3 oz(17)

2 oz(17)

1.5 oz(16)

1 lb(14)

10 oz(14)

8 oz(8)

0.9 oz(7)

1.75 oz(7)

0.75 oz(6)

0.35 oz(6)

0.25 oz(4)

2.2 lbs(4)

1.4 oz(4)

31.1 oz(4)

2.25 oz(4)

0.12 oz(4)

1.5 oz.(3)

8 g(3)

12 oz(3)

20 oz(3)

1.1 oz(3)

33 oz(2)

1.25 oz(2)

30.6 oz(2)

0.32 oz(2)

0.1 oz(2)

1.2 oz(2)

48 oz(2)

25.4 oz(2)

28 oz(2)

30.5 oz(2)

24.2 oz(2)

0.06 oz(2)

2 lb(2)

22.6 oz(2)

32 oz(2)

4.05 oz(2)

31 oz(1)

40 oz(1)

34.5 oz(1)

26 oz(1)

33.9 oz(1)

7 g(1)

0.08 oz(1)

16 oz(1)

0.8 oz(1)

18.4 oz(1)

36 oz(1)

20.8 oz(1)

1.05 oz(1)

0.25 oz.(1)

0.34 oz(1)

29.3 oz(1)

9 g(1)

11.5 g(1)

0.634 oz(1)

8.8 oz(1)

0.7 oz(1)

 
Roast Type

Medium(21)

Dark(7)

Dark Roast(5)

Light Roast(4)

Light(2)

Medium Roast(1)

 
 
 

© 2018-2019 Horizon Business Products, All Rights Reserved