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

Women

Filter
Shopping Options
Category
Category
  • Tops 6 items
  • Jeans And Trousers 1 item
    • Jeans 1 item
  • Denim 1 item
    • Jeans 1 item
Styles
Styles
  1. Asymmetrical Dresses 5 items
  2. Blouses 27 items
  3. Bodycon 31 items
  4. Crop Tops 11 items
  5. Cropped Jeans 6 items
  6. Dungarees 2 items
  7. Flared Jeans 6 items
  8. Jumpsuits 3 items
  9. Maxi Dresses 15 items
  10. Midi Dresses 33 items
  11. Midi Skirts 1 item
  12. Mini Skirts 13 items
  13. Nightdresses 0 items
  14. Off Shoulder Tops 14 items
  15. Off-shoulder And Bandeau Dresses 14 items
  16. Pencil Dresses 1 item
  17. Pencil Skirts 1 item
  18. Playsuits And Rompers 2 items
  19. Ripped Jeans 1 item
  20. Sets 11 items
  21. Shift Dresses 5 items
  22. Shirt Dresses 7 items
  23. Shirts 6 items
  24. Skater Dresses 15 items
  25. Skater Skirts 2 items
  26. Skinny Jeans 12 items
  27. Straight Jeans 10 items
  28. Swimsuit 2 items
  29. T-shirts 67 items
  30. Tunic Dresses 30 items
  31. Tunic Tops 29 items
  32. Vests And Camis 16 items
  33. Hipster 30 items
  34. Bikini 28 items
  35. Boyshort 35 items
  36. T-Shirt Bra 2 items
Colour
Colour
  1. Beige 1 item
  2. Blue 1 item
  3. Brown 1 item
  4. Grey 1 item
  5. Multi 1 item
  6. Purple 1 item
  7. Red 1 item
Less
Size
Size
  1. 25 1 item
  2. 26 3 items
  3. 27 3 items
  4. 28 2 items
  5. 29 1 item
  6. 30 1 item
  7. 31 1 item
  8. 32 1 item
  9. L 7 items
  10. M 7 items
  11. S 7 items
  12. XL 6 items
  13. XXL 1 item
Less
Price
Price
  1. Rs. 0 - 1,500 6 items
  1. Nightdresses Remove This Item
  2. Shirts Remove This Item
  3. Ripped Jeans Remove This Item
  4. 29 Remove This Item
  5. XL 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_61f04f05549786_54851980` 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

7 styles found
  1. 88% Off
    -88%
    APPROPRIATE BUTTON DOWN APRICOT SHIRT
    New
    Appropriate Button Down Apricot Shirt
    ₹3,199
    ₹368 (88% Off)
  2. 88% Off
    -88%
    RIP MY STYLE BLUE JEANS
    New
    Rip My Style Blue Jeans
    ₹4,599
    ₹529 (88% Off)
  3. 88% Off
    -88%
    RUN FOR PRINTS GREY SHIRT
    New
    Run For Prints Grey Shirt
    ₹3,049
    ₹351 (88% Off)
  4. 89% Off
    -89%
    SHADES OF COFFEE SHIRT
    New
    Shades Of Coffee Shirt
    ₹4,299
    ₹494 (89% Off)
  5. 89% Off
    -89%
    CARRY ME ALL THE WAY PURPLE SHIRT
    New
    Carry Me All The Way Purple Shirt
    ₹2,549
    ₹293 (89% Off)
  6. 85% Off
    PREMIUM
    PERFECT FOR CASUAL DAY LEOPARD SHIRT
    New
    Perfect For Casual Day Leopard Shirt
    ₹6,664
    ₹1,000 (85% Off)
  7. 89% Off
    -89%
    ALERT RED SHIRT
    New
    Alert Red Shirt
    ₹2,749
    ₹316 (89% Off)