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

Clothing

Filter
Shopping Options
Styles
Styles
  1. Asymmetrical Dresses 2 items
  2. Blouses 9 items
  3. Bodycon 11 items
  4. Crop Tops 4 items
  5. Jumpsuits 1 item
  6. Maxi Dresses 7 items
  7. Midi Dresses 11 items
  8. Mini Skirts 1 item
  9. Off Shoulder Tops 7 items
  10. Off-shoulder And Bandeau Dresses 4 items
  11. Pencil Dresses 2 items
  12. Sets 13 items
  13. Shift Dresses 1 item
  14. Shirt Dresses 6 items
  15. Shirts 2 items
  16. Skater Dresses 4 items
  17. Skater Skirts 0 items
  18. Swimsuit 1 item
  19. T-shirts 18 items
  20. Tunic Dresses 14 items
  21. Tunic Tops 4 items
  22. Vests And Camis 8 items
Colour
Colour
  1. Beige 2 items
  2. Black 12 items
  3. Blue 7 items
  4. Brown 9 items
  5. Gold 1 item
  6. Green 6 items
  7. Grey 3 items
  8. Maroon 3 items
  9. Orange 1 item
  10. Pink 6 items
  11. Purple 1 item
  12. Red 7 items
  13. White 8 items
  14. Yellow 5 items
Less
Size
Size
  1. 2XL 2 items
  2. FS 1 item
  3. L 20 items
  4. M 11 items
  5. S 8 items
  6. XL 18 items
  7. XXL 6 items
Less
Price
Price
  1. Rs. 0 - 1,500 18 items
  2. Rs. 1,501 - 3,000 1 item
  1. Tunic Dresses Remove This Item
  2. Tunic Tops Remove This Item
  3. Mini Skirts Remove This Item
  4. Skater Skirts Remove This Item
  5. Shift Dresses Remove This Item
  6. Green Remove This Item
  7. Pink Remove This Item
  8. White Remove This Item
  9. 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`, `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=389 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_61ad22243049a9_09715202` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `e`.`special_price` ASC, `e`.`entity_id` DESC LIMIT 24

20 styles found
  1. 90% Off
    -90%
    CUT IT SHORT WHITE SKIRT
    New
    Cut It Short White Skirt
    ₹3,249
    ₹325 (90% Off)
  2. 90% Off
    -90%
    TAME ME NOT GREEN TUNIC DRESS
    New
    Tame Me Not Green Tunic Dress
    ₹3,249
    ₹325 (90% Off)
  3. 90% Off
    -90%
    LACE ME UP PINK TUNIC TOP
    New
    Lace Me Up Pink Tunic Top
    ₹3,499
    ₹350 (90% Off)
  4. 90% Off
    -90%
    LACE ME UP GREEN TUNIC TOP
    New
    Lace Me Up Green Tunic Top
    ₹3,499
    ₹350 (90% Off)
  5. 90% Off
    -90%
    FIELD GIRL GREEN DRESS
    New
    Field Girl Green Dress
    ₹3,699
    ₹370 (90% Off)
  6. 90% Off
    -90%
    SPRING IS COMING IN SHEEN PINK SPAGHETTI DRESS
    New
    Spring Is Coming In Sheen Pink Spaghetti Dress
    ₹4,149
    ₹415 (90% Off)
  7. 90% Off
    -90%
    SPRING IS COMING IN SHEEN WHITE SPAGHETTI DRESS
  8. 90% Off
    -90%
    PLAID WITH BUTTONS BLACK TUNIC TOP
    New
    Plaid With Buttons Black Tunic Top
    ₹4,499
    ₹450 (90% Off)
  9. 90% Off
    -90%
    IN THE GOLDEN HOUR OF LINES PINK BODYCON DRESS
    New
    In The Golden Hour Of Lines Pink Bodycon Dress
    ₹4,549
    ₹455 (90% Off)
  10. 90% Off
    -90%
    LILLIES ARE LURKING WHITE MINI DRESS
    New
    Lillies Are Lurking White Mini Dress
    ₹4,649
    ₹465 (90% Off)
  11. 90% Off
    -90%
    BATWING CLASSIC ARMY GREEN SHIFT DRESS
    New
    Batwing Classic Army Green Shift Dress
    ₹4,949
    ₹495 (90% Off)
  12. 90% Off
    -90%
    SUBTLE AND SUMPTUOUS PINK DRESS
    New
    Subtle And Sumptuous Pink Dress
    ₹5,249
    ₹525 (90% Off)
  13. 90% Off
    -90%
    SCOOP OF CUTENESS WHITE DRESS
    New
    Scoop Of Cuteness White Dress
    ₹5,799
    ₹580 (90% Off)
  14. 90% Off
    -90%
    CHECK ON THE MOON WHITE DRESS
    New
    Check On The Moon White Dress
    ₹5,949
    ₹595 (90% Off)
  15. 90% Off
    -90%
    BE MY MOON PIE WHITE DRESS
    New
    Be My Moon Pie White Dress
    ₹5,999
    ₹600 (90% Off)
  16. 90% Off
    -90%
    YOU'RE CUTE AND YOU SHOULD KNOW IT PINK SPAGHETTI DRESS
  17. 90% Off
    -90%
    YOU'RE CUTE AND YOU SHOULD KNOW IT GREEN SPAGHETTI DRESS
  18. 90% Off
    -90%
    CHECK THE TREND PARADE GREEN CHECK DRESS
    New
    Check The Trend Parade Green Check Dress
    ₹6,499
    ₹650 (90% Off)
  19. 90% Off
    -90%
    LONGED FOR YOU WHITE TUNIC TOP
    New
    Longed For You White Tunic Top
    ₹6,849
    ₹685 (90% Off)
  20. 80% Off
    -80%
    LOVE STRUCK PINK DRESS
    New
    Love Struck Pink Dress
    ₹11,060
    ₹2,212 (80% Off)