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 66 items
  2. Blouses 85 items
  3. Body Suits 195 items
  4. Bodycon 464 items
  5. Cover Ups 17 items
  6. Crop Tops 247 items
  7. Denim Dresses 1 item
  8. Denim Tops 3 items
  9. Dungarees 1 item
  10. Flare Jeans 20 items
  11. Jumpsuits 116 items
  12. Maxi Dresses 270 items
  13. Maxi Skirts 36 items
  14. Midi Dresses 125 items
  15. Midi Skirts 64 items
  16. Nightdresses 81 items
  17. Nightwear Set 130 items
  18. Off Shoulder Tops 41 items
  19. Off-shoulder And Bandeau Dresses 160 items
  20. Pencil Dresses 63 items
  21. Pencil Skirts 9 items
  22. Playsuits And Rompers 72 items
  23. Ripped Jeans 1 item
  24. Sets 635 items
  25. Shift Dresses 37 items
  26. Shirt Dresses 10 items
  27. Shirts 28 items
  28. Short And Mini Skirts 50 items
  29. Skater Dresses 92 items
  30. Skater Skirts 23 items
  31. Skinny Jeans 1 item
  32. Straight Jeans 31 items
  33. Swimsuit 105 items
  34. T-shirts 453 items
  35. Tunic Dresses 9 items
  36. Tunic Tops 1 item
  37. Vests And Camis 226 items
  38. Hipster 24 items
  39. Bikini 56 items
  40. Boyshort 38 items
  41. Thong 235 items
  42. Cycling Short 2 items
  43. Boyleg 4 items
  44. Full Figure 2 items
  45. Sports 24 items
  46. Racerback 1 item
  47. T-Shirt Bra 18 items
  48. Bralette 12 items
  49. Padded 4 items
  50. Non Padded 11 items
  51. Sports Bra 7 items
  52. Collars 13 items
  53. Wrap Dresses 10 items
  54. Mom Jeans 1 item
  55. Baggy Jeans 2 items
  56. Wide Leg Jeans 16 items
  57. Thongbody 3 items
  58. Corsets & Tube Tops 208 items
  59. Cold Shoulder Tops 10 items
  60. Sarong 6 items
  61. Corset Dresses 46 items
  62. Dressing Gowns & Robes 6 items
Colour
Colour
  1. Beige 122 items
  2. Black 490 items
  3. Blue 238 items
  4. Brown 160 items
  5. Gold 4 items
  6. Green 203 items
  7. Grey 86 items
  8. Maroon 2 items
  9. Multi 133 items
  10. Orange 60 items
  11. Pink 219 items
  12. Purple 63 items
  13. Red 165 items
  14. Silver 15 items
  15. White 268 items
  16. Yellow 62 items
Less
Size
Size
  1. 1XL 9 items
  2. 2XL 63 items
  3. 3XL 21 items
  4. 4XL 10 items
  5. 5XL 3 items
  6. 70A 5 items
  7. 70ABC-S 5 items
  8. 70B 5 items
  9. 70C 4 items
  10. 70D 4 items
  11. 70E 2 items
  12. 75A 5 items
  13. 75ABC-M 6 items
  14. 75B 5 items
  15. 75C 5 items
  16. 75D 4 items
  17. 75E 2 items
  18. 80A 4 items
  19. 80ABC-L 7 items
  20. 80B 5 items
  21. 80C 5 items
  22. 80D 4 items
  23. 80E 2 items
  24. 85B 5 items
  25. 85C 5 items
  26. 85D 4 items
  27. 85E 2 items
  28. 90C 3 items
  29. 90D 3 items
  30. 95C 3 items
  31. 95D 3 items
  32. FS 53 items
  33. L 652 items
  34. M 650 items
  35. S 607 items
  36. XL 285 items
  37. XS 22 items
  38. XXL 22 items
  39. XXXL 2 items
  40. 0XL 2 items
Less
Price
Price
  1. Rs. 200 - 400 20 items
  2. Rs. 400 - 600 4 items
  3. Rs. 600 - 800 4 items
  4. Rs. 800 - 1000 4 items
  5. Rs. 1000 - 1200 17 items
  6. Rs. 1200 - 1400 65 items
  7. Rs. 1400 - 1600 94 items
  8. Rs. 1600 - 1800 106 items
  9. Rs. 1800 - 2000 80 items
  10. Rs. 2000 - 2500 162 items
  11. Rs. 2500 - 3000 143 items
  12. Rs. 3000 - 3500 61 items
  13. Rs. 3500 - 4000 17 items
  14. Rs. 4000 - 4500 7 items
  15. Rs. 4500 - 5000 7 items
  16. Rs. 5000 - 5500 1 item
  17. Rs. 6000 - 6500 1 item
  1. Tunic Dresses Remove This Item
  2. Skater Dresses Remove This Item
  3. Maxi Skirts Remove This Item
  4. Sets Remove This Item
  5. Purple Remove This Item
  6. Pink Remove This Item
  7. Black 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_6606b9ad6b23a6_39522386` 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

770 styles found
  1. 60% Off
    -60%
    Printed Two Piece Pink Leisure Set
  2. 60% Off
    -60%
    BLACK PUFFER JACKET WITH TIE-UP SKIRT
  3. 60% Off
    -60%
    Black Knitted Pullover & Pants Set
  4. 60% Off
    -60%
    PINK VERSATILE THREE PIECE CO-ORD SET
  5. 60% Off
    -60%
    Tiered V-neck Full Sleeved Pink Dress
  6. 60% Off
    -60%
    Black Lace-up Strap Skirt Suit Set
  7. 60% Off
    -60%
    Black Cold-shoulder Short Dress
  8. 60% Off
    -60%
    Pink Sequin Plus Size Skater Dress
  9. 60% Off
    -60%
    RETRO KNITTED BLACK 2PC CO-ORD SET
  10. 60% Off
    -60%
    FLORAL PINK KNITTED LOOSE CO-ORD SET
  11. 60% Off
    -60%
    Purple Three Piece Casual Co-ord Set
  12. 60% Off
    -60%
    PINK RIB-KNIT JACKET WITH PANTS
  13. 60% Off
    -60%
    BLACK CORSETRY HOODIE & JOGGER SET