0

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') 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(35)

Celestial Seasonings(19)

Tazo(16)

Numi(10)

TWININGS(8)

Lipton(7)

Snapple(5)

Twinings(5)

Tiesta(5)

diet Snapple(4)

Café Escapes(2)

Tetley(2)

Tea One(1)

Arizona(1)

Brisk(1)

Pure Leaf(1)

 
Quantity

25 per box(8)

1 each(7)

72 per carton(4)

6 per carton(3)

168 per carton(1)

6 tins(1)

 
Packing Type

K-Cup(37)

Filterbag(28)

Bag(14)

Box(11)

Tea Bag(9)

Tetra Pak(6)

Pod(5)

Tin(4)

Can(2)

Bottle(1)

 
Flavor

Assorted(7)

Earl Grey(5)

English Breakfast(5)

Green Tea(5)

Chai Love(2)

Iced Sangria Black Tea(2)

Lemon Zinger(2)

Iced Passion Tea(2)

Mandarin Orange(2)

Chai Latte(2)

Breakfast Blend(2)

India Spice Chai(2)

Iced Peachy Green Tea(2)

Cozy Chamomile(2)

Green(2)

Chamomile Lemon(1)

Gunpowder Green(1)

Aged Earl Grey(1)

Rooibos Chai(1)

Wild Sweet Orange(1)

Jasmine Green(1)

White Orange Spice(1)

Moroccan Mint(1)

Diet Raspberry Tea(1)

Diet Peach Tea(1)

Tropical Citrus Green(1)

Diet Green Tea(1)

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

China Green Tips(1)

Regular(1)

Decaffeinated(1)

Emperor's Puerh(1)

Chocolate Puerh(1)

Peppermint(1)

Camomile(1)

Nutty Almond Cream(1)

Zen(1)

English Breakfast Decaf.(1)

Green with Jasmine(1)

Chai(1)

Lean Green Machine(1)

Calm Chamomile(1)

Organic Chai(1)

Sweet Tea with Lemon(1)

Pure Leaf Lemon(1)

Passion(1)

Refresh Mint(1)

Sweet Tea(1)

Awake English Breakfast(1)

British Blend(1)

Pure Green(1)

Assorted Herbal(1)

Cranberry Apple Herbal Tea(1)

Lemon Ginger(1)

Chamomile Citrus Herbal(1)

Dandelion & Peach Rooibos & Green Tea(1)

Sweet Cinnamon Black Tea(1)

Mint(1)

Orange & Spice Herbal Tea(1)

Sweet Dreams(1)

Lemon Lift Black Tea(1)

Decaffeinated Black(1)

Premium Ceylon(1)

Cinnamon Stick Black Tea(1)

Plantation Mint Black Tea(1)

Mint Medley Herbal Tea(1)

English Teatime Decaf(1)

Earl Grey Black 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)

Herbal Lemon Zinger(1)

Ginseng & Honey(1)

Southern Sweet Tea(1)

Diet Iced Tea w/Peach(1)

British Blend Decaf(1)

Indulge Rich Black Tea(1)

Raspberry(1)

Lemon(1)

Soothe Smooth Green Tea(1)

Iced Tea/Lemonade(1)

Black(1)

Sleepytime(1)

Decaffeinated Green Tea(1)

Green Tea Decaf(1)

Cinnamon Apple Spice(1)

Breakfast Tea(1)

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

Earl Grey Tea(1)

Peach(1)

 
Beverage Type

Tea(85)

Iced Tea(11)

Green Tea(7)

Herbal Tea(6)

Black Tea(6)

Decaffeinated Tea(1)

Decaffeinated Black Tea(1)

 
Manufacturer Part Number

10200(1)

10220(1)

10170(1)

10150(1)

10108(1)

10109(1)

10240(1)

10350(1)

11041593EA(1)

11041594(1)

11041593(1)

134073(1)

10360(1)

10091PK(1)

10104(1)

291(1)

6871(1)

6872(1)

6870(1)

6868(1)

6856(1)

6867(1)

6878(1)

20700(1)

33620(1)

290(1)

33619(1)

33617(1)

33616(1)

11041594EA(1)

11041595(1)

149898(1)

149899(1)

10021(1)

09954(1)

09185(1)

09187(1)

149900(1)

149901(1)

153961(1)

153966(1)

151598(1)

149904(1)

149902(1)

149903(1)

09183(1)

09182(1)

97465(1)

97533(1)

97243(1)

70667(1)

11041595EA(1)

60001(1)

08755(1)

08756(1)

09179(1)

09181(1)

09178(1)

08760(1)

08759(1)

6855(1)

6825(1)

17700(1)

17701(1)

16578(1)

15577(1)

10400(1)

10906(1)

17703(1)

17704(1)

30568(1)

30568CT(1)

17715(1)

17712(1)

17707(1)

17709(1)

10398(1)

10396(1)

007906(1)

008906(1)

00401(1)

00388(1)

00351(1)

00356(1)

009906(1)

10342(1)

10357(1)

10393(1)

10348(1)

10344(1)

10343(1)

031010(1)

49683(1)

6085CT(1)

6113(1)

6085(1)

6082CT(1)

6080CT(1)

6082(1)

6505(1)

6505CT(1)

6805(1)

6805CT(1)

6622(1)

6528(1)

6518(1)

6080(1)

5402(1)

14734(1)

14734CT(1)

14732CT(1)

14732(1)

14731(1)

14731CT(1)

14735(1)

14735CT(1)

14738CT(1)

14739(1)

14738(1)

14737CT(1)

14737(1)

827195(1)

 
Country of Origin

US(93)

CN(15)

IN(4)

EG(2)

United States(1)

PE(1)

ID(1)

ZA(1)

 
For Use With

Keurig K-Cup System(36)

Single-Cup Brewers(1)

Keurig Brewing System(1)

 
Capacity (Volume)

32 oz(7)

1.90 oz(4)

4 oz(3)

0.68 oz(2)

1(1)

18.5 oz(1)

4oz(1)

16 oz(1)

0.25 oz(1)

0.61 oz(1)

23 oz(1)

12 oz(1)

 
Capacity (Weight)

1.76 oz(8)

1.7 oz(4)

1.6 oz(3)

1.27 oz(3)

1.4 oz(2)

1 oz(2)

0.3 lbs(1)

1.28 oz(1)

1.13 oz(1)

1 lb(1)

2 oz(1)

1.9 oz(1)

2.1 oz(1)

1.82 oz(1)

.125 oz(1)

1.71 oz(1)

3.05 oz(1)

1.18 oz(1)

1.41 oz(1)

0.15 oz(1)

0.8 lbs(1)

0.91 oz(1)

1.08 oz(1)

1.58 oz(1)

 
Serve Type

K-Cup(5)

 
Number of Serving Cups

1(3)

 
Tea Type

Black Tea(3)

Herbal Tea(1)

Green Tea(1)

 
Compatible Brewer

Keurig Brewer(4)

Keurig K-Cup Brewer(1)

 
Tea Weight

0.1 oz(1)

 
Product Type

Tea(5)

 
Packaged Quantity

24 / Box(5)

 
Flavor/Blend

Malt(1)

Scorched Wood(1)

Chai(1)

Dark Chocolate(1)

Caramel(1)

Earl Grey(1)

Peppermint Tea(1)

Madison Blend(1)

English Breakfast(1)

 
Packing

Box(1)