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 19 items
  2. Blouses 27 items
  3. Body Suits 28 items
  4. Bodycon 127 items
  5. Crop Tops 73 items
  6. Cropped Jeans 1 item
  7. Flare Jeans 9 items
  8. Jumpsuits 43 items
  9. Maxi Dresses 84 items
  10. Maxi Skirts 17 items
  11. Midi Dresses 59 items
  12. Midi Skirts 10 items
  13. Nightdresses 17 items
  14. Nightwear Set 26 items
  15. Off Shoulder Tops 12 items
  16. Off-shoulder And Bandeau Dresses 37 items
  17. Pencil Dresses 17 items
  18. Pencil Skirts 1 item
  19. Playsuits And Rompers 19 items
  20. Ripped Jeans 1 item
  21. Sets 237 items
  22. Shift Dresses 21 items
  23. Shirt Dresses 2 items
  24. Shirts 13 items
  25. Short And Mini Skirts 15 items
  26. Skater Dresses 17 items
  27. Skater Skirts 6 items
  28. Skinny Jeans 1 item
  29. Straight Jeans 26 items
  30. Swimsuit 33 items
  31. T-shirts 143 items
  32. Tunic Dresses 3 items
  33. Vests And Camis 61 items
  34. Hipster 3 items
  35. Bikini 10 items
  36. Boyshort 7 items
  37. Thong 30 items
  38. Cycling Short 1 item
  39. Sports 10 items
  40. Bralette 1 item
  41. Sports Bra 4 items
  42. Wrap Dresses 2 items
  43. Mom Jeans 1 item
  44. Baggy Jeans 2 items
  45. Wide Leg Jeans 11 items
  46. Corsets & Tube Tops 21 items
  47. Cold Shoulder Tops 3 items
  48. Corset Dresses 4 items
Colour
Colour
  1. Beige 521 items
  2. Black 2971 items
  3. Blue 1269 items
  4. Brown 836 items
  5. Gold 53 items
  6. Green 834 items
  7. Grey 597 items
  8. Maroon 27 items
  9. Multi 567 items
  10. Orange 204 items
  11. Pink 1009 items
  12. Purple 342 items
  13. Red 767 items
  14. Silver 91 items
  15. White 1557 items
  16. Yellow 230 items
Less
Size
Size
  1. 1XL 15 items
  2. 26 2 items
  3. 27 4 items
  4. 28 3 items
  5. 29 3 items
  6. 2XL 179 items
  7. 30 2 items
  8. 32B 5 items
  9. 32C 5 items
  10. 32E 1 item
  11. 34B 4 items
  12. 34C 3 items
  13. 36B 3 items
  14. 36C 3 items
  15. 38B 3 items
  16. 38C 3 items
  17. 38D 1 item
  18. 3XL 57 items
  19. 40B 4 items
  20. 40C 3 items
  21. 42B 5 items
  22. 42C 4 items
  23. 44B 1 item
  24. 4XL 26 items
  25. 5XL 10 items
  26. 70A 1 item
  27. 70B 3 items
  28. 70C 4 items
  29. 70D 2 items
  30. 70E 2 items
  31. 75A 1 item
  32. 75B 6 items
  33. 75C 6 items
  34. 75D 5 items
  35. 75E 2 items
  36. 80A 1 item
  37. 80B 6 items
  38. 80C 6 items
  39. 80D 5 items
  40. 80E 2 items
  41. 85B 6 items
  42. 85C 6 items
  43. 85D 5 items
  44. 85E 2 items
  45. 90C 2 items
  46. 90D 2 items
  47. 95C 2 items
  48. 95D 2 items
  49. FS 230 items
  50. L 1411 items
  51. M 1428 items
  52. M/L 2 items
  53. S 1287 items
  54. XL 686 items
  55. XL/XXL 2 items
  56. XS 89 items
  57. XXL 84 items
  58. XXXL 22 items
  59. 0XL 3 items
Less
Price
Price
  1. Rs. 0 - 200 23 items
  2. Rs. 200 - 400 50 items
  3. Rs. 400 - 600 33 items
  4. Rs. 600 - 800 40 items
  5. Rs. 800 - 1000 74 items
  6. Rs. 1000 - 1200 98 items
  7. Rs. 1200 - 1400 143 items
  8. Rs. 1400 - 1600 167 items
  9. Rs. 1600 - 1800 168 items
  10. Rs. 1800 - 2000 158 items
  11. Rs. 2000 - 2500 232 items
  12. Rs. 2500 - 3000 229 items
  13. Rs. 3000 - 3500 91 items
  14. Rs. 3500 - 4000 35 items
  15. Rs. 4000 - 4500 14 items
  16. Rs. 4500 - 5000 5 items
  17. Rs. 5500 - 6000 1 item
  18. Rs. 6000 - 6500 1 item
Brand
Brand
  1. LULUANDSKY 1546 items
  2. KOSHA YOGA 3 items
  1. Grey Remove This Item
  2. Green Remove This Item
  3. M Remove This Item
  4. 28 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_65f979a351d433_90686238` 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

1513 styles found
  1. 58% Off
    -58%
    CASUAL PRINTED GREEN MAXI DRESS
  2. 58% Off
    -58%
    GREEN PRINTED STRAPLESS CORSET
  3. 58% Off
    -58%
    MESH BACKLESS CUT-WAIST MIDI DRESS
  4. 58% Off
    -58%
    GREEN CONVERTIBLE MAXI BODYCON DRESS
  5. 58% Off
    -58%
    GREEN Y2K TWO PIECE TOP SET
  6. 60% Off
    -60%
    DARK GREEN PRINTED STRAPLESS CORSET
  7. 60% Off
    -60%
    GREY MARBLE PRINT CUT-OUT BACK DRESS
  8. 59% Off
    -59%
    TIE-STRAP A-LINE GREEN MIDI DRESS
  9. 60% Off
    -60%
    GREEN SHIRRED SLIT HALTER MAXI DRESS
  10. 58% Off
    -58%
    GREEN LACE-TRIM SLIM BLOUSE
  11. 60% Off
    -60%
    SATIN LACE GREEN 2PC LINGERIE SET
  12. 60% Off
    -60%
    Green 3d Effect Sleeveless Dress
  13. 60% Off
    -60%
    FLORAL PRINT ZIPPER GREEN CORSET
  14. 60% Off
    -60%
    Grey Low-waisted Ruched Pants
  15. 60% Off
    -60%
    Grey Kick-pleats Wide Trousers