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

Celestial Seasonings(18)

Tazo(10)

Numi(10)

Mighty Leaf Tea(6)

Lipton(6)

Snapple(5)

Café Escapes(2)

Tetley(2)

Arizona(1)

Tea One(1)

 
Packing Type

K-Cup(36)

Filterbag(26)

Bag(13)

Box(9)

Tea Bag(8)

Pod(5)

Can(1)

 
Flavor

Green Tea(5)

Assorted(5)

Earl Grey(4)

English Breakfast(4)

Breakfast Blend(2)

Lemon Zinger(2)

Mandarin Orange(2)

India Spice Chai(2)

Lemon(2)

Chai Latte(2)

Cozy Chamomile(2)

Raspberry(2)

Moroccan Mint(1)

Jasmine Green(1)

British Blend(1)

Chamomile Lemon(1)

Gunpowder Green(1)

Regular(1)

Peach(1)

Soothe Smooth Green Tea(1)

Aged Earl Grey(1)

Tropical Citrus Green(1)

Decaffeinated(1)

British Blend Decaf(1)

Indulge Rich Black Tea(1)

Chamomile Citrus(1)

Calm Chamomile(1)

Zen(1)

Awake English Breakfast(1)

Refresh Mint(1)

Passion(1)

China Green Tips(1)

Wild Sweet Orange(1)

Organic Chai(1)

Wild Berry Hibiscus(1)

Organic Mint Melange(1)

Chocolate Puerh(1)

Emperor's Puerh(1)

White Orange Spice(1)

Southern Sweet Tea(1)

Green Tea Tropical(1)

Organic Earl Grey(1)

Organic Breakfast(1)

Rooibos Chai(1)

Breakfast Tea(1)

Mint Medley Herbal Tea(1)

English Teatime Decaf(1)

Sweet Dreams(1)

Orange & Spice Herbal Tea(1)

Assorted Herbal(1)

Cranberry Apple Herbal Tea(1)

Earl Grey Black Tea(1)

Green Decaf(1)

Decaffeinated Black(1)

Premium Ceylon(1)

Green(1)

Lemon Lift Black Tea(1)

Plantation Mint Black Tea(1)

Cinnamon Stick Black Tea(1)

Pure Green(1)

Lemon Ginger(1)

Ginseng & Honey(1)

Cinnamon Apple Spice(1)

Earl Grey Tea(1)

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

Iced Tea/Lemonade(1)

Black(1)

Sleepytime(1)

Decaffeinated Green Tea(1)

Mint(1)

Chamomile Citrus Herbal(1)

Dandelion & Peach Rooibos & Green Tea(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)

Green Tea Decaf(1)

Herbal Lemon Zinger(1)

Diet Iced Tea w/Peach(1)

 
Beverage Type

Tea(72)

Green Tea(8)

Herbal Tea(6)

Iced Tea(5)

Black Tea(5)

Decaffeinated Tea(1)

Decaffeinated Black Tea(1)

 
Manufacturer Part Number

6868(1)

6870(1)

6867(1)

6856(1)

6855(1)

6871(1)

6872(1)

10104(1)

291(1)

290(1)

20700(1)

6825(1)

6805CT(1)

6113(1)

6085CT(1)

6085(1)

6082CT(1)

6505(1)

6505CT(1)

6805(1)

6622(1)

6528(1)

6518(1)

10108(1)

10109(1)

149900(1)

149901(1)

149899(1)

149898(1)

510144(1)

149902(1)

149903(1)

153966(1)

153961(1)

151598(1)

149904(1)

510142(1)

510140(1)

10220(1)

10200(1)

10170(1)

10150(1)

10240(1)

10350(1)

510139(1)

510138(1)

510136(1)

10360(1)

6082(1)

6080CT(1)

10393(1)

10396(1)

10357(1)

10348(1)

10347(1)

10398(1)

10400(1)

17700(1)

17578(1)

15577(1)

10906(1)

10346(1)

10344(1)

00388(1)

00356(1)

00351(1)

003401(1)

00401(1)

007906(1)

10343(1)

10342(1)

009906(1)

008906(1)

17701(1)

17703(1)

14737(1)

14735CT(1)

14735(1)

14734CT(1)

14737CT(1)

14738(1)

6080(1)

5402(1)

14739(1)

14738CT(1)

14734(1)

14732CT(1)

17715(1)

17709(1)

17707(1)

17704(1)

30568(1)

30568CT(1)

14732(1)

14731CT(1)

14731(1)

031010(1)

827195(1)

 
Country of Origin

US(76)

CN(9)

IN(5)

EG(4)

MA(1)

PE(1)

ID(1)

ZA(1)

 
For Use With

Keurig K-Cup System(36)

Single-Cup Brewers(1)

 
Capacity (Volume)

1.90 oz(4)

32 oz(1)

16 oz(1)

23 oz(1)

 
Capacity (Weight)

1.32 oz(5)

1.7 oz(4)

0.34 lbs(3)

1.27 oz(3)

1.6 oz(2)

1.4 oz(2)

1 oz(2)

1.59 oz(1)

0.3 lbs(1)

1.13 oz(1)

2 oz(1)

1.9 oz(1)

2.1 oz(1)

1.82 oz(1)

.125 oz(1)

0.8 lbs(1)

1.71 oz(1)

1.18 oz(1)

1.41 oz(1)

0.91 oz(1)

3.05 oz(1)

0.15 oz(1)

1.08 oz(1)

1.28 oz(1)

1.58 oz(1)

 
 
 

© 2019-2020 Office Solutions & Innovations, Inc., All Rights Reserved