Close Extra 5% OFF* On App Only
Use Code: APP5
Upto 95% OFF on Shoes | Till noon today | Till 9pm today
Extra 15% OFF* on Spend ₹9495
Use code: EXTRA15
Sale Ends In
Hours
:
Mins
:
Secs

Clothing

Filter
Shopping Options
Brand
Brand
  1. LULUANDSKY 96 items
Styles
Styles
  1. Asymmetrical Dresses 5 items
  2. Blouses 29 items
  3. Body Suits 1 item
  4. Bodycon 48 items
  5. Crop Tops 34 items
  6. Cropped Jeans 1 item
  7. Denim Dresses 5 items
  8. Dungarees 7 items
  9. Flared Jeans 6 items
  10. Jumpsuits 23 items
  11. Maxi Dresses 18 items
  12. Maxi Skirts 5 items
  13. Midi Dresses 21 items
  14. Midi Skirts 21 items
  15. Mini Skirts 20 items
  16. Nightwear Set 24 items
  17. Off Shoulder Tops 7 items
  18. Off-shoulder And Bandeau Dresses 8 items
  19. Pencil Dresses 1 item
  20. Playsuits And Rompers 5 items
  21. Ripped Jeans 1 item
  22. Sets 36 items
  23. Shift Dresses 83 items
  24. Shirt Dresses 10 items
  25. Shirts 16 items
  26. Skater Dresses 20 items
  27. Skater Skirts 4 items
  28. Skinny Jeans 3 items
  29. Straight Jeans 29 items
  30. Swimsuit 27 items
  31. T-shirts 37 items
  32. Tunic Dresses 7 items
  33. Tunic Tops 2 items
  34. Vests And Camis 13 items
  35. Hipster 10 items
  36. Bikini 27 items
  37. Boyshort 23 items
Colour
Colour
  1. Beige 13 items
  2. Black 98 items
  3. Blue 65 items
  4. Brown 15 items
  5. Gold 6 items
  6. Green 32 items
  7. Grey 12 items
  8. Maroon 2 items
  9. Multi 20 items
  10. Orange 10 items
  11. Pink 17 items
  12. Purple 10 items
  13. Red 35 items
  14. Silver 10 items
  15. White 30 items
  16. Yellow 14 items
Less
Size
Size
  1. 2XL 30 items
  2. 3XL 3 items
  3. 4XL 1 item
  4. 5XL 1 item
  5. L 103 items
  6. M 102 items
  7. S 104 items
  8. XL 82 items
  9. XS 3 items
  10. XXL 11 items
