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','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(62)

Folgers(51)

Starbucks(25)

Peet's Coffee & Tea(17)

Lavazza(17)

1850(16)

Day to Day Coffee(15)

Caribou Coffee(13)

Café Bustelo(13)

NESCAFÉ Dolce Gusto(11)

Maxwell House(10)

PapaNicholas Coffee(10)

Tully's Coffee(10)

Eight O'Clock(8)

Melitta(8)

Java One(7)

Nescafé(6)

Distant Lands Coffee(6)

Dunkin Donuts(5)

Seattle's Best(5)

New England Coffee(5)

The Original Donut Shop(5)

Diedrich Coffee(5)

Barista Prima Coffeehouse(4)

Café Escapes(4)

McCafe(4)

Yuban(3)

Gloria Jean's(3)

Gevalia(3)

Newman's Own Organics(3)

National Coffee Roasters(3)

Donut House(2)

Krispy Kreme Doughnuts(2)

Hills Bros.(2)

BUSTELO cool(2)

revv(2)

Kahlúa(1)

Cinnabon(1)

Office Snax(1)

Chock full o'Nuts(1)

Chase & Sanborn(1)

Peet's(1)

 
Quantity

24 per box(18)

42 per carton(6)

22 per box(4)

36 per carton(4)

40 per box(2)

24 per carton(1)

12 per pack(1)

24 per box.(1)

96 per carton(1)

1 each(1)

42 per box(1)

18 per carton(1)

 
Packing Type

K-Cup(144)

Fraction Pack(50)

Bag(49)

Pod(29)

Packet(28)

Can(14)

Canister(13)

Capsule(10)

Filter Pack(8)

Stick(8)

Portion Pack(5)

Vacket Pack(3)

Cartridges(3)

Lavazza BLUE Capsule(2)

Jar(2)

Brick Pack(2)

Coffee Pod(1)

Capsules(1)

 
Flavor

French Roast(20)

Classic Roast(15)

Breakfast Blend(14)

House Blend(13)

Espresso(11)

Hazelnut(9)

French Vanilla(8)

Regular(7)

Original(7)

Assorted(6)

100% Colombian(5)

Dark Roast(5)

Original Blend(5)

Black Silk(5)

Pioneer Blend(5)

Classic Roast Decaf(5)

Black Gold(5)

Colombian(4)

Italian Roast(4)

Caffe Verona(4)

Veranda Blend(4)

Decaf House Blend(4)

Medium Roast(4)

Major Dickason's Blend(4)

Decaffeinated(4)

Hazelnut Creme(4)

Breakfast Blend Decaf(4)

Morning Blend(3)

Vermont Country Blend Decaf(3)

Vermont Country Blend(3)

Daybreak Morning Blend(3)

Pike Place(3)

Caribou Blend(3)

Nantucket Blend(3)

Pike Place Decaf(3)

Lantern Glow(3)

Caramel Vanilla Cream(2)

Caramel Macchiato(2)

Single Origin Colombian Select(2)

Latte Macchiato(2)

Lake & Lodge(2)

Donut House(2)

Café Domingo Blend(2)

Our Blend(2)

Hawaiian Blend(2)

Donut Shop Regular(2)

Morning Edition(2)

Blonde Espresso Roast(2)

Southern Pecan(2)

Wild Mountain Blueberry(2)

Mocha(2)

Dark and Bold(2)

Dark and Intense(2)

Mahogany(2)

Caribou Blend Decaf(2)

Half-Caff(2)

French Vanilla Decaf(2)

Colombian Decaf(2)

Colombian Supremo(2)

Special Blend Extra Bold(2)

Trailblazer(2)

House Blend Decaf(2)

French Roast Decaf(2)

Hawaiian Islands Blend(2)

Organic Sumatran Extra Bold(2)

Dark Magic Extra Bold(2)

Double Black Diamond Extra Bold(2)

Half Caff(2)

Dark Magic Decaf Extra Bold(2)

