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_19` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` 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 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` WHERE (`category_name` LIKE "Coffee") 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_cost`=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 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


Search Again >>


Refine Search

  GO
Brand

Folgers(41)

Green Mountain Coffee(40)

Lavazza(25)

Starbucks(21)

Peet's Coffee & Tea(19)

Day to Day Coffee(15)

PapaNicholas Coffee(11)

Java One(9)

Maxwell House(8)

Mighty Leaf Tea(8)

Tully's Coffee(7)

Eight O'Clock(7)

Timothy's World Coffee(6)

Barista Prima Coffeehouse(5)

Café Bustelo(5)

New England Coffee(5)

Seattle's Best(4)

Caribou Coffee(4)

Distant Lands Coffee(4)

Nescafé(4)

Diedrich Coffee(4)

Gevalia(4)

Gloria Jean's(4)

Café Escapes(3)

Hills Bros.(3)

The Original Donut Shop(3)

Chase & Sanborn(3)

Newman's Own Organics(3)

Panera Bread(3)

Donut House(3)

BUSTELO cool(2)

Coffee People(2)

Yuban(2)

Coffee-mate(2)

Van Houtte(2)

Krispy Kreme Doughnuts(2)

Office Snax(2)

revv(1)

Emeril's(1)

Kahlúa(1)

Cinnabon(1)

Dunkin Donuts(1)

Quantity

24 per box(110)

1 each(40)

42 per carton(33)

18 per box(15)

22 per box(11)

100 per box(10)

14 per box(9)

18 per carton(8)

15 per box(8)

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

40 per carton(5)

50 per carton(4)

36 per carton(4)

30 per carton(4)

50 per box(3)

42 per box(3)

24 per box.(3)

6 per carton(3)

24 per carton(2)

60 per carton(2)

12 per pack(2)

160 per carton(1)

3 per pack(1)

63 per carton(1)

150 per carton(1)

1 bag(1)

100 per carton(1)

4 per carton(1)

Packing Type

K-Cup(121)

Bag(37)

Fraction Pack(37)

Packet(25)

Pod(15)

Can(12)

Filter Pack(10)

Filterbag(8)

Lavazza BLUE Capsule(6)

Portion Pack(5)

Cartridges(5)

Stick(4)

Canister(4)

Vacuum Bag(3)

Vacket Pack(3)

Pump Bottle(2)

Jar(1)

Coffee Pod(1)

Flavor

French Roast(18)

House Blend(12)

Breakfast Blend(11)

Regular(9)

Classic Roast(8)

French Vanilla(6)

Original Blend(6)

Hazelnut(5)

Dark Roast(5)

Classic Roast Decaf(5)

Espresso(5)

Medium Roast(4)

100% Colombian(4)

Italian Roast(4)

Major Dickason's Blend(4)

Colombian(4)

Black Silk(4)

Decaf House Blend(4)

Morning Blend(3)

Decaf(3)

Pike Place Decaf(3)

Colombian Decaf(3)

Assorted(3)

Original(3)

Vermont Country Blend(2)

Vermont Country Blend Decaf(2)

House Blend Decaf(2)

Gran Filtro Light Roast(2)

Hazelnut Crème(2)

Colombian Supremo(2)

Breakfast Blend Decaf(2)

Hazelnut Créme(2)

Colombia(2)

Filtro Classico Medium Roast(2)

Gran Filtro Dark Roast(2)

Café Domingo Blend(2)

Light Roast(2)

Decaffeinated(2)

Veranda Blend(2)

Caramel Drizzle(2)

Kona Blend(2)

Pike Place(2)

Classic Roast Regular(2)

Hawaiian Islands Blend(2)

Caffè Verona(2)

Aroma Point Blue Arabica/Robusta(1)

Level 2(1)

Signature-Level 3(1)

Crema Aroma Arabica/Robusta(1)

Aroma Club 100% Arabica Blend(1)

100% Arabica Blend Decaf(1)

Tierra 100% Arabica Blend(1)

Sumatra Mandheling(1)

Veranda(1)

Decaf Signature-Level 3(1)

Level 4(1)

Caribou Blend Decaf(1)

Half-Caff(1)

Daybreak Morning Blend(1)

Caribou Blend(1)

Mahogany(1)

Regular Roast(1)

Donut House Decaf(1)

Special Delivery(1)

Estate Costa Rican(1)

Kahlúa Original(1)

Hazelnut Decaf(1)

French Vanilla Decaf(1)

Emeril's Big Easy Bold(1)

Espresso Roast(1)

White Orchard(1)

Caramel(1)

Organic Spring Jasmine(1)

Organic Mint Melange(1)

Bombay Chai(1)

Original Roast Decaf(1)

Eye Opener(1)

Special House Blend(1)

Colombian Blend(1)

Decaffeinated French Roast(1)

Hazelnut Creme(1)

Cafe Mocha(1)

Sumatra(1)

Pikes Place(1)

Cafe Verona(1)

Rotondo/Dark Roast(1)

Rotondo/Dark Roast Double(1)

Intenso/Medium Roast(1)

Decaffeinated Medium Roast(1)

Ricco/Dark Roast(1)

Crema Dolce/Light Roast(1)

Organic Earl Grey(1)

Organic Breakfast(1)

Green Tea Tropical(1)

Chamomile Citrus(1)

Colombia Medium(1)

Vanilla Biscotti(1)

Cinnamon Pastry(1)

French Roast Decaf(1)

Extra Bold Breakfast Blend(1)

Rainforest Espresso(1)

German Chocolate Cake(1)

Lively Colombian Decaf(1)

Italian Blend(1)

Newman's Own Special Blend Extra Bold(1)

Newman's Own Special Decaf(1)

Double Black Diamond Extra Bold(1)

Dark Magic Decaf Extra Bold(1)

Signature Blend(1)

Arabica Blend(1)

Dark Magic Extra Bold(1)

Kenyan AA(1)

Organic Sumatran Extra Bold(1)

Morning Café(1)

Mocha Swirl(1)

Donut Shop Decaf(1)

Café con Leche(1)

Café con Leche Chocolate(1)

Black Tiger Extra Bold(1)

Jet Fuel(1)

Mudslide(1)

Donut Shop(1)

Gourmet Supreme(1)

Special Roast(1)

Hazelnut Cream(1)

Raspberry Chocolate Truffle(1)

100% Colombian Decaf(1)

Traditional Roast Decaf(1)

Traditional Roast(1)

Regular Traditional Roast(1)

Original Roast(1)

Dark Royal(1)

Caramel Vanilla Cream(1)

Island Coconut(1)

Chocolate Glazed Donut(1)

Nantucket Blend(1)

Butter Toffee(1)

Decaf Italian Roast(1)

Lively Colombian(1)

Morning Edition(1)

Morning Edition Decaf(1)

Spicy Egg Nog(1)

Wild Mountain Blueberry(1)

Mocha(1)

Southern Pecan(1)

Pumpkin Spice(1)

Rio Blend(1)

Mocha Nut Fudge(1)

Hawaiian Blend(1)

Our Blend(1)

Summer Sunrise(1)

Holiday Blend(1)

Wicked Winter Blend(1)

Vanilla Hazelnut Decaf(1)

Colombian Fair Trade Select(1)

Signature Blend Decaf(1)

Cinnamon Sugar Cookie(1)

Autumn Harvest Blend(1)

Coconut Mocha(1)

Donut House(1)

Brazil Minas Naturais(1)

Lake & Lodge(1)

Original Decaf(1)

Cinnamon Roll(1)

Toasted Marshmallow Mocha(1)

Vanilla(1)

Beverage Type

Coffee(251)

Decaffeinated Coffee(33)

Tea(8)

Coffee, Instant(2)

Coffee Drink(2)

Instant Coffee(2)

Half-caffeinated Coffee(1)

Manufacturer Part Number

4066(2)

40004(1)

40003(1)

40002(1)

40001(1)

40005(1)

40018(1)

40016(1)

40008(1)

970(1)

960(1)

7512(1)

7511(1)

7510(1)

910(1)

940(1)

953(1)

950(1)

04648(1)

04658(1)

11386EA(1)

11386(1)

11062(1)

32486(1)

83426(1)

00034(1)

86073(1)

026530(1)

026480(1)

866150(1)

862400(1)

390390(1)

866350(1)

026160(1)

026260(1)

026190(1)

7509(1)

4483(1)

302742(1)

30220(1)

302142(1)

30400(1)

30800(1)

4073(1)

40300(1)

308042(1)

30210(1)

30200(1)

7534(1)

7522(1)

6999(1)

7602(1)

7732(1)

PB4141(1)

7792(1)

4097(1)

60000(1)

2431(1)

2410(1)

2401(1)

2440(1)

2709(1)

4202(1)

2851(1)

2850(1)

1450(1)

0603(1)

705024(1)

70500(1)

70400(1)

0427(1)

0460(1)

0490(1)

0470(1)

00058(1)

01084(1)

011067987(1)

011067986(1)

011067985(1)

011068092(1)

11008130(1)

11018185(1)

11018131(1)

11008131(1)

011067984(1)

011067983(1)

504914(1)

504913(1)

501677(1)

504915(1)

504916(1)

504918(1)

504917(1)

11018186(1)

11018187(1)

11008558(1)

11008556(1)

11008554(1)

11008560(1)

1014962(1)

866550(1)

863070(1)

PB4137(1)

11029358(1)

11023061(1)

11018193(1)

11018192(1)

11018190(1)

11018194(1)

11018197(1)

11020676(1)

11019631(1)

501619(1)

501546(1)

23003(1)

23002(1)

23001(1)

23004(1)

23005(1)

25182(1)

25181(1)

24001(1)

22005(1)

22003(1)

32410(1)

01101(1)

6995(1)

32420(1)

33000(1)

22002(1)

21001(1)

25183(1)

25184(1)

39003(1)

39002(1)

39001(1)

500350(1)

500689(1)

501487(1)

500705(1)

39000(1)

33150(1)

25187(1)

25186(1)

25185(1)

