0

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

Green Mountain Coffee(81)

Folgers(59)

Lavazza(31)

Peet's Coffee & Tea(19)

Marley Coffee(19)

Starbucks(17)

Tully's Coffee(17)

Day to Day Coffee(15)

PapaNicholas Coffee(14)

Caribou Coffee(10)

Maxwell House(10)

Java One(9)

Eight O'Clock(9)

Barista Prima Coffeehouse(8)

Gloria Jean's(8)

Melitta(8)

Café Bustelo(8)

The Original Donut Shop(7)

Timothy's World Coffee(6)

Diedrich Coffee(6)

Donut House(6)

Distant Lands Coffee(6)

Newman's Own Organics(5)

Dunkin Donuts(5)

Seattle's Best(5)

National Coffee Roasters(5)

New England Coffee(5)

Hills Bros.(4)

Nescafé(4)

Coffee-mate(4)

Café Escapes(4)

Gevalia(4)

Panera Bread(3)

revv(3)

Chase & Sanborn(3)

Yuban(3)

GFIC(2)

Kahlúa(2)

Office Snax(2)

Krispy Kreme Doughnuts(2)

VERSANTO(2)

Van Houtte(2)

BUSTELO cool(2)

Emeril's(2)

Cinnabon(1)

Chock full o'Nuts(1)

Dunkin' Donuts(1)

 
Quantity

1 each(29)

24 per box(22)

16 per box(10)

12 per box(8)

18 per box(7)

42 per carton(7)

100 per box(6)

96 per carton(6)

36 per carton(5)

6 per carton(3)

42 per box(3)

30 per carton(3)

15 per box(2)

18 per carton(2)

100 per carton(2)

40 per box(2)

14 per box(2)

8 per box(2)

12 per pack(1)

1 bag(1)

22 per box(1)

50 per carton(1)

63 per carton(1)

60 per carton(1)

24 per carton(1)

88 per carton(1)

 
Packing Type

K-Cup(185)

Fraction Pack(51)

Bag(49)

Pod(39)

Packet(34)

Can(15)

Canister(14)

Filter Pack(11)

Vue Pack(9)

Stick(8)

Lavazza BLUE Capsule(6)

Cartridges(6)

Portion Pack(5)

Pump Bottle(4)

Vacuum Bag(3)

Vacket Pack(3)

Jar(2)

Brick Pack(2)

Travel Mug Vue Pack(2)

Coffee Pod(1)

 
Flavor

French Roast(21)

House Blend(16)

Classic Roast(16)

Breakfast Blend(14)

Hazelnut(13)

French Vanilla(12)

Regular(9)

Original Blend(9)

Espresso(9)

Original(7)

Dark Roast(7)

Medium Roast(7)

Italian Roast(7)

Classic Roast Decaf(6)

Assorted(6)

Decaffeinated(5)

Black Silk(5)

Breakfast Blend Decaf(5)

100% Colombian(5)

Hazelnut Creme(4)

Nantucket Blend(4)

House Blend Decaf(4)

Decaf House Blend(4)

Colombian Decaf(4)

Colombian(4)

Major Dickason's Blend(4)

Simmer Down Swiss Water Decaf(3)

Pumpkin Spice(3)

Half-Caff(3)

Vermont Country Blend Decaf(3)

Morning Blend(3)

Morning Café(3)

Colombia(3)

Vermont Country Blend(3)

Get Up, Stand Up(3)

Hawaiian Blend(3)

One Love(3)

Caramel Vanilla Cream(2)

Our Blend(2)

Morning Edition(2)

Mocha Nut Fudge(2)

Café Domingo Blend(2)

Donut House(2)

Southern Pecan(2)

Lake & Lodge(2)

Wild Mountain Blueberry(2)

Chocolate Glazed Donut(2)

Butter Toffee(2)

Mocha(2)

Lively Up(2)

Emeril's Big Easy Bold(2)

Pike Place Decaf(2)

Pike Place(2)

Caffe Verona(2)

High Octane Premium(2)

Hawaiian Islands Blend(2)

Cafe Mocha(2)

Buffalo Soldier(2)

Jamaica Blue Mountain Blend(2)

Filtro Classico Medium Roast(2)

Mahogany(2)

Gran Filtro Dark Roast(2)

Gran Filtro Light Roast(2)

Colombian Supremo(2)

Kahlúa Original(2)

Caramel(2)

Donut House Decaf(2)

Caribou Blend Decaf(2)

Daybreak Morning Blend(2)

Caribou Blend(2)

French Vanilla Decaf(2)

Island Coconut(2)

Single Origin Colombian Select(2)

Dark Magic Decaf Extra Bold(2)

Hazelnut Cream(2)

Country Roast(2)

Half Caff(2)

Simply Smooth(2)

Special Roast(2)

French Roast Decaf(2)

