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 ('90238')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock','spl_call_for_price') 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 '%Caffeinated' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('Caffeinated' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Caffeinated' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Caffeinated"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Caffeinated"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Caffeinated"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Caffeinated"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Caffeinated' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Caffeinated',`category_4` ='Caffeinated') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Caffeinated,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Caffeinated', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Caffeinated

Refine Search

  GO
 
Brand

Green Mountain Coffee(57)

Starbucks(36)

Folgers(31)

Peet's Coffee & Tea(12)

The Original Donut Shop(11)

1850(11)

Dunkin Donuts(10)

Eight O'Clock(8)

New England Coffee(8)

Caribou Coffee(8)

Maxwell House(8)

Tully's Coffee(8)

PapaNicholas Coffee(7)

La Colombe(7)

Java One(7)

Nescafé(7)

Seattle's Best(7)

Café Bustelo(7)

Barista Prima Coffeehouse(6)

Snack Box Pros(6)

Community Coffee(6)

Lavazza(6)

Day to Day Coffee(5)

HIGH Brew Coffee(5)

McCafe(5)

RISE Brewing Co.(4)

Gloria Jean's(4)

Café Escapes(4)

Distant Lands Coffee(3)

BLK & Bold(3)

Monster(3)

Kahlúa(2)

Tim Hortons(2)

National Coffee Roasters(2)

Gevalia(2)

Intelligentsia(2)

ALTERRA(2)

Newman's Own Organics(2)

Laughing Man Coffee Company(2)

CALIFIA FARMS(2)

Emeril's(2)

Krispy Kreme Doughnuts(1)

KITULife(1)

Starbucks By NESPRESSO(1)

Cinnabon(1)

revv(1)

Hills Bros.(1)

Nestle(1)

Chock full o'Nuts(1)

EVO Bean Coffee(1)

Yuban(1)

 
Packaged Quantity

6 / Carton(1)

 
For Use With

Keurig K-Cup System(152)

Commercial Coffee Brewers(21)

Single Cup Brewers(7)

Drip Coffee Brewers(5)

Standard Coffee Brewers(4)

FLAVIA Hot Beverage Brewers(3)

Commercial Coffee Brewers; Standard Coffee Brewers(3)

NESCAFE Bean-to-Cup Specialty Coffee Makers: Total Barista 30, Ultimate Barista 50(3)

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

Grinder; Coffee Brewer(3)

Pod Brewers(2)

Select Flavia Freshpack Pod Machines(2)

Coffee Brewer(1)

Standard and Commercial Coffee Makers(1)

Original-Line Nespresso Machines(1)

Any traditional coffee maker(1)

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

FLAVIA Machines only(1)

 
Flavor

Breakfast Blend(18)

French Roast(17)

House Blend(11)

Classic Roast(11)

French Vanilla(9)

Espresso(8)

Caffe Verona(8)

Pike Place Roast(8)

Regular(8)

Assorted(8)

Original(8)

Hazelnut(7)

Original Blend(6)

Mocha(6)

Italian Roast(5)

Pumpkin Spice(5)

Black Silk(5)

Vanilla(5)

Veranda Blend(5)

Hazelnut Creme(5)

Major Dickason's Blend(4)

Black Gold(4)

Dark Magic(3)

Nantucket Blend(3)

Vermont Country Blend(3)

Caramel(3)

Portside Blend(3)

Colombia(3)

100% Colombian(3)

Dark Roast(3)

Donut Shop Regular(3)

Traditional Roast(2)

Southern Pecan(2)

Holiday Blend(2)

Lake & Lodge(2)

Medium Roast(2)

Our Blend(2)

Hawaiian Blend(2)

Caramel Vanilla Cream(2)

Island Coconut(2)

Wild Mountain Blueberry(2)

Single Origin Colombian Select(2)

Mahogany(2)

Caribou Blend(2)

Daybreak Morning Blend(2)

Trailblazer(2)

Big Easy Bold(2)

Kahlúa Original(2)

Butter Toffee(2)

Café Domingo Blend(2)

Sumatran(2)

Pier 70 Blend(2)

Colombian(2)

6th Avenue Bistro(2)

Cinnamon Sugar Cookie(2)

Expedition Blend(2)

Colombian Supremo(2)

Chicory(2)

Special Blend(2)

Café Special(2)

Organic Sumatran Extra Bold(2)

Dark Magic Extra Bold(2)