Less
Price
Price
  1. Rs. 0 - 1,500 26 items
  2. Rs. 1,501 - 3,000 6 items
  1. Tunic Tops Remove This Item
  2. Mini Skirts Remove This Item
  3. Bodycon Remove This Item
  4. Maxi Dresses Remove This Item
  5. Midi Skirts Remove This Item
  6. Green Remove This Item
  7. Blue Remove This Item
  8. Grey Remove This Item
  9. L Remove This Item
  10. M 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=389 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_62f11038d89860_40763746` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `e`.`entity_id` DESC LIMIT 24

109 styles found
  1. 60% Off
    -60%
    CHAINED AND TIED BLUE DRESS
    New
    Chained And Tied Blue Dress
    ₹3,389
    ₹1,356 (60% Off)
  2. 60% Off
    -60%
    C YOU SOON BODYCON DRESS
    New
    C You Soon Bodycon Dress
    ₹3,270
    ₹1,308 (60% Off)
  3. 60% Off
    -60%
    ETHNIC ENCOUNTER GREEN AND YELLOW DRESS
    New
    Ethnic Encounter Green And Yellow Dress
    ₹3,850
    ₹1,540 (60% Off)
  4. 60% Off
    -60%
    IN CANNES GREEN DRESS
    New
    In Cannes Green Dress
    ₹4,217
    ₹1,687 (60% Off)
  5. 60% Off
    -60%
    WRAP PARTY GREEN SKIRT
    New
    Wrap Party Green Skirt
    ₹3,931
    ₹1,572 (60% Off)
  6. 60% Off
    -60%
    LOVING THE PRINT PURPLE MAXI DRESS
    New
    Loving The Print Purple Maxi Dress
    ₹4,052
    ₹1,621 (60% Off)
  7. 60% Off
    -60%
    LOVING THE PRINT BLUE MAXI DRESS
    New
    Loving The Print Blue Maxi Dress
    ₹4,052
    ₹1,621 (60% Off)
  8. 60% Off
    -60%
    THAT'S A MOMENT GREEN DRESS
    New
    That's A Moment Green Dress
    ₹3,847
    ₹1,539 (60% Off)
  9. 60% Off
    -60%
    SET THE TONE BLUE DRESS
    New
    Set The Tone Blue Dress
    ₹2,140
    ₹856 (60% Off)
  10. 60% Off
    -60%
    CLASSY FASHION GREY SKIRT
    New
    Classy Fashion Grey Skirt
    ₹2,151
    ₹860 (60% Off)
  11. 60% Off
    -60%
    RUGGED CUTE DENIM SKIRT
    New
    Rugged Cute Denim Skirt
    ₹3,031
    ₹1,212 (60% Off)
  12. 60% Off
    -60%
    DENIM DAYS MINI SKIRT
    New
    Denim Days Mini Skirt
    ₹3,305
    ₹1,322 (60% Off)
  13. 60% Off
    -60%
    FLOSS FASHION BLACK SKIRT
    New
    Floss Fashion Black Skirt
    ₹3,620
    ₹1,448 (60% Off)
  14. 80% Off
    -80%
    SHE'S A STUNNER GREEN SKIRT
    New
    She's A Stunner Green Skirt
    ₹5,175
    ₹1,035 (80% Off)
  15. 80% Off
    -80%
    DANCE IT OFF BLUE PRINTED SKIRT
    New
    Dance It Off Blue Printed Skirt
    ₹5,730
    ₹1,146 (80% Off)
  16. 80% Off
    -80%
    PICNIC WITH ME SKY BLUE PRINTED SKIRT
    New
    Picnic With Me Sky Blue Printed Skirt
    ₹4,514
    ₹903 (80% Off)
  17. 80% Off
    -80%
    PICNIC WITH ME NAVY PRINTED SKIRT
    New
    Picnic With Me Navy Printed Skirt
    ₹4,514
    ₹903 (80% Off)
  18. 80% Off
    -80%
    WAIT AND WATCH GREEN DRESS
    New
    Wait And Watch Green Dress
    ₹3,809
    ₹762 (80% Off)
  19. 80% Off
    -80%
    SEE ME SOON BLUE DRESS
    New
    See Me Soon Blue Dress
    ₹4,260
    ₹852 (80% Off)
  20. 80% Off
    -80%
    WISHING WELL GREEN MAXI DRESS
    New
    Wishing Well Green Maxi Dress
    ₹5,789
    ₹1,158 (80% Off)
  21. 80% Off
    -80%
    DRINKS ON ME GREY BODYCON DRESS
    New
    Drinks On Me Grey Bodycon Dress
    ₹6,614
    ₹1,323 (80% Off)
  22. 80% Off
    -80%
    COVER GIRL GREY BODYCON DRESS
    New
    Cover Girl Grey Bodycon Dress
    ₹6,537
    ₹1,307 (80% Off)
  23. 80% Off
    -80%
    MESMERISING STRIPES BLUE BODYCON DRESS
    New
    Mesmerising Stripes Blue Bodycon Dress
    ₹3,276
    ₹655 (80% Off)
  24. 80% Off
    -80%
    TEMPTED BY YOU GREY BODYCON DRESS
    New
    Tempted By You Grey Bodycon Dress
    ₹7,254
    ₹1,451 (80% Off)