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_19` 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(28)

Celestial Seasonings(24)

Lipton(14)

Tazo(11)

Snapple(11)

Numi(10)

TWININGS(8)

Tiesta(4)

diet Snapple(4)

The Coffee Bean & Tea Leaf(3)

Tetley(2)

Café Escapes(2)

Vitamin Burst(2)

Tea One(1)

Arizona(1)

 
Quantity

24 per box(20)

96 per carton(15)

28 per box(11)

18 per box(10)

88 per carton(10)

25 per box(9)

1 each(6)

16 per box(6)

22 per box(5)

72 per carton(4)

6 per carton(3)

24 per box.(3)

168 per carton(3)

22 per box.(2)

100 per box(2)

64 per box(2)

6 tins(1)

150 per carton(1)

72 per box(1)

14 per box(1)

24 per carton(1)

48 per box(1)

 
Packing Type

K-Cup(57)

Bag(29)

Box(21)

Tetra Pak(6)

Pod(5)

Vue Pack(2)

Tin(2)

Tea Bag(1)

Can(1)

 
Flavor

Green Tea(7)

Assorted(6)

English Breakfast(4)

Sleepytime(3)

Earl Grey(3)

Sweet Tea(3)

Raspberry(2)

Breakfast Blend(2)

India Spice Chai(2)

Peach(2)

Mandarin Orange(2)

Decaffeinated Green Tea(2)

Darjeeling Tea(2)

Black(2)

Indulge Rich Black Tea(2)

Lemon(2)

Lemon Zinger(2)

Chai Latte(2)

Iced Tea/Lemonade(2)

Soothe Smooth Green Tea(2)

Iced Passion Tea(2)

Green(2)

Cozy Chamomile(2)

Iced Peachy Green Tea(2)

Iced Sangria Black Tea(2)

Nutty Almond Cream(2)

Decaffeinated(1)

Awake English Breakfast(1)

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

Green with Jasmine(1)

Regular(1)

Calm Chamomile(1)

China Green Tips(1)

Diet Peach Tea(1)

Organic Chai(1)

Moroccan Mint(1)

Diet Raspberry Tea(1)

Diet Green Tea(1)

Chamomile Lemon(1)

Chocolate Puerh(1)

Emperor's Puerh(1)

Camomile(1)

Tropical Citrus Green(1)

Lean Green Machine(1)

Fireberry(1)

White Orange Spice(1)

Peppermint(1)

Chai(1)

Gunpowder Green(1)

Aged Earl Grey(1)

English Breakfast Decaf.(1)

Rooibos Chai(1)

Jasmine Green(1)

Southern Sweet(1)

Orange & Spice Herbal Tea(1)

Sweet Dreams(1)

Cranberry Apple Herbal Tea(1)

Assorted Herbal(1)

Herbal Lemon Zinger(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)

Mint Medley Herbal Tea(1)

English Teatime Decaf(1)

Decaffeinated Black(1)

Premium Ceylon(1)

Lemon Lift Black Tea(1)

Cinnamon Stick Black Tea(1)

Earl Grey Black Tea(1)

Plantation Mint Black Tea(1)

Cinnamon Apple Spice(1)

Breakfast Tea(1)

Ginseng & Honey(1)

Diet Peach(1)

British Blend(1)

British Blend Decaf(1)

Strawberry Pomegranate(1)

Acai Berry(1)

Diet Iced Tea w/Peach(1)

Diet Lemon(1)

Jasmine Green Tea(1)

Earl Grey Tea(1)

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

Unsweetened(1)

Diet Iced Tea w/Lemon(1)

Berry(1)

 
Beverage Type

Tea(82)

Iced Tea(20)

Herbal Tea(8)

Green Tea(7)

Black Tea(5)

Decaffeinated Tea(1)

Decaffeinated Black Tea(1)

 
Manufacturer Part Number

9701(1)

20700(1)

9348(1)

9325(1)

6878(1)

6878CT(1)

33616(1)

33617(1)

10104(1)

10108(1)

291(1)

290(1)

33619(1)

33620(1)

6872CT(1)

6872(1)

6863(1)

6864(1)

6856(1)

6855(1)

6825(1)

6825CT(1)

6867(1)

6867CT(1)

6871(1)

6871CT(1)

6870CT(1)

6870(1)

6868(1)

6868CT(1)

10109(1)

10150(1)

09182(1)

09183(1)

09181(1)

09179(1)

97533(1)

09178(1)

09185(1)

09187(1)

153961(1)

153966(1)

149904(1)

149901(1)

10021(1)

149898(1)

96420(1)

70872(1)

10350(1)

10360(1)

10240(1)

10220(1)

10170(1)

10200(1)

11041593(1)

11041593EA(1)

11041595EA(1)

69685(1)

11041595(1)

11041594EA(1)

11041594(1)

6805CT(1)

6805(1)

30568(1)

30568CT(1)

16578(1)

15577(1)

10400(1)

10906(1)

031010(1)

49683(1)

14734(1)

14734CT(1)

14732CT(1)

14732(1)

14731(1)

14731CT(1)

10398(1)

10396(1)

00401(1)

007906(1)

00388CT(1)

00388(1)

00351(1)

00356(1)

008906(1)

009906(1)

10357(1)

10393(1)

10348(1)

10344(1)

10342(1)

10343(1)

14735(1)

14735CT(1)

6505CT(1)

6518(1)

6505(1)

6113(1)

6101(1)

6101CT(1)

6518CT(1)

6526CT(1)

6622(1)

6622CT(1)

6621CT(1)

6621(1)

6528(1)

6528CT(1)

6100(1)

6085CT(1)

14739(1)

14739CT(1)

14738CT(1)

14738(1)

14737(1)

14737CT(1)

5402(1)

5402CT(1)

6082CT(1)

6085(1)

6082(1)

6080CT(1)

6080(1)

827195(1)

 
Country of Origin

US(107)

CN(13)

EG(2)

IN(2)

ZA(1)

 
For Use With

Keurig Brewing System(56)

Single-Cup Brewers(1)

Keurig Vue Brewing System(1)

Keurig Vue System Brewers(1)

 
Capacity (Volume)

1.76 oz(7)

32 oz(7)

1.90 oz(4)

0.68 oz(2)

4 oz(1)

4oz(1)

0.61 oz(1)

0.25 oz(1)

23 oz(1)

16 oz(1)

 
Capacity (Weight)

1.76 oz(8)

1.7 oz(4)

1.27 oz(3)

1.4 oz(2)

1 lb(2)

.125 oz(1)

1.13 oz(1)

1.58 oz(1)

1.08 oz(1)

0.3 lbs.(1)

3.05 oz(1)

0.15 oz(1)

0.8 lbs.(1)

1.71 oz(1)

 
Roast Type

Light(1)