Special Blend Extra Bold(2)

Special Decaf(2)

Organic Sumatran Extra Bold(2)

Dark Magic Extra Bold(2)

Double Black Diamond Extra Bold(2)

Kenyan AA(2)

Mudslide(2)

Donut Shop Regular(2)

Donut Shop Decaf(2)

Medium Decaf(1)

Love at First Sip (Medium Roast)(1)

2 Get Up, Stand Up; 2 Buffalo Soldier; 2 Lively Up; 2 One Love; 2 Simmer Down Decaf; 2 Smile Jamaica(1)

Portside Blend(1)

6th Avenue Bistro(1)

Decaf Classic(1)

Lively Up!(1)

Parisian Café (Dark Roast)(1)

Breakfast Blend (Light Roast)(1)

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

Special Delivery(1)

Talkin' Blues Jamaica Blue Mountain(1)

Buzzworthy (Dark Roast)(1)

Parisian Vanilla(1)

Crema Dolce/Medium Roast(1)

Ricco/Dark Roast(1)

Rotondo/Dark Roast(1)

Rotondo/Dark Roast Double(1)

Intenso/Medium Roast(1)

Decaffeinated Medium Roast(1)

Espresso Roast(1)

Arabica Blend(1)

Pier 70 Blend(1)

Mystic Morning(1)

Gourmet Supreme(1)

Columbia(1)

Sumatra(1)

Cinnamon Coffee Cake(1)

Decaf Colombian(1)

Donut Blend(1)

Decaffeinated French Roast(1)

Special House Blend(1)

French Vanilla Cruller(1)

Kona Blend(1)

Veranda(1)

Colombian Blend(1)

Colombia Medium(1)

Decaf(1)

Veranda Blend(1)

Café con Leche(1)

Café con Leche Chocolate(1)

Regular Traditional Roast(1)

FT Vanilla(1)

Eye Opener(1)

Decaf Portside Blend(1)

French Dark Roast(1)

Original Roast Decaf(1)

Traditional Roast(1)

Crema Aroma Arabica/Robusta(1)

Traditional Roast Decaf(1)

Brazil Minas Naturais(1)

TURBOCHARGER(1)

AFTERBURNER(1)

Caramel Drizzle(1)

Vanilla Biscotti(1)

Lively Colombian(1)

Decaf Italian Roast(1)

Colombia Select(1)

Fair Trade Organic Breakfast Blend(1)

Signature Blend(1)

Original Roast(1)

Dark Royal(1)

Signature Blend Decaf(1)

Rio Blend(1)

Cinnamon Sugar Cookie(1)

Perfetto(1)

Original Decaf(1)

Gran Aroma(1)

Toasted Marshmallow Mocha(1)

Cinnamon Roll(1)

Coconut Mocha(1)

Holiday Blend(1)

Summer Sunrise(1)

Classic Decaf(1)

Classic(1)

Morning Edition Decaf(1)

Extra Bold Breakfast Blend(1)

100% Arabica Blend Decaf(1)

Regular Extra Bold Coffee(1)

Tierra 100% Arabica Blend(1)

Aroma Club 100% Arabica Blend(1)

Vanilla Hazelnut Decaf(1)

Aroma Point Blue Arabica/Robusta(1)

100% Colombian Decaf(1)

Sumatra Mandheling(1)

Hazelnut Crème(1)

Costa Rican La Sonrisa(1)

Colombian De Jardin(1)

Estate Costa Rican(1)

Raspberry Chocolate Truffle(1)

Decaf Extra Bold(1)

Cafe Vanilla(1)

Dark Magic(1)

Lively Colombian Decaf(1)

Dunkin' Decaf(1)

Dunkin' Dark(1)

Vanilla Hazelnut(1)

Italian Blend(1)

Caramel Hideaway(1)

Decaffeinated Colombian(1)

German Chocolate Cake(1)

Rainforest Espresso(1)

Cinnamon Pastry(1)

NO SURRENDER(1)

Regular Roast(1)

 
Beverage Type

Coffee(378)

Decaffeinated Coffee(60)

Half-caffeinated Coffee(4)

Instant Coffee(4)

Coffee Drink(2)

Instant Decaffeinated Coffee(1)

 
Manufacturer Part Number

4066(2)

1450(1)

7509(1)

4483(1)

4202(1)

3302(1)

2851(1)

2850(1)

2709(1)

2440(1)

2431(1)

2410(1)

2401(1)

0603(1)

7511(1)

0490(1)

0470(1)

0460(1)

0427(1)

0425(1)

705024(1)

70500(1)

70400(1)

60000(1)

4097(1)

4073(1)

7510(1)

7512(1)

39930404021(1)

75424(1)

02448(1)

02424(1)

02400(1)

02394(1)

02370(1)

02363(1)

02226(1)

