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

Women

Filter
Shopping Options
Category
Category
  • Dresses 4 items
  • Tops 5 items
Styles
Styles
  1. Asymmetrical Dresses 4 items
  2. Blouses 17 items
  3. Bodycon 19 items
  4. Crop Tops 5 items
  5. Dungarees 1 item
  6. Flared Jeans 2 items
  7. Maxi Dresses 8 items
  8. Maxi Skirts 0 items
  9. Midi Dresses 19 items
  10. Midi Skirts 1 item
  11. Mini Skirts 3 items
  12. Off Shoulder Tops 8 items
  13. Off-shoulder And Bandeau Dresses 3 items
  14. Pencil Dresses 0 items
  15. Pencil Skirts 1 item
  16. Playsuits And Rompers 1 item
  17. Sets 9 items
  18. Shift Dresses 6 items
  19. Shirt Dresses 5 items
  20. Shirts 6 items
  21. Skater Dresses 14 items
  22. Skater Skirts 1 item
  23. Skinny Jeans 2 items
  24. Straight Jeans 1 item
  25. Swimsuit 2 items
  26. T-shirts 28 items
  27. Tunic Dresses 12 items
  28. Tunic Tops 25 items
  29. Vests And Camis 2 items
Colour
Colour
  1. Beige 1 item
  2. Black 4 items
  3. Blue 4 items
  4. Brown 1 item
  5. Green 3 items
  6. Grey 1 item
  7. Maroon 3 items
  8. Multi 1 item
  9. Pink 4 items
  10. Purple 1 item
  11. Red 4 items
  12. White 7 items
  13. Yellow 3 items
Less
Size
Size
  1. L 6 items
  2. M 6 items
  3. S 2 items
  4. XL 4 items
Less
Price
Price
  1. Rs. 0 - 1,500 7 items
  1. Pencil Dresses Remove This Item
  2. Maxi Skirts Remove This Item
  3. Crop Tops Remove This Item
  4. Asymmetrical Dresses Remove This Item
  5. Beige Remove This Item
  6. Red Remove This Item
  7. Black 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_6174bf03a47cd7_02645924` 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

9 styles found
  1. 79% Off
    PREMIUM
    TWINKLE TWINKLE LITTLE STAR DRESS
    New
    Twinkle Twinkle Little Star Dress
    ₹9,744
    ₹2,049 (79% Off)
  2. 90% Off
    CHECK OUT IN AWE BANDAGE BACKLESS HALTER TOP IN RED
  3. 90% Off
    MOST LIKED
    CHECK OUT IN AWE BANDAGE BACKLESS HALTER TOP IN BLACK
  4. 79% Off
    PREMIUM
    OWN KIND OF BURGUNDY BEAUTY DRESS
    New
    Own Kind Of Burgundy Beauty Dress
    ₹12,441
    ₹2,588 (79% Off)
  5. 90% Off
    CALL IT A TIE FLORAL CROP TOP
    New
    Call It A Tie Floral Crop Top
    ₹3,599
    ₹360 (90% Off)
  6. 90% Off
    FEW LEFT
    SOME FRILLS AND THRILLS BLACK ASYMMETRICAL DRESS
  7. 90% Off
    ALWAYS A SMARTY BLACK CROP TOP
    New
    Always A Smarty Black Crop Top
    ₹3,049
    ₹305 (90% Off)
  8. 90% Off
    IT'S YOUR MESH BLACK CROP TOP
    New
    It's Your Mesh Black Crop Top
    ₹3,249
    ₹325 (90% Off)
  9. 90% Off
    LOVE MY CHECKERBOARD RED SHIFT DRESS
    Sale
    Love My Checkerboard Red Shift Dress
    ₹3,049
    ₹305 (90% Off)