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_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_name` LIKE "Coffee") AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') 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®(42)

Starbucks(27)

PapaNicholas(14)

Peet's(11)

Nescafe Dolce Gusto(10)

Green Mountain Coffee Roasters®(9)

Alterra(9)

Seattle's Best Coffee(7)

Melitta(6)

Café Bustelo®(6)

Office Snax(6)

Maxwell House(6)

Green Mountain Coffee(4)

Coffee Pro(2)

Yuban(2)

Java One(1)

Nescafe Taster's Choice(1)

Tully's® Coffee(1)

Chase and Sanborn(1)

Smucker(1)

Supreme by Bustelo(1)

 
Packaged Quantity

1 Each(41)

18 / Box(24)

42 / Carton(19)

100 / Carton(12)

16 / Box(10)

50 / Carton(9)

24 / Carton(8)

18 / Carton(6)

40 / Carton(6)

6 / Carton(5)

108 / Carton(4)

1 Box(3)

42 / Box(3)

80 / Carton(3)

200 / Carton(2)

50 / Box(2)

8 / Box(2)

36 / Carton(2)

2 / Bundle(1)

80 / Box(1)

63 / Carton(1)

1 Bag(1)

30 / Carton(1)

24 / Box(1)

 
Weight (Approximate)

1.15 lb(1)

 
Package Type

Bulk(4)

 
Flavor/Blend

Arabica(37)

Espresso(10)

Cocoa(9)

House Blend(9)

Colombian(6)

French Roast(6)

Nut(6)

Pike Place(6)

Toasted Nut(6)

Hazelnut(5)

Caramel(5)

Italian Roast(5)

Breakfast Blend(5)

Veranda Blend(4)

Colombia(4)

Roasty Sweet(4)

Latin America(4)

Latte Macchiato(4)

Smoky(4)

Black Silk(4)

French Vanilla(4)

Original Blend(3)

Soft Cocoa(3)

Rich Aroma(3)

Major Dickason's(3)

Dark Cocoa(3)

Caffe Verona(3)

Cafe Domingo(2)

Mellow(2)

Subtle Aroma(2)

Spicy(2)

Signature Blend(2)

Almond(2)

Vanilla(2)

Hawaiian Blend(2)

Cherry(2)

Morning Blend(2)

Robusta(2)

Pioneer(2)

Bustelo(2)

Hazelnut Creme(2)

Chocolate Peppermint(1)

Hot Cocoa(1)

Sumatran Reserve(1)

Signature Walnut(1)

Nantucket Blend(1)

Dutch Chocolate(1)

Colombian Arabica(1)

Vermont Country Blend(1)

Madison Blend(1)

Day To Day House Blend(1)

Columbian(1)

Buzzworthy(1)

Dark Blend(1)

Morning Cafe(1)

Brown Sugar(1)

Country Roast(1)

Mountain Grown(1)

Bright Citrus(1)

Cappuccino(1)

Espresso Blend(1)

Asia/Pacific(1)

Walnut(1)

Arabic(1)

Pier 70(1)

Special House Blend(1)

Day To Day Decaffeinated(1)

Spice(1)

Intenso(1)

Love At First Sip(1)

Sweet Caramel(1)

Rich Vanilla Cream(1)

Vanilla Creme Brulee(1)

Parisian Vanilla(1)

Creamy(1)

Mocha(1)

Caffé Verona(1)

Espresso Intenso(1)

Gourmet Blend(1)

Pike Place Roast(1)

Velvety(1)

Donut Shop Blend(1)

Skip The Buzz(1)

Licorice Root(1)

Dark Chocolate(1)

Brazilian(1)

Ethiopian Blend(1)

Jasmine(1)

Toasty Spicy(1)

Toasted Cereal(1)

Cafe Au Lait(1)

Pure Arabica(1)

Sumatra(1)

Original(1)

Day To Day Colombian Blend(1)

Day To Day Breakfast Blend(1)

Chocolate(1)

 
Serve Type

Ground(37)

Pod(11)

Whole Bean(7)

Capsule(4)

Filter Pack(3)

Pot Pack(3)

Instant(2)

K-Cup(1)

Portion Pack(1)

 
Coffee Type

Regular(89)

Decaffeinated(23)

Caffeinated(2)

 
Packing

Pod(16)

Packet(13)

Pouch(10)

Bag(10)

Jar(1)

 
Coffee Roast Level

Medium(44)

Dark(22)

Dark/Bold(11)

Light/Mild(8)

Light(6)

Bold(4)

Smooth(3)

Dark/Bold/Smooth(2)

Classic/Medium(2)

Classic(2)

French/Dark(2)

Blonde(2)

Full/Extra Dark/Extra Bold(1)

Medium/Dark(1)

French(1)

 
Number of Serving Cups

1(26)

12(5)

10(2)

240(1)

8(1)

 
Coffee Weight

16 oz(14)

2.5 oz(12)

0.4 oz(9)

16 oz Per Bag(5)

2.2 oz(5)

2 oz(5)

0.3 oz(5)

2.5 oz Per Pack(4)

12 oz(4)

10 oz Per Can(4)

1.4 oz(4)

0.1 oz(4)

2.5 oz Per Packet(3)

32 oz(3)

0.3 oz Per Packet(3)

1.1 oz(3)

22.6 oz(2)

1.5 oz Per Packet(2)

1.2 oz Per Packet(2)

2.5 oz Per Carton(2)

31.1 oz Per Canister(2)

25.4 oz(2)

0.9 oz(2)

30.6 oz(2)

1.5 oz(2)

24.2 oz Per Canister(2)

0.1 oz Per Packet(1)

4 oz(1)

1.3 oz Per Carton(1)

76 oz Per Box(1)

2.5 oz Per Pouch(1)

33 oz(1)

1.1 oz Per Carton(1)

1.8 oz Per Packet(1)

26 oz(1)

34.5 oz Per Can(1)

33.9 oz(1)

2 oz Per Pack(1)

5.9 oz Per Pack(1)

1.8 oz Per Bag(1)

36 oz Per Can(1)

10 oz(1)

48 oz(1)

9 oz Per Pouch(1)

0.9 oz Per Pouch(1)

1.5 oz Per Bag(1)

1.8 oz(1)

0.8 oz(1)

2.2 oz Per Pouch(1)

0.9 oz Per Packet(1)

1.1 oz Per Packet(1)

30.5 oz Per Canister(1)

8 oz(1)

25.1 oz(1)

0.4 oz Per Pod(1)

2.2 oz Per Pack(1)

12 oz Per Packet(1)

 
Coffee Quantity

18 Pod(7)

18 Packet(5)

108 Pod(3)

42 Packet(3)

50 CoffeeBag(2)

24 Packet(2)

Pod(1)

100 CoffeeBag(1)

42(1)

8 Capsule(1)

80 Stick(1)

 
Compatible Brewer

Flavia(9)

Majesto Automatic Coffee Machine(7)

Drip-coffee Brewer(4)

Dolce Gusto(2)

Hamilton Brewer(1)

Bunn Brewer(1)

Newco Brewer(1)

Keurig Brewer(1)

 
Manufacturer Part Number

CCFEOC1D(1)

25181(1)

01096(1)

01101(1)

10044(1)

33000(1)

23001(1)

23003(1)

23004(1)

25183(1)

00058(1)

25184(1)

25185(1)

25186(1)

25187(1)

32003(1)

32006(1)

33100(1)

79224(1)

01027(1)

00034(1)

500350(1)

02430(1)

SX03(1)

75410(1)

75411(1)

75412(1)

75413(1)

75415(1)

75416(1)

15782(1)

77321(1)

27326(1)

27359(1)

38106(1)

52640(1)

70396(1)

70420(1)

77317(1)

77319(1)

79424(1)

500705(1)

SX01(1)

12420849(1)

12411960(1)

12411961(1)

12411962(1)

12413961(1)

12413966(1)

12413967(1)

12413968(1)

12420877(1)

12411957(1)

12420953(1)

12420994(1)

12421004(1)

12421012(1)

12407830(1)

12420867(1)

12420869(1)

12420871(1)

12411958(1)

12411956(1)

501487(1)

504918(1)

501546(1)

501619(1)

501677(1)

504874(1)

504914(1)

504915(1)

504916(1)

12407827(1)

12411955(1)

12407831(1)

12407838(1)

12407839(1)

12411945(1)

12411946(1)

12411948(1)

12411949(1)

12411954(1)

SX02(1)

A200(1)

CCFEOC1R(1)

20421BD(1)

06927(1)

06931(1)

10107(1)

10117(1)

1014(1)

101800(1)

11544(1)

20513(1)

06897(1)

20513CT(1)

20527(1)

20527CT(1)

20540(1)

20540CT(1)

20629(1)

20672(1)

21510(1)

06898(1)

06451(1)

21512(1)

00374EA(1)

00016(1)

00019(1)

00050(1)

00050CT(1)

00055(1)

00126(1)

00374CT(1)

01720(1)

06437(1)

01720CT(1)

0529C(1)

06119(1)

06122(1)

06125(1)

06239(1)

06430(1)

06433(1)

21511(1)

21513(1)

A194(1)

GEN862400(1)

8287(1)

399302742151(1)

04648(1)

04648CT(1)

86230(1)

866150(1)

GEN390390(1)

GEN86307(1)

T4792(1)

GEN86635(1)

A180(1)

A181(1)

A182(1)

A183(1)

A184(1)

A185(1)

A186(1)

T5493(1)

T4732(1)

63100(1)

63104(1)

63100CT(1)

63101BX(1)

63101CT(1)

63102BX(1)

63102CT(1)

63103BX(1)

63103CT(1)

0448(1)

T4670(1)

T151305(1)

T4162(1)

T4332(1)

T4432(1)

T4441(1)

T4461(1)

T4493(1)

T4524(1)

12420873(1)

 
Country of Origin

United States(140)

Colombia(10)

United Kingdom(5)

Great Britain(3)

Brazil(2)

Vietnam(2)

China(1)

Spain(1)

France(1)

 
Height

8.8"(1)

 
Width

3.8"(1)

 
 
 

© 2020-2021 Panola Paper Co, All Rights Reserved