Close Extra 5% OFF* On App Only
Use Code: APP5
Upto 95% OFF on Shoes | Till noon today
Extra 15% OFF* on Spend ₹9495
Use code: EXTRA15
Sale Ends In
Hours
:
Mins
:
Secs

Women

Filter
Shopping Options
Category
Category
  • Tops 5 items
  • Jeans And Trousers 1 item
    • Jeans 1 item
Styles
Styles
  1. Asymmetrical Dresses 1 item
  2. Blouses 24 items
  3. Bodycon 2 items
  4. Cover Ups 2 items
  5. Crop Tops 6 items
  6. Dungarees 2 items
  7. Jumpsuits 1 item
  8. Maxi Dresses 6 items
  9. Maxi Skirts 1 item
  10. Midi Dresses 7 items
  11. Midi Skirts 2 items
  12. Mini Skirts 2 items
  13. Nightwear Set 14 items
  14. Off-shoulder And Bandeau Dresses 3 items
  15. Pinafore 1 item
  16. Playsuits And Rompers 1 item
  17. Sets 3 items
  18. Shift Dresses 7 items
  19. Shirt Dresses 1 item
  20. Shirts 3 items
  21. Skater Dresses 13 items
  22. Skinny Jeans 0 items
  23. Straight Jeans 1 item
  24. Swimsuit 7 items
  25. T-shirts 5 items
  26. Vests And Camis 1 item
  27. Hipster 75 items
  28. Bikini 1 item
  29. Boyshort 21 items
  30. Sports 4 items
Colour
Colour
  1. Black 20 items
  2. Blue 21 items
  3. Brown 2 items
  4. Green 8 items
  5. Grey 21 items
  6. Multi 4 items
  7. Orange 2 items
  8. Pink 8 items
  9. Purple 2 items
  10. Red 5 items
  11. White 26 items
  12. Yellow 11 items
Less
Size
Size
  1. 2XL 3 items
  2. L 14 items
  3. M 15 items
  4. S 12 items
  5. XL 11 items
  6. XS 1 item
  7. XXL 3 items
Less
  1. Skinny Jeans Remove This Item
  2. T-shirts Remove This Item
  3. Straight Jeans Remove This Item
  4. Purple Remove This Item
  5. Multi Remove This Item
  6. XXL Remove This Item
  7. 2XL 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_62fdd09b0e0f84_21687278` 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

6 styles found
  1. 80% Off
    -80%
    FUN FRENZY TIE DYE JEANS
    New
    Fun Frenzy Tie Dye Jeans
    ₹8,630
    ₹1,726 (80% Off)
  2. 80% Off
    -80%
    POLKA DOT HEART BLACK T-SHIRT
    New
    Polka Dot Heart Black T-shirt
    ₹4,258
    ₹852 (80% Off)
  3. 80% Off
    -80%
    POLKA DOT HEART GREEN T-SHIRT
    New
    Polka Dot Heart Green T-shirt
    ₹4,258
    ₹852 (80% Off)
  4. 80% Off
    -80%
    POLKA DOT HEART RED T-SHIRT
    New
    Polka Dot Heart Red T-shirt
    ₹4,258
    ₹852 (80% Off)
  5. 80% Off
    -80%
    WORLD CHAMPS PURPKE TOP
    New
    World Champs Purpke Top
    ₹3,260
    ₹652 (80% Off)
  6. 80% Off
    -80%
    HEY QUEEN PURPLE TOP
    New
    Hey Queen Purple Top
    ₹2,494
    ₹499 (80% Off)