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(58)

Starbucks(39)

Folgers(32)

Peet's Coffee & Tea(11)

1850(11)

Dunkin Donuts(10)

The Original Donut Shop(10)

New England Coffee(8)

Eight O'Clock(8)

Maxwell House(8)

Tully's Coffee(8)

Nescafé(7)

Caribou Coffee(7)

PapaNicholas Coffee(7)

Seattle's Best(7)

Café Bustelo(7)

Java One(7)

La Colombe(7)

Snack Box Pros(6)

Bestpresso(6)

Community Coffee(6)

Barista Prima Coffeehouse(6)

HIGH Brew Coffee(5)

Day to Day Coffee(5)

Lavazza(5)

ALTERRA(5)

Café Escapes(4)

RISE Brewing Co.(4)

McCafe(4)

Gloria Jean's(4)

Gevalia(4)

Monster(3)

Distant Lands Coffee(3)

BLK & Bold(3)

Intelligentsia(2)

Tim Hortons(2)

Newman's Own Organics(2)

National Coffee Roasters(2)

Kahlúa(2)

Emeril's(2)

Laughing Man Coffee Company(2)

CALIFIA FARMS(2)

Chock full o'Nuts(1)

Nestle(1)

revv(1)

KITULife(1)

Hills Bros.(1)

Starbucks By NESPRESSO(1)

Cinnabon(1)

Krispy Kreme Doughnuts(1)

EVO Bean Coffee(1)

Yuban(1)

 
Packaged Quantity

6 / Carton(1)

 
For Use With

Keurig K-Cup System(150)

Commercial Coffee Brewers(21)

Single Cup Brewers(7)

Original-Line Nespresso Machines(6)

Drip Coffee Brewers(5)

Select Flavia Freshpack Pod Machines(5)

Standard Coffee Brewers(4)

Grinder; Coffee Brewer(3)

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

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

Commercial Coffee Brewers; Standard Coffee Brewers(3)

FLAVIA Hot Beverage Brewers(2)

FLAVIA Machines only(2)

Pod Brewers(2)

Standard and Commercial Coffee Makers(1)

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

Nespresso Business Solution Zenius, Gemini Series(1)

Any traditional coffee maker(1)

 
Flavor

French Roast(18)

Breakfast Blend(18)

House Blend(12)

Classic Roast(12)

Assorted(10)

French Vanilla(10)

Espresso(8)

Original(8)

Regular(8)

Caffe Verona(8)

Pike Place Roast(8)

Hazelnut(7)

Original Blend(7)

Mocha(6)

Veranda Blend(6)

Hazelnut Creme(5)

Pumpkin Spice(5)

Italian Roast(5)

Black Silk(5)

Major Dickason's Blend(4)

Vanilla(4)

Colombia(4)

Black Gold(4)

Vermont Country Blend(3)

Nantucket Blend(3)

Dark Magic(3)

100% Colombian(3)

Portside Blend(3)

Dark Roast(3)

Donut Shop Regular(3)

Wild Mountain Blueberry(2)

Café Domingo Blend(2)

Pier 70 Blend(2)

Café Special(2)

Chicory(2)

Cinnamon Sugar Cookie(2)

Single Origin Colombian Select(2)

Sumatran(2)

Colombian(2)

Lake & Lodge(2)

Holiday Blend(2)

Kahlúa Original(2)

Southern Pecan(2)

Big Easy Bold(2)

Daybreak Morning Blend(2)

Our Blend(2)

Caribou Blend(2)

Mahogany(2)

Caramel Vanilla Cream(2)

Island Coconut(2)

Caramel(2)

Hawaiian Blend(2)

6th Avenue Bistro(2)

Donut Shop Blend(2)

Butter Toffee(2)

Medium Roast(2)

Special Roast(2)

Expedition Blend(2)

Trailblazer(2)

Traditional Roast(2)

Colombian Supremo(2)

Lantern Glow(2)

Organic Sumatran Extra Bold(2)

Special Blend(2)

Double Black Diamond Extra Bold(2)

