Close Extra 5% OFF* On App Only
Use Code: APP5
CLEARANCE SALE - UPTO 95% OFF ON BAGS | Till 9pm today
Buy 3 items get Extra 15% OFF
Use code: EXTRA15
Sale Ends In
Hours
:
Mins
:
Secs

Women

Filter
Shopping Options
Category
Category
Brand Name
Brand Name
  1. LULUANDSKY 50 items
Styles
Styles
  1. Asymmetrical Dresses 24 items
  2. Blouses 158 items
  3. Body Suits 5 items
  4. Bodycon 257 items
  5. Crop Tops 202 items
  6. Cropped Jeans 1 item
  7. Denim Dresses 4 items
  8. Dungarees 12 items
  9. Flared Jeans 11 items
  10. Joggers 1 item
  11. Jumpsuits 57 items
  12. Maxi Dresses 62 items
  13. Maxi Skirts 20 items
  14. Maxi Tops 1 item
  15. Midi Dresses 102 items
  16. Midi Skirts 46 items
  17. Mini Skirts 65 items
  18. Nightdresses 1 item
  19. Nightwear Set 113 items
  20. Off Shoulder Tops 26 items
  21. Off-shoulder And Bandeau Dresses 46 items
  22. Pencil Dresses 8 items
  23. Pencil Skirts 6 items
  24. Playsuits And Rompers 8 items
  25. Ripped Jeans 3 items
  26. Sets 165 items
  27. Shift Dresses 303 items
  28. Shirt Dresses 24 items
  29. Shirts 73 items
  30. Skater Dresses 70 items
  31. Skater Skirts 10 items
  32. Skinny Jeans 3 items
  33. Straight Jeans 39 items
  34. Swimsuit 121 items
  35. T-shirts 303 items
  36. Tunic Dresses 29 items
  37. Tunic Tops 21 items
  38. Vests And Camis 64 items
  39. Hipster 38 items
  40. Bikini 66 items
  41. Boyshort 87 items
  42. Sports 1 item
  43. T-Shirt Bra 2 items
Colour
Colour
  1. Beige 2 items
  2. Black 18 items
  3. Blue 48 items
  4. Brown 6 items
  5. Gold 1 item
  6. Green 4 items
  7. Grey 6 items
  8. Maroon 2 items
  9. Multi 2 items
  10. Pink 4 items
  11. Red 7 items
  12. Silver 1 item
  13. White 1 item
  14. Yellow 2 items
Less
Size
Size
  1. 25 9 items
  2. 26 14 items
  3. 27 15 items
  4. 28 18 items
  5. 29 18 items
  6. 2XL 43 items
  7. 30 18 items
  8. 31 18 items
  9. 32 13 items
  10. 33 1 item
  11. 3XL 7 items
  12. 4XL 3 items
  13. 5XL 3 items
  14. L 99 items
  15. M 97 items
  16. S 92 items
  17. S/M 0 items
  18. XL 84 items
  19. XS 7 items
  20. XXL 1 item
Less
Price
Price
  1. Rs. 0 - 1,500 21 items
  1. Midi Skirts Remove This Item
  2. Pencil Skirts Remove This Item
  3. Dungarees Remove This Item
  4. Straight Jeans Remove This Item
  5. S/M Remove This Item
  6. M Remove This Item
  7. XL Remove This Item
  8. XS 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_629226976da232_81593994` 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

103 styles found
  1. 60% Off
    -60%
    LUSH LOVE WINE SKIRT
    New
    Lush Love Wine Skirt
    ₹3,120
    ₹1,248 (60% Off)
  2. 60% Off
    -60%
    WRAP PARTY GREEN SKIRT
    New
    Wrap Party Green Skirt
    ₹3,931
    ₹1,572 (60% Off)
  3. 60% Off
    -60%
    SLIGHT SLIT BLUE JEANS
    New
    Slight Slit Blue Jeans
    ₹5,021
    ₹2,008 (60% Off)
  4. 60% Off
    -60%
    PINK PASSION JEANS
    New
    Pink Passion Jeans
    ₹4,343
    ₹1,737 (60% Off)
  5. 80% Off
    -80%
    DOSE OF BLUE JEANS
    New
    Dose Of Blue Jeans
    ₹9,554
    ₹1,911 (80% Off)
  6. 80% Off
    -80%
    DOSE OF PINK JEANS
    New
    Dose Of Pink Jeans
    ₹9,554
    ₹1,911 (80% Off)
  7. 80% Off
    -80%
    THROUGH THE CROWD BLUE JEANS
    New
    Through The Crowd Blue Jeans
    ₹8,370
    ₹1,674 (80% Off)
  8. 86% Off
    -86%
    END GAME NAVY SKIRT
    New
    End Game Navy Skirt
    ₹4,799
    ₹672 (86% Off)
  9. 80% Off
    -80%
    THROUGH THE CROWD GREY JEANS
    New
    Through The Crowd Grey Jeans
    ₹8,370
    ₹1,674 (80% Off)
  10. 80% Off
    -80%
    THROUGH THE CROWD WHITE JEANS
    New
    Through The Crowd White Jeans
    ₹8,370
    ₹1,674 (80% Off)
  11. 80% Off
    -80%
    THROUGH THE CROWD BLACK JEANS
    New
    Through The Crowd Black Jeans
    ₹8,370
    ₹1,674 (80% Off)
  12. 80% Off
    -80%
    FUN FRENZY TIE DYE JEANS
    New
    Fun Frenzy Tie Dye Jeans
    ₹8,630
    ₹1,726 (80% Off)
  13. 80% Off
    -80%
    YOUNG BLOOD BLACK JEANS
    New
    Young Blood Black Jeans
    ₹8,266
    ₹1,653 (80% Off)
  14. 80% Off
    PREMIUM
    CASUAL EVERYDAY BLUE DENIM JEANS
    New
    Casual Everyday Blue Denim Jeans
    ₹10,836
    ₹2,167 (80% Off)
  15. 80% Off
    -80%
    COME TOGETHER DARK BLUE JEANS
    New
    Come Together Dark Blue Jeans
    ₹8,370
    ₹1,674 (80% Off)
  16. 80% Off
    -80%
    COME TOGETHER LIGHT BLUE JEANS
    New
    Come Together Light Blue Jeans
    ₹8,370
    ₹1,674 (80% Off)
  17. 80% Off
    -80%
    BAGGY BABE DARK BLUE JEANS
    New
    Baggy Babe Dark Blue Jeans
    ₹8,500
    ₹1,700 (80% Off)
  18. 80% Off
    -80%
    BAGGY BABE LIGHT BLUE JEANS
    New
    Baggy Babe Light Blue Jeans
    ₹8,370
    ₹1,674 (80% Off)
  19. 86% Off
    -86%
    A TOTALLY VIVID YELLOW SKIRT
    New
    A Totally Vivid Yellow Skirt
    ₹4,549
    ₹637 (86% Off)
  20. 80% Off
    -80%
    BAGGY BABE BLACK JEANS
    New
    Baggy Babe Black Jeans
    ₹8,370
    ₹1,674 (80% Off)
  21. 80% Off
    -80%
    BAGGY BABE BLUE JEANS
    New
    Baggy Babe Blue Jeans
    ₹8,370
    ₹1,674 (80% Off)
  22. 86% Off
    -86%
    LIVE IN THE MOMENT BLACK SKIRT
    New
    Live In The Moment Black Skirt
    ₹4,799
    ₹672 (86% Off)
  23. 80% Off
    -80%
    DENIM LOVER LIGHT BLUE JEANS
    New
    Denim Lover Light Blue Jeans
    ₹8,266
    ₹1,653 (80% Off)
  24. 86% Off
    -86%
    BEING CLASSY KHAKI SKIRT
    New
    Being Classy Khaki Skirt
    ₹4,549
    ₹637 (86% Off)