Simply Smooth(2)

Special Roast(2)

Espresso Decaf(2)

Hazelnut Cream(2)

Sumatra Mandheling(1)

Pike Place Roast(1)

Special House Blend(1)

Decaffeinated French Roast(1)

Gold Selection(1)

Aroma Club 100% Arabica Blend(1)

Sumatra(1)

100% Arabica Blend Decaf(1)

Decaf Pike Place Roast(1)

Light and Aromatic(1)

Special Delivery(1)

Rotondo/Dark Roast(1)

6th Avenue Bistro(1)

Crema Aroma Arabica/Robusta(1)

Decaffeinated Medium Roast(1)

Colombian Blend(1)

Parisian Vanilla(1)

Colombia Medium(1)

Veranda Blend Blonde Roast(1)

Costa Rican La Sonrisa(1)

Cappuccino(1)

Lungo Decaf(1)

Eye Opener(1)

French Dark Roast(1)

Original Roast Decaf(1)

Decaf Portside Blend(1)

Veranda(1)

Pier 70 Blend(1)

Portside Blend(1)

Parisian Café (Dark Roast)(1)

Breakfast Blend (Light Roast)(1)

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

Kona Blend(1)

Love at First Sip (Medium Roast)(1)

Buzzworthy (Dark Roast)(1)

FT Vanilla(1)

Colombia(1)

Colombian De Jardin(1)

100% Colombian Decaf(1)

Dark Royal(1)

Original Roast(1)

Signature Blend(1)

Special Decaf(1)

Extra Bold Breakfast Blend(1)

Dunkin' Dark(1)

Dunkin' Decaf(1)

Lively Colombian Decaf(1)

Morning Café(1)

Traditional Roast(1)

Gran Aroma(1)

Pioneer Blend Decaf(1)

Country Roast(1)

Decaf Classic(1)

Gourmet Supreme(1)

Café con Leche Chocolate(1)

Café con Leche(1)

Medium Decaf(1)

Donut Shop Decaf(1)

Butter Toffee(1)

Decaf Caribou Blend(1)

Perfetto(1)

Classic(1)

Kahlúa Original(1)

Rio Blend(1)

Premium Roast Decaf(1)

Premium Roast(1)

Peppermint Bark(1)

Dark Magic(1)

Caramel Hideaway(1)

NO SURRENDER(1)

Caramel(1)

Cafe Vanilla(1)

Pumpkin Spice(1)

Morning Edition Decaf(1)

Classic Decaf(1)

TURBOCHARGER(1)

Island Coconut(1)

Caramel Drizzle(1)

Vanilla Biscotti(1)

Lively Colombian(1)

Decaf Italian Roast(1)

Decaf Original(1)

Cinnamon Roll(1)

Coconut Mocha(1)

Holiday Blend(1)

Regular Roast(1)

 
Beverage Type

Coffee(310)

Decaffeinated Coffee(49)

Instant Coffee(6)

Half-caffeinated Coffee(4)

Coffee Drink(2)

Instant Decaffeinated Coffee(1)

 
Manufacturer Part Number

008710(1)

0603(1)

3454(1)

3451(1)

3446(1)

3445(1)

3427(1)

3425(1)

2709(1)

1450(1)

0470(1)

4483(1)

0460(1)

705024(1)

70500(1)

70400(1)

60000(1)

40300(1)

39930404021(1)

39930274021(1)

308042(1)

4202(1)

910(1)

302742(1)

04648PLT(1)

026260(1)

026190(1)

026160(1)

866350(1)

866150(1)

862400(1)

390390(1)

04658(1)

04648CT(1)

953(1)

04648(1)

75424(1)

75421(1)

75416(1)

75415(1)

75413(1)

75412(1)

75411(1)

75410(1)

30800(1)

30220(1)

026530(1)

6792CT(1)

6992(1)

6990CT(1)

6990(1)

6873(1)

6813(1)

6812(1)

6803CT(1)

