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
  • Dresses 33 items
  • Tops 214 items
  • Jeans And Trousers 2 items
    • Jeans 2 items
  • Denim 2 items
    • Jeans 2 items
Styles
Styles
  1. Asymmetrical Dresses 13 items
  2. Blouses 35 items
  3. Body Suits 4 items
  4. Bodycon 42 items
  5. Crop Tops 24 items
  6. Cropped Jeans 2 items
  7. Dungarees 2 items
  8. Flare Jeans 4 items
  9. Jumpsuits 21 items
  10. Maxi Dresses 29 items
  11. Midi Dresses 57 items
  12. Midi Skirts 4 items
  13. Nightwear Set 63 items
  14. Off Shoulder Tops 2 items
  15. Off-shoulder And Bandeau Dresses 19 items
  16. Pencil Dresses 43 items
  17. Playsuits And Rompers 5 items
  18. Sets 84 items
  19. Shift Dresses 13 items
  20. Shirt Dresses 1 item
  21. Shirts 4 items
  22. Short And Mini Skirts 3 items
  23. Skater Dresses 19 items
  24. Skater Skirts 7 items
  25. Skinny Jeans 2 items
  26. Straight Jeans 31 items
  27. Swimsuit 25 items
  28. T-shirts 208 items
  29. Tunic Dresses 3 items
  30. Tunic Tops 1 item
  31. Vests And Camis 16 items
  32. Hipster 26 items
  33. Bikini 6 items
  34. Thong 18 items
  35. Sports 9 items
  36. Bralette 5 items
  37. Wrap Dresses 8 items
  38. Baggy Jeans 1 item
  39. Wide Leg Jeans 11 items
  40. Corsets & Tube Tops 16 items
  41. Cold Shoulder Tops 3 items
Colour
Colour
  1. Beige 11 items
  2. Black 71 items
  3. Blue 22 items
  4. Brown 16 items
  5. Green 18 items
  6. Grey 14 items
  7. Multi 3 items
  8. Orange 2 items
  9. Pink 15 items
  10. Purple 8 items
  11. Red 10 items
  12. White 53 items
  13. Yellow 6 items
Less
Size
Size
  1. 12 0 items
  2. 1XL 14 items
  3. 25 1 item
  4. 26 1 item
  5. 27 2 items
  6. 29 2 items
  7. 2XL 211 items
  8. 30 1 item
  9. 31 2 items
  10. 3XL 81 items
  11. 4XL 20 items
  12. 5XL 4 items
  13. FS 210 items
  14. L 1582 items
  15. M 1638 items
  16. S 1392 items
  17. XL 719 items
  18. XS 67 items
  19. XXL 156 items
  20. XXXL 4 items
Less
Price
Price
  1. Rs. 0 - 200 1 item
  2. Rs. 200 - 400 5 items
  3. Rs. 400 - 600 7 items
  4. Rs. 600 - 800 17 items
  5. Rs. 800 - 1000 23 items
  6. Rs. 1000 - 1200 7 items
  7. Rs. 1200 - 1400 47 items
  8. Rs. 1400 - 1600 16 items
  9. Rs. 1600 - 1800 29 items
  10. Rs. 1800 - 2000 21 items
  11. Rs. 2000 - 2500 50 items
  12. Rs. 2500 - 3000 17 items
  13. Rs. 3000 - 3500 9 items
  14. Rs. 3500 - 4000 1 item
  15. Rs. 4000 - 4500 3 items
  16. Rs. 4500 - 5000 2 items
  1. Skinny Jeans Remove This Item
  2. T-shirts Remove This Item
  3. Maxi Dresses Remove This Item
  4. 12 Remove This Item
  5. 3XL Remove This Item
  6. XXL Remove This Item
  7. 27 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_66055d0dc7a361_62181255` 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` DESC, `e`.`entity_id` DESC LIMIT 24

249 styles found
  1. 60% Off
    -60%
    Halter Plunge White Long Sequin Dress
  2. 60% Off
    -60%
    Apricot Thigh Slit Long Sequin Dress
  3. 60% Off
    -60%
    Green V-neck A-line Long Dress
  4. 59% Off
    -59%
    MULTILAYERED BLACK OMBRE MAXI DRESS
  5. 60% Off
    -60%
    BIG BOW-DECOR PURPLE MAXI DRESS
  6. 60% Off
    -60%
    BIG BOW-DECOR GREEN MAXI DRESS
  7. 60% Off
    -60%
    PINK BIG BOW-DECOR MAXI DRESS
  8. 60% Off
    -60%
    PURPLE PRINTED CREW NECK T-SHIRT
  9. 60% Off
    -60%
    SIMPLISTIC EMBROIDERED PINK T-SHIRT
  10. 58% Off
    -58%
    GREEN V-NECK SLIT MAXI DRESS
  11. 58% Off
    -58%
    PURPLE V-NECK SLIT MAXI DRESS
  12. 58% Off
    -58%
    RED V-NECK SLIT MAXI DRESS
  13. 58% Off
    -58%
    BLACK V-NECK SLIT MAXI DRESS
  14. 58% Off
    -58%
    CRIMSON V-NECK SLIT MAXI DRESS
  15. 60% Off
    -60%
    Black Round Neck Graphic Tee