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 16 items
  2. Blouses 19 items
  3. Body Suits 14 items
  4. Bodycon 84 items
  5. Crop Tops 35 items
  6. Jumpsuits 16 items
  7. Maxi Dresses 58 items
  8. Maxi Skirts 4 items
  9. Midi Dresses 22 items
  10. Midi Skirts 4 items
  11. Nightdresses 15 items
  12. Nightwear Set 52 items
  13. Off Shoulder Tops 7 items
  14. Off-shoulder And Bandeau Dresses 36 items
  15. Pencil Dresses 16 items
  16. Pencil Skirts 3 items
  17. Playsuits And Rompers 10 items
  18. Sets 164 items
  19. Shift Dresses 12 items
  20. Shirt Dresses 2 items
  21. Shirts 7 items
  22. Short And Mini Skirts 7 items
  23. Skater Dresses 27 items
  24. Skater Skirts 3 items
  25. Straight Jeans 5 items
  26. Swimsuit 17 items
  27. T-shirts 78 items
  28. Tunic Dresses 5 items
  29. Vests And Camis 38 items
  30. Hipster 6 items
  31. Bikini 14 items
  32. Boyshort 14 items
  33. Thong 60 items
  34. Sports 8 items
  35. T-Shirt Bra 2 items
  36. Bralette 2 items
  37. Sports Bra 3 items
  38. Wrap Dresses 1 item
  39. Baggy Jeans 1 item
  40. Wide Leg Jeans 2 items
  41. Corsets & Tube Tops 56 items
  42. Cold Shoulder Tops 1 item
  43. Corset Dresses 8 items
Colour
Colour
  1. Beige 506 items
  2. Black 2925 items
  3. Blue 1279 items
  4. Brown 819 items
  5. Gold 47 items
  6. Green 838 items
  7. Grey 577 items
  8. Maroon 29 items
  9. Multi 553 items
  10. Orange 217 items
  11. Pink 991 items
  12. Purple 354 items
  13. Red 798 items
  14. Silver 91 items
  15. White 1547 items
  16. Yellow 231 items
Less
Size
Size
  1. 1XL 16 items
  2. 26 1 item
  3. 27 1 item
  4. 28 1 item
  5. 29 1 item
  6. 2XL 106 items
  7. 30 1 item
  8. 32C 3 items
  9. 36B 1 item
  10. 36C 2 items
  11. 38B 3 items
  12. 38C 2 items
  13. 38D 1 item
  14. 3XL 52 items
  15. 40B 5 items
  16. 40C 4 items
  17. 42B 6 items
  18. 42C 6 items
  19. 44B 2 items
  20. 4XL 15 items
  21. 5XL 2 items
  22. 6XL 1 item
  23. 70A 1 item
  24. 70ABC-S 2 items
  25. 70B 2 items
  26. 70C 2 items
  27. 70D 1 item
  28. 70E 1 item
  29. 75A 1 item
  30. 75ABC-M 1 item
  31. 75B 2 items
  32. 75C 2 items
  33. 75D 2 items
  34. 75E 1 item
  35. 80A 1 item
  36. 80ABC-L 2 items
  37. 80B 2 items
  38. 80C 2 items
  39. 80D 2 items
  40. 80E 1 item
  41. 85B 2 items
  42. 85C 2 items
  43. 85D 2 items
  44. 85E 1 item
  45. 90C 1 item
  46. 90D 1 item
  47. 95C 1 item
  48. 95D 1 item
  49. FS 179 items
  50. L 968 items
  51. M 980 items
  52. S 859 items
  53. XL 468 items
  54. XS 74 items
  55. XXL 49 items
  56. XXXL 13 items
  57. 0XL 2 items
Less
Price
Price
  1. Rs. 0 - 200 21 items
  2. Rs. 200 - 400 48 items
  3. Rs. 400 - 600 44 items
  4. Rs. 600 - 800 22 items
  5. Rs. 800 - 1000 42 items
  6. Rs. 1000 - 1200 73 items
  7. Rs. 1200 - 1400 112 items
  8. Rs. 1400 - 1600 126 items
  9. Rs. 1600 - 1800 110 items
  10. Rs. 1800 - 2000 87 items
  11. Rs. 2000 - 2500 157 items
  12. Rs. 2500 - 3000 155 items
  13. Rs. 3000 - 3500 70 items
  14. Rs. 3500 - 4000 20 items
  15. Rs. 4000 - 4500 9 items
  16. Rs. 4500 - 5000 3 items
  17. Rs. 5000 - 5500 1 item
Brand
Brand
  1. LULUANDSKY 1062 items
  2. KOSHA YOGA 3 items
  1. Pink Remove This Item
  2. XL Remove This Item
  3. L Remove This Item

SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `e`.`name`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`small_image`, `e`.`thumbnail`, `e`.`color`, `e`.`color_value`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`url_key`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`tax_class_id`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`size`, `e`.`size_value`, `e`.`eancode`, `e`.`wallet_credit_based_on`, `e`.`wallet_credit_based_on_value`, `e`.`wallet_cash_back`, `e`.`hsn_code`, `e`.`dateofupload`, `e`.`heel_size`, `e`.`heel_size_value`, `e`.`product_color`, `e`.`price_filter`, `e`.`price_filter_value`, `e`.`styles`, `e`.`app_special_price`, `e`.`swatch_image`, `e`.`disable_cod`, `e`.`product_tag`, `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_flat_1` 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_65f913d78bb6f4_02211809` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `cat_index_position` ASC, `cat_index`.`position` ASC, `e`.`entity_id` DESC LIMIT 24

1061 styles found
  1. 60% Off
    -60%
    PINK SEAMLESS FISHTAIL MAXI DRESS
  2. 60% Off
    -60%
    PINK LACY IRREGULAR STRAPLESS CORSET
  3. 95% Off
    -95%
    SLEEP TIME IS PINK SLEEPWEAR
  4. 60% Off
    -60%
    Pink Criss-cross Back Mermaid Dress
  5. 60% Off
    -60%
    LACY HOOK-&-EYE CLOSURE PINK CORSET
  6. 58% Off
    -58%
    PINK IRREGULAR SUSPENDER CORSET
  7. 60% Off
    -60%
    LACY PINK DETACHABLE STRAP BRA
  8. 60% Off
    -60%
    FISHTAIL BACKLESS PINK MAXI DRESS
  9. 58% Off
    -58%
    TOUCHING UP PINK BRALETTE
  10. 58% Off
    -58%
    PINK EMBROIDERED MESH CORSET TOP
  11. 60% Off
    -60%
    PINK HANGING TASSEL CROP TOP
  12. 60% Off
    -60%
    Pink Zip-up Back Lace Corset
  13. 60% Off
    -60%
    Slim Fit Pink Long Sleeves T-shirt
  14. 60% Off
    -60%
    CONTRAST STRAP PINK ZIPPER CORSET
  15. 60% Off
    -60%
    PINK FLORAL-EMBROIDERY CORSET
  16. 60% Off
    -60%
    Pink Cami & Hot Pants Set
  17. 60% Off
    -60%
    Pink Scoop Neck Sleeveless Cami
  18. 60% Off
    -60%
    PINK U-NECK FINGER SLEEVED CORSET
  19. 60% Off
    -60%
    TWISTED PINK PLEAT-DETAIL MAXI DRESS
  20. 60% Off
    -60%
    Pink Floral Pattern Y2k Top