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

Special Prices

Upto 90% Off

Sale Ends In
Hours
:
Mins
:
Secs
  • 24 - Hours - Only

Special Prices

Filter
Shopping Options
Styles
Styles
  1. Asymmetrical Dresses 3 items
  2. Blouses 13 items
  3. Bodycon 16 items
  4. Crop Tops 12 items
  5. Flared Jeans 1 item
  6. Maxi Dresses 20 items
  7. Midi Dresses 24 items
  8. Mini Skirts 11 items
  9. Off Shoulder Tops 3 items
  10. Off-shoulder And Bandeau Dresses 5 items
  11. Pencil Dresses 1 item
  12. Pencil Skirts 2 items
  13. Ripped Jeans 1 item
  14. Sets 3 items
  15. Shift Dresses 2 items
  16. Shirt Dresses 4 items
  17. Shirts 1 item
  18. Skater Dresses 10 items
  19. Skater Skirts 5 items
  20. Straight Jeans 4 items
  21. Swimsuit 4 items
  22. T-shirts 33 items
  23. Tunic Dresses 27 items
  24. Tunic Tops 3 items
  25. Vests And Camis 19 items
Colour
Colour
  1. Black 11 items
  2. Blue 13 items
  3. Brown 2 items
  4. Gold 1 item
  5. Green 10 items
  6. Grey 4 items
  7. Maroon 2 items
  8. Orange 1 item
  9. Pink 8 items
  10. Purple 2 items
  11. Red 8 items
  12. White 14 items
  13. Yellow 4 items
Less
Size
Size
  1. 10 0 items
  2. L 79 items
  3. M 72 items
  4. S 62 items
  5. XL 79 items
  6. XS 11 items
  7. XXL 25 items
  8. XXXL 2 items
Less
Price
Price
  1. Rs. 0 - 1,500 62 items
  2. Rs. 1,501 - 3,000 17 items
  1. Tunic Dresses Remove This Item
  2. Maxi Dresses Remove This Item
  3. Crop Tops Remove This Item
  4. Shift Dresses Remove This Item
  5. Vests And Camis Remove This Item
  6. 10 Remove This Item
  7. L 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=642 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_614f5ffa6ee482_08445499` 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

79 styles found
  1. 90% Off
    WHEN THE HEAT GOES UP BURGUNDY CROP TOP
    New
    When The Heat Goes Up Burgundy Crop Top
    ₹1,849
    ₹185 (90% Off)
  2. 90% Off
    WHEN THE HEAT GOES UP ARMY GREEN CROP TOP
    New
    When The Heat Goes Up Army Green Crop Top
    ₹1,849
    ₹185 (90% Off)
  3. 90% Off
    WHEN THE HEAT TAKES ON YOU WHITE
    New
    When The Heat Takes On You White
    ₹1,849
    ₹185 (90% Off)
  4. 90% Off
    WHEN THE HEAT TAKES ON YOU BURGUNDY
    New
    When The Heat Takes On You Burgundy
    ₹1,849
    ₹185 (90% Off)
  5. 90% Off
    WHEN THE HEAT TAKES ON YOU BLUE
    New
    When The Heat Takes On You Blue
    ₹1,849
    ₹185 (90% Off)
  6. 90% Off
    BRING IT ON STRAP GREEN TANK TOP
    New
    Bring It On Strap Green Tank Top
    ₹1,799
    ₹180 (90% Off)
  7. 90% Off
    BRING IT ON COFFEE TANK TOP
    New
    Bring It On Coffee Tank Top
    ₹1,799
    ₹180 (90% Off)
  8. 90% Off
    BRING IT ON NAVY TANK TOP
    New
    Bring It On Navy Tank Top
    ₹1,799
    ₹180 (90% Off)
  9. 90% Off
    BRING IT ON GREEN TANK TOP
    New
    Bring It On Green Tank Top
    ₹1,799
    ₹180 (90% Off)
  10. 90% Off
    A CUT OF MY WHIMS BLACK DRESS
    New
    A Cut Of My Whims Black Dress
    ₹6,499
    ₹650 (90% Off)
  11. 90% Off
    WHISPER OF WHIM RED DRESS
    New
    Whisper Of Whim Red Dress
    ₹6,499
    ₹650 (90% Off)
  12. 90% Off
    CHECK THE TREND PARADE GREEN CHECK DRESS
    New
    Check The Trend Parade Green Check Dress
    ₹6,499
    ₹650 (90% Off)
  13. 90% Off
    CHECK THE TREND PARADE BLACK CHECK DRESS
    New
    Check The Trend Parade Black Check Dress
    ₹6,499
    ₹650 (90% Off)
  14. 90% Off
    FLORAL SWIRL BLACK DRESS
    New
    Floral Swirl Black Dress
    ₹6,799
    ₹680 (90% Off)
  15. 90% Off
    BE MY MOON PIE WHITE DRESS
    New
    Be My Moon Pie White Dress
    ₹5,999
    ₹600 (90% Off)
  16. 90% Off
    CHECK ON THE MOON WHITE DRESS
    New
    Check On The Moon White Dress
    ₹5,949
    ₹595 (90% Off)
  17. 90% Off
    SPRING IS COMING IN SHEEN PINK SPAGHETTI DRESS
    New
    Spring Is Coming In Sheen Pink Spaghetti Dress
    ₹4,149
    ₹415 (90% Off)
  18. 90% Off
    SPRING IS COMING IN SHEEN WHITE SPAGHETTI DRESS
  19. 90% Off
    SPRING IS COMING IN SHEEN BLUE SPAGHETTI DRESS
    New
    Spring Is Coming In Sheen Blue Spaghetti Dress
    ₹4,149
    ₹415 (90% Off)
  20. 90% Off
    LILLIES ARE LURKING WHITE MINI DRESS
    New
    Lillies Are Lurking White Mini Dress
    ₹4,649
    ₹465 (90% Off)
  21. 90% Off
    SNUGGLE TIME WHITE MADI DRESS
    New
    Snuggle Time White Madi Dress
    ₹4,199
    ₹420 (90% Off)
  22. 90% Off
    SNUGGLE TIME BLUE MADI DRESS
    New
    Snuggle Time Blue Madi Dress
    ₹4,199
    ₹420 (90% Off)
  23. 90% Off
    BLOSSOM FOR YOUR OWN JOY BODYCON DRESS IN BLACK
  24. 90% Off
    SNUGGLE TIME RED MADI DRESS
    New
    Snuggle Time Red Madi Dress
    ₹4,199
    ₹420 (90% Off)