Close Extra 5% OFF* On App Only
Use Code: APP5
FINAL CLEARANCE SALE - FLAT 85% OFF ON BAGS | Till noon 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 12 items
  3. Bodycon 8 items
  4. Crop Tops 7 items
  5. Denim Dresses 1 item
  6. Dungarees 1 item
  7. Flared Jeans 2 items
  8. Jumpsuits 3 items
  9. Maxi Dresses 8 items
  10. Midi Dresses 12 items
  11. Mini Skirts 3 items
  12. Off Shoulder Tops 3 items
  13. Off-shoulder And Bandeau Dresses 4 items
  14. Pencil Dresses 2 items
  15. Sets 8 items
  16. Shift Dresses 8 items
  17. Shirt Dresses 2 items
  18. Shirts 2 items
  19. Skater Dresses 6 items
  20. Skater Skirts 2 items
  21. Skinny Jeans 2 items
  22. Straight Jeans 1 item
  23. Swimsuit 2 items
  24. T-shirts 19 items
  25. Tunic Dresses 20 items
  26. Tunic Tops 8 items
  27. Vests And Camis 2 items
Colour
Colour
  1. Black 10 items
  2. Blue 8 items
  3. Green 3 items
  4. Maroon 2 items
  5. Multi 3 items
  6. Pink 3 items
  7. Red 3 items
  8. White 8 items
  9. Yellow 3 items
Less
Size
Size
  1. 2XL 1 item
  2. L 17 items
  3. M 11 items
  4. S 10 items
  5. XL 15 items
  6. XS 3 items
  7. XXL 3 items
Less
Price
Price
  1. Rs. 0 - 1,500 18 items
  2. Rs. 1,501 - 3,000 1 item
  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. Black 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_6148edd5b25a48_48131968` 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

19 styles found
  1. 89% Off
    Your Royal Highness Black Off-Shoulder Dress
    New
    Your Royal Highness Black Off-shoulder Dress
    ₹7,249
    ₹775 (89% Off)
  2. 89% Off
    CHECK OUT IN AWE BANDAGE BACKLESS HALTER TOP IN BLACK
  3. 89% Off
    I'M AN AQUA-HOLIC MULTICOLOR BEACHWEAR SET
    Sale
    I'm An Aqua-holic Multicolor Beachwear Set
    ₹4,349
    ₹475 (89% Off)
  4. 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)
  5. 89% Off
    WIND CAUGHT MY DREAMS BLACK TWO PIECE SET
    New
    Wind Caught My Dreams Black Two Piece Set
    ₹4,299
    ₹470 (89% Off)
  6. 89% Off
    BLESSED WITH THE BEST WHITE ONE SHOULDER DRESS
    New
    Blessed With The Best White One Shoulder Dress
    ₹4,199
    ₹460 (89% Off)
  7. 89% Off
    PRINT ATTACK MULTICOLOR BEACHWEAR SET
    New
    Print Attack Multicolor Beachwear Set
    ₹4,099
    ₹450 (89% Off)
  8. 89% Off
    WASH OVER THE SHORE WHITE TWO PIECE
    New
    Wash Over The Shore White Two Piece
    ₹4,049
    ₹445 (89% Off)
  9. 89% Off
    A FLORAL SPLASH PRINTED BLACK SWIMWEAR SET
    Sale
    A Floral Splash Printed Black Swimwear Set
    ₹3,599
    ₹400 (89% Off)
  10. 83% Off
    FEELING SO SUMMERY WHITE OFF-SHOULDER SHIFT DRESS
  11. 89% Off
    IT'S YOUR MESH BLACK CROP TOP
    New
    It's Your Mesh Black Crop Top
    ₹3,249
    ₹365 (89% Off)
  12. 89% Off
    ALWAYS A SMARTY BLACK CROP TOP
    New
    Always A Smarty Black Crop Top
    ₹3,049
    ₹345 (89% Off)
  13. 89% Off
    SWIM SEASON READY PRINTED BLACK BEACHWEAR SET
    Sale
    Swim Season Ready Printed Black Beachwear Set
    ₹2,949
    ₹335 (89% Off)
  14. 89% Off
    ALL HAIL POLKA DOTS BLACK BEACHWEAR SET
    Sale
    All Hail Polka Dots Black Beachwear Set
    ₹2,949
    ₹335 (89% Off)
  15. 88% Off
    THE SAND LOVER BLACK BEACHWEAR SET
    Sale
    The Sand Lover Black Beachwear Set
    ₹2,599
    ₹300 (88% Off)
  16. 85% Off
    WHEN THE HEAT GOES UP BLACK
    New
    When The Heat Goes Up Black
    ₹1,849
    ₹277 (85% Off)
  17. 88% Off
    WHEN THE HEAT GOES UP WHITE CROP TOP
    New
    When The Heat Goes Up White Crop Top
    ₹1,849
    ₹225 (88% Off)
  18. 88% Off
    WHEN THE HEAT TAKES ON YOU WHITE
    New
    When The Heat Takes On You White
    ₹1,849
    ₹225 (88% Off)
  19. 88% Off
    WHEN THE HEAT TAKES ON YOU BLACK
    New
    When The Heat Takes On You Black
    ₹1,849
    ₹225 (88% Off)