02141(1)

02127(1)

02103(1)

02097(1)

75421(1)

910(1)

75416(1)

75415(1)

75413(1)

75412(1)

75411(1)

75410(1)

970(1)

960(1)

953(1)

950(1)

940(1)

40300(1)

60051-012(1)

02561(1)

6992CT(1)

7522CT(1)

7522(1)

71550(1)

7000(1)

6999CT(1)

6999(1)

6996(1)

6995CT(1)

6995(1)

6994CT(1)

6994(1)

6992(1)

7534CT(1)

6990CT(1)

6990(1)

6873(1)

6813(1)

6812(1)

6803CT(1)

6803(1)

6792CT(1)

6792(1)

6783CT(1)

6783(1)

7534(1)

7602(1)

308042(1)

9349(1)

30800(1)

30400(1)

302742(1)

30220(1)

302142(1)

30210(1)

30200(1)

PB4141CT(1)

PB4141(1)

9397(1)

9352(1)

9341(1)

7602CT(1)

9335(1)

9312(1)

9304(1)

9303(1)

9302(1)

9301(1)

9300(1)

7792CT(1)

7792(1)

7732CT(1)

7732(1)

39930274021(1)

02592(1)

6772(1)

500350(1)

504917(1)

504916(1)

504915(1)

504914(1)

504913(1)

501677(1)

501619(1)

501546(1)

501487(1)

500705(1)

500689(1)

93251(1)

11008130(1)

93110(1)

85108(1)

85107(1)

85106(1)

85105(1)

39003(1)

39002(1)

39001(1)

39000(1)

33750(1)

33700(1)

504918(1)

11008131(1)

32006(1)

11023061(1)

863070(1)

04707(1)

PB4137CT(1)

PB4137(1)

1014962(1)

11008560(1)

11008558(1)

11008556(1)

11008554(1)

1092836(1)

11029358(1)

11020676(1)

11018131(1)

11019881(1)

11019880(1)

11019631(1)

11018197(1)

11018194(1)

11018193(1)

11018192(1)

11018190(1)

11018187(1)

11018186(1)

11018185(1)

33300(1)

32003(1)

02875(1)

862400(1)

47337(1)

32486(1)

15782(1)

11062(1)

026530(1)

026480(1)

026260(1)

026190(1)

026160(1)

866350(1)

866150(1)

395680(1)

66488(1)

395640(1)

390390(1)

04658(1)

04648PLT(1)

04648CT(1)

04648(1)

20031(1)

02967(1)

02943(1)

02905(1)

02882(1)

50930(1)

83426(1)

25188(1)

23001(1)

25187(1)

25186(1)

25185(1)

25184(1)

25183(1)

25182(1)

25181(1)

23005(1)

23004(1)

23003(1)

23002(1)

22005(1)

86073(1)

22002(1)

21001(1)

33000(1)

32420(1)

32410(1)

02059(1)

01101(1)

01096(1)

01084(1)

01027(1)

00058(1)

00034(1)

6772CT(1)

6758CT(1)

60051012CT(1)

63100(1)

0845(1)

0570(1)

0448(1)

0243(1)

0162(1)

72909(1)

63104(1)

63103(1)

63102(1)

63101(1)

63100CT(1)

63018(1)

0847(1)

63015(1)

63006(1)

52320(1)

20631CT(1)

20631(1)

20630(1)

20540CT(1)

20540(1)

20527CT(1)

20527(1)

20513CT(1)

0846(1)

0848(1)

20421PL(1)

192719(1)

4057CT(1)

4057(1)

4051CT(1)

4051(1)

4050CT(1)

4050(1)

193019CT(1)

193019(1)

192919CT(1)

192919(1)

192719CT(1)

192619CT(1)

0849(1)

192619(1)

192519CT(1)

192519(1)

192419CT(1)

192419(1)

1135(1)

1120(1)

1113(1)

1109(1)

1102(1)

1101(1)

20513(1)

20421EA(1)

4060CT(1)

2299961590(1)

00518X(1)

00374EA(1)

00374CT(1)

00055(1)

00050(1)

00019(1)

00016(1)

320840(1)

320820(1)

8599961590(1)

599961590(1)

22499961590(1)

01500(1)

1099961590(1)

60224101CT(1)

60224-101(1)

60052101CT(1)

60052-101(1)

60051056CT(1)

60051-056(1)

60051052CT(1)

60051-052(1)

60051046CT(1)

60051-046(1)

01014(1)

01501(1)

20421CT(1)

06547(1)

20121CT(1)

20121(1)

11248(1)

10117(1)

10107(1)

06931(1)

06930(1)

06927(1)

06922(1)

06898(1)

06897(1)

06546(1)

01720(1)

06451(1)

06437(1)

06433(1)

06430(1)

06239(1)

06125(1)

