Banner1 Banner1
 
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 ('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_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(22)

Numi(14)

Tazo(11)

Tiesta(9)

TWININGS(8)

Inko's(7)

diet Snapple(4)

Arizona(2)

Celestial Seasonings(2)

Lipton(2)

Tea One(1)

 
Quantity

1 each(11)

28 per box(11)

18 per box(10)

25 per box(9)

12 per box(6)

24 per box(5)

12 per carton(5)

72 per carton(4)

16 per box(4)

168 per carton(3)

6 per carton(3)

100 per box(2)

64 per box(2)

6 tins(1)

30(1)

72 per box(1)

14 per box(1)

24 per carton(1)

48 per box(1)

150 per carton(1)

 
Packing Type

Bag(31)

Box(25)

Tetra Pak(6)

Pod(5)

Bottle(5)

Tin(5)

Can(3)

Stick(1)

Tea Bag(1)

 
Flavor

Assorted(5)

Fireberry(2)

Lean Green Machine(2)

Iced Peachy Green Tea(2)

Iced Sangria Black Tea(2)

Nutty Almond Cream(2)

Chai Love(2)

Iced Passion Tea(2)

English Breakfast(2)

Earl Grey(2)

Green(2)

Cozy Chamomile(2)

Green Tea(2)

Rooibos Chai(1)

Breakfast Blend(1)

Spinach Chive(1)

Emperor's Puerh(1)

Chocolate Puerh(1)

Carrot Curry(1)

Tomato Mint(1)

Aged Earl Grey(1)

Chamomile Lemon(1)

White Orange Spice(1)

Iced Tea/Lemonade(1)

Garden Sampler(1)

Jasmine Green(1)

Camomile(1)

Peppermint(1)

English Breakfast Decaf.(1)

Chai(1)

Green with Jasmine(1)

Awake English Breakfast(1)

Calm Chamomile(1)

Organic Chai(1)

Gunpowder Green(1)

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

Moroccan Mint(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)

Premium Ceylon(1)

Decaffeinated Black(1)

Lemon Lift Black Tea(1)

Cinnamon Stick Black Tea(1)

Plantation Mint Black Tea(1)

Earl Grey Black Tea(1)

English Teatime Decaf(1)

Mint Medley Herbal Tea(1)

Sweet Dreams(1)

Orange & Spice Herbal Tea(1)

Cranberry Apple Herbal Tea(1)

Assorted Herbal(1)

Herbal Lemon Zinger(1)

Regular(1)

Half and Half Green Tea Lemonade(1)

Citrus Black Currant(1)

Original White Tea(1)

Unsweetened Hint 'O Mint White Tea(1)

White Peach White Tea(1)

Blueberry White Tea(1)

Honeydew White Tea(1)

Tropical Citrus Green(1)

Diet Peach Tea(1)

Diet Raspberry Tea(1)

Diet Green Tea(1)

Ginseng & Honey(1)

Decaffeinated(1)

China Green Tips(1)

 
Beverage Type

Tea(64)

White Tea(5)

Green Tea(4)

Iced Tea(4)

Flavored Drink Mix(1)

Decaffeinated Black Tea(1)

Oolong Tea(1)

Decaffeinated Tea(1)

Black Tea(1)

 
Manufacturer Part Number

72769(1)

16005(1)

11041595EA(1)

11041595(1)

11041594EA(1)

11041594(1)

11041593EA(1)

11041593(1)

16110(1)

16004(1)

69685(1)

16002(1)

10360(1)

10350(1)

10240(1)

10220(1)

10200(1)

10170(1)

60001(1)

69692(1)

10109(1)

09183(1)

153961(1)

149904(1)

149901(1)

149898(1)

10021(1)

09187(1)

09185(1)

09182(1)

70667(1)

09181(1)

09179(1)

09178(1)

97533(1)

97465(1)

97243(1)

96420(1)

70872(1)

10150(1)

10108(1)

827195(1)

10343(1)

10400(1)

10398(1)

10396(1)

10393(1)

10357(1)

10348(1)

10344(1)

10342(1)

15577(1)

009906(1)

008906(1)

007906(1)

00401(1)

00388CT(1)

00388(1)

00356(1)

00351(1)

10906(1)

16578(1)

10104(1)

T5(1)

291(1)

290(1)

33620(1)

33619(1)

33617(1)

33616(1)

20700(1)

T4(1)

30568(1)

T3(1)

T2(1)

T1(1)

93C(1)

91C(1)

49683(1)

031010(1)

30568CT(1)

153966(1)

 
Country of Origin

US(64)

CN(13)

EG(2)

IN(2)

ZA(1)

 
For Use With

Single-Cup Brewers(1)

 
Capacity (Volume)

1.76 oz(7)

32 oz(7)

16 oz(6)

1.90 oz(4)

4 oz(4)

15.5 oz(2)

0.68 oz(2)

23 oz(1)

0.25 oz(1)

0.61 oz(1)

4oz(1)

 
Capacity (Weight)

1.76 oz(8)

1.85 oz(4)

1 lb(4)

1.7 oz(4)

1.27 oz(3)

1.4 oz(2)

0.12 oz(1)

0.8 lbs.(1)

0.3 lbs.(1)

3.05 oz(1)

0.15 oz(1)

1.08 oz(1)

1.71 oz(1)

1.58 oz(1)

.125 oz(1)

1.13 oz(1)

 
 
 

© 2020-2021 Onestop, Inc., All Rights Reserved