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_38` 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(38)

Celestial Seasonings(19)

Tazo(16)

Numi(10)

Tiesta(9)

Lipton(9)

TWININGS(7)

Snapple(6)

Mighty Leaf Tea(6)

diet Snapple(3)

Tetley(2)

Café Escapes(2)

Twinings(2)

Tea One(1)

Bigelow®(1)

Arizona(1)

Starbucks(1)

 
Quantity

1 each(11)

25 per box(7)

6 per carton(3)

72 per carton(3)

6 tins(1)

24 per box(1)

 
Packing Type

K-Cup(40)

Filterbag(33)

Bag(18)

Box(13)

Tea Bag(9)

Tetra Pak(6)

Tin(5)

Pod(5)

K-Cup®(1)

Can(1)

 
Flavor

Assorted(7)

English Breakfast(5)

Green Tea(5)

Earl Grey(4)

Chai Latte(3)

Nutty Almond Cream(2)

Fireberry(2)

Chai Love(2)

Lean Green Machine(2)

Iced Sangria Black Tea(2)

Iced Passion Tea(2)

Mandarin Orange(2)

Lemon Zinger(2)

Breakfast Blend(2)

India Spice Chai(2)

Iced Peachy Green Tea(2)

Green(2)

Cozy Chamomile(2)

Lemon(2)

Raspberry(2)

Rooibos Chai(1)

Tropical Citrus Green(1)

Diet Peach Tea(1)

White Orange Spice(1)

Emperor's Puerh(1)

Chamomile Citrus(1)

Chocolate Puerh(1)

Aged Earl Grey(1)

Chamomile Lemon(1)

Moroccan Mint(1)

Regular(1)

Decaffeinated(1)

Diet Raspberry Tea(1)

Jasmine Green(1)

Gunpowder Green(1)

China Green Tips(1)

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

Organic Breakfast(1)

Camomile(1)

Zen(1)

Calm Chamomile(1)

Awake English Breakfast(1)

Peppermint(1)

Chai(1)

English Breakfast Decaf.(1)

Refresh Mint(1)

Passion(1)

Organic Earl Grey(1)

Wild Sweet Orange(1)

Green with Jasmine(1)

Organic Mint Melange(1)

Wild Berry Hibiscus(1)

Berry(1)

Organic Chai(1)

Green Tea Tropical(1)

British Blend(1)

Pure Green(1)

Assorted Herbal(1)

Cranberry Apple Herbal Tea(1)

Orange & Spice Herbal Tea(1)

Lemon Ginger(1)

Chamomile Citrus Herbal(1)

Dandelion & Peach Rooibos & Green Tea(1)

Sweet Cinnamon Black Tea(1)

Mint(1)

Sweet Dreams(1)

Mint Medley Herbal Tea(1)

Lemon Lift Black Tea(1)

Decaffeinated Black(1)

Premium Ceylon(1)

Cinnamon Stick Black Tea(1)

Plantation Mint Black Tea(1)

English Teatime Decaf(1)

Earl Grey Black Tea(1)

Green Decaf(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)

Diet Iced Tea w/Lemon(1)

British Blend Decaf(1)

Indulge Rich Black Tea(1)

Sweet Tea(1)

Peach(1)

Soothe Smooth Green Tea(1)

Iced Tea/Lemonade(1)

Unsweetened(1)

Sleepytime(1)

Decaffeinated Green Tea(1)

Green Tea Decaf(1)

Cinnamon Apple Spice(1)

Breakfast Tea(1)

Black(1)

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

Earl Grey Tea(1)

English Breakfast; Green(1)

 
Beverage Type

Tea(99)

Iced Tea(11)

Green Tea(8)

Herbal Tea(6)

Black Tea(5)

Decaffeinated Tea(1)

Decaffeinated Black Tea(1)

 
Manufacturer Part Number

10240(1)

10350(1)

10360(1)

10220(1)

10200(1)

10150(1)

10170(1)

510136(1)

510138(1)

11041593(1)

11041593EA(1)

510144(1)

510142(1)

510139(1)

510140(1)

10109(1)

10108(1)

6872(1)

6878(1)

8355(1)

6871(1)

6870(1)

6867(1)

6868(1)

9701(1)

20700(1)

291(1)

10104(1)

290(1)

33620(1)

33616(1)

33617(1)

11041594(1)

11041594EA(1)

10021(1)

149898(1)

149899(1)

09187(1)

09185(1)

09181(1)

09182(1)

149900(1)

149901(1)

153961(1)

153966(1)

151598(1)

149904(1)

149902(1)

149903(1)

09179(1)

09178(1)

69685(1)

69692(1)

60001(1)

11093270(1)

11041595(1)

11041595EA(1)

70667(1)

70872(1)

08759(1)

08760(1)

97533(1)

97465(1)

96420(1)

97243(1)

6856(1)

6855(1)

17578(1)

17700(1)

17701(1)

15577(1)

10906(1)

10398(1)

10400(1)

17703(1)

17704(1)

30568(1)

30568CT(1)

17715(1)

17712(1)

17707(1)

17709(1)

10396(1)

10393(1)

00401(1)

007906(1)

008906(1)

00388(1)

00356(1)

003401(1)

00351(1)

009906(1)

10342(1)

10348(1)

10357(1)

10347(1)

10346(1)

10343(1)

10344(1)

031010(1)

49683(1)

6113(1)

6505(1)

6505CT(1)

6085CT(1)

6085(1)

6082(1)

6082CT(1)

6518(1)

6526(1)

6805CT(1)

6825(1)

6805(1)

6622(1)

6528(1)

6621(1)

6080CT(1)

6080(1)

14734(1)

14734CT(1)

14732CT(1)

14732(1)

14731(1)

14731CT(1)

14735(1)

14735CT(1)

14739(1)

5402(1)

14738CT(1)

14738(1)

14737(1)

14737CT(1)

827195(1)

 
Country of Origin

US(102)

CN(16)

IN(5)

EG(4)

United States(1)

MA(1)

ZA(1)

ID(1)

PE(1)

 
For Use With

Keurig K-Cup System(36)

Keurig Brewing System(4)

Starbucks Serenade Single-Cup Brewer(1)

Keurig® K-Cup® System(1)

Single-Cup Brewers(1)

 
Capacity (Volume)

32 oz(7)

1.90 oz(4)

4 oz(4)

0.68 oz(2)

4oz(1)

0.61 oz(1)

23 oz(1)

16 oz(1)

 
Capacity (Weight)

1.76 oz(7)

1.32 oz(5)

1 lb(4)

1.7 oz(4)

1.6 oz(3)

1.27 oz(3)

0.34 lbs(3)

1 oz(2)

1.4 oz(2)

1.59 oz(1)

1.9 oz(1)

2.1 oz(1)

2 oz(1)

1.13 oz(1)

1.82 oz(1)

2 lbs(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)

.125 oz(1)

 
Serve Type

K-Cup(2)

 
Roast Type

Light(1)

 
Tea Type

Herbal Tea(1)

Green Tea(1)

 
Compatible Brewer

Keurig K-Cup Brewer(1)

Keurig Brewer(1)

 
Tea Weight

0.1 oz(1)

 
Product Type

Tea(2)

 
Packaged Quantity

24 / Box(2)

 
Flavor/Blend

Malt(1)

Scorched Wood(1)

Dark Chocolate(1)

Caramel(1)

Madison Blend(1)

Peppermint Tea(1)

 
Packing

Box(1)

 
 
 

© 2019-2020 NBJ Form & Function Inc. , All Rights Reserved