Dark Magic Extra Bold(2)

Verona Italian Espresso(1)

Gold Selection(1)

Arabica(1)

Eye Opener(1)

French Dark Roast(1)

Sumatra Blend(1)

Dark and Bold(1)

Dark and Intense(1)

Nitro Extra Bold(1)

Brazilian Bold(1)

Triple Shot(1)

Vanilla Latte(1)

Sumatra Mandheling(1)

Creamy Cappuccino(1)

Black and Bold(1)

Dark Chocolate Mocha(1)

Classico 100% Arabica(1)

Clasico(1)

Intenso Italian Espresso(1)

Oat Milk Mocha(1)

Lungo Italian Espresso(1)

Cremoso(1)

Oat Milk Vanilla(1)

Dark Espresso Roast(1)

Espresso Dark Roast(1)

Blonde Espresso Roast(1)

Oat Milk(1)

Colombian Blend(1)

Original Black(1)

Salted Caramel(1)

Special House Blend(1)

Double Expresso(1)

Hawaiian Islands Blend(1)

Intense Assortment(1)

Kona Blend(1)

Mexican Vanilla(1)

Regular Extra Bold(1)

XX Expresso(1)

Dark Italian Espresso(1)

Cafe Vanilla(1)

Pioneer Blend(1)

Columbian(1)

Gentle On Your Stomach(1)

Buttery Caramel(1)

Lively Colombian(1)

Signature Blend(1)

Gourmet Supreme(1)

Cinnamon Roll(1)

Coconut Mocha(1)

Toasty Hazelnut(1)

Classic(1)

Extra Bold Breakfast Blend(1)

Dark Royal(1)

Original Roast(1)

NO SURRENDER(1)

Honduran(1)

Mocha Noir(1)

Cappuccino(1)

Dunkin Original; Polar Peppermint(1)

Mean Bean(1)

Pike Place(1)

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

Turtle Love(1)

Snickers(1)

Ethiopian Supreme(1)

Caramel Hideaway(1)

Dukale's Blend(1)

Colombia Huila(1)

Sumatra Reserve(1)

Costa Rica Paraiso(1)

Maple Pecan(1)

Premium Roast(1)

Peppermint Bark(1)

Loca Moca(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(322)

CA(16)

ES(5)

IT(5)

BR(2)

 
Quantity

1 each(1)

 
Packing Type

K-Cup(2)

Bag(2)

Pod(1)

 
Capacity (Weight)

2.5 oz(21)

1 lb(14)

12 oz(12)

1.5 oz(9)

2.2 oz(9)

0.3 oz(8)

2 oz(6)

1.4 oz(5)

2.2 lb(5)

0.4 oz(4)

4.25 lb(4)

0.35 oz(3)

18 oz(3)

2 lb(3)

2.25 oz(3)

22.6 oz(3)

2.1 oz(3)

0.9 oz(3)

0.25 oz(2)

30.5 oz(2)

1.75 oz(2)

0.06 oz(2)

28 oz(2)

0.8 oz(2)

16 oz(2)

25.9 oz(2)

1.2 oz(2)

2.7 oz(2)

30.6 oz(2)

0.28 oz(2)

0.44 oz(1)

32 oz(1)

8 oz(1)

0.1 oz(1)

0.11 oz(1)

1.1 oz(1)

1.25 oz(1)

0.32 oz(1)

0.23 oz(1)

7 g(1)

3.12 lb(1)

3 lb(1)

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

0.21 oz(1)

0.38 oz(1)

30 oz(1)

0.16 oz(1)

1.05 oz(1)

27 oz(1)

0.6 oz(1)

36 oz(1)

31 oz(1)

 
Beverage Type

Coffee(311)

Coffee Drink(27)

Instant Coffee(4)

Coffee; Hot Cocoa(3)

Latte(2)

Coffee, Instant(1)

Coffee, Whole Bean(1)

 
Roast Type

Medium(103)

Dark(101)

Light(45)

Assorted(1)

Extra Dark(1)

Medium; Dark(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved