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

Currently Filtered by

Category

Tea

Refine Search

  GO
 
Brand

Bigelow(47)

TWININGS(14)

Celestial Seasonings(12)

Numi(12)

Tazo(9)

The Bright Tea Co.(4)

Lipton(4)

Mighty Leaf Tea(4)

Harney & Sons(4)

Arizona(2)

Starbucks(2)

Café Escapes(2)

diet Snapple(1)

POM Wonderful(1)

Blue Diamond(1)

GT's Living Foods(1)

Tea One(1)

Pure Leaf(1)

 
For Use With

Keurig K-Cup System(22)

Select Flavia Freshpack Pod Machines(4)

Serenade Single-Cup Brewer(2)

Single Cup Brewers(1)

 
Flavor

Assorted(7)

English Breakfast(6)

Green Tea(5)

Earl Grey(4)

Earl Grey Black Tea(3)

Mandarin Orange(2)

Green Tea Decaf(2)

Black(2)

Mint(2)

Chai Latte(2)

Breakfast Blend(2)

Lemon and Ginger(2)

Lemon(2)

Lemon Ginger(2)

Chai(2)

India Spice Chai(2)

Green(2)

Cozy Chamomile(2)

Emperor's Puerh(1)

Three Roots(1)

Chocolate Puerh(1)

Raspberry(1)

White Orange Spice(1)

Rooibos Chai(1)

Amber Sun(1)

Chamomile Lemon(1)

Gunpowder Green(1)

Jasmine Green(1)

Moroccan Mint(1)

Peppermint Herbal(1)

White with Orange(1)

Aged Earl Grey(1)

Peppermint(1)

Chamomile Citrus(1)

Organic Awake English Breakfast(1)

Wild Sweet Orange(1)

Organic Green Ginger(1)

Organic Calm Chamomile(1)

Organic Earl Grey(1)

Organic Refresh Mint(1)

Organic Zen(1)

Organic Chai(1)

Mango Chili Chai(1)

Green Tea Tropical(1)

Orange and Star Anise(1)

Peach(1)

English Classic(1)

Decaffeinated(1)

Camomile(1)

Wild Berry Hibiscus(1)

Organic Mint Melange(1)

Green with Jasmine(1)

Pomegranate Honey Green Tea(1)

Tropical Citrus Green(1)

Cranberry Apple Herbal Tea(1)

Watermelon Cucumber Mint(1)

Blackberry Raspberry Hibiscus(1)

Dandelion & Peach Rooibos & Green Tea(1)

Chamomile Citrus Herbal(1)

Pure Green(1)

Assorted Herbal(1)

Orange & Spice Herbal Tea(1)

English Teatime(1)

Mint Medley Herbal Tea(1)

English Teatime Decaf(1)

Perfectly Mint Black Tea(1)

Lemon Lift Black Tea(1)

Lemon & Echinacea(1)

Decaffeinated Black(1)

Turmeric Chili Matcha(1)

I Love Lemon(1)

Organic Earl Grey Supreme(1)

Premium Ceylon(1)

Tropical Green(1)

Organic Rooibos(1)

Organic Peppermint(1)

Gingerade(1)

Ginseng & Honey(1)

Unsweetened Vanilla(1)

Unsweetened Black(1)

Green Tea with Pomegranate(1)

Half & Half - Iced Tea & Lemonade(1)

Breakfast Tea(1)

Sleepytime(1)

Decaffeinated Green Tea(1)

Herbal Lemon Zinger(1)

Tropical(1)

Apple Cinnamon(1)

Passion(1)

 
Volume Capacity

16 oz(2)

0.11 oz(2)

11.5 oz(1)

16.9 oz(1)

20 oz(1)

12 oz(1)

64 oz(1)

16.2 oz(1)

32 oz(1)

18.5 oz(1)

 
Country of Origin

US(97)

CN(10)

IN(4)

EG(4)

MG(2)

ZA(1)

ID(1)

PE(1)

MA(1)

FR(1)

 
Quantity

28 per box(1)

20 per box(1)

25 per box(1)

 
Packing Type

Bag(1)

Tea Bag(1)

Filterbag(1)

 
Capacity (Weight)

0.07 oz(7)

1.4 oz(4)

1.9 oz(4)

1.32 oz(4)

1.76 oz(3)

1.27 oz(3)

0.34 lb(3)

1.58 oz(2)

0.09 oz(2)

0.6 oz(2)

0.7 oz(2)

2 lb(2)

1.6 oz(2)

1.46 oz(1)

1.59 oz(1)

0.3 lb(1)

0.11 oz(1)

0.95 oz(1)

3.53 oz(1)

1.13 oz(1)

1.2 oz(1)

0.67 oz(1)

1.38 oz(1)

0.73 oz(1)

1.23 oz(1)

1.42 oz(1)

0.91 oz(1)

0.13 oz(1)

1 oz(1)

1.71 oz(1)

1.08 oz(1)

1.28 oz(1)

0.8 lb(1)

0.05 oz(1)

0.03 oz(1)

0.15 oz(1)

3.85 oz(1)

0.06 oz(1)

0.08 oz(1)

3.05 oz(1)

1.18 oz(1)

1.41 oz(1)

1.8 oz(1)

 
Beverage Type

Tea(77)

Herbal Tea(12)

Green Tea(12)

Black Tea(9)

Iced Tea(8)

Decaffeinated Black Tea(1)

Almond Milk(1)

Kombucha(1)

Decaffeinated Tea(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved