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_id` IN ('10018')) 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(44)

Starbucks(19)

Day to Day Coffee(17)

Lavazza(15)

Peet's Coffee & Tea(14)

PapaNicholas Coffee(10)

Java One(9)

Melitta(8)

Maxwell House(7)

Café Bustelo(6)

Distant Lands Coffee(6)

New England Coffee(5)

Hills Bros.(4)

Nescafé(4)

Seattle's Best(4)

Yuban(3)

National Coffee Roasters(3)

Eight O'Clock(2)

Chase & Sanborn(2)

BUSTELO cool(2)

Office Snax(1)

Chock full o'Nuts(1)

GFIC(1)

 
Quantity

42 per carton(5)

36 per carton(4)

40 per box(2)

210 per pallet(1)

18 per carton(1)

24 per box(1)

12 per pack(1)

 
Packing Type

Bag(34)

Fraction Pack(33)

Packet(30)

Pod(27)

Can(14)

Canister(11)

Filter Pack(9)

Stick(8)

Portion Pack(5)

Cartridges(3)

Lavazza BLUE Capsule(3)

Vacket Pack(3)

K-Cup(2)

Jar(2)

Brick Pack(2)

Coffee Pod(1)

 
Flavor

Classic Roast(14)

House Blend(9)

French Roast(9)

Regular(9)

Breakfast Blend(8)

Espresso(7)

Original Blend(6)

Classic Roast Decaf(6)

100% Colombian(5)

Black Silk(4)

Hazelnut Creme(4)

Dark Roast(4)

Decaffeinated(4)

Decaf House Blend(4)

Medium Roast(4)

Original(4)

French Vanilla(3)

Major Dickason's Blend(3)

Morning Blend(3)

Pike Place Decaf(2)

Breakfast Blend Decaf(2)

Gran Filtro Light Roast(2)

Italian Roast(2)

Gran Filtro Dark Roast(2)

Caffe Verona(2)

Pike Place(2)

Hawaiian Islands Blend(2)

Kona Blend(2)

Special Roast(2)

Simply Smooth(2)

Half Caff(2)

Colombian Supremo(2)

Colombian Decaf(2)

Cafe Domingo(1)

Colombian(1)

Colombian Blend(1)

Special House Blend(1)

Sumatra(1)

Decaffeinated French Roast(1)

Decaf(1)

Sumatran(1)

Portside Blend(1)

Pier 70 Blend(1)

6th Avenue Bistro(1)

Special Delivery(1)

Regular Roast(1)

Decaf Portside Blend(1)

Caramel(1)

Colombia Medium(1)

Veranda(1)

Colombia(1)

Veranda Blend(1)

Café Domingo Blend(1)

Rotondo/Dark Roast(1)

Colombian De Jardin(1)

Estate Costa Rican(1)

Costa Rican La Sonrisa(1)

Sumatra Mandheling(1)

Aroma Club 100% Arabica Blend(1)

Crema Aroma Arabica/Robusta(1)

Hazelnut(1)

100% Colombian Decaf(1)

Café con Leche Chocolate(1)

Café con Leche(1)

Gourmet Supreme(1)

Decaf Classic(1)

Traditional Roast(1)

100% Arabica Blend Decaf(1)

Filtro Classico Medium Roast(1)

Breakfast Blend (Light Roast)(1)

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

Parisian Café (Dark Roast)(1)

Original Roast Decaf(1)

French Dark Roast(1)

Love at First Sip (Medium Roast)(1)

Buzzworthy (Dark Roast)(1)

Medium Decaf(1)

Decaffeinated Medium Roast(1)

Crema Dolce/Medium Roast(1)

Hazelnut Cream(1)

Parisian Vanilla(1)

Eye Opener(1)

 
Beverage Type

Coffee(153)

Decaffeinated Coffee(25)

Instant Coffee(4)

Coffee Drink(2)

Half-caffeinated Coffee(2)

Instant Decaffeinated Coffee(1)

 
Manufacturer Part Number

23001(1)

23002(1)

23003(1)

23004(1)

22005(1)

22003(1)

32410(1)

33000(1)

21001(1)

22002(1)

23005(1)

24001(1)

25187(1)

25188(1)

32003(1)

32006(1)

25186(1)

25185(1)

25181(1)

25182(1)

25183(1)

25184(1)

02059(1)

01101(1)

866150(1)

866350(1)

026160(1)

026190(1)

862400(1)

395640(1)

04648(1)

04648CT(1)

04658(1)

390390(1)

026260(1)

026480(1)

00058(1)

01027(1)

01084(1)

01096(1)

86073(1)

66488(1)

026530(1)

15782(1)

32486(1)

33300(1)

33700(1)

11018197(1)

11019631(1)

11019880(1)

11019881(1)

11018194(1)

11018193(1)

11018186(1)

11018187(1)

11018190(1)

11018192(1)

11020676(1)

11023061(1)

11008560(1)

04707(1)

863070(1)

866550(1)

11008558(1)

11008556(1)

11029358(1)

11075822(1)

11075823(1)

11008554(1)

11018185(1)

11018131(1)

500689(1)

500705(1)

501487(1)

501546(1)

500350(1)

39003(1)

33750(1)

39000(1)

39001(1)

39002(1)

501619(1)

501677(1)

504917(1)

504918(1)

11008130(1)

11008131(1)

504916(1)

504915(1)

504874(1)

504913(1)

504914(1)

75424(1)

75421(1)

06897(1)

06898(1)

06922(1)

06927(1)

06547(1)

06546(1)

06430(1)

06433(1)

06437(1)

06451(1)

06930(1)

06931(1)

20513(1)

20513CT(1)

20527(1)

20527CT(1)

20421PL(1)

20421EA(1)

10107(1)

10117(1)

11248(1)

20421CT(1)

06239(1)

06125(1)

00050(1)

00055(1)

00374CT(1)

00374EA(1)

00019(1)

00016(1)

599961590(1)

8599961590(1)

320820(1)

320840(1)

006546(1)

01014(1)

0529CPL(1)

06114(1)

06119(1)

06122(1)

0529C(1)

01720CT(1)

01500(1)

01501(1)

01720(1)

20540(1)

20540CT(1)

2410(1)

2431(1)

2440(1)

2709(1)

2401(1)

1450(1)

705024(1)

0460(1)

0470(1)

0603(1)

2851(1)

4202(1)

75412(1)

75413(1)

75415(1)

75416(1)

75411(1)

75410(1)

4483(1)

910(1)

953(1)

970(1)

70500(1)

70400(1)

63102(1)

63103(1)

63104(1)

30200(1)

63101(1)

63100CT(1)

20630(1)

52320(1)

63006(1)

63100(1)

30210(1)

302142(1)

39930274021(1)

39930404021(1)

40300(1)

60000(1)

308042(1)

30800(1)

30220(1)

302742(1)

30400(1)

1099961590(1)

 
Country of Origin

US(172)

IT(15)

 
For Use With

Drip Coffee Brewers(17)

Commercial Coffee Brewers(17)

Pod Brewers(9)

Single Cup Brewers(9)

Standard Coffee Brewers(3)

Lavazza 2312 BLUE Machine(3)

Keurig K-Cup System(2)

LavAzza Espresso Point Machine(2)

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

LavAzza Espresso Point Machine (sold separately)(1)

Pod Espresso Brewer(1)

1/2-Gallon Brewers(1)

 
Capacity (Volume)

10 oz(2)

8 oz(2)

0.9 oz(1)

6 oz(1)

 
Capacity (Weight)

2.5 oz(26)

1.5 oz(17)

0.3 oz(17)

2 oz(16)

1 lb(13)

0.9 oz(6)

0.35 oz(6)

1.4 oz(4)

0.12 oz(4)

2.25 oz(4)

28 oz(3)

30.5 oz(3)

1.75 oz(3)

0.25 oz(3)

1.1 oz(3)

2.2 lbs(3)

30.6 oz(2)

8 g(2)

22.6 oz(2)

1.2 oz(2)

32 oz(2)

0.1 oz(2)

0.06 oz(2)

48 oz(2)

10 oz(2)

7 g(2)

1.05 oz(2)

16 oz(2)

31.1 oz(2)

25.4 oz(2)

8 oz(2)

0.6 oz(2)

24.2 oz(2)

34.5 oz(1)

31 oz(1)

36 oz(1)

1.25 oz(1)

9 g(1)

0.8 oz(1)

0.8(1)

29.3 oz(1)

0.7 oz(1)

33.9 oz(1)

26 oz(1)

 
Roast Type

Medium(28)

Dark(28)

Light(4)

Dark Roast(3)

Light Roast(2)

Medium Roast(1)

 
 
 

© 2019-2020 Office Outfitters, All Rights Reserved