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

Currently Filtered by

Category

Decaffeinated

Refine Search

  GO
 
Brand

Green Mountain Coffee(14)

Folgers(7)

Starbucks(6)

Seattle's Best(5)

Caribou Coffee(4)

Nescafé(4)

Peet's Coffee & Tea(3)

Maxwell House(2)

The Original Donut Shop(2)

McCafe(2)

Tully's Coffee(2)

Newman's Own Organics(2)

Community Coffee(2)

PapaNicholas Coffee(1)

Day to Day Coffee(1)

Nescafe(1)

BLK & Bold(1)

ALTERRA(1)

Lavazza(1)

Barista Prima Coffeehouse(1)

Eight O'Clock(1)

Bestpresso(1)

Dunkin Donuts(1)

1850(1)

Krispy Kreme Doughnuts(1)

 
Packaged Quantity

4 / Carton(1)

 
For Use With

Keurig K-Cup System(30)

Commercial Coffee Brewers(4)

Standard Coffee Brewers(2)

Original-Line Nespresso Machines(1)

Standard and Commercial Coffee Makers(1)

LavAzza Espresso Point Machine(1)

Select Flavia Freshpack Pod Machines(1)

NESCAFÉ Bean-to-Cup Equipment(1)

Drip Coffee Brewers(1)

 
Flavor

Pike Place Decaf(6)

Special Decaf(4)

Classic Roast Decaf(4)

Decaffeinated(4)

Vermont Country Blend Decaf(3)

Decaf House Blend(3)

Dark Magic Decaf Extra Bold(2)

French Roast Decaf(2)

Premium Roast Decaf(2)

Hazelnut(2)

House Blend Decaf(2)

Classic Decaf(2)

Breakfast Blend Decaf(2)

French Vanilla Decaf(2)

Decaf Portside Blend(2)

Caribou Blend Decaf(2)

House Blend(1)

Decaf Blend(1)

100% Arabica Blend Decaf(1)

Decaf Arabica and Robusta Blend(1)

Decaffeinated French Roast(1)

Portside Blend(1)

Level 3 Decaf(1)

Original Roast Decaf(1)

Original Decaf(1)

Assorted(1)

Decaf Italian Roast(1)

Decaffeinato Italian Espresso(1)

Colombian Decaf(1)

Dunkin' Decaf(1)

Lively Colombian Decaf(1)

100% Colombian(1)

Pioneer Blend Decaf(1)

Donut Shop(1)

Decaf(1)

Decaf Caribou Blend(1)

Caribou Blend(1)

Level 3(1)

 
Flavor/Blend

Ristretto(1)

 
Coffee Roast Level

Dark(1)

 
Coffee Weight

8.8 oz Per Pouch(1)

 
Country of Origin

US(62)

CA(2)

ES(1)

IT(1)

 
Quantity

50 per carton(1)

42 per carton(1)

1 each(1)

 
Packing Type

Fraction Pack(2)

Bag(2)

 
Capacity (Weight)

2.5 oz(6)

12 oz(3)

1 lb(3)

0.06 oz(2)

19.2 oz(2)

1.5 oz(2)

2.2 oz(2)

0.25 oz(2)

2.25 oz(1)

2 oz(1)

2.7 oz(1)

8.8 oz(1)

0.1 oz(1)

0.38 oz(1)

1.1 oz(1)

29.3 oz(1)

2.5 lbs(1)

24 oz(1)

24.2 oz(1)

8 oz(1)

0.9 oz(1)

0.4 oz(1)

2.6 oz(1)

 
Beverage Type

Decaffeinated Coffee(53)

Coffee(9)

Instant Coffee(3)

Instant Decaffeinated Coffee(1)

 
Roast Type

Medium(34)

Dark(8)

Light(3)

Light; Medium(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved