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','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(40)

Celestial Seasonings(19)

Tazo(15)

Numi(10)

Tiesta(9)

Lipton(6)

Snapple(5)

TWININGS(4)

Mighty Leaf Tea(3)

Café Escapes(2)

Tetley(2)

Tea One(1)

diet Snapple(1)

 
Quantity

1 each(11)

25 per box(4)

28 per box(2)

6 per carton(2)

48 per box(1)

150 per carton(1)

24 per box.(1)

72 per carton(1)

6 tins(1)

 
Packing Type

K-Cup(37)

Filterbag(27)

Bag(17)

Box(11)

Tea Bag(10)

Pod(5)

Tetra Pak(5)

Tin(5)

 
Flavor

Assorted(7)

Green Tea(5)

English Breakfast(5)

Earl Grey(4)

Raspberry(2)

Lean Green Machine(2)

Chai Latte(2)

Breakfast Blend(2)

India Spice Chai(2)

Mandarin Orange(2)

Lemon Zinger(2)

Iced Peachy Green Tea(2)

Nutty Almond Cream(2)

Fireberry(2)

Chai Love(2)

Iced Passion Tea(2)

Cozy Chamomile(2)

Lemon(2)

Green(2)

Peppermint(1)

Rooibos Chai(1)

English Breakfast; Green(1)

Tropical Citrus Green(1)

Wild Sweet Orange(1)

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

Decaffeinated(1)

Regular(1)

Moroccan Mint(1)

Jasmine Green(1)

Gunpowder Green(1)

Chamomile Lemon(1)

Aged Earl Grey(1)

White Orange Spice(1)

English Breakfast Decaf.(1)

Organic Chai(1)

Passion(1)

Emperor's Puerh(1)

Chocolate Puerh(1)

Chamomile Citrus(1)

Green Tea Tropical(1)

Organic Mint Melange(1)

Soothe Smooth Green Tea(1)

Refresh Mint(1)

Iced Sangria Black Tea(1)

Calm Chamomile(1)

Zen(1)

Awake English Breakfast(1)

Peach(1)

Iced Tea/Lemonade(1)

Indulge Rich Black Tea(1)

English Teatime Decaf(1)

Pure Green(1)

Assorted Herbal(1)

Cranberry Apple Herbal Tea(1)

Orange & Spice Herbal Tea(1)

Sweet Dreams(1)

Mint Medley Herbal Tea(1)

Earl Grey Black Tea(1)

Chamomile Citrus Herbal(1)

Green Decaf(1)

Plantation Mint Black Tea(1)

Cinnamon Stick Black Tea(1)

Lemon Lift Black Tea(1)

Constant Comment(1)

Decaffeinated Black(1)

Lemon Ginger(1)

Mint(1)

British Blend Decaf(1)

Earl Grey Tea(1)

British Blend(1)

Southern Sweet Tea(1)

Diet Iced Tea w/Peach(1)

Premium Ceylon(1)

Black(1)

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

Breakfast Tea(1)

Sweet Cinnamon Black Tea(1)

Cinnamon Apple Spice(1)

Sleepytime(1)

Decaffeinated Green Tea(1)

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

Dandelion & Peach Rooibos & Green Tea(1)

China Green Tips(1)

 
Beverage Type

Tea(91)

Green Tea(7)

Herbal Tea(6)

Iced Tea(6)

Black Tea(5)

Decaffeinated Black Tea(1)

Decaffeinated Tea(1)

 
Manufacturer Part Number

003401(1)

290(1)

10360(1)

10350(1)

10240(1)

10220(1)

10200(1)

10170(1)

10150(1)

10109(1)

10108(1)

10104(1)

291(1)

33620(1)

510138(1)

20700(1)

8355(1)

6872(1)

6871(1)

6870(1)

6868(1)

6867(1)

6856(1)

6855(1)

6825(1)

6805CT(1)

6805(1)

510136(1)

510142(1)

6528(1)

09179(1)

153961(1)

151598(1)

149904(1)

149903(1)

149902(1)

149901(1)

149900(1)

149899(1)

149898(1)

09187(1)

09182(1)

09181(1)

97533(1)

11041593(1)

97465(1)

97243(1)

96420(1)

70872(1)

70667(1)

69692(1)

69685(1)

60001(1)

11041595EA(1)

11041594EA(1)

11041594(1)

11041593EA(1)

6622(1)

6518(1)

00351(1)

10357(1)

17704(1)

17703(1)

17701(1)

17700(1)

17578(1)

15577(1)

10906(1)

10400(1)

10398(1)

10396(1)

10393(1)

10348(1)

17709(1)

10347(1)

10346(1)

10344(1)

10343(1)

10342(1)

10341(1)

009906(1)

008906(1)

007906(1)

00401(1)

00388(1)

00356(1)

17707(1)

17712(1)

6505CT(1)

14737CT(1)

6505(1)

6113(1)

6085CT(1)

6085(1)

6082CT(1)

6082(1)

6080CT(1)

6080(1)

5402(1)

14739(1)

14738CT(1)

14738(1)

14737(1)

17715(1)

14735CT(1)

14735(1)

14734CT(1)

14734(1)

14732CT(1)

14732(1)

14731CT(1)

14731(1)

49683(1)

031010(1)

30568CT(1)

30568(1)

153966(1)

 
Country of Origin

US(96)

CN(10)

IN(4)

EG(3)

ZA(1)

ID(1)

PE(1)

MA(1)

 
For Use With

Keurig K-Cup System(35)

Keurig Brewing System(2)

Single-Cup Brewers(1)

 
Capacity (Volume)

32 oz(6)

4 oz(4)

1.66 oz(1)

0.61 oz(1)

16 oz(1)

4oz(1)

 
Capacity (Weight)

1.7 oz(4)

1.90 oz(4)

1.76 oz(4)

1 lb(4)

0.34 lbs(3)

1.32 oz(3)

1.27 oz(3)

1.6 oz(3)

1 oz(2)

1.4 oz(2)

1.13 oz(1)

2.1 oz(1)

1.82 oz(1)

2 oz(1)

0.3 lbs.(1)

1.28 oz(1)

0.91 oz(1)

0.13 oz(1)

1.41 oz(1)

1.58 oz(1)

1.71 oz(1)

1.08 oz(1)

0.8 lbs(1)

0.15 oz(1)

3.05 oz(1)

1.18 oz(1)

1.9 oz(1)

 
Roast Type

Light(1)

 
 
 

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