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

Clothing

Filter
Shopping Options
Styles
Styles
  1. Blouses 4 items
  2. Bodycon 1 item
  3. Midi Dresses 4 items
  4. Midi Skirts 1 item
  5. Mini Skirts 5 items
  6. Sets 1 item
  7. Shirt Dresses 1 item
  8. Shirts 1 item
  9. Skater Dresses 1 item
  10. Skater Skirts 4 items
  11. Straight Jeans 1 item
  12. T-shirts 1 item
  13. Tunic Dresses 1 item
  14. Tunic Tops 4 items
  15. Vests And Camis 1 item
Colour
Colour
  1. Beige 2 items
  2. Black 37 items
  3. Blue 13 items
  4. Brown 14 items
  5. Gold 1 item
  6. Green 6 items
  7. Grey 5 items
  8. Maroon 5 items
  9. Multi 2 items
  10. Orange 1 item
  11. Pink 9 items
  12. Purple 2 items
  13. Red 13 items
  14. White 17 items
  15. Yellow 9 items
Less
Size
Size
  1. 2XL 5 items
  2. 3XL 3 items
  3. 4XL 3 items
  4. 5XL 2 items
  5. L 11 items
  6. M 6 items
  7. S 7 items
  8. XL 11 items
  9. XXL 1 item
Less
Price
Price
  1. Rs. 0 - 1,500 8 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. Midi Dresses Remove This Item
  5. Brown Remove This Item
  6. L Remove This Item
  7. S 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_61ad1f39c1fe66_57111862` 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

14 styles found
  1. 80% Off
    PREMIUM
    ALL HIGHSCHOOL VIBES KHAKI CHIC DRESS
    New
    All Highschool Vibes Khaki Chic Dress
    ₹14,311
    ₹2,862 (80% Off)
  2. 80% Off
    PREMIUM
    WHO DOESN’T LOVE KHAKI WINTER DRESS
    New
    Who Doesn’t Love Khaki Winter Dress
    ₹12,699
    ₹2,540 (80% Off)
  3. 79% Off
    PREMIUM
    DIP IN CHOCOLATE DRESS
    New
    Dip In Chocolate Dress
    ₹11,755
    ₹2,451 (79% Off)
  4. 79% Off
    PREMIUM
    TWO IN ONE IS KHAKI FUN PULLOVER
    New
    Two In One Is Khaki Fun Pullover
    ₹8,160
    ₹1,732 (79% Off)
  5. 79% Off
    PREMIUM
    TWO IN ONE IS BROWN FUN PULLOVER
    New
    Two In One Is Brown Fun Pullover
    ₹8,160
    ₹1,732 (79% Off)
  6. 90% Off
    -90%
    UNDER COVER COFFEE DRESS
    New
    Under Cover Coffee Dress
    ₹6,299
    ₹630 (90% Off)
  7. 90% Off
    -90%
    SUBTLY SOPHISTICATED COFFEE DRESS
    New
    Subtly Sophisticated Coffee Dress
    ₹6,049
    ₹605 (90% Off)
  8. 87% Off
    -87%
    A LITTLE RASH COFFEE SKIRT
    New
    A Little Rash Coffee Skirt
    ₹4,449
    ₹565 (87% Off)
  9. 90% Off
    -90%
    OWN THE DAY COFFEE TOP
    New
    Own The Day Coffee Top
    ₹4,799
    ₹480 (90% Off)
  10. 90% Off
    -90%
    I MAINTAIN MYSELF COFFEE SKIRT
    New
    I Maintain Myself Coffee Skirt
    ₹4,449
    ₹445 (90% Off)
  11. 90% Off
    -90%
    NO TIME TO REGRET BROWN A-LINE SKIRT
    New
    No Time To Regret Brown A-line Skirt
    ₹4,449
    ₹445 (90% Off)
  12. 90% Off
    -90%
    SELF BOUND BROWN A-LINE SKIRT
    New
    Self Bound Brown A-line Skirt
    ₹4,449
    ₹445 (90% Off)
  13. 90% Off
    -90%
    NO TIME TO REGRET KHAKI A-LINE SKIRT
    New
    No Time To Regret Khaki A-line Skirt
    ₹4,449
    ₹445 (90% Off)
  14. 90% Off
    -90%
    LACE ME UP COFFEE TUNIC TOP
    New
    Lace Me Up Coffee Tunic Top
    ₹3,499
    ₹350 (90% Off)