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

Celestial Seasonings(19)

Tazo(14)

Mighty Leaf Tea(10)

Numi(10)

TWININGS(9)

Lipton(7)

Snapple(5)

diet Snapple(3)

Tetley(2)

Café Escapes(2)

Arizona(1)

Brisk(1)

Tea One(1)

 
Quantity

24 per box(24)

28 per box(11)

15 per box(10)

18 per box(10)

96 per carton(10)

25 per box(9)

20 per box(6)

16 per box(4)

72 per carton(3)

22 per box(3)

22 per box.(2)

24 per box.(2)

6 per carton(2)

168 per carton(2)

64 per box(2)

1 each(2)

100 per box(2)

48 per box(1)

12 per pack(1)

88 per carton(1)

150 per carton(1)

24 per carton(1)

14 per box(1)

72 per box(1)

 
Packing Type

Filterbag(38)

K-Cup(38)

Bag(13)

Box(10)

Tea Bag(7)

Pod(5)

Tetra Pak(4)

Can(2)

 
Flavor

Assorted(6)

Green Tea(5)

English Breakfast(5)

Earl Grey(5)

Iced Passion Tea(2)

Iced Peachy Green Tea(2)

India Spice Chai(2)

Chai Latte(2)

Breakfast Blend(2)

Mandarin Orange(2)

Lemon Zinger(2)

Cozy Chamomile(2)

Green(2)

Cherry Lemon Green Tea(1)

Wild Berry Hibiscus(1)

China Green Tips(1)

Jasmine Green(1)

Chamomile Lemon(1)

Gunpowder Green(1)

White Orchard(1)

Moroccan Mint(1)

Organic Spring Jasmine(1)

Chamomile Citrus(1)

Regular(1)

Decaffeinated(1)

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

Green Tea Tropical(1)

Organic Breakfast(1)

Organic Mint Melange(1)

Bombay Chai(1)

Organic Earl Grey(1)

Wild Sweet Orange(1)

Rooibos Chai(1)

Refresh Mint(1)

Peppermint(1)

Camomile(1)

English Breakfast Decaf.(1)

Chai(1)

Zen(1)

Awake English Breakfast(1)

Green with Jasmine(1)

Peppermint Tea(1)

Passion(1)

Emperor's Puerh(1)

White Orange Spice(1)

Calm Chamomile(1)

Diet Green Tea(1)

Chocolate Puerh(1)

Organic Chai(1)

Sweet Tea with Lemon(1)

Aged Earl Grey(1)

Lemon(1)

Pure Green(1)

Assorted Herbal(1)

Cranberry Apple Herbal Tea(1)

Lemon Ginger(1)

Chamomile Citrus 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(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)

Green Tea Decaf(1)

Decaffeinated Green Tea(1)

Soothe Smooth Green Tea(1)

Indulge Rich Black Tea(1)

British Blend Decaf(1)

Ginseng & Honey(1)

Raspberry(1)

Tropical Citrus Green(1)

Sweet Tea(1)

Peach(1)

British Blend(1)

Southern Sweet Tea(1)

Breakfast Tea(1)

Cinnamon Apple Spice(1)

Sleepytime(1)

Earl Grey Tea(1)

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

Diet Iced Tea w/Peach(1)

Iced Tea/Lemonade(1)

Black(1)

Diet Raspberry Tea(1)

 
Beverage Type

Tea(87)

Iced Tea(10)

Green Tea(7)

Herbal Tea(6)

Black Tea(5)

Decaffeinated Tea(1)

Decaffeinated Black Tea(1)

 
Manufacturer Part Number

40016(1)

40018(1)

40008(1)

40005(1)

40003(1)

40004(1)

40027(1)

40028(1)

10150(1)

10170(1)

10109(1)

10108(1)

10104(1)

40002(1)

40001(1)

6871(1)

6872(1)

6870(1)

6868(1)

6856(1)

6867(1)

6878(1)

20700(1)

290(1)

291(1)

33620(1)

33619(1)

33617(1)

10200(1)

10220(1)

149899(1)

149900(1)

149898(1)

10021(1)

09185(1)

09187(1)

149901(1)

149902(1)

153961(1)

153966(1)

151598(1)

149904(1)

149903(1)

09183(1)

09182(1)

10091PK(1)

11041593(1)

10360(1)

10350(1)

10240(1)

11041593EA(1)

11041594(1)

09179(1)

09181(1)

09178(1)

08760(1)

11041594EA(1)

6855(1)

6825(1)

17700(1)

17701(1)

16578(1)

15577(1)

10400(1)

10906(1)

17703(1)

17704(1)

30568CT(1)

031010(1)

30568(1)

17709(1)

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

49683(1)

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

14731CT(1)

14735(1)

14735CT(1)

14738CT(1)

14739(1)

14738(1)

14737CT(1)

14737(1)

827195(1)

 
Country of Origin

US(83)

CN(22)

EG(4)

IN(4)

PA(1)

ID(1)

ZA(1)

MA(1)

 
For Use With

Keurig Brewing System(36)

Keurig K-Cup System(1)

Single-Cup Brewers(1)

 
Capacity (Volume)

32 oz(5)

1.90 oz(4)

12 oz(1)

1(1)

0.11 oz(1)

0.61 oz(1)

0.68 oz(1)

0.25 oz(1)

23 oz(1)

16 oz(1)

 
Capacity (Weight)

1.32 oz(9)

1.76 oz(8)

1.7 oz(4)

1.27 oz(3)

1 oz(2)

1.4 oz(2)

1.6 oz(2)

1.28 oz(1)

1.13 oz(1)

0.3 lbs.(1)

2 oz(1)

1.9 oz(1)

2.1 oz(1)

1.82 oz(1)

.125 oz(1)

1.71 oz(1)

0.91 oz(1)

0.15 oz(1)

3.05 oz(1)

1.59 oz(1)

0.8 lbs.(1)

1.41 oz(1)

1.08 oz(1)

1.58 oz(1)

 
 
 
 
 

© 2018-2019 Office 8, All Rights Reserved