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 28 items
  2. Blouses 30 items
  3. Body Suits 53 items
  4. Bodycon 163 items
  5. Cover Ups 9 items
  6. Crop Tops 73 items
  7. Jumpsuits 32 items
  8. Maxi Dresses 113 items
  9. Maxi Skirts 12 items
  10. Midi Dresses 69 items
  11. Midi Skirts 38 items
  12. Nightdresses 52 items
  13. Nightwear Set 73 items
  14. Off Shoulder Tops 14 items
  15. Off-shoulder And Bandeau Dresses 62 items
  16. Pencil Dresses 31 items
  17. Playsuits And Rompers 16 items
  18. Sets 294 items
  19. Shift Dresses 19 items
  20. Shirt Dresses 3 items
  21. Shirts 12 items
  22. Short And Mini Skirts 11 items
  23. Skater Dresses 38 items
  24. Skater Skirts 7 items
  25. Straight Jeans 3 items
  26. Swimsuit 33 items
  27. T-shirts 120 items
  28. Tunic Dresses 6 items
  29. Tunic Tops 1 item
  30. Vests And Camis 71 items
  31. Hipster 23 items
  32. Bikini 51 items
  33. Boyshort 43 items
  34. Thong 127 items
  35. Cycling Short 2 items
  36. Boyleg 3 items
  37. Full Figure 3 items
  38. Sports 11 items
  39. Racerback 1 item
  40. T-Shirt Bra 9 items
  41. Bralette 3 items
  42. Padded 4 items
  43. Non Padded 7 items
  44. Sports Bra 2 items
  45. Collars 2 items
  46. Wrap Dresses 1 item
  47. Corsets & Tube Tops 98 items
  48. Cold Shoulder Tops 2 items
  49. Sarong 2 items
  50. Corset Dresses 13 items
  51. Dressing Gowns & Robes 5 items
Colour
Colour
  1. Beige 44 items
  2. Black 273 items
  3. Blue 73 items
  4. Brown 86 items
  5. Gold 7 items
  6. Green 65 items
  7. Grey 65 items
  8. Maroon 1 item
  9. Multi 27 items
  10. Orange 12 items
  11. Pink 65 items
  12. Purple 31 items
  13. Red 48 items
  14. Silver 12 items
  15. White 163 items
  16. Yellow 10 items
Less
Size
Size
  1. 2XL 10 items
  2. 3XL 8 items
  3. 4XL 1 item
  4. FS 18 items
  5. L 94 items
  6. M 96 items
  7. S 97 items
  8. XL 48 items
  9. XS 8 items
  10. XXL 7 items
  11. XXXL 6 items
Less
Price
Price
  1. Rs. 200 - 400 1 item
  2. Rs. 600 - 800 5 items
  3. Rs. 800 - 1000 21 items
  4. Rs. 1000 - 1200 16 items
  5. Rs. 1200 - 1400 14 items
  6. Rs. 1400 - 1600 10 items
  7. Rs. 1600 - 1800 13 items
  8. Rs. 1800 - 2000 5 items
  9. Rs. 2000 - 2500 21 items
  10. Rs. 2500 - 3000 21 items
  11. Rs. 3500 - 4000 1 item
  1. Pencil Dresses Remove This Item
  2. Maxi Skirts Remove This Item
  3. Crop Tops Remove This Item
  4. Skater Skirts Remove This Item
  5. Beige Remove This Item
  6. Red Remove This Item
  7. Purple 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_6606bb33583f77_42955844` 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

122 styles found
  1. 58% Off
    -58%
    HIGH-NECK RED CUT-OUT PENCIL DRESS
  2. 58% Off
    -58%
    ROSE-RED HALTER-PLUNGE PENCIL DRESS
  3. 60% Off
    -60%
    Red Fs Halter Neck Crochet Crop Top
  4. 58% Off
    -58%
    ROSE-RED CRISS-CROSS PENCIL DRESS
  5. 60% Off
    -60%
    Purple Ladder-stitch 2pc Upper Set
  6. 95% Off
    -95%
    I MEAN BUSINESS RED DRESS
  7. 60% Off
    -60%
    Purple Y2k Printed Mesh Crop Top
  8. 59% Off
    -59%
    RED DRAWSTRING DETAIL CROP TOP
  9. 60% Off
    -60%
    RUCHED-AND-SO RED PENCIL DRESS
  10. 59% Off
    -59%
    SQUARE NECK RIBBED PINK CROP TOP
  11. 58% Off
    -58%
    LAVENDER SWEETHEART-NECK CROP TOP
  12. 59% Off
    -59%
    OFF-WHITE DRAWSTRING CROP TOP
  13. 60% Off
    -60%
    SIMPLE TASSEL-DETAIL RIBBED CROP TOP
  14. 60% Off
    -60%
    Mesh Splicing Red Fitted Dress
  15. 59% Off
    -59%
    ROSE RED SEAMLESS CROPPED TOP
  16. 58% Off
    -58%
    RED KNOT-TIE PRINTED CROP TOP
  17. 60% Off
    -60%
    APRICOT HOLLOW-OUT CROCHET CROP TOP