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

Women

Filter
Shopping Options
Category
Category
  • Dresses 25 items
  • Skirts 7 items
Brand Name
Brand Name
  1. LULUANDSKY 26 items
  2. UNTUNG 2 items
Styles
Styles
  1. Asymmetrical Dresses 3 items
  2. Babydoll 1 item
  3. Blouses 36 items
  4. Body Suits 1 item
  5. Bodycon 55 items
  6. Cover Ups 4 items
  7. Crop Tops 29 items
  8. Dungarees 4 items
  9. Jumpsuits 11 items
  10. Maxi Dresses 20 items
  11. Maxi Skirts 2 items
  12. Midi Dresses 21 items
  13. Midi Skirts 6 items
  14. Mini Skirts 5 items
  15. Nightwear Set 15 items
  16. Off Shoulder Tops 6 items
  17. Off-shoulder And Bandeau Dresses 11 items
  18. Palazzos 1 item
  19. Pencil Dresses 1 item
  20. Playsuits And Rompers 3 items
  21. Sets 29 items
  22. Shift Dresses 54 items
  23. Shirt Dresses 5 items
  24. Shirts 10 items
  25. Skater Dresses 17 items
  26. Skater Skirts 1 item
  27. Straight Jeans 2 items
  28. Swimsuit 23 items
  29. T-shirts 27 items
  30. Tunic Dresses 3 items
  31. Tunic Tops 10 items
  32. Vests And Camis 12 items
  33. Hipster 7 items
  34. Bikini 14 items
  35. Boyshort 41 items
  36. Full Figure 27 items
  37. Sports 5 items
  38. T-Shirt Bra 78 items
  39. Bralette 3 items
  40. Padded 13 items
  41. Non Padded 78 items
Colour
Colour
  1. Beige 6 items
  2. Black 70 items
  3. Blue 52 items
  4. Brown 17 items
  5. Gold 1 item
  6. Green 20 items
  7. Grey 6 items
  8. Maroon 4 items
  9. Multi 10 items
  10. Orange 5 items
  11. Pink 14 items
  12. Purple 3 items
  13. Red 23 items
  14. White 32 items
  15. Yellow 17 items
Less
Size
Size
  1. 2XL 6 items
  2. 3XL 3 items
  3. FS 1 item
  4. L 28 items
  5. M 28 items
  6. S 25 items
  7. XL 25 items
  8. XS 2 items
  9. XXL 3 items
Less
Price
Price
  1. Rs. 0 - 1,500 9 items
  2. Rs. 1,501 - 3,000 4 items
  1. Mini Skirts Remove This Item
  2. Pencil Dresses Remove This Item
  3. Maxi Skirts Remove This Item
  4. Midi Dresses Remove This Item
  5. Tunic Dresses Remove This Item
  6. Beige Remove This Item
  7. Purple Remove This Item
  8. Red 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_62c3e4d5725843_31544380` 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

Page
32 styles found
  1. 80% Off
    PREMIUM
    ALL IT TAKES APRICOT WINTER DRESS
    New
    All It Takes Apricot Winter Dress
    ₹9,699
    ₹1,940 (80% Off)
  2. 38% Off
    -38%
    Wine dress with pockets and embroidery
    New
    Wine Dress With Pockets And Embroidery
    ₹2,899
    ₹1,799 (38% Off)
  3. 60% Off
    -60%
    LOVE IN THE AIR RED DRESS
    New
    Love In The Air Red Dress
    ₹4,438
    ₹1,775 (60% Off)
  4. 80% Off
    PREMIUM
    ROCKING IT APRICOT DRESS
    New
    Rocking It Apricot Dress
    ₹8,069
    ₹1,614 (80% Off)
  5. 60% Off
    -60%
    REDS ARE LOVE MIDI DRESS
    New
    Reds Are Love Midi Dress
    ₹3,833
    ₹1,533 (60% Off)
  6. 60% Off
    -60%
    FEELING FLOWERY RED DRESS
    New
    Feeling Flowery Red Dress
    ₹3,514
    ₹1,406 (60% Off)
  7. 60% Off
    -60%
    PLEATS PLEASE APRICOT DRESS
    New
    Pleats Please Apricot Dress
    ₹3,449
    ₹1,380 (60% Off)
  8. 60% Off
    -60%
    FIELDS OF ROSES MIDI DRESS
    New
    Fields Of Roses Midi Dress
    ₹3,128
    ₹1,251 (60% Off)
  9. 80% Off
    -80%
    INTO THE WIND RED SKIRT
    New
    Into The Wind Red Skirt
    ₹6,127
    ₹1,225 (80% Off)
  10. 60% Off
    -60%
    RUFFLES AND FLOWERS RED DRESS
    New
    Ruffles And Flowers Red Dress
    ₹3,056
    ₹1,222 (60% Off)
  11. 60% Off
    -60%
    FLORAL AND FLOUNCY APRICOT SKIRT
    New
    Floral And Flouncy Apricot Skirt
    ₹3,042
    ₹1,217 (60% Off)
  12. 60% Off
    -60%
    SENORITA RED FLORAL DRESS
    New
    Senorita Red Floral Dress
    ₹3,017
    ₹1,207 (60% Off)
  13. 60% Off
    -60%
    BABY BLOOMER PURPLE FLORAL DRESS
    New
    Baby Bloomer Purple Floral Dress
    ₹2,953
    ₹1,181 (60% Off)
  14. 60% Off
    -60%
    SIMPLICITY IS HERE WHITE DRESS
    New
    Simplicity Is Here White Dress
    ₹2,887
    ₹1,155 (60% Off)
  15. 60% Off
    -60%
    LETS GET AWAY RED DRESS
    New
    Lets Get Away Red Dress
    ₹2,793
    ₹1,117 (60% Off)
  16. 60% Off
    -60%
    SUMMER'S CALLING RED DRESS
    New
    Summer's Calling Red Dress
    ₹2,757
    ₹1,103 (60% Off)
  17. 80% Off
    PREMIUM
    I'M CHECKING RED SKIRT
    New
    I'm Checking Red Skirt
    ₹5,089
    ₹1,018 (80% Off)
  18. 57% Off
    -57%
    Amia dress
    New
    Amia Dress
    ₹2,299
    ₹999 (57% Off)
  19. 80% Off
    -80%
    CLASSIC COMFORT APRICOT DENIM SKIRT
    New
    Classic Comfort Apricot Denim Skirt
    ₹4,978
    ₹996 (80% Off)
  20. 90% Off
    -90%
    SPOTTY DELIGHT RED DEER DRESS
    New
    Spotty Delight Red Deer Dress
    ₹6,499
    ₹682 (90% Off)
  21. 90% Off
    -90%
    CHECK THE TREND PARADE RED CHECK DRESS
    New
    Check The Trend Parade Red Check Dress
    ₹6,499
    ₹682 (90% Off)
  22. 90% Off
    -90%
    CONNECTING THE DOTS VIOLET MIDI DRESS
    New
    Connecting The Dots Violet Midi Dress
    ₹6,249
    ₹656 (90% Off)
  23. 90% Off
    -90%
    CONNECTING THE DOTS RED MIDI DRESS
    New
    Connecting The Dots Red Midi Dress
    ₹6,249
    ₹656 (90% Off)
  24. 90% Off
    -90%
    IT'S ALL SHINY PURPLE SKIRT
    New
    It's All Shiny Purple Skirt
    ₹6,049
    ₹635 (90% Off)
Page