Close Extra 5% OFF* On App Only
Use Code: APP5
FINAL CLEARANCE SALE - FLAT 85% OFF ON BAGS | Till 9pm today
Extra 15% off on Spend ₹2995
Use code: SKY15
Sale Ends In
Hours
:
Mins
:
Secs

Women

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Asymmetrical Dresses 3 items
  2. Blouses 13 items
  3. Bodycon 4 items
  4. Crop Tops 5 items
  5. Cropped Jeans 4 items
  6. Denim Dresses 1 item
  7. Dungarees 2 items
  8. Flared Jeans 4 items
  9. Jumpsuits 3 items
  10. Maxi Dresses 8 items
  11. Midi Dresses 9 items
  12. Mini Skirts 3 items
  13. Off Shoulder Tops 6 items
  14. Off-shoulder And Bandeau Dresses 5 items
  15. Pencil Dresses 3 items
  16. Ripped Jeans 4 items
  17. Sets 8 items
  18. Shift Dresses 7 items
  19. Shirt Dresses 3 items
  20. Shirts 2 items
  21. Skater Dresses 9 items
  22. Skater Skirts 1 item
  23. Skinny Jeans 6 items
  24. Straight Jeans 4 items
  25. Swimsuit 2 items
  26. T-shirts 32 items
  27. Tunic Dresses 17 items
  28. Tunic Tops 5 items
  29. Vests And Camis 6 items
Colour
Colour
  1. Black 10 items
  2. Blue 7 items
  3. Green 3 items
  4. Maroon 2 items
  5. Multi 3 items
  6. Pink 1 item
  7. Red 3 items
  8. White 8 items
  9. Yellow 3 items
Less
Size
Size
  1. L 12 items
  2. M 12 items
  3. S 10 items
  4. XL 9 items
  5. XS 1 item
  6. XXL 2 items
Less
  1. Off-shoulder And Bandeau Dresses Remove This Item
  2. Crop Tops Remove This Item
  3. Sets Remove This Item
  4. Multi Remove This Item
  5. White Remove This Item
  6. Blue 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`, `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_6149f234bde104_47387060` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `e`.`special_price` DESC, `e`.`entity_id` DESC LIMIT 24

18 styles found
  1. 89% Off
    I'M AN AQUA-HOLIC MULTICOLOR BEACHWEAR SET
    Sale
    I'm An Aqua-holic Multicolor Beachwear Set
    ₹4,349
    ₹475 (89% Off)
  2. 89% Off
    CARRY THE SHINE TO THE NEXT FLOOR WHITE DRESS
    New
    Carry The Shine To The Next Floor White Dress
    ₹4,299
    ₹470 (89% Off)
  3. 89% Off
    BLESSED WITH THE BEST WHITE ONE SHOULDER DRESS
    New
    Blessed With The Best White One Shoulder Dress
    ₹4,199
    ₹460 (89% Off)
  4. 89% Off
    PRINT ATTACK MULTICOLOR BEACHWEAR SET
    New
    Print Attack Multicolor Beachwear Set
    ₹4,099
    ₹450 (89% Off)
  5. 89% Off
    WASH OVER THE SHORE WHITE TWO PIECE
    New
    Wash Over The Shore White Two Piece
    ₹4,049
    ₹445 (89% Off)
  6. 89% Off
    A FLORAL SPLASH PRINTED BLACK SWIMWEAR SET
    Sale
    A Floral Splash Printed Black Swimwear Set
    ₹3,599
    ₹400 (89% Off)
  7. 83% Off
    FEELING SO SUMMERY WHITE OFF-SHOULDER SHIFT DRESS
  8. 85% Off
    SOAKING UP THE VIBES BLUE OFF-SHOULDER TOP
    New
    Soaking Up The Vibes Blue Off-shoulder Top
    ₹2,749
    ₹399 (85% Off)
  9. 88% Off
    CATCHING HAPPY VIBES BLUE OFF-SHOULDER DRESS
    New
    Catching Happy Vibes Blue Off-shoulder Dress
    ₹3,299
    ₹399 (88% Off)
  10. 89% Off
    ALL HAIL POLKA DOTS BLACK BEACHWEAR SET
    Sale
    All Hail Polka Dots Black Beachwear Set
    ₹2,949
    ₹335 (89% Off)
  11. 89% Off
    GO WITH THE TIDES BLUE BEACHWEAR SET
    Sale
    Go With The Tides Blue Beachwear Set
    ₹2,949
    ₹335 (89% Off)
  12. 88% Off
    WHEN THE HEAT GOES UP WHITE CROP TOP
    New
    When The Heat Goes Up White Crop Top
    ₹1,849
    ₹225 (88% Off)
  13. 88% Off
    WHEN THE HEAT TAKES ON YOU WHITE
    New
    When The Heat Takes On You White
    ₹1,849
    ₹225 (88% Off)
  14. 88% Off
    WHEN THE HEAT TAKES ON YOU BLUE
    New
    When The Heat Takes On You Blue
    ₹1,849
    ₹225 (88% Off)
  15. 95% Off
    OH MY PRETTY PEARLS LIGHT BLUE STRIPED OFF-SHOULDER DRESS
  16. 95% Off
    CROSS MY HEART BLUE BEACHWEAR SET
    Sale
    Cross My Heart Blue Beachwear Set
    ₹4,099
    ₹205 (95% Off)
  17. 95% Off
    BRING ON THE SUNSHINE BLUE CROP OFF-SHOULDER TOP
  18. 95% Off
    SWIM SEASON READY PRINTED BLACK BEACHWEAR SET
    Sale
    Swim Season Ready Printed Black Beachwear Set
    ₹2,949
    ₹147 (95% Off)