New Arrivals



Our Brands


Offers



All Best Seller Gift Set Features


select p.ID,p.out_of_stock,p.is_new,p.is_best_seller, p.Title, p.code, p.image_path, p.price, p.price_2, b.rate, b.title as brand_title, b.ID as brand_id, ((select o.price from offer o where o.product_id=p.ID and o.status=1 and o.end_date>='2021-12-09')* b.rate) as offer_price, ROUND(IF(((select o.price from offer o where o.product_id=p.ID and o.status=1 and o.end_date>='2021-12-09') * b.rate) is null, ((p.price_2)*b.rate ), ((select o.price from offer o where o.product_id=p.ID and o.status=1 and o.end_date>='2021-12-09') * b.rate))) as final_price from products p, brands b where b.ID=p.brands_id and p.status=1 and p.is_best_seller=1 order by p.bestseller_date desc LIMIT 4
Image
select p.ID,p.out_of_stock,p.is_new,p.is_best_seller, p.Title, p.code, p.image_path, p.price, p.price_2, b.rate, b.title as brand_title, b.ID as brand_id, ((select o.price from offer o where o.product_id=p.ID and o.status=1 and o.end_date>='2021-12-09')* b.rate) as offer_price, ROUND(IF(((select o.price from offer o where o.product_id=p.ID and o.status=1 and o.end_date>='2021-12-09') * b.rate) is null, ((p.price_2)*b.rate ), ((select o.price from offer o where o.product_id=p.ID and o.status=1 and o.end_date>='2021-12-09') * b.rate))) as final_price from products p, brands b where b.ID=p.brands_id and p.status=1 and p.is_best_seller=1 order by p.bestseller_date desc LIMIT 4
Image
select p.ID,p.out_of_stock,p.is_new,p.is_best_seller, p.Title, p.code, p.image_path, p.price, p.price_2, b.rate, b.title as brand_title, b.ID as brand_id, ((select o.price from offer o where o.product_id=p.ID and o.status=1 and o.end_date>='2021-12-09')* b.rate) as offer_price, ROUND(IF(((select o.price from offer o where o.product_id=p.ID and o.status=1 and o.end_date>='2021-12-09') * b.rate) is null, ((p.price_2)*b.rate ), ((select o.price from offer o where o.product_id=p.ID and o.status=1 and o.end_date>='2021-12-09') * b.rate))) as final_price from products p, brands b where b.ID=p.brands_id and p.status=1 and p.is_best_seller=1 order by p.bestseller_date desc LIMIT 4
New
Image
select p.ID,p.out_of_stock,p.is_new,p.is_best_seller, p.Title, p.code, p.image_path, p.price, p.price_2, b.rate, b.title as brand_title, b.ID as brand_id, ((select o.price from offer o where o.product_id=p.ID and o.status=1 and o.end_date>='2021-12-09')* b.rate) as offer_price, ROUND(IF(((select o.price from offer o where o.product_id=p.ID and o.status=1 and o.end_date>='2021-12-09') * b.rate) is null, ((p.price_2)*b.rate ), ((select o.price from offer o where o.product_id=p.ID and o.status=1 and o.end_date>='2021-12-09') * b.rate))) as final_price from products p, brands b where b.ID=p.brands_id and p.status=1 and p.is_best_seller=1 order by p.bestseller_date desc LIMIT 4
Image
Image
Image
Image
Image
Image
Image
Image
Image