app-download-header
24 Hours Sale - 95% Off on Everything
20% OFF on Buy 4 any items, Use Code: MERRY
20% OFF on Buy 4 any items
Use Code: MERRY
HR
:
MN
:
SC
ENDS IN

Women

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Asymmetrical Dresses 1 item
  2. Bodycon 6 items
  3. Maxi Dresses 4 items
  4. Nightdresses 2 items
  5. Nightwear Set 1 item
  6. Pencil Dresses 1 item
  7. Sets 3 items
  8. Shift Dresses 1 item
  9. Skater Skirts 1 item
  10. Corset Dresses 1 item
Colour
Colour
  1. Beige 229 items
  2. Black 1138 items
  3. Blue 720 items
  4. Brown 340 items
  5. Gold 21 items
  6. Green 435 items
  7. Grey 242 items
  8. Maroon 24 items
  9. Multi 268 items
  10. Orange 111 items
  11. Pink 458 items
  12. Purple 185 items
  13. Red 362 items
  14. Silver 18 items
  15. White 641 items
  16. Yellow 131 items
Less
Size
Size
  1. 2XL 1 item
  2. 4XL 0 items
  3. FS 8 items
  4. L 45 items
  5. M 53 items
  6. S 42 items
  7. S-9 0 items
  8. XL 21 items
  9. XS 2 items
  10. XXL 1 item
Less
Price
Price
  1. Rs. 1000 - 1200 1 item
  2. Rs. 1200 - 1400 1 item
  3. Rs. 1400 - 1600 4 items
  4. Rs. 1600 - 1800 1 item
  5. Rs. 2000 - 2500 2 items
  6. Rs. 2500 - 3000 5 items
  7. Rs. 3000 - 3500 5 items
  8. Rs. 3500 - 4000 3 items
  9. Rs. 5000 - 5500 1 item
  1. Gold Remove This Item
  2. XL Remove This Item
  3. S-9 Remove This Item
  4. 4XL Remove This Item

SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `at_special_price`.`value` AS `special_price` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=469 INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `search_tmp_6605319319fc71_35840890` AS `search_result` ON e.entity_id = search_result.entity_id LEFT JOIN `catalog_product_entity_decimal` AS `at_special_price` ON (`at_special_price`.`entity_id` = `e`.`entity_id`) AND (`at_special_price`.`attribute_id` = '76') AND (`at_special_price`.`store_id` = 0) WHERE (stock_status_index.stock_status = 1) ORDER BY `special_price` ASC, `e`.`entity_id` DESC LIMIT 24

23 styles found
  1. 60% Off
    -60%
    GOLD HIGH-RISE SKATER SKIRT
  2. 60% Off
    -60%
    Golden Strappy Two Piece Bikini Set
  3. 60% Off
    -60%
    SATIN LACE ROSE GOLD LINGERIE SET
  4. 60% Off
    -60%
    Velour Mock-button Short Nightdress
  5. 60% Off
    -60%
    Double-slit Lace Detail Nightdress
  6. 60% Off
    -60%
    COMPROMETIDA LATTE SPARKLED DRESS
  7. 58% Off
    -58%
    GLITZY STRAPLESS GOLDEN CORSET DRESS
  8. 60% Off
    -60%
    OWN THE PARTY GOLD BODYCON DRESS
  9. 60% Off
    -60%
    OH SO CHARMING GOLD DRESS
  10. 60% Off
    -60%
    Golden Slanted Hem Sequin Maxi Dress
  11. 59% Off
    -59%
    EVENING GOLDEN SEQUIN PENCIL DRESS
  12. 60% Off
    -60%
    GOLDEN TASSEL HEM SLIM MAXI DRESS
  13. 60% Off
    -60%
    STRAPLESS SEQUIN FISHTAIL MAXI DRESS