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

Women

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

22 styles found
  1. 90% Off
    -90%
    DARK ROSE WHITE TWO PIECE SET
    New
    Dark Rose White Two Piece Set
    ₹5,899
    ₹590 (90% Off)
  2. 80% Off
    -80%
    LET THEM TALK WHITE AND GREEN TWO PIECE SET
    New
    Let Them Talk White And Green Two Piece Set
    ₹18,483
    ₹3,697 (80% Off)
  3. 79% Off
    PREMIUM
    LAY THE LANTERNS ACROSS TWO PIECE SET
    New
    Lay The Lanterns Across Two Piece Set
    ₹16,657
    ₹3,431 (79% Off)
  4. 90% Off
    -90%
    FLORAL FLARE WHITE TOP
    New
    Floral Flare White Top
    ₹2,599
    ₹260 (90% Off)
  5. 90% Off
    -90%
    FINDING SWEET SPOTS RED BLOUSE
    New
    Finding Sweet Spots Red Blouse
    ₹3,949
    ₹395 (90% Off)
  6. 79% Off
    PREMIUM
    YOUR ADMIRER WHITE TOP
    New
    Your Admirer White Top
    ₹7,465
    ₹1,593 (79% Off)
  7. 80% Off
    -80%
    FEEL THE ELEGANCE WHITE TWO PIECE SET
    New
    Feel The Elegance White Two Piece Set
    ₹14,946
    ₹2,989 (80% Off)
  8. 90% Off
    -90%
    DARK ROSE CLARET RED TWO PIECE SET
    New
    Dark Rose Claret Red Two Piece Set
    ₹5,899
    ₹590 (90% Off)
  9. 90% Off
    -90%
    IN THE MOOD TO DALLY WHITE TOP
    New
    In The Mood To Dally White Top
    ₹3,999
    ₹400 (90% Off)
  10. 90% Off
    -90%
    OH LA LA WHITE TOP
    New
    Oh La La White Top
    ₹6,299
    ₹630 (90% Off)
  11. 79% Off
    PREMIUM
    LACE ALL DAY LONG TWO PIECE SET
    New
    Lace All Day Long Two Piece Set
    ₹16,008
    ₹3,302 (79% Off)
  12. 90% Off
    -90%
    WIND CAUGHT MY DREAMS RED TWO PIECE SET
    New
    Wind Caught My Dreams Red Two Piece Set
    ₹4,299
    ₹430 (90% Off)
  13. 90% Off
    -90%
    PRETTY LITTLE RED TWO PIECE SET
    New
    Pretty Little Red Two Piece Set
    ₹5,699
    ₹570 (90% Off)
  14. 93% Off
    -93%
    FRINGE BY FRINGE WHITE TOP
    New
    Fringe By Fringe White Top
    ₹4,599
    ₹299 (93% Off)
  15. 90% Off
    -90%
    MY BAE-SIC RED MIDI DRESS
    New
    My Bae-sic Red Midi Dress
    ₹3,449
    ₹345 (90% Off)
  16. 90% Off
    -90%
    SPOOKY BEHAVIOUR RED SHIFT DRESS
    New
    Spooky Behaviour Red Shift Dress
    ₹2,049
    ₹199 (90% Off)
  17. 90% Off
    -90%
    SUBTLE LOVE PINK RIBBED TOP
    New
    Subtle Love Pink Ribbed Top
    ₹2,549
    ₹255 (90% Off)
  18. 90% Off
    -90%
    SWEET TALKER  WHITE TOP
    New
    Sweet Talker White Top
    ₹2,899
    ₹290 (90% Off)
  19. 90% Off
    -90%
    MY HEART IN A MESH TOP
    New
    My Heart In A Mesh Top
    ₹2,749
    ₹275 (90% Off)
  20. 90% Off
    -90%
    LOVE MY CHECKERBOARD RED SHIFT DRESS
    Sale
    Love My Checkerboard Red Shift Dress
    ₹3,049
    ₹305 (90% Off)
  21. 90% Off
    -90%
    ALL HAIL POLKA DOTS BLACK BEACHWEAR SET
    Sale
    All Hail Polka Dots Black Beachwear Set
    ₹2,949
    ₹295 (90% Off)
  22. 79% Off
    PREMIUM
    OFF DUTY SHIRT
    New
    Off Duty Shirt
    ₹7,342
    ₹1,568 (79% Off)