select p.products_id, p.products_image, p.products_tax_class_id, p.products_featured_status, p.products_model, p.products_price as old_products_price, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price, p.products_coming_soon_status, p.products_new_in_start, p.products_hot_item_start, p.products_bestseller_start, p.products_new_in, p.products_hot_item, p.products_bestseller, p.products_related_tag from products p left join specials s on p.products_id = s.products_id, products_description pd where p.products_free_gift_status = '0' and p.products_third_party_status = '0' and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1'and (p.products_style_with like '%PINK%' ) and (p.products_date_available < now() or p.products_date_available IS NULL) and p.products_quantity > 0 order by p.products_new desc, p.products_date_added desc
Return & Exchange Policy
All the item are good sold are not refund and exchange size or color.
We only accept the returns or exchange if faulty products.
All Product descriptions, information and materials posted on this Site are provided ‘as is’ and without warranties express, implied or otherwise howsoever arising.
Product image as seen on the Site may slightly different from the actual Product that you receive due to lighting / brightness on the device's screen.
If the item you receive is faulty, please contact our Customer Service Team and provide your Order number, your name and address, details of the Product and the reason for return, and whether you require a refund or a replacement.
Upon receipt of the Products, we will examine it and we will advise you on the status of the replacement (if any) via email as soon as practicable.
Do email us: admin@jemelsatelier.com