6803(1)

6792(1)

6994(1)

6783CT(1)

6783(1)

6772CT(1)

6772(1)

6758(1)

6746(1)

6745(1)

6744(1)

6743CT(1)

6992CT(1)

6994CT(1)

302142(1)

7522(1)

30200(1)

PB1141(1)

7792CT(1)

7792(1)

7732CT(1)

7732(1)

7602CT(1)

7602(1)

7522CT(1)

7468(1)

6995(1)

7467(1)

7466(1)

7465(1)

7428(1)

7134(1)

6999CT(1)

6999(1)

6996(1)

6995CT(1)

026480(1)

15782(1)

6732CT(1)

504918(1)

11017854(1)

11015640(1)

11008131(1)

11008130(1)

011111161(1)

011111160(1)

011111159(1)

011111156(1)

504917(1)

11017871(1)

504916(1)

504915(1)

504914(1)

504913(1)

504874(1)

501677(1)

501619(1)

501546(1)

501487(1)

11017860EA(1)

11018131(1)

500350(1)

11028473(1)

863070(1)

04707(1)

11008560(1)

11008558(1)

11008556(1)

11008554(1)

1092836(1)

11029358(1)

11028510(1)

11023061(1)

11018185(1)

11020676(1)

11019631(1)

11018197(1)

11018194(1)

11018193(1)

11018192(1)

11018190(1)

11018187(1)

11018186(1)

500705(1)

39003(1)

15782CT(1)

94245BX(1)

01101(1)

01096(1)

01027(1)

00058(1)

94333BX(1)

94333(1)

94273BX(1)

94273(1)

94245(1)

21001(1)

94142BX(1)

94142(1)

86073(1)

77317(1)

66488CT(1)

66488(1)

32486(1)

27376(1)

27329(1)

33000(1)

22002(1)

39002(1)

25186(1)

39001(1)

39000(1)

33750(1)

33700(1)

33300(1)

32006(1)

32003(1)

25188(1)

25187(1)

25185(1)

22005(1)

25184(1)

25183(1)

25182(1)

25181(1)

23005(1)

23004(1)

23003(1)

23002(1)

23001(1)

6743(1)

6732(1)

008711(1)

20540CT(1)

60513(1)

52320(1)

21513(1)

21512(1)

21511(1)

21510(1)

20672(1)

20630(1)

20540(1)

60514(1)

20527CT(1)

20527(1)

20513CT(1)

20513(1)

20421PL(1)

20421EA(1)

20421CT(1)

11545BX(1)

11545(1)

60513EA(1)

60514EA(1)

11544(1)

63101(1)

0846(1)

0845(1)

0570(1)

0448(1)

0162(1)

63104(1)

63103(1)

63102(1)

63100CT(1)

60515(1)

63100(1)

63006(1)

60518EA(1)

60518(1)

60517EA(1)

60517(1)

60516EA(1)

60516(1)

60515EA(1)

11544BX(1)

11248(1)

0848(1)

8599961590(1)

00374CT(1)

00055(1)

00050CT(1)

00050(1)

00019(1)

00016(1)

320840(1)

320820(1)

599961590(1)

00518X(1)

1099961590(1)

60224-101(1)

60052101CT(1)

60052-101(1)

60051-052(1)

60051-046(1)

60051-012(1)

008715(1)

008712(1)

00374EA(1)

01014(1)

10117(1)

06437(1)

10107(1)

06931(1)

06930(1)

06927(1)

06922(1)

06898(1)

06897(1)

06546(1)

06451(1)

06433(1)

01500(1)

06430(1)

06239(1)

06125(1)

06122(1)

06114(1)

0529C(1)

01720CT(1)

01720(1)

01501(1)

0847(1)

0849(1)

6728(1)

6520CT(1)

6546(1)

6545(1)

6544(1)

6543(1)

6534CT(1)

6534(1)

6523CT(1)

6523(1)

6520(1)

6570(1)

6503CT(1)

