PHYTO continues to explore the world in search of the finest ingredients. Overall, our formulas contain over 500 active botanical ingredients and are 95% botanical. Our scientists extract the most active molecules found in the root, flower, bud, fruit, resin, or seeds. The manufacturing secret lies in the various extraction methods used, such as decoction or maceration. Also, PHYTO's highly concentrated formulas are housed in recyclable aluminum and glass for their non-porous properties which help minimize the use of preservatives.
PHYTO's first mission is to make products with the utmost quality and effectiveness in order to reveal beautiful, healthy hair.
SELECT distinct(products.idProduct), products.sku, products.description, products.price, products.listhidden, products.listprice, products.serviceSpec, products.bToBPrice, products.imageUrl,products.noprices,products.stock, products.noStock,products.pcprod_HideBTOPrice, 0 as POrder,products.FormQuantity,products.pcProd_BackOrder,brands.IH_showprice,brands.IH_callOrder,brands.callOrderPrice,products.idbrand,disc.discountDesc, CAST(products.sdesc AS NVARCHAR(MAX)) ,products.pcProd_BTODefaultWPrice, products.pcProd_BTODefaultPrice, CASE WHEN showOrder.POrder = 0 THEN 999 WHEN showOrder.POrder is null THEN 999 ELSE showOrder.POrder END as PshowOrder FROM products left join brands on products.idbrand = brands.idbrand left join (select idproduct,pOrder from categories_products where idcategory = 324)as showOrder on showOrder.idproduct = products.idproduct left join discountsperquantity as disc on disc.idDiscountperquantity = (Select top 1 idDiscountperquantity from discountsperquantity where discountsperquantity.idproduct = products.idproduct and discountPerUnit<>0), categories_products WHERE products.idProduct=categories_products.idProduct AND categories_products.idCategory in(324,2965) AND active=-1 AND configOnly=0 and removed=0 ORDER BY products.description Asc