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)

Celestial Seasonings(12)

Numi(12)

TWININGS(10)

Tazo(7)

The Bright Tea Co.(5)

Lipton(4)

Mighty Leaf Tea(4)

Harney & Sons(4)

Arizona(2)

Pure Leaf(2)

Starbucks(2)

Café Escapes(2)

diet Snapple(1)

POM Wonderful(1)

Blue Diamond(1)

GT's Living Foods(1)

Tea One(1)

 
For Use With

Keurig K-Cup System(21)

Select Flavia Freshpack Pod Machines(5)

Serenade Single-Cup Brewer(2)

Single Cup Brewers(1)

 
Flavor

English Breakfast(6)

Green Tea(5)

Assorted(5)

Earl Grey Black Tea(4)

Earl Grey(4)

Chai(3)

Black(2)

Chai Latte(2)

Mint(2)

Lemon and Ginger(2)

Breakfast Blend(2)

Lemon(2)

Green Tea Decaf(2)

India Spice Chai(2)

Mandarin Orange(2)

Green(2)

Cozy Chamomile(2)

Lemon Ginger(2)

Chamomile Lemon(1)

Gunpowder Green(1)

Aged Earl Grey(1)

Moroccan Mint(1)

Jasmine Green(1)

White Orange Spice(1)

Peppermint Herbal(1)

White with Orange(1)

Green with Jasmine(1)

Chai Spice(1)

Decaffeinated(1)

Rooibos Chai(1)

Wild Berry Hibiscus(1)

Emperor's Puerh(1)

English Classic(1)

Organic Chai(1)

Passion(1)

Refresh Mint(1)

Calm Chamomile(1)

Mango Chili Chai(1)

Orange and Star Anise(1)

Peppermint(1)

Chocolate Puerh(1)

Unsweetened(1)

Organic Earl Grey Supreme(1)

Organic Mint Melange(1)

Green Tea Tropical(1)

Chamomile Citrus(1)

Amber Sun(1)

Three Roots(1)

Tropical Citrus Green(1)

Raspberry(1)

Tropical Green(1)

Assorted Herbal(1)

Turmeric Chili Matcha(1)

Watermelon Cucumber Mint(1)

Blackberry Raspberry Hibiscus(1)

Dandelion & Peach Rooibos & Green Tea(1)

Chamomile Citrus Herbal(1)

Pure Green(1)

Cranberry Apple Herbal Tea(1)

Darjeeling(1)

Orange & Spice Herbal Tea(1)

Mint Medley Herbal Tea(1)

English Teatime Decaf(1)

Perfectly Mint Black Tea(1)

Lemon Lift Black Tea(1)

Rose & Mint(1)

English Teatime(1)

I Love Lemon(1)

Organic Rooibos(1)

Premium Ceylon(1)

Organic Peppermint(1)

Gingerade(1)

Ginseng & Honey(1)

Unsweetened Vanilla(1)

Pomegranate Honey Green Tea(1)

Unsweetened Black(1)

Half & Half - Iced Tea & Lemonade(1)

Green Tea with Pomegranate(1)

Breakfast Tea(1)

Sleepytime(1)

Decaffeinated Green Tea(1)

Herbal Lemon Zinger(1)

Tropical(1)

Apple Cinnamon(1)

China Green Tips(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(93)

CN(10)

IN(4)

EG(4)

MG(2)

ZA(1)

ID(1)

PE(1)

MA(1)

FR(1)

 
Quantity

28 per box(1)

 
Packing Type

Box(1)

Bag(1)

Tea Bag(1)

Bottle(1)

 
Capacity (Volume)

18.5 oz(1)

 
Capacity (Weight)

0.07 oz(6)

1.9 oz(4)

1.32 oz(4)

1.27 oz(3)

1.76 oz(3)

1.7 oz(3)

1.4 oz(2)

0.09 oz(2)

0.08 oz(2)

2 lb(2)

0.7 oz(2)

1 oz(2)

1.6 oz(2)

0.34 lb(2)

0.6 oz(2)

0.95 oz(1)

1.58 oz(1)

1.59 oz(1)

2 oz(1)

1.46 oz(1)

1.42 oz(1)

1.13 oz(1)

0.13 oz(1)

0.34 lbs(1)

0.03 oz(1)

1.71 oz(1)

1.08 oz(1)

0.1 oz(1)

0.05 oz(1)

0.8 lb(1)

0.15 oz(1)

5.94 oz(1)

0.06 oz(1)

3.05 oz(1)

1.18 oz(1)

1.41 oz(1)

0.91 oz(1)

1.28 oz(1)

2.1 oz(1)

 
Beverage Type

Tea(71)

Herbal Tea(12)

Green Tea(12)

Black Tea(12)

Iced Tea(8)

Almond Milk(1)

Kombucha(1)

Decaffeinated Tea(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved