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 2 items
  2. Blouses 7 items
  3. Body Suits 23 items
  4. Bodycon 32 items
  5. Crop Tops 5 items
  6. Denim Dresses 1 item
  7. Flare Jeans 10 items
  8. Jumpsuits 2 items
  9. Maxi Dresses 8 items
  10. Midi Dresses 6 items
  11. Midi Skirts 1 item
  12. Nightwear Set 4 items
  13. Off-shoulder And Bandeau Dresses 6 items
  14. Pencil Dresses 2 items
  15. Pencil Skirts 1 item
  16. Playsuits And Rompers 1 item
  17. Ripped Jeans 1 item
  18. Sets 19 items
  19. Shirts 1 item
  20. Short And Mini Skirts 6 items
  21. Skater Dresses 5 items
  22. Skater Skirts 4 items
  23. Skinny Jeans 1 item
  24. Straight Jeans 6 items
  25. Swimsuit 5 items
  26. T-shirts 13 items
  27. Vests And Camis 11 items
  28. Thong 1 item
  29. Sports 1 item
  30. Bralette 4 items
  31. Wrap Dresses 2 items
  32. Wide Leg Jeans 12 items
  33. Corsets & Tube Tops 24 items
  34. Corset Dresses 5 items
Colour
Colour
  1. Beige 47 items
  2. Black 247 items
  3. Blue 193 items
  4. Brown 65 items
  5. Gold 2 items
  6. Green 68 items
  7. Grey 45 items
  8. Maroon 1 item
  9. Multi 37 items
  10. Orange 16 items
  11. Pink 88 items
  12. Purple 33 items
  13. Red 67 items
  14. Silver 10 items
  15. White 127 items
  16. Yellow 12 items
Less
Size
Size
  1. 1XL 39 items
  2. 25 1 item
  3. 26 1 item
  4. 27 1 item
  5. 28 2 items
  6. 2XL 262 items
  7. 36E 1 item
  8. 3XL 112 items
  9. 40B 1 item
  10. 40C 1 item
  11. 42B 2 items
  12. 42C 2 items
  13. 44B 1 item
  14. 4XL 42 items
  15. 5XL 12 items
  16. 70A 7 items
  17. 70ABC-S 4 items
  18. 70B 11 items
  19. 70C 11 items
  20. 70D 6 items
  21. 70E 4 items
  22. 75A 7 items
  23. 75ABC-M 5 items
  24. 75B 13 items
  25. 75C 14 items
  26. 75D 11 items
  27. 75E 4 items
  28. 80A 6 items
  29. 80ABC-L 5 items
  30. 80B 14 items
  31. 80C 14 items
  32. 80D 11 items
  33. 80E 4 items
  34. 85B 14 items
  35. 85C 14 items
  36. 85D 11 items
  37. 85E 4 items
  38. 90C 5 items
  39. 90D 5 items
  40. 95C 5 items
  41. 95D 5 items
  42. FS 326 items
  43. L 2903 items
  44. M 2913 items
  45. PLUS 1 item
  46. S 2658 items
  47. S31 0 items
  48. XL 1118 items
  49. XS 206 items
  50. XXL 119 items
  51. XXS 1 item
  52. XXXL 12 items
  53. 0XL 5 items
Less
Price
Price
  1. Rs. 0 - 200 1 item
  2. Rs. 200 - 400 1 item
  3. Rs. 400 - 600 1 item
  4. Rs. 600 - 800 5 items
  5. Rs. 800 - 1000 15 items
  6. Rs. 1000 - 1200 25 items
  7. Rs. 1200 - 1400 29 items
  8. Rs. 1400 - 1600 21 items
  9. Rs. 1600 - 1800 27 items
  10. Rs. 1800 - 2000 16 items
  11. Rs. 2000 - 2500 43 items
  12. Rs. 2500 - 3000 42 items
  13. Rs. 3000 - 3500 33 items
  14. Rs. 3500 - 4000 7 items
  15. Rs. 4000 - 4500 7 items
  16. Rs. 4500 - 5000 3 items
Brand
Brand
  1. LULUANDSKY 266 items
  2. KOSHA YOGA 4 items
  1. Black Remove This Item
  2. XS Remove This Item
  3. S31 Remove This Item
  4. 4XL 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_6605387b1872a2_88597666` 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` ASC, `e`.`entity_id` DESC LIMIT 24

270 styles found
  1. 60% Off
    -60%
    Side Zipper Black Skater Skirt
  2. 58% Off
    -58%
    BLACK FANCY-HEM BONING TUBE TOP
  3. 58% Off
    -58%
    BLACK SOLID LACY FITTED BRALETTE
  4. 58% Off
    -58%
    FANCY STRAP BLACK LACY BRALETTE
  5. 60% Off
    -60%
    Black Printed Drop-shoulder Tee
  6. 60% Off
    -60%
    BLACK SLIM SINGLE-STRAP TUBE TOP
  7. 60% Off
    -60%
    DIAMOND-SHAPED BLACK SLIM CORSET
  8. 60% Off
    -60%
    Sheer Lace Black Corset
  9. 60% Off
    -60%
    Deep V-neck Black Lace Crop Top
  10. 60% Off
    -60%
    Black Lace Cropped Corset Top
  11. 58% Off
    -58%
    BLACK UNDERWIRED LACY CORSET
  12. 58% Off
    -58%
    POLKA DOT BONING BLACK CORSET
  13. 60% Off
    -60%
    BLACK TURTLE NECK SLIM SHORT VEST