Double Black Diamond Extra Bold(2)

Lantern Glow(2)

Special Roast(2)

Sumatra Blend(1)

Intenso(1)

Dark and Bold(1)

Dark and Intense(1)

Brazilian Bold(1)

Gold Selection(1)

Eye Opener(1)

Triple Shot(1)

Nitro Extra Bold(1)

Vanilla Latte(1)

Sumatra Mandheling(1)

Creamy Cappuccino(1)

Black and Bold(1)

Dark Chocolate Mocha(1)

Mexican Vanilla(1)

French Dark Roast(1)

Kona Blend(1)

Arabica(1)

Oat Milk Mocha(1)

Blonde Espresso Roast(1)

Salted Caramel(1)

Donut Shop Blend(1)

Mean Bean(1)

Loca Moca(1)

Oat Milk Vanilla(1)

Oat Milk(1)

Classico 100% Arabica(1)

Original Black(1)

Special House Blend(1)

Hawaiian Islands Blend(1)

XX Expresso(1)

Colombian Blend(1)

Clasico(1)

Double Expresso(1)

Blonde Espresso Roast; Colombia; Espresso Roast; Pikes Place(1)

Mocha Noir(1)

Honduran(1)

Pioneer Blend(1)

NO SURRENDER(1)

Cafe Vanilla(1)

Buttery Caramel(1)

Lively Colombian(1)

Gourmet Supreme(1)

Regular Extra Bold(1)

Caramel Hideaway(1)

Turtle Love(1)

Dark Italian Espresso(1)

Signature Blend(1)

Cinnamon Roll(1)

Coconut Mocha(1)

Classic(1)

Original Roast(1)

Extra Bold Breakfast Blend(1)

Peppermint Bark(1)

Dunkin Original; Polar Peppermint(1)

Cookie Dough(1)

Rise & GRND(1)

Pike Place(1)

Dark Royal(1)

Toasty Hazelnut(1)

Gentle On Your Stomach(1)

Snickers(1)

Blueberry Muffin(1)

Columbian(1)

Cappuccino(1)

Ethiopian Supreme(1)

Dukale's Blend(1)

Colombia Huila(1)

Sumatra Reserve(1)

Costa Rica Paraiso(1)

Maple Pecan(1)

Premium Roast(1)

 
Volume Capacity

9 oz(7)

8 oz(5)

7 oz(4)

15 oz(3)

10 oz(2)

13.7 oz(2)

9.5 oz(2)

10.5 oz(2)

12 oz(1)

 
Flavor/Blend

French Vanilla(1)

 
Coffee Weight

32 oz(1)

 
Country of Origin

US(317)

CA(16)

IT(5)

BR(1)

 
Quantity

1 each(1)

 
Packing Type

Bag(2)

K-Cup(2)

 
Capacity (Weight)

2.5 oz(22)

1 lb(13)

12 oz(10)

0.3 oz(9)

1.5 oz(9)

2.2 oz(9)

2 oz(6)

1.4 oz(5)

2.2 lb(5)

0.4 oz(4)

4.25 lb(4)

2.1 oz(3)

0.35 oz(3)

18 oz(3)

2 lb(3)

2.25 oz(3)

0.9 oz(3)

22.6 oz(3)

30.5 oz(2)

2.7 oz(2)

1.75 oz(2)

0.06 oz(2)

28 oz(2)

0.32 oz(2)

0.8 oz(2)

25.9 oz(2)

1.2 oz(2)

30.6 oz(2)

0.11 oz(1)

0.44 oz(1)

32 oz(1)

8 oz(1)

0.1 oz(1)

0.25 oz(1)

1.1 oz(1)

36 oz(1)

1.05 oz(1)

7 g(1)

27 oz(1)

0.6 oz(1)

3.12 lb(1)

3 lb(1)

11 oz (Polar Peppermint); 12 oz (Original)(1)

1.25 oz(1)

0.38 oz(1)

16 oz(1)

0.34 oz(1)

30 oz(1)

0.33 oz(1)

0.41 oz(1)

31 oz(1)

 
Beverage Type

Coffee(300)

Coffee Drink(27)

Instant Coffee(4)

Coffee; Hot Cocoa(3)

Latte(2)

Coffee, Instant(1)

Coffee, Whole Bean(1)

 
Roast Type

Medium(100)

Dark(93)

Light(47)

Extra Dark(1)

Medium; Dark(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved