Close Extra 5% OFF* On App Only
Use Code: APP5

Women

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Asymmetrical Dresses 2 items
  2. Blouses 9 items
  3. Bodycon 6 items
  4. Crop Tops 4 items
  5. Jumpsuits 4 items
  6. Maxi Dresses 7 items
  7. Midi Dresses 6 items
  8. Mini Skirts 1 item
  9. Off Shoulder Tops 6 items
  10. Off-shoulder And Bandeau Dresses 2 items
  11. Pencil Dresses 2 items
  12. Sets 5 items
  13. Shift Dresses 1 item
  14. Shirt Dresses 4 items
  15. Shirts 1 item
  16. Skater Dresses 2 items
  17. Swimsuit 1 item
  18. T-shirts 23 items
  19. Tunic Dresses 10 items
  20. Tunic Tops 3 items
  21. Vests And Camis 1 item
Colour
Colour
  1. Beige 2 items
  2. Black 15 items
  3. Blue 14 items
  4. Brown 2 items
  5. Gold 1 item
  6. Green 9 items
  7. Grey 1 item
  8. Maroon 6 items
  9. Multi 1 item
  10. Orange 1 item
  11. Pink 6 items
  12. Red 5 items
  13. White 16 items
  14. Yellow 5 items
Less
Size
Size
  1. 10 1 item
  2. 12 1 item
  3. L 12 items
  4. M 4 items
  5. S 4 items
  6. XL 15 items
  7. XS 1 item
  8. XXL 6 items
Less
Price
Price
  1. Rs. 0 - 1,500 17 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. Tunic Dresses Remove This Item
  4. Swimsuit Remove This Item
  5. Multi Remove This Item
  6. White Remove This Item
  7. Rs. 0 - 1,500 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_61ad1751f17293_99629609` 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

17 styles found
  1. 90% Off
    -90%
    BE MY MOON PIE WHITE DRESS
    New
    Be My Moon Pie White Dress
    ₹5,999
    ₹600 (90% Off)
  2. 90% Off
    -90%
    SUBTLE IN MY STRIPES WHITE DRESS
    New
    Subtle In My Stripes White Dress
    ₹3,499
    ₹350 (90% Off)
  3. 90% Off
    -90%
    QUIRKY LITLE GURL WHITE CROP TOP
    New
    Quirky Litle Gurl White Crop Top
    ₹2,149
    ₹215 (90% Off)
  4. 90% Off
    -90%
    SCOOP OF CUTENESS WHITE DRESS
    New
    Scoop Of Cuteness White Dress
    ₹5,799
    ₹580 (90% Off)
  5. 90% Off
    -90%
    CHECK ON THE MOON WHITE DRESS
    New
    Check On The Moon White Dress
    ₹5,949
    ₹595 (90% Off)
  6. 90% Off
    -90%
    SPRING IS COMING IN SHEEN WHITE SPAGHETTI DRESS
  7. 90% Off
    -90%
    LILLIES ARE LURKING WHITE MINI DRESS
    New
    Lillies Are Lurking White Mini Dress
    ₹4,649
    ₹465 (90% Off)
  8. 90% Off
    -90%
    TAME ME NOT WHITE TUNIC DRESS
    New
    Tame Me Not White Tunic Dress
    ₹3,249
    ₹325 (90% Off)
  9. 90% Off
    -90%
    BLESSED WITH THE BEST WHITE ONE SHOULDER DRESS
    New
    Blessed With The Best White One Shoulder Dress
    ₹4,199
    ₹420 (90% Off)
  10. 90% Off
    -90%
    COMING BACK TO YOU WHITE MINI DRESS
    New
    Coming Back To You White Mini Dress
    ₹3,349
    ₹335 (90% Off)
  11. 90% Off
    -90%
    WHEN THE HEAT GOES UP WHITE CROP TOP
    New
    When The Heat Goes Up White Crop Top
    ₹1,849
    ₹185 (90% Off)
  12. 90% Off
    -90%
    COLOSSAL COLOURS MULTI STRAP CROP TOP
    New
    Colossal Colours Multi Strap Crop Top
    ₹2,499
    ₹250 (90% Off)
  13. 90% Off
    -90%
    WHEN THE HEAT TAKES ON YOU WHITE
    New
    When The Heat Takes On You White
    ₹1,849
    ₹185 (90% Off)
  14. 90% Off
    -90%
    SLAY ALONG THE WAVES WHITE BEACHWEAR
    New
    Slay Along The Waves White Beachwear
    ₹4,399
    ₹440 (90% Off)
  15. 91% Off
    -91%
    WEAVE LACE ON ME WHITE TUNIC DRESS
    Sale
    Weave Lace On Me White Tunic Dress
    ₹3,199
    ₹299 (91% Off)
  16. 91% Off
    -91%
    BLOCK ME WITH COLORS PINK TUNIC DRESS
    Sale
    Block Me With Colors Pink Tunic Dress
    ₹3,349
    ₹299 (91% Off)
  17. 90% Off
    -90%
    CARRY THE SHINE TO THE NEXT FLOOR WHITE DRESS
    New
    Carry The Shine To The Next Floor White Dress
    ₹4,299
    ₹430 (90% Off)