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 204 items
  • Jeans And Trousers 1 item
    • Jeans 1 item
Styles
Styles
  1. Asymmetrical Dresses 46 items
  2. Blouses 31 items
  3. Body Suits 172 items
  4. Bodycon 347 items
  5. Cover Ups 5 items
  6. Crop Tops 151 items
  7. Denim Dresses 1 item
  8. Denim Tops 3 items
  9. Dungarees 1 item
  10. Flare Jeans 19 items
  11. Jumpsuits 95 items
  12. Maxi Dresses 182 items
  13. Maxi Skirts 22 items
  14. Midi Dresses 72 items
  15. Midi Skirts 12 items
  16. Nightdresses 2 items
  17. Nightwear Set 13 items
  18. Off Shoulder Tops 27 items
  19. Off-shoulder And Bandeau Dresses 114 items
  20. Pencil Dresses 38 items
  21. Pencil Skirts 5 items
  22. Playsuits And Rompers 56 items
  23. Ripped Jeans 1 item
  24. Sets 325 items
  25. Shift Dresses 18 items
  26. Shirt Dresses 5 items
  27. Shirts 16 items
  28. Short And Mini Skirts 37 items
  29. Skater Dresses 57 items
  30. Skater Skirts 11 items
  31. Skinny Jeans 1 item
  32. Straight Jeans 25 items
  33. Swimsuit 17 items
  34. T-shirts 213 items
  35. Tunic Dresses 5 items
  36. Vests And Camis 143 items
  37. Hipster 1 item
  38. Bikini 8 items
  39. Boyshort 10 items
  40. Thong 19 items
  41. Cycling Short 1 item
  42. Sports 7 items
  43. T-Shirt Bra 2 items
  44. Bralette 8 items
  45. Sports Bra 3 items
  46. Wrap Dresses 5 items
  47. Mom Jeans 1 item
  48. Baggy Jeans 2 items
  49. Wide Leg Jeans 13 items
  50. Thongbody 1 item
  51. Corsets & Tube Tops 127 items
  52. Cold Shoulder Tops 7 items
  53. Corset Dresses 34 items
Colour
Colour
  1. Beige 30 items
  2. Black 205 items
  3. Blue 90 items
  4. Brown 43 items
  5. Gold 3 items
  6. Green 76 items
  7. Grey 21 items
  8. Maroon 2 items
  9. Multi 42 items
  10. Orange 13 items
  11. Pink 63 items
  12. Purple 24 items
  13. Red 81 items
  14. Silver 7 items
  15. White 96 items
  16. Yellow 18 items
Less
Size
Size
  1. 1XL 2 items
  2. 2XL 13 items
  3. 3XL 11 items
  4. 4XL 3 items
  5. 5XL 3 items
  6. FS 12 items
  7. L 190 items
  8. M 186 items
  9. S 188 items
  10. XL 75 items
  11. XS 9 items
  12. XXL 8 items
  13. XXS 1 item
  14. XXXL 2 items
Less
Price
Price
  1. Rs. 200 - 400 12 items
  2. Rs. 400 - 600 1 item
  3. Rs. 800 - 1000 2 items
  4. Rs. 1000 - 1200 8 items
  5. Rs. 1200 - 1400 13 items
  6. Rs. 1400 - 1600 32 items
  7. Rs. 1600 - 1800 29 items
  8. Rs. 1800 - 2000 18 items
  9. Rs. 2000 - 2500 52 items
  10. Rs. 2500 - 3000 36 items
  11. Rs. 3000 - 3500 6 items
  12. Rs. 3500 - 4000 4 items
  13. Rs. 4000 - 4500 1 item
  1. Shift Dresses Remove This Item
  2. Off-shoulder And Bandeau Dresses Remove This Item
  3. Skinny Jeans Remove This Item
  4. Midi Dresses Remove This Item
  5. Black Remove This Item
  6. S 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` 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_6606ab29b24227_72780019` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `cat_index`.`position` ASC, `e`.`entity_id` DESC LIMIT 24

204 styles found
  1. 58% Off
    -58%
    HONEY GIRL BLACK MIDI DRESS
  2. 80% Off
    -80%
    LIKE THE BLACK NIGHT DRESS
  3. 60% Off
    -60%
    Black Bow Decor A-line Bandeau Dress
  4. 60% Off
    -60%
    BLACK FISHTAIL MIDI HALTER-TIE DRESS
  5. 60% Off
    -60%
    Black Mid Length Fishtail Dress
  6. 60% Off
    -60%
    Black Lace Dress With Tie-straps
  7. 60% Off
    -60%
    Strapless Cut-out Black Sequin Dress
  8. 60% Off
    -60%
    Black Embellished Strappy Midi Dress
  9. 58% Off
    -58%
    BLACK CUT-OUT MAXI BANDEAU DRESS
  10. 58% Off
    -58%
    BLACK SHIRRED SLIP MIDI DRESS
  11. 58% Off
    -58%
    BLACK VELOUR SLIT MIDI DRESS
  12. 58% Off
    -58%
    TRANSLUCENT MAXI BANDEAU LACY DRESS
  13. 60% Off
    -60%
    BLACK PRINTED SLIT BANDEAU DRESS
  14. 58% Off
    -58%
    BANDEAU MIDI FITTED PU BLACK DRESS
  15. 58% Off
    -58%
    RETRO FLARED BLACK MIDI DRESS
  16. 58% Off
    -58%
    BLACK IRREGULAR SLIM BANDEAU DRESS
  17. 58% Off
    -58%
    BLACK SLIT SUSPENDER MIDI DRESS
  18. 58% Off
    -58%
    BLACK MIDI BANDEAU DRESS