SELECT `pinfo`.`sku`,`pinfo`.`vendor`, 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_12` 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 ('1016')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_cost`=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 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(37)

Celestial Seasonings(18)

Numi(12)

Tazo(10)

Mighty Leaf Tea(6)

Snapple(5)

Lipton(4)

Café Escapes(2)

Tetley(2)

Arizona(1)

Starbucks(1)

Tea One(1)

Packing Type

K-Cup(34)

Filterbag(26)

Bag(13)

Box(11)

Tea Bag(9)

Pod(5)

Can(1)

Flavor

Green Tea(5)

Assorted(5)

English Breakfast(4)

Earl Grey(4)

Chai Latte(3)

Mandarin Orange(2)

Lemon(2)

Raspberry(2)

Breakfast Blend(2)

Lemon Zinger(2)

Cozy Chamomile(2)

India Spice Chai(2)

Gunpowder Green(1)

Chamomile Lemon(1)

Rooibos Chai(1)

Aged Earl Grey(1)

Decaffeinated(1)

Peach(1)

Soothe Smooth Green Tea(1)

British Blend Decaf(1)

Tropical Citrus Green(1)

White Orange Spice(1)

Moroccan Mint(1)

Regular(1)

Jasmine Green(1)

Chamomile Citrus(1)

Calm Chamomile(1)

Zen(1)

Awake English Breakfast(1)

Refresh Mint(1)

Passion(1)

China Green Tips(1)

Wild Sweet Orange(1)

Organic Chai(1)

Wild Berry Hibiscus(1)

Organic Mint Melange(1)

Amber Sun(1)

Three Roots(1)

Chocolate Puerh(1)

British Blend(1)

Green Tea Tropical(1)

Organic Earl Grey(1)

Organic Breakfast(1)

Emperor's Puerh(1)

Breakfast Tea(1)

Sweet Dreams(1)

Mint Medley Herbal Tea(1)

Orange & Spice Herbal Tea(1)

Cranberry Apple Herbal Tea(1)

Pure Green(1)

Assorted Herbal(1)

English Teatime Decaf(1)

Earl Grey Black Tea(1)

Decaffeinated Black(1)

Premium Ceylon(1)

Green(1)

Lemon Lift Black Tea(1)

Green Decaf(1)

Cinnamon Stick Black Tea(1)

Lemon Ginger(1)

Chamomile Citrus Herbal(1)

Ginseng & Honey(1)

Cinnamon Apple Spice(1)

Earl Grey Tea(1)

Diet Half n' Half (Lemonade/Iced Tea)(1)

Diet Iced Tea w/Peach(1)

Black(1)

Sleepytime(1)

Decaffeinated Green Tea(1)

Sweet Cinnamon Black Tea(1)

Mint(1)

Dandelion & Peach Rooibos & Green Tea(1)

Assorted Green Teas: Classic, Decaffeinated, Green Tea w/Mint, Green Tea w/Peach, "Constant Comment" Green, Green Tea w/Lemon, Earl Grey Green Tea(1)

Green Tea Decaf(1)

Herbal Lemon Zinger(1)

Southern Sweet Tea(1)

Beverage Type

Tea(74)

Green Tea(8)

Herbal Tea(6)

Black Tea(5)

Iced Tea(4)

Decaffeinated Tea(1)

Decaffeinated Black Tea(1)

Country of Origin

US(77)

CN(7)

IN(5)

EG(4)

MG(2)

MA(1)

ZA(1)

ID(1)

PE(1)

For Use With

Keurig K-Cup System(34)

Starbucks Serenade Single-Cup Brewer(1)

Single-Cup Brewers(1)

Capacity (Volume)

32 oz(1)

16 oz(1)

23 oz(1)

Capacity (Weight)

1.32 oz(5)

1.90 oz(4)

1.7 oz(4)

1.27 oz(3)

0.34 lbs(3)

1.6 oz(3)

1 oz(2)

1.4 oz(2)

1.46 oz(1)

1.42 oz(1)

1.9 oz(1)

2 lbs(1)

1.82 oz(1)

2 oz(1)

1.13 oz(1)

2.1 oz(1)

1.59 oz(1)

1.08 oz(1)

0.91 oz(1)

1.28 oz(1)

0.3 lbs.(1)

0.8 lbs(1)

1.41 oz(1)

1.18 oz(1)

1.58 oz(1)

1.71 oz(1)

0.15 oz(1)

3.05 oz(1)

0.13 oz(1)

Special Features

Four Boxes(1)

25 Tea Bags per Box(1)

Three Roots Blend-Step right into a spice market with the Three Roots blend, a delicious mixture of spicy ginger, and sweet licorice, designed to bring mental clarity, grounding and centering of the spirit.(1)

Amber Sun Blend-Blended with a tasty combination of flavors, including turmeric, rooibos, vanilla bean, and a hint of cinnamon, with mellow apple notes and a sweet peppery zest.(1)

Assortment(1)

Dandelion & Peach Rooibos & Green Tea-Gentle tasting dandelion leaves blend with a delicate green tea and a sweet hint of peach, for a mild soothing flavor with earthy tones.(1)

Sweet Cinnamon Black Tea-Sweet and bold all at once, this special blend combines the finest cinnamon with organic spices and hand-picked, mountain grown black tea for a full-bodied experience.(1)

Pure Green Tea-Delicate green tea, with a smooth, delicious flavor and a hint of sweetness.(1)

Organic English Breakfast Tea-Full-bodied tea, hand-picked from the mountains high in altitude and clouded in mist, produce a sweet liquor that is intense and delicious taking you on a magical journey steeped in the traditions of this ancient brew.(1)

Organic Lemon Ginger-Spicy ginger root and zesty citrus combine for a flavorful cup of caffeine free herbal tea.(1)

Chamomile Citrus Herbal-Natural chamomile, blended with a hint of lemon provides a sweet and soothing way to unwind; caffeine free herbal tea.(1)

Mint Herbal Tea-A provocative blend of spearmint and peppermint provides a refreshingly cool boost to your day, without the caffeine.(1)

Earl Grey-The purest Bergamot oil, derived from a pristine province in Southern Italy, blends with the finest, mountain-grown black tea to create the perfect, flavorful brew.(1)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor HP Qualified Supplies Partner

© 2020-2021 United Supply Corp, All Rights Reserved