By creating an account with our store, you will be able to move through the checkout process faster, store multiple shipping addresses, view and track your orders in your account and more.
Fine Chiffon
select p.products_id, pd.products_name, pd.products_display_name, p.products_image, p.products_related_code, p.manufacturers_id, p.products_special_text, p.products_price, p.products_color,p.products_tax_class_id, p.products_price, p.products_coming_soon_status, p.products_viewonly_status, p.address_key, 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, p.pwp_group_id from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c where p.products_status = '1' and p.products_free_gift_status = '0' and p.products_third_party_status = '0' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '104' and (p.products_date_available < now() or p.products_date_available IS NULL) order by p.products_instock desc, p.products_new desc, p.products_date_added desc, pd.products_name
(0 / 0 Products)
There are currently no products to list in this category.
Reward Points

Reward Points
Sign up and become a member to collect our Waarna points
and exclusive rewards will be coming to you soon.

Join Us Today


Any purchase
- 1 point for every RM1 spent

Sign Up
- 100 points


100 points = RM1
* No limit on redemption