25188(1)

32003(1)

33100(1)

32006(1)

01027(1)

6994(1)

0316(1)

0243(1)

0162(1)

0448(1)

0570(1)

1109(1)

1102(1)

1101(1)

63104(1)

63103(1)

63015(1)

63014(1)

63006(1)

63018(1)

63100(1)

63102(1)

63101(1)

1113(1)

1120(1)

4061(1)

4060(1)

4057(1)

4062(1)

4067(1)

4493(1)

4441(1)

4162(1)

4051(1)

4050(1)

192519(1)

192419(1)

1135(1)

192619(1)

192719(1)

193019(1)

192919(1)

52320(1)

20540CT(1)

00374CT(1)

00055(1)

00016(1)

00374EA(1)

01014(1)

06114(1)

01501(1)

01500(1)

320840(1)

320820(1)

60051-056(1)

60051-052(1)

60051-046(1)

60052-101(1)

60052-103(1)

60224-101(1)

60052-107(1)

06122(1)

06239(1)

11248(1)

10117(1)

10107(1)

20145(1)

20421CT(1)

20540(1)

20421EA(1)

06931(1)

06930(1)

06437(1)

06433(1)

06430(1)

06451(1)

06897(1)

06927(1)

06922(1)

4792(1)

5161(1)

6662(1)

6661(1)

6659(1)

6663(1)

6680(1)

6700(1)

6694(1)

6685(1)

6624(1)

6614(1)

6602(1)

6570(1)

6547(1)

6606(1)

6611(1)

6613(1)

6612(1)

6720(1)

6722(1)

6803(1)

6792(1)

6783(1)

6812(1)

6813(1)

6992(1)

6990(1)

6774(1)

6772(1)

6744(1)

6743(1)

6732(1)

6745(1)

6746(1)

6758(1)

6752(1)

6546(1)

6545(1)

6107(1)

6106(1)

6024(1)

6110(1)

6111(1)

6205(1)

6204(1)

6115(1)

6003(1)

5814(1)

5305(1)

5304(1)

5303(1)

5339(1)

5469(1)

5471(1)

5470(1)

6206(1)

6248(1)

6523(1)

6520(1)

6503(1)

6534(1)

6542(1)

6544(1)

6543(1)

6502(1)

6501(1)

6405(1)

6336(1)

6305(1)

6406(1)

6407(1)

6425(1)

6408(1)

60051-012(1)

Country of Origin

US(251)

IT(25)

CO(11)

CN(5)

CA(2)

JP(2)

United States(1)

EG(1)

IN(1)

MA(1)

For Use With

Keurig Brewing System(121)

Drip Coffee Brewers(15)

Commercial Coffee Brewers(11)

Single Cup Brewers(9)

Commercial Brewers(8)

Pod Brewers(5)

LavAzza Espresso Point Machine (sold separately)(5)

Lavazza 2312 BLUE Machine(4)

Drip Coffee Maker; French Press(4)

Nescafé Alegria 510 Machine(2)

Standard Coffee Brewers(2)

Standard and Commercial Coffee Makers(1)

Lavazza BLUE 2312 and 910 Machines(1)

Pod Espresso Brewer(1)

Lavazza BLUE Single-Cup Brewing System(1)

Capacity (Volume)

12 oz(3)

1.5 L(2)

8 oz(2)

1.5 oz(1)

8 g(1)

Capacity (Weight)

2.5 oz(26)

1.5 oz(16)

2 oz(15)

1 lb(13)

0.3 oz(9)

1.32 oz(8)

0.9 oz(6)

0.35 oz(5)

0.25 oz(5)

0.4 oz(5)

2.2 oz(4)

2.2 lbs(4)

12 oz(4)

2.25 oz(4)

1.1 oz(3)

1.4 oz(3)

1.5 oz.(3)

8 g(3)

22.6 oz(2)

1.25 oz(2)

4.05 oz(2)

1.2 oz(2)

24.2 oz(2)

1.75 oz(2)

7 g(2)

10 oz(2)

30.5 oz(2)

0.1 oz(2)

0.12 oz(2)

32 oz(2)

33.9 oz(1)

34.5 oz(1)

40 oz(1)

33 oz(1)

30.6 oz(1)

8 oz(1)

1.05 oz(1)

2.5 lbs(1)

16 oz(1)

0.8 oz(1)

29.3 oz(1)

9 g(1)

11.5 g(1)

36 oz(1)

Serve Type

Ground(1)

Coffee Type

Regular(1)

Roast Type

Medium(51)

Dark(35)

Light(21)

Dark Roast(5)

Light Roast(3)

Medium Roast(1)

Mild(1)

Coffee Weight

33 oz(1)

Compatible Brewer

Drip-coffee Brewer(1)

Product Type

Coffee(1)

Packaged Quantity

1 Each(1)

Flavor/Blend

Day To Day House Blend(1)

Price Range

$0-$99.99(284)

$100-$199.99(13)

$200-$299.99(3)

To  GO

 
 
1%
Searching for your Best Results.....
 

© 2017-2018 Carriage Paper Products, All Rights Reserved