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

TWININGS(20)

Celestial Seasonings(13)

Numi(12)

Tazo(9)

The Bright Tea Co.(8)

Mighty Leaf Tea(4)

Lipton(4)

Harney & Sons(4)

Zevia(3)

Arizona(2)

Pure Leaf(2)

Starbucks(2)

Caf� Escapes(2)

Blue Diamond(1)

Tea One(1)

POM Wonderful(1)

diet Snapple(1)

GT's Living Foods(1)

 
For Use With

Keurig K-Cup System(25)

Select Flavia Freshpack Pod Machines(8)

Serenade Single-Cup Brewer(2)

Single Cup Brewers(1)

 
Flavor

Assorted(8)

English Breakfast(7)

Green Tea(6)

Earl Grey(5)

Chai(3)

Earl Grey Black Tea(3)

Lemon and Ginger(3)

Green(3)

Lemon Ginger(2)

Black(2)

Unsweetened Black(2)

Peach(2)

Breakfast Blend(2)

Lemon(2)

Green Tea Decaf(2)

Mint(2)

India Spice Chai(2)

Mandarin Orange(2)

Cozy Chamomile(2)

Peppermint(2)

Chai Latte(2)

Rooibos Chai(1)

White Orange Spice(1)

Emperor's Puerh(1)

Chamomile Lemon(1)

Aged Earl Grey(1)

Three Roots(1)

Gunpowder Green(1)

Jasmine Green(1)

Moroccan Mint(1)

Select Green(1)

Peppermint Herbal(1)

White with Orange(1)

Green with Jasmine(1)

Chocolate Puerh(1)

Raspberry(1)

Amber Sun(1)

Organic Chai(1)

Raspberry Black Tea(1)

Passion(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 Awake English Breakfast(1)

Chamomile Citrus(1)

Mango Chili Chai(1)

Probiotic+ Lemon & Ginger(1)

English Classic(1)

Camomile(1)

Chai Spice(1)

Unsweetened(1)

Wild Berry Hibiscus(1)

Organic Mint Melange(1)

Green Tea Tropical(1)

Lemon Herbal(1)

Pomegranate Honey Green Tea(1)

Decaffeinated(1)

Cranberry Apple Herbal Tea(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)

Assorted Herbal(1)

Orange & Spice Herbal Tea(1)

Darjeeling(1)

Mint Medley Herbal Tea(1)

English Teatime Decaf(1)

Perfectly Mint Black Tea(1)

Lemon Lift Black Tea(1)

Rose & Mint(1)

Lemon & Echinacea(1)

Decaffeinated Black(1)

English Teatime(1)

I Love Lemon(1)

Tropical Citrus Green(1)

Premium Ceylon(1)

Organic Earl Grey Supreme(1)

Tropical Green(1)

Organic Rooibos(1)

Organic Peppermint(1)

Gingerade(1)

Ginseng & Honey(1)

Unsweetened Vanilla(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)

Oolong & Jasmine Green(1)

Rooibos Hibiscus(1)

Apple Cinnamon(1)

Peach Black Tea(1)

 
Volume Capacity

12 oz(4)

16 oz(2)

18.5 oz(2)

0.11 oz(2)

11.5 oz(1)

16.9 oz(1)

20 oz(1)

64 oz(1)

16.2 oz(1)

32 oz(1)

 
Country of Origin

US(114)

CN(11)

IN(4)

EG(4)

MG(2)

GB(1)

ZA(1)

ID(1)

PE(1)

MA(1)

FR(1)

PL(1)

 
Quantity

28 per box(1)

 
Packing Type

Bag(1)

 
Capacity (Weight)

0.07 oz(6)

1.4 oz(4)

0.08 oz(4)

1.76 oz(4)

1.9 oz(4)

1.32 oz(4)

0.09 oz(4)

1.27 oz(3)

0.34 lb(3)

0.6 oz(3)

1.6 oz(2)

2 lb(2)

0.11 oz(2)

3.53 oz(2)

0.05 oz(2)

0.1 oz(2)

1.58 oz(2)

0.7 oz(2)

0.06 oz(2)

0.67 oz(1)

1.46 oz(1)

1.38 oz(1)

0.95 oz(1)

0.73 oz(1)

0.3 lb(1)

1.23 oz(1)

1.59 oz(1)

1.2 oz(1)

1.41 oz(1)

1.42 oz(1)

1.13 oz(1)

0.13 oz(1)

1.18 oz(1)

1.71 oz(1)

1.08 oz(1)

1.28 oz(1)

0.8 lb(1)

0.03 oz(1)

0.15 oz(1)

3.85 oz(1)

0.91 oz(1)

1 oz(1)

3.05 oz(1)

1.8 oz(1)

 
Beverage Type

Tea(85)

Herbal Tea(15)

Iced Tea(14)

Green Tea(12)

Black Tea(10)

Decaffeinated Black Tea(1)

Oolong/Green Tea(1)

Green Tea; Herbal Tea(1)

Almond Milk(1)

Kombucha(1)

Decaffeinated Tea(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved