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 69 items
  • Tops 122 items
Styles
Styles
  1. Asymmetrical Dresses 28 items
  2. Blouses 53 items
  3. Body Suits 80 items
  4. Bodycon 144 items
  5. Crop Tops 122 items
  6. Denim Dresses 1 item
  7. Jumpsuits 29 items
  8. Maxi Dresses 114 items
  9. Maxi Skirts 12 items
  10. Maxi Tops 1 item
  11. Midi Dresses 56 items
  12. Midi Skirts 12 items
  13. Nightdresses 23 items
  14. Nightwear Set 74 items
  15. Off Shoulder Tops 27 items
  16. Off-shoulder And Bandeau Dresses 69 items
  17. Pencil Dresses 24 items
  18. Pencil Skirts 1 item
  19. Playsuits And Rompers 27 items
  20. Sets 289 items
  21. Shift Dresses 15 items
  22. Shirt Dresses 15 items
  23. Shirts 46 items
  24. Short And Mini Skirts 13 items
  25. Skater Dresses 52 items
  26. Skater Skirts 9 items
  27. Straight Jeans 3 items
  28. Swimsuit 81 items
  29. T-shirts 228 items
  30. Tunic Dresses 9 items
  31. Tunic Tops 3 items
  32. Vests And Camis 117 items
  33. Hipster 5 items
  34. Bikini 29 items
  35. Boyshort 56 items
  36. Thong 79 items
  37. Sports 6 items
  38. T-Shirt Bra 1 item
  39. Bralette 2 items
  40. Sports Bra 1 item
  41. Collars 2 items
  42. Wrap Dresses 2 items
  43. Mom Jeans 1 item
  44. Baggy Jeans 1 item
  45. Vests 1 item
  46. Wide Leg Jeans 2 items
  47. Corsets & Tube Tops 87 items
  48. Cold Shoulder Tops 3 items
  49. Corset Dresses 16 items
  50. Dressing Gowns & Robes 1 item
Colour
Colour
  1. Beige 38 items
  2. Black 283 items
  3. Blue 67 items
  4. Brown 66 items
  5. Gold 3 items
  6. Green 63 items
  7. Grey 49 items
  8. Maroon 1 item
  9. Multi 31 items
  10. Orange 12 items
  11. Pink 70 items
  12. Purple 24 items
  13. Red 63 items
  14. Silver 10 items
  15. White 160 items
  16. Yellow 11 items
Less
Size
Size
  1. 1XL 1 item
  2. 2XL 20 items
  3. 3XL 2 items
  4. 4XL 2 items
  5. FS 16 items
  6. L 181 items
  7. M 182 items
  8. S 162 items
  9. XL 62 items
  10. XS 13 items
  11. XXL 2 items
  12. XXS 1 item
  13. XXXL 1 item
Less
Price
Price
  1. Rs. 200 - 400 6 items
  2. Rs. 400 - 600 6 items
  3. Rs. 600 - 800 13 items
  4. Rs. 800 - 1000 36 items
  5. Rs. 1000 - 1200 20 items
  6. Rs. 1200 - 1400 15 items
  7. Rs. 1400 - 1600 14 items
  8. Rs. 1600 - 1800 19 items
  9. Rs. 1800 - 2000 5 items
  10. Rs. 2000 - 2500 26 items
  11. Rs. 2500 - 3000 28 items
  12. Rs. 3000 - 3500 5 items
  13. Rs. 3500 - 4000 2 items
  14. Rs. 4000 - 4500 1 item
  15. Rs. 4500 - 5000 1 item
  1. Off-shoulder And Bandeau Dresses Remove This Item
  2. Crop Tops Remove This Item
  3. Multi Remove This Item
  4. White Remove This Item
  5. L 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_66052ef1c74592_33096720` 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

191 styles found
  1. 59% Off
    -59%
    GAUZE OFF-SHOULDER SLEEVE WHITE DRESS
  2. 60% Off
    -60%
    White Backless Bandeau Dress
  3. 60% Off
    -60%
    White Lace A-line Tube Dress
  4. 60% Off
    -60%
    White Off-shoulder Sheath Dress
  5. 59% Off
    -59%
    OFF-SHOULDER A-LINE LING MAXI DRESS
  6. 60% Off
    -60%
    WHITE LETTER PRINTS COTTON CROP TOP
  7. 58% Off
    -58%
    MULTI-SLIT WHITE BANDEAU DRESS
  8. 60% Off
    -60%
    WHITE OFF-SHOULDER MIDI DRESS
  9. 60% Off
    -60%
    WHITE PRINTED RUCHED DETAIL CROP TOP
  10. 60% Off
    -60%
    Blue Tiered Summer Bandeau Dress
  11. 58% Off
    -58%
    BANDEAU DRESS W/ DETACHABLE SLEEVES
  12. 60% Off
    -60%
    Off-shoulder Ruched White Slim Dress
  13. 60% Off
    -60%
    Black And White Tube Dress With Slit
  14. 60% Off
    -60%
    White Tube Dress With Slit
  15. 58% Off
    -58%
    MULTICOLOUR Y2K FLORAL BANDEAU DRESS