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 4 items
  3. Body Suits 1 item
  4. Bodycon 8 items
  5. Crop Tops 3 items
  6. Jumpsuits 3 items
  7. Maxi Dresses 9 items
  8. Maxi Skirts 1 item
  9. Midi Dresses 6 items
  10. Midi Skirts 1 item
  11. Nightdresses 4 items
  12. Nightwear Set 5 items
  13. Off Shoulder Tops 1 item
  14. Off-shoulder And Bandeau Dresses 2 items
  15. Pencil Dresses 3 items
  16. Pencil Skirts 1 item
  17. Sets 32 items
  18. Shift Dresses 1 item
  19. Shirt Dresses 1 item
  20. Shirts 6 items
  21. Short And Mini Skirts 1 item
  22. Skater Dresses 3 items
  23. Skater Skirts 1 item
  24. Swimsuit 6 items
  25. T-shirts 6 items
  26. Tunic Dresses 2 items
  27. Vests And Camis 3 items
  28. Bikini 1 item
  29. Boyshort 6 items
  30. Sports 3 items
  31. Sports Bra 3 items
  32. Wrap Dresses 1 item
  33. Corsets & Tube Tops 2 items
Colour
Colour
  1. Beige 225 items
  2. Black 1118 items
  3. Blue 711 items
  4. Brown 339 items
  5. Gold 21 items
  6. Green 425 items
  7. Grey 238 items
  8. Maroon 24 items
  9. Multi 253 items
  10. Orange 110 items
  11. Pink 447 items
  12. Purple 181 items
  13. Red 354 items
  14. Silver 17 items
  15. White 640 items
  16. Yellow 131 items
Less
Size
Size
  1. 1XL 3 items
  2. 2XL 27 items
  3. 32B 1 item
  4. 32C 3 items
  5. 32D 1 item
  6. 34B 1 item
  7. 34C 1 item
  8. 34D 1 item
  9. 36B 1 item
  10. 36C 2 items
  11. 36D 1 item
  12. 38B 1 item
  13. 38C 1 item
  14. 38D 1 item
  15. 38E 1 item
  16. 3XL 7 items
  17. 40B 1 item
  18. 40D 1 item
  19. 42B 2 items
  20. 42C 2 items
  21. 44B 1 item
  22. 4XL 3 items
  23. 5XL 1 item
  24. 70B 3 items
  25. 70C 3 items
  26. 75B 3 items
  27. 75C 3 items
  28. 75D 3 items
  29. 80B 3 items
  30. 80C 3 items
  31. 80D 2 items
  32. 85B 3 items
  33. 85C 3 items
  34. 85D 3 items
  35. FS 13 items
  36. L 231 items
  37. M 226 items
  38. S 210 items
  39. XL 134 items
  40. XS 14 items
  41. XXL 7 items
  42. XXXL 1 item
Less
Price
Price
  1. Rs. 0 - 200 7 items
  2. Rs. 200 - 400 8 items
  3. Rs. 400 - 600 2 items
  4. Rs. 600 - 800 3 items
  5. Rs. 800 - 1000 7 items
  6. Rs. 1000 - 1200 6 items
  7. Rs. 1200 - 1400 7 items
  8. Rs. 1400 - 1600 19 items
  9. Rs. 1600 - 1800 11 items
  10. Rs. 1800 - 2000 18 items
  11. Rs. 2000 - 2500 32 items
  12. Rs. 2500 - 3000 26 items
  13. Rs. 3000 - 3500 9 items
  14. Rs. 3500 - 4000 1 item
  15. Rs. 4000 - 4500 1 item
Brand
Brand
  1. LULUANDSKY 148 items
  2. KOSHA YOGA 1 item
  1. Maroon Remove This Item
  2. Orange Remove This Item
  3. XL 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_66053c79bf2fb4_46394789` 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

149 styles found
  1. 58% Off
    -58%
    WHEN ORANGE MEETS NIGHTWEAR SET
  2. 60% Off
    -60%
    U-NECK ORANGE SPORTS BRA
  3. 60% Off
    -60%
    DARK PINK U-NECK SPORTS BRA
  4. 60% Off
    -60%
    LET'S GET PLAYFUL ORANGE SWIMSUIT
  5. 60% Off
    -60%
    Crimson Pleated Column Midi Dress
  6. 95% Off
    -95%
    LET'S GET CHATTY ORANGE JUMPER
  7. 58% Off
    -58%
    ABSTRACT PRINT ORANGE WRAP DRESS
  8. 58% Off
    -58%
    CASUAL ORANGE RELAXED FIT CO-ORD SET
  9. 58% Off
    -58%
    PRINTED ORANGE CASUAL SKATER DRESS
  10. 58% Off
    -58%
    CRIMSON ONE-SHOULDER HOLLOW SWIMSUIT
  11. 60% Off
    -60%
    CRINKLE ORANGE COLLARED LOOSE SHIRT
  12. 58% Off
    -58%
    THREE PIECE ORANGE BIKINI SET
  13. 59% Off
    -59%
    SLIM SQUARE NECK ORANGE CROP TOP
  14. 60% Off
    -60%
    VELOUR CRIMSON SLIT BODYCON DRESS
  15. 58% Off
    -58%
    CRIMSON PLUNGING BLOUSE & SHORTS SET
  16. 60% Off
    -60%
    ORANGE RIBBED CROPPED VEST