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_27` 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

Green Mountain Coffee(67)

Folgers(55)

Starbucks(37)

Peet's Coffee & Tea(20)

Lavazza(19)

1850(16)

Day to Day Coffee(15)

Caribou Coffee(14)

Café Bustelo(14)

Tully's Coffee(14)

Maxwell House(13)

PapaNicholas Coffee(10)

Eight O'Clock(9)

Java One(9)

Barista Prima Coffeehouse(8)

Melitta(8)

Gloria Jean's(6)

Donut House(6)

Nescafé(6)

Distant Lands Coffee(6)

Dunkin Donuts(6)

Seattle's Best(5)

NESCAFÉ Dolce Gusto(5)

New England Coffee(5)

Diedrich Coffee(5)

Newman's Own Organics(5)

Hills Bros.(4)

The Original Donut Shop(4)

Coffee People(4)

Gevalia(4)

Café Escapes(4)

McCafe(4)

National Coffee Roasters(3)

revv(3)

Yuban(3)

Krispy Kreme Doughnuts(3)

Kahlúa(2)

Chase & Sanborn(2)

Emeril's(2)

BUSTELO cool(2)

Chock full o'Nuts(1)

Cinnabon(1)

Dolce Gusto(1)

Office Snax(1)

GFIC(1)

 
Quantity

36 per carton(4)

42 per carton(4)

24 per box(3)

40 per box(2)

18 per carton(1)

96 per carton(1)

12 per pack(1)

24 per carton(1)

 
Packing Type

K-Cup(193)

Bag(52)

Fraction Pack(51)

Packet(34)

Pod(31)

Can(15)

Canister(12)

Stick(10)

Filter Pack(9)

Capsule(6)

Portion Pack(5)

Lavazza BLUE Capsule(3)

Vacket Pack(3)

Cartridges(3)

Jar(2)

Brick Pack(2)

Coffee Pod(1)

 
Flavor

French Roast(24)

House Blend(16)

Breakfast Blend(16)

Classic Roast(15)

Espresso(11)

Hazelnut(9)

Regular(9)

French Vanilla(9)

Original Blend(8)

Original(7)

Italian Roast(7)

Classic Roast Decaf(6)

Assorted(6)

Dark Roast(6)

100% Colombian(6)

Pioneer Blend(5)

Decaffeinated(5)

Caffe Verona(5)

House Blend Decaf(5)

Black Gold(5)

Decaf House Blend(5)

Black Silk(5)

Medium Roast(5)

Colombian(4)

Breakfast Blend Decaf(4)

Pike Place Decaf(4)

Morning Blend(4)

Pike Place(4)

Hazelnut Creme(4)

Colombian Decaf(4)

Major Dickason's Blend(4)

Daybreak Morning Blend(3)

Caribou Blend(3)

Colombia(3)

Veranda Blend(3)

Vermont Country Blend Decaf(3)

Nantucket Blend(3)

Vermont Country Blend(3)

Lantern Glow(3)

Mocha(2)

Caramel(2)

Wild Mountain Blueberry(2)

Southern Pecan(2)

Single Origin Colombian Select(2)

Mahogany(2)

Half-Caff(2)

Gran Filtro Dark Roast(2)

Half Caff(2)

Pumpkin Spice(2)

Hawaiian Islands Blend(2)

Simply Smooth(2)

Special Roast(2)

Morning Edition(2)

Caramel Vanilla Cream(2)

Island Coconut(2)

Hawaiian Blend(2)

Our Blend(2)

Lake & Lodge(2)

Donut House(2)

Café Domingo Blend(2)

Espresso Decaf(2)

Vanilla Hazelnut(2)

Caribou Blend Decaf(2)

Donut Shop(2)

French Vanilla Decaf(2)

Colombian Supremo(2)

Gran Filtro Light Roast(2)

Special Blend Extra Bold(2)

French Roast Decaf(2)

Emeril's Big Easy Bold(2)

Hazelnut Cream(2)

Donut House Decaf(2)

Trailblazer(2)

Traditional Roast(2)

Special Decaf(2)

Butter Toffee(2)

Chocolate Glazed Donut(2)

Hazelnut Decaf(2)

Kahlúa Original(2)

Organic Sumatran Extra Bold(2)

Dark Magic Decaf Extra Bold(2)

Double Black Diamond Extra Bold(2)

Dark Magic Extra Bold(2)

Buzzworthy (Dark Roast)(1)

Love at First Sip (Medium Roast)(1)

Rotondo/Dark Roast(1)

Aroma Club 100% Arabica Blend(1)

Parisian Vanilla(1)

Sumatra Mandheling(1)

100% Arabica Blend Decaf(1)

Filtro Classico Medium Roast(1)

Decaffeinated Medium Roast(1)

Crema Aroma Arabica/Robusta(1)

Crema Dolce/Medium Roast(1)

Vanilla Latte Macchiato(1)

Colombia Medium(1)

Decaf Pike Place Roast(1)

Special Delivery(1)

Regular Roast(1)

Sumatra(1)

Costa Rican La Sonrisa(1)

Pike Place Roast(1)

Veranda(1)

Portside Blend(1)

Pier 70 Blend(1)

FT Vanilla(1)

Sumatran(1)

Veranda Blend Blonde Roast(1)

6th Avenue Bistro(1)

Cafe Domingo(1)

Decaffeinated French Roast(1)

Eye Opener(1)

Caramel Latte Macchiato(1)

French Dark Roast(1)

Original Roast Decaf(1)

Breakfast Blend (Light Roast)(1)

Parisian Café (Dark Roast)(1)

Lungo Decaf(1)

Cappuccino(1)

Kona Blend(1)

Special House Blend(1)

Colombian Blend(1)

Decaf Portside Blend(1)

Chococino(1)

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

Decaf Italian Roast(1)

Extra Bold Breakfast Blend(1)

Signature Blend(1)

Dunkin' Dark(1)

Dunkin' Decaf(1)

Lively Colombian Decaf(1)

Original Roast(1)

Dark Royal(1)

Perfetto(1)

Cinnamon Sugar Cookie(1)

Toasted Marshmallow Mocha(1)

Signature Blend Decaf(1)

Morning Café(1)

100% Colombian Decaf(1)

Estilo Espresso(1)

Café con Leche(1)

Medium Decaf(1)

Donut Shop Decaf(1)

Decaf Caribou Blend(1)

Café con Leche Chocolate(1)

Gourmet Supreme(1)

Traditional Roast Decaf(1)

Pioneer Blend Decaf(1)

Country Roast(1)

Decaf Classic(1)

Gran Aroma(1)

Classic(1)

NO SURRENDER(1)

Bold 1937(1)

Cafe Vanilla(1)

Rio Blend(1)

Morning Edition Decaf(1)

Caramel Hideaway(1)

Premium Roast(1)

Estate Costa Rican(1)

Dark Blend(1)

Round the Clock Blend(1)

Premium Roast Decaf(1)

TURBOCHARGER(1)

AFTERBURNER(1)

Cinnamon Roll(1)

Coconut Mocha(1)

Holiday Blend(1)

Classic Decaf(1)

Original Decaf(1)

Brazil Minas Naturais(1)

Caramel Drizzle(1)

Big Bang(1)

Vanilla Biscotti(1)

Lively Colombian(1)

Colombian De Jardin(1)

 
Beverage Type

Coffee(350)

Decaffeinated Coffee(68)

Instant Coffee(6)

Half-caffeinated Coffee(4)

Coffee Drink(2)

Hot Chocolate(1)

Instant Decaffeinated Coffee(1)

 
Manufacturer Part Number

0460(1)

0470(1)

705024(1)

70500(1)

70400(1)

0603(1)

1450(1)

2440(1)

2709(1)

2431(1)

2410(1)

2401(1)

60000(1)

40300(1)

30210(1)

302142(1)

30200(1)

PB4141CT(1)

PB4141(1)

30220(1)

302742(1)

39930274021(1)

39930404021(1)

308042(1)

30800(1)

30400(1)

2851(1)

4202(1)

390390(1)

395640(1)

04658(1)

04648PLT(1)

04648CT(1)

862400(1)

866150(1)

026260(1)

026480(1)

026190(1)

026160(1)

866350(1)

04648(1)

75424(1)

970(1)

75410(1)

953(1)

910(1)

4483(1)

75411(1)

75412(1)

75421(1)

75416(1)

75415(1)

75413(1)

7792CT(1)

7792(1)

6803CT(1)

6812(1)

6803(1)

6792CT(1)

6792(1)

6813(1)

6873(1)

6992(1)

6992CT(1)

6990CT(1)

6990(1)

6974(1)

6783CT(1)

6783(1)

6743CT(1)

6744(1)

6743(1)

6732CT(1)

6732(1)

6745(1)

6746(1)

6772CT(1)

6772(1)

6758CT(1)

6758(1)

6994(1)

6994CT(1)

7564(1)

7586(1)

7563(1)

7534CT(1)

7534(1)

7602(1)

7602CT(1)

7732(1)

7732CT(1)

7608(1)

7607(1)

7605(1)

7522CT(1)

7522(1)

6999(1)

6999CT(1)

6996(1)

6995CT(1)

6995(1)

7000(1)

71550(1)

7468(1)

7467(1)

7466(1)

7465(1)

026530(1)

02430(1)

11008130(1)

11008131(1)

011068092CT(1)

011068092(1)

011067987CT(1)

11015640(1)

11017854(1)

11018185(1)

11018186(1)

11018131(1)

11017871(1)

11017860EA(1)

011067987(1)

011067986CT(1)

504918(1)

011067983(1)

504917(1)

504916(1)

504915(1)

011067983CT(1)

011067984(1)

011067986(1)

011067985CT(1)

011067985(1)

011067984CT(1)

11018187(1)

11018190(1)

11008556(1)

11008558(1)

11008554(1)

1092836(1)

11075823(1)

11008560(1)

1261330(1)

863070(1)

866550(1)

04707(1)

PB4137CT(1)

PB4137(1)

11075822(1)

11029358(1)

11018197(1)

11019631(1)

11018194(1)

11018193(1)

11018192(1)

11019880(1)

11019881(1)

11028510(1)

11028473(1)

11023061(1)

11020676(1)

504914(1)

504913(1)

02059(1)

32410(1)

01101(1)

01096(1)

01084(1)

33000(1)

21001(1)

23002(1)

23003(1)

23001(1)

22005(1)

22002(1)

01027(1)

00058(1)

27376(1)

32486(1)

27329(1)

15782CT(1)

15782(1)

66488(1)

66488CT(1)

87066(1)

86073(1)

77317(1)

69749(1)

23004(1)

23005(1)

39003(1)

500350(1)

39002(1)

39001(1)

39000(1)

500689(1)

500705(1)

501677(1)

504874(1)

501619(1)

501546(1)

501487(1)

33750(1)

33700(1)

25184(1)

25185(1)

25183(1)

25182(1)

25181(1)

25186(1)

25187(1)

33300(1)

32006(1)

32003(1)

25188(1)

6728(1)

6727(1)

21513(1)

52320(1)

21512(1)

21511(1)

21510(1)

56375(1)

56376(1)

60514EA(1)

60515(1)

60514(1)

60513EA(1)

60513(1)

20672(1)

20630(1)

20421EA(1)

20421PL(1)

20421CT(1)

11545BX(1)

11545(1)

20513(1)

20513CT(1)

20540CT(1)

20540(1)

20527CT(1)

20527(1)

60515EA(1)

60516(1)

0846(1)

0847(1)

0845(1)

0570(1)

0448(1)

0848(1)

0849(1)

192519CT(1)

192619(1)

192519(1)

192419CT(1)

192419(1)

0162(1)

63104(1)

60518(1)

60518EA(1)

60517EA(1)

60517(1)

60516EA(1)

63006(1)

63100(1)

63103(1)

63102(1)

63101(1)

63100CT(1)

11544BX(1)

11544(1)

320840(1)

00016(1)

320820(1)

8599961590(1)

599961590(1)

00019(1)

00050(1)

00374EA(1)

006546(1)

00374CT(1)

00055(1)

00050CT(1)

1099961590(1)

60224-101(1)

60051-012(1)

60051012CT(1)

008715(1)

008712(1)

008711(1)

60051-046(1)

60051046CT(1)

60052101CT(1)

60052-101(1)

60051052CT(1)

60051-052(1)

01014(1)

01074(1)

06897(1)

06898(1)

06547(1)

06546(1)

06451(1)

06922(1)

06927(1)

10117(1)

11248(1)

10107(1)

06931(1)

06930(1)

06437(1)

06433(1)

01720CT(1)

0529C(1)

01720(1)

01501(1)

01500(1)

06114(1)

06119(1)

06430(1)

06239(1)

06125(1)

06122(1)

192619CT(1)

192719(1)

6543(1)

6544(1)

6542(1)

6534CT(1)

6534(1)

6545(1)

6546(1)

6602(1)

6602CT(1)

6570CT(1)

6570(1)

6547(1)

6523CT(1)

6523(1)

6501(1)

6501CT(1)

6425(1)

6408(1)

6407(1)

6502(1)

6502CT(1)

6520CT(1)

6520(1)

6503CT(1)

6503(1)

6606(1)

6606CT(1)

6685CT(1)

6694(1)

6685(1)

6680(1)

6664(1)

6694CT(1)

6700(1)

6722(1)

6722CT(1)

6720CT(1)

6720(1)

6700CT(1)

6663CT(1)

6663(1)

6613(1)

6613CT(1)

6612(1)

6611CT(1)

6611(1)

6614(1)

6614CT(1)

6662(1)

6661(1)

6659(1)

6624(1)

6406CT(1)

6406(1)

4067CT(1)

4162(1)

4067(1)

4066CT(1)

4066(1)

4432(1)

4441(1)

4792(1)

5161(1)

4732(1)

4493(1)

4461(1)

4061CT(1)

4061(1)

193019(1)

193019CT(1)

192919CT(1)

192919(1)

192719CT(1)

4050(1)

4050CT(1)

4060CT(1)

4060(1)

4051CT(1)

4051(1)

5303(1)

5304(1)

6106(1)

6107(1)

6006(1)

6003CT(1)

6003(1)

6110(1)

6111(1)

6405(1)

6405CT(1)

6305(1)

6248(1)

6204(1)

6002(1)

6001(1)

5469(1)

5470(1)

5462CT(1)

5339(1)

5305(1)

5471(1)

5493(1)

6000(1)

5814(1)

5807(1)

5531(1)

008710(1)

 
Country of Origin

US(370)

CA(41)

IT(15)

GB(4)

ES(1)

AX(1)

 
For Use With

Keurig K-Cup System(190)

Commercial Coffee Brewers(28)

Drip Coffee Brewers(15)

Single Cup Brewers(9)

Pod Brewers(9)

NESCAFÉ Dolce Gusto Machines(5)

Single Cup Brewers Hamilton, Bunn and Newco(4)

Standard Coffee Brewers(4)

Keurig Brewing System(3)

Lavazza 2312 BLUE Machine(3)

LavAzza Espresso Point Machine(2)

Standard and Commercial Coffee Makers(2)

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

1/2-Gallon Brewers(1)

Pod Espresso Brewer(1)

Any traditional coffee maker(1)

LavAzza Espresso Point Machine (sold separately)(1)

 
Capacity (Volume)

0.38 oz(4)

0.27 oz(3)

10 oz(2)

8 oz(2)

0(1)

25.1 oz(1)

6 oz(1)

0.9 oz(1)

 
Capacity (Weight)

2.5 oz(34)

1 lb(19)

0.3 oz(17)

1.5 oz(17)

2 oz(14)

12 oz(12)

2.2 oz(8)

0.9 oz(6)

0.35 oz(6)

0.4 oz(5)

0.06 oz(4)

2.25 oz(4)

1.4 oz(4)

0.12 oz(4)

2.2 lbs(3)

0.25 oz(3)

30.5 oz(3)

1.75 oz(3)

10 oz(3)

28 oz(3)

1.1 oz(3)

30.6 oz(3)

0.1 oz(2)

32 oz(2)

1.2 oz(2)

8 g(2)

2.5 lbs(2)

7 g(2)

0.6 oz(2)

1.05 oz(2)

22.6 oz(2)

31.1 oz(2)

8 oz(2)

24.2 oz(2)

25.4 oz(2)

16 oz(2)

34.5 oz(1)

48 oz(1)

45 oz(1)

31 oz(1)

1.25 oz(1)

2 oz.(1)

36 oz(1)

0.8(1)

0.7 oz(1)

29.3 oz(1)

9 g(1)

1.93 oz(1)

5 lb(1)

33.9 oz(1)

0.8 oz(1)

26 oz(1)

 
Roast Type

Medium(122)

Dark(96)

Light(41)

Dark Roast(3)

Medium Roast(1)

 
 
 

© 2019-2020 Hi Tech Office Products, All Rights Reserved