6503(1)

6502CT(1)

6502(1)

6501CT(1)

6501(1)

6425(1)

6408(1)

6407(1)

6547(1)

6570CT(1)

6405CT(1)

6663(1)

6720(1)

6700CT(1)

6700(1)

6694CT(1)

6694(1)

6685CT(1)

6685(1)

6680(1)

6663CT(1)

6662(1)

6602(1)

6661(1)

6659(1)

6624(1)

6614(1)

6613(1)

6611(1)

6606CT(1)

6606(1)

6602CT(1)

6406(1)

6405(1)

192419(1)

4060(1)

4162(1)

4067CT(1)

4067(1)

4066CT(1)

4066(1)

4061CT(1)

4061(1)

4060CT(1)

4051(1)

4441(1)

4050CT(1)

4050(1)

193019(1)

192719CT(1)

192719(1)

192619CT(1)

192619(1)

192519(1)

192419CT(1)

4432(1)

4461(1)

6305(1)

6000(1)

6248(1)

6204(1)

6111(1)

6110(1)

6107(1)

6106(1)

6003CT(1)

6003(1)

6002(1)

5531(1)

4493(1)

5493(1)

5470(1)

5469(1)

5305(1)

5304(1)

5303(1)

5161(1)

4792(1)

4732(1)

866550(1)

 
Country of Origin

US(332)

IT(15)

CA(13)

GB(10)

CO(1)

ES(1)

United States(1)

 
For Use With

Keurig K-Cup System(117)

Commercial Coffee Brewers(27)

Keurig Brewing System(24)

Drip Coffee Brewers(14)

Pod Brewers(9)

Dolce Gusto Coffee Machine(8)

Single Cup Brewers(7)

Standard Coffee Brewers(5)

Single Cup Brewers Hamilton, Bunn and Newco(4)

Coffee Brewer(3)

Grinder; Coffee Brewer(3)

NESCAFÉ Dolce Gusto Machines(3)

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

Standard and Commercial Coffee Makers(2)

LavAzza Espresso Point Machine(2)

Lavazza 2312(2)

Any traditional coffee maker(1)

Pod Espresso Brewer(1)

LavAzza Espresso Point Machine (sold separately)(1)

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

 
Capacity (Volume)

0.38 oz(4)

8 oz(2)

10 oz(2)

48 oz(1)

25.1 oz(1)

0(1)

 
Capacity (Weight)

2.5 oz(34)

1 lb(18)

1.5 oz(17)

0.3 oz(15)

2 oz(14)

12 oz(12)

2.2 oz(9)

0.9 oz(6)

0.35 oz(6)

0.06 oz(4)

1.4 oz(4)

30.5 oz(3)

2.2 lb(3)

8 oz(3)

30.6 oz(3)

1.1 oz(3)

10 oz(3)

0.25 oz(3)

28 oz(3)

1.75 oz(3)

0.4 oz(3)

1.2 oz(2)

0.1 oz(2)

32 oz(2)

0.12 oz(2)

22.6 oz(2)

31.1 oz(2)

1.05 oz(2)

2.5 lbs(2)

24.2 oz(2)

25.4 oz(2)

7 g(2)

2 oz.(1)

0.6 oz(1)

0.8 oz(1)

0.8(1)

16 oz(1)

34.5 oz(1)

33.9 oz(1)

18 oz(1)

48 oz(1)

29.3 oz(1)

9 g(1)

8 g(1)

2.2 lbs(1)

36 oz(1)

2.25 oz(1)

31 oz(1)

 
Coffee Type

Regular(1)

 
Roast Type

Medium(97)

Dark(80)

Light(39)

Dark Roast(4)

Medium Roast(1)

 
Coffee Weight

16 oz(1)

 
Product Type

Coffee(1)

 
Packaged Quantity

1 Each(1)

 
Flavor/Blend

Cafe Domingo(1)

 
Coffee Roast Level

Medium(1)

 
 
 

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