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 1 item
  2. Blouses 6 items
  3. Body Suits 14 items
  4. Bodycon 37 items
  5. Cover Ups 2 items
  6. Crop Tops 45 items
  7. Cropped Jeans 1 item
  8. Flare Jeans 9 items
  9. Jumpsuits 21 items
  10. Maxi Dresses 16 items
  11. Maxi Skirts 8 items
  12. Midi Dresses 19 items
  13. Midi Skirts 17 items
  14. Nightdresses 4 items
  15. Nightwear Set 12 items
  16. Off Shoulder Tops 8 items
  17. Off-shoulder And Bandeau Dresses 9 items
  18. Pencil Dresses 1 item
  19. Pencil Skirts 2 items
  20. Playsuits And Rompers 13 items
  21. Ripped Jeans 0 items
  22. Sets 74 items
  23. Shift Dresses 1 item
  24. Shirt Dresses 1 item
  25. Shirts 3 items
  26. Short And Mini Skirts 10 items
  27. Skater Dresses 4 items
  28. Skater Skirts 12 items
  29. Skinny Jeans 1 item
  30. Straight Jeans 23 items
  31. Swimsuit 7 items
  32. T-shirts 114 items
  33. Tunic Tops 0 items
  34. Vests And Camis 37 items
  35. Hipster 1 item
  36. Bikini 5 items
  37. Boyshort 1 item
  38. Thong 25 items
  39. Cycling Short 1 item
  40. Sports 2 items
  41. T-Shirt Bra 1 item
  42. Non Padded 1 item
  43. Sports Bra 1 item
  44. Collars 2 items
  45. Baggy Jeans 2 items
  46. Wide Leg Jeans 6 items
  47. Corsets & Tube Tops 6 items
  48. Cold Shoulder Tops 2 items
  49. Corset Dresses 1 item
  50. Dressing Gowns & Robes 1 item
Colour
Colour
  1. Beige 24 items
  2. Black 85 items
  3. Blue 30 items
  4. Brown 20 items
  5. Gold 7 items
  6. Green 32 items
  7. Grey 15 items
  8. Maroon 7 items
  9. Multi 32 items
  10. Orange 9 items
  11. Pink 34 items
  12. Purple 35 items
  13. Red 20 items
  14. White 73 items
  15. Yellow 8 items
Less
Size
Size
  1. FS 1 item
  2. L 13 items
  3. M 14 items
  4. S 10 items
  5. XL 3 items
  6. XXL 1 item
Less
Price
Price
  1. Rs. 1000 - 1200 1 item
  2. Rs. 1200 - 1400 3 items
  3. Rs. 1400 - 1600 2 items
  4. Rs. 1600 - 1800 2 items
  5. Rs. 1800 - 2000 4 items
  6. Rs. 2500 - 3000 2 items
  1. Nightdresses Remove This Item
  2. Shirts Remove This Item
  3. Ripped Jeans Remove This Item
  4. Tunic Tops Remove This Item
  5. Off Shoulder Tops Remove This Item
  6. Grey 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_66054aeed8aa83_67143722` 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. 58% Off
    -58%
    HALTERNECK A-LINE GREY NIGHTDRESS
  2. 58% Off
    -58%
    SATIN SLIP GREY LACE-UP NIGHTDRESS
  3. 60% Off
    -60%
    CRINKLE GREY COLLARED LOOSE SHIRT
  4. 60% Off
    -60%
    Grey Blue Short Cotton Shirt
  5. 60% Off
    -60%
    OFF-SHOULDER GREY KNITTED SLIM TOP
  6. 60% Off
    -60%
    Off-the-shoulder Grey Crop Top
  7. 60% Off
    -60%
    Polka Dot Collared Grey Shirt