06122(1)

06119(1)

06114(1)

0529C(1)

01720CT(1)

4060(1)

4061(1)

6758(1)

6570CT(1)

6614CT(1)

6614(1)

6613CT(1)

6613(1)

6612(1)

6611CT(1)

6611(1)

6606CT(1)

6606(1)

6602CT(1)

6602(1)

6570(1)

6659(1)

6547(1)

6546(1)

6545(1)

6544(1)

6543(1)

6542(1)

6534CT(1)

6534(1)

6523CT(1)

6523(1)

6520CT(1)

6624(1)

6661(1)

6503CT(1)

6722CT(1)

6752CT(1)

6752(1)

6746(1)

6745(1)

6744(1)

6743CT(1)

6743(1)

6732CT(1)

6732(1)

6728(1)

6727(1)

6722(1)

6662(1)

6720CT(1)

6720(1)

6700CT(1)

6700(1)

6694CT(1)

6694(1)

6685CT(1)

6685(1)

6680(1)

6663CT(1)

6663(1)

6520(1)

6503(1)

4061CT(1)

5161(1)

6000(1)

5814(1)

5531(1)

5493(1)

5471(1)

5470(1)

5469(1)

5339(1)

5305(1)

5304(1)

5303(1)

4792(1)

6002(1)

4732(1)

4493(1)

4461(1)

4441(1)

4432(1)

4426(1)

4162(1)

4092(1)

4067CT(1)

4067(1)

4066CT(1)

6001(1)

6003(1)

6502CT(1)

6377(1)

6502(1)

6501CT(1)

6501(1)

6425(1)

6408(1)

6407(1)

6406CT(1)

6406(1)

6405CT(1)

6405(1)

6378(1)

6376(1)

6003CT(1)

6336(1)

6305(1)

6248(1)

6204(1)

6115(1)

6111(1)

6110(1)

6107(1)

6106(1)

6024(1)

6006(1)

866550(1)

 
Country of Origin

US(399)

IT(27)

CA(16)

CO(6)

JM(1)

 
For Use With

Keurig K-Cup System(151)

Keurig Brewing System(29)

Commercial Coffee Brewers(25)

Drip Coffee Brewers(14)

Keurig Vue Brewing System(9)

Pod Brewers(9)

Single Cup Brewers(9)

Standard Coffee Brewers(5)

B-40; B-60; B-70; B-100(5)

Soft Pod Coffee Brewers(4)

Drip Coffee Maker; French Press(4)

LavAzza Espresso Point Machine (sold separately)(4)

Lavazza 2312 BLUE Machine(3)

Standard and Commercial Coffee Makers(2)

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

LavAzza Espresso Point Machine(2)

Lavazza 2312(2)

Single Serve Pod Brewing Systems(2)

Keurig Vue Brewing System(1)

Keurig Vue System Brewers(1)

1/2-Gallon Brewers(1)

Home Brewers(1)

Electric Espresso Machines(1)

Any traditional coffee maker(1)

Lavazza BLUE 2312 and 910 Machines(1)

Pod Espresso Brewer(1)

 
Capacity (Volume)

1.5 L(4)

12 oz(3)

8 oz(2)

10 oz(2)

48 oz(1)

0.9 oz(1)

 
Capacity (Weight)

2.5 oz(32)

1.5 oz(19)

0.3 oz(17)

2 oz(15)

1 lb(13)

8 oz(10)

2.2 oz(9)

0.34 oz(6)

0.35 oz(6)

0.4 oz(6)

0.9 oz(6)

0.25 oz(5)

10 oz(5)

1.4 oz(4)

8 g(4)

2.2 lbs(4)

2.25 oz(4)

0.12 oz(4)

2.5 lbs(4)

0.75 oz(4)

12 oz(4)

31.1 oz(4)

1.1 oz(3)

1.75 oz(3)

30.6 oz(3)

30.5 oz(3)

28 oz(3)

0.1 oz(2)

1.25 oz(2)

32 oz(2)

1.2 oz(2)

0.7 oz(2)

0.06 oz(2)

0.6 oz(2)

1.05 oz(2)

22.6 oz(2)

7 g(2)

0.31 oz(2)

25.4 oz(2)

24.2 oz(2)

0.8 oz(1)

26 oz(1)

2 oz.(1)

0.8(1)

16 oz(1)

34.5 oz(1)

0.634 oz(1)

33.9 oz(1)

11.5 g(1)

48 oz(1)

0.33 oz(1)

5 lb(1)

29.3 oz(1)

8.8 oz(1)

36 oz(1)

9 g(1)

31 oz(1)

 
Roast Type

Medium(108)

Dark(72)

Light(36)

Dark Roast(5)

Mild(1)

Medium Roast(1)

 
 
 

© 2020-2021 Service Office Supplies, All Rights Reserved