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
  • Tops 11 items
  • Sleepwear And Innerwear 4 items
    • Sleepwear 4 items
Styles
Styles
  1. Asymmetrical Dresses 5 items
  2. Blouses 10 items
  3. Body Suits 17 items
  4. Bodycon 59 items
  5. Cover Ups 4 items
  6. Crop Tops 51 items
  7. Cropped Jeans 1 item
  8. Flare Jeans 9 items
  9. Jumpsuits 23 items
  10. Maxi Dresses 37 items
  11. Maxi Skirts 10 items
  12. Midi Dresses 24 items
  13. Midi Skirts 18 items
  14. Nightdresses 4 items
  15. Nightwear Set 14 items
  16. Off Shoulder Tops 9 items
  17. Off-shoulder And Bandeau Dresses 15 items
  18. Pencil Dresses 4 items
  19. Pencil Skirts 2 items
  20. Playsuits And Rompers 13 items
  21. Ripped Jeans 0 items
  22. Sets 128 items
  23. Shift Dresses 3 items
  24. Shirt Dresses 2 items
  25. Shirts 10 items
  26. Short And Mini Skirts 12 items
  27. Skater Dresses 7 items
  28. Skater Skirts 12 items
  29. Skinny Jeans 1 item
  30. Straight Jeans 23 items
  31. Swimsuit 13 items
  32. T-shirts 119 items
  33. Tunic Dresses 1 item
  34. Tunic Tops 1 item
  35. Vests And Camis 43 items
  36. Hipster 1 item
  37. Bikini 6 items
  38. Boyshort 4 items
  39. Thong 28 items
  40. Cycling Short 1 item
  41. Sports 6 items
  42. T-Shirt Bra 2 items
  43. Non Padded 2 items
  44. Sports Bra 3 items
  45. Collars 2 items
  46. Wrap Dresses 2 items
  47. Baggy Jeans 2 items
  48. Wide Leg Jeans 6 items
  49. Corsets & Tube Tops 17 items
  50. Cold Shoulder Tops 3 items
  51. Sarong 1 item
  52. Corset Dresses 3 items
  53. Dressing Gowns & Robes 1 item
Colour
Colour
  1. Beige 19 items
  2. Black 56 items
  3. Blue 25 items
  4. Brown 11 items
  5. Gold 7 items
  6. Green 26 items
  7. Grey 7 items
  8. Maroon 7 items
  9. Multi 27 items
  10. Orange 8 items
  11. Pink 24 items
  12. Purple 31 items
  13. Red 15 items
  14. White 49 items
  15. Yellow 7 items
Less
Size
Size
  1. 2XL 1 item
  2. FS 1 item
  3. L 12 items
  4. M 14 items
  5. S 9 items
  6. XL 8 items
  7. XXL 2 items
Less
Price
Price
  1. Rs. 1200 - 1400 4 items
  2. Rs. 1400 - 1600 3 items
  3. Rs. 1600 - 1800 4 items
  4. Rs. 1800 - 2000 1 item
  5. Rs. 2500 - 3000 1 item
  1. Nightdresses Remove This Item
  2. Shirts Remove This Item
  3. Ripped Jeans Remove This Item
  4. Tunic Tops Remove This Item
  5. Grey Remove This Item
  6. Orange 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_6606ce0c251db5_07591593` 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

15 styles found
  1. 80% Off
    -80%
    SOMETHING EXTRA ORANGE TOP
  2. 60% Off
    -60%
    CRINKLE ORANGE COLLARED LOOSE SHIRT
  3. 58% Off
    -58%
    HALTERNECK A-LINE GREY NIGHTDRESS
  4. 58% Off
    -58%
    SATIN SLIP GREY LACE-UP NIGHTDRESS
  5. 60% Off
    -60%
    ORANGE LANTERN-SLEEVE PRINTED SHIRT
  6. 60% Off
    -60%
    CASUAL LOOSE FIT ORANGE SHIRT
  7. 60% Off
    -60%
    CRINKLE GREY COLLARED LOOSE SHIRT
  8. 60% Off
    -60%
    Grey Blue Short Cotton Shirt
  9. 60% Off
    -60%
    Orange Boxy Fit Crop Shirt
  10. 60% Off
    -60%
    Polka Dot Collared Grey Shirt