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_name` LIKE "Tea") 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(26)

Teavana(11)

Tazo(10)

Numi(9)

Celestial Seasonings®(7)

Twinings(5)

Bigelow Tea(3)

Lipton(3)

Bright Tea Co(3)

Bigelow®(2)

Lipton®(2)

Pure Leaf(2)

steep(1)

The Hain Celestial(1)

Snapple®(1)

Brisk(1)

 
Packaged Quantity

24 / Box(27)

28 / Box(8)

18 / Box(7)

20 / Box(6)

25 / Box(5)

6 Box(4)

24 / Carton(4)

100 / Carton(3)

12 / Carton(2)

16 / Box(2)

80 / Carton(2)

100 / Box(2)

384 / Carton(2)

6 / Carton(2)

64 / Box(2)

168 / Carton(2)

22 / Box(1)

72 / Box(1)

128 / Bundle(1)

1 Box(1)

60 / Box(1)

25 Each(1)

 
Flavor

Regular(1)

 
Flavor/Blend

Earl Grey(10)

English Breakfast(7)

Lemon(6)

Assorted(5)

Hibiscus(4)

Citrus(4)

Chai(3)

Ginger(3)

Chamomile(3)

Mint(3)

Lemongrass(2)

Spice(2)

Calm Blend(2)

Refresh(2)

Spearmint(2)

China Green(2)

Mountain Grown(2)

Harmonic Mint(2)

Peppermint(2)

Apple(2)

Radiant Green(2)

Sweet Licorice(1)

Cinnamon Spice(1)

Jasmine Citrus(1)

Ginger Peach(1)

Classic(1)

Cinnamon(1)

Cardamom(1)

Clove(1)

Black Pepper(1)

Pomegranate Zest(1)

Blackberry Leaf(1)

Chamomile Rose(1)

Rose Hip(1)

Zesty Lemon(1)

Floral(1)

Jasmine Green Lemon(1)

Passion(1)

Bergamot(1)

Sweet Spearmint(1)

Tarragon(1)

Passion Fruit(1)

Awake(1)

Wild Sweet Orange(1)

Citrus Herb(1)

Licorice Root(1)

Orange(1)

Hibiscus Spice(1)

Lavender(1)

Soft Floral(1)

Rooibos(1)

Cinnamon Stick(1)

Perfectly Mint(1)

English Teatime(1)

Cranberry Apple(1)

Cozy Chamomile Herb(1)

Herbal(1)

Cranberry(1)

Sweet Dreams(1)

Orange and Spice(1)

Mint Medley(1)

Lemon Ginger(1)

Spicy Ginger(1)

Chamomile Citrus(1)

Sweet Cinnamon(1)

Dandelion(1)

Chamomile Blush(1)

Peach Rooibos(1)

Lemon Zinger(1)

Sleepytime(1)

Cinnamon Apple Spice(1)

Morroccan Mint(1)

Jasmine Green(1)

Gunpowder Green(1)

Chamomile Lemon(1)

Breakfast Blend(1)

White Orange Spice(1)

Chocolate(1)

Modern Earl Grey(1)

Bergamot Citrus(1)

Verbena(1)

ZEN(1)

 
Serve Type

K-Cup(11)

Bottle(3)

Tea Bag(2)

OneCup(1)

 
Packing

Box(14)

Bag(10)

Pouch(5)

Pod(3)

Packet(1)

 
Number of Serving Cups

1(18)

24(3)

22(1)

 
Tea Type

Black Tea(30)

Green Tea(28)

Herbal Tea(25)

Decaffeinated(7)

Caffeinated(3)

Ice Tea(2)

White Tea(1)

 
Tea Quantity

28 Teabag(7)

120 Teabag(7)

18 Teabag(7)

24 Filterbag(4)

24 Bottle(3)

25 Cup(3)

168 Teabag(2)

108 Teabag(2)

24 Teabag(2)

60(1)

64 Teabag(1)

72 Teabag(1)

100 Teabag(1)

16 Teabag(1)

16(1)

24 Packet(1)

 
Compatible Brewer

Keurig Brewer(12)

Flavia(3)

Flavia Barista(1)

Flavia Creation 500(1)

Flavia Creation 200(1)

Flavia Creation 150(1)

 
Tea Weight

1.7 oz(6)

1.6 oz(4)

1.9 oz(3)

20 oz(3)

1.8 oz(2)

0.1 oz(2)

1.1 oz(2)

2.1 oz(2)

18 oz(2)

8 oz Per Bag(1)

1.3 oz Per Packet(1)

3.2 oz Per Box(1)

0 oz(1)

1.2 oz(1)

1 oz(1)

1.3 oz(1)

8 oz(1)

16 oz Per Bag(1)

 
Manufacturer Part Number

00351(1)

10220(1)

12416720(1)

92375(1)

92373(1)

69294(1)

134072(1)

134071(1)

10360(1)

10240(1)

10200(1)

12416722(1)

10170(1)

10150(1)

10109(1)

10108(1)

10104(1)

TZ02(1)

TZ01(1)

B508(1)

12416721(1)

12418637(1)

B506(1)

09183(1)

153961(1)

151598(1)

149904(1)

149903(1)

149902(1)

149901(1)

149899(1)

09187(1)

09182(1)

12418656(1)

09181(1)

09179(1)

12434034(1)

12434019(1)

12434018(1)

12434017(1)

12434016(1)

12421607(1)

B507(1)

TJL00291(1)

00388(1)

10393(1)

17700(1)

17578(1)

15577(1)

10906(1)

10578(1)

10568BD(1)

10568(1)

10400(1)

10357(1)

17703(1)

10348(1)

10344(1)

10343(1)

008906(1)

007906(1)

00450(1)

00401(1)

00388CT(1)

17701(1)

17704(1)

291(1)

T14737(1)

290(1)

T6870(1)

T6085(1)

T6082(1)

T6080(1)

T5000055655(1)

T14739(1)

T14738(1)

T14734CT(1)

17707(1)

T14734(1)

T14732(1)

031010(1)

30568CT(1)

30568(1)

17715(1)

17713(1)

17712(1)

153966(1)

 
Country of Origin

United States(55)

China(5)

Egypt(2)

Canada(2)

Poland(2)

Sri Lanka(1)

US(1)

India(1)

South Africa(1)

Indonesia(1)

 
Height

7"(1)

 
Width

6"(1)

 
Packing Type

Box(1)

 
Capacity (Volume)

32 oz(1)

 
Beverage Type

Tea(1)

 
 
 

© 2020-2021 Panola Paper Co, All Rights Reserved