Close Extra 5% OFF* On App Only
Use Code: APP5
MIN 90-95% OFF ON EVERYTHING | Till midnight today
Buy 3 items get Extra 15% OFF
Use code: EXTRA15
Sale Ends In
Hours
:
Mins
:
Secs

Clothing

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

23 styles found
  1. 80% Off
    -80%
    PICNIC WITH ME SKY BLUE PRINTED SKIRT
    New
    Picnic With Me Sky Blue Printed Skirt
    ₹4,514
    ₹903 (80% Off)
  2. 80% Off
    -80%
    PICNIC WITH ME NAVY PRINTED SKIRT
    New
    Picnic With Me Navy Printed Skirt
    ₹4,514
    ₹903 (80% Off)
  3. 80% Off
    -80%
    CLASSIC COMFORT DARK BLUE DENIM SKIRT
    New
    Classic Comfort Dark Blue Denim Skirt
    ₹4,978
    ₹996 (80% Off)
  4. 80% Off
    -80%
    CLASSIC COMFORT LIGHT BLUE DENIM SKIRT
    New
    Classic Comfort Light Blue Denim Skirt
    ₹4,978
    ₹996 (80% Off)
  5. 80% Off
    -80%
    ONE LAST GREEN RIPPED SKIRT
    New
    One Last Green Ripped Skirt
    ₹4,204
    ₹841 (80% Off)
  6. 80% Off
    -80%
    A REAL STUNNER GREEN DENIM SKIRT
    New
    A Real Stunner Green Denim Skirt
    ₹9,010
    ₹1,802 (80% Off)
  7. 85% Off
    -85%
    MADE TO BE ADMIRED BLUE STRIPED SKIRT
    New
    Made To Be Admired Blue Striped Skirt
    ₹4,549
    ₹682 (85% Off)
  8. 80% Off
    PREMIUM
    CRAZY 'BOUT YOU BLUE DENIM CROP TOP
    New
    Crazy 'bout You Blue Denim Crop Top
    ₹7,149
    ₹1,430 (80% Off)
  9. 80% Off
    PREMIUM
    LONG TIME AGO LIGHT BLUE DENIM SKIRT
    New
    Long Time Ago Light Blue Denim Skirt
    ₹7,980
    ₹1,596 (80% Off)
  10. 80% Off
    PREMIUM
    FLOWERS ON HEM LIGHT BLUE DENIM SKIRT
    New
    Flowers On Hem Light Blue Denim Skirt
    ₹8,321
    ₹1,664 (80% Off)
  11. 80% Off
    PREMIUM
    MY OFFBEAT BLUE DENIM SKIRT
    New
    My Offbeat Blue Denim Skirt
    ₹9,258
    ₹1,852 (80% Off)
  12. 80% Off
    PREMIUM
    MY LAYERED BLUE DENIM SKIRT
    New
    My Layered Blue Denim Skirt
    ₹10,300
    ₹2,060 (80% Off)
  13. 80% Off
    PREMIUM
    LET'S GET GOING BLUE SKIRT
    New
    Let's Get Going Blue Skirt
    ₹9,258
    ₹1,852 (80% Off)
  14. 80% Off
    PREMIUM
    WITH ALL COMFORT BLUE SKIRT
    New
    With All Comfort Blue Skirt
    ₹9,115
    ₹1,823 (80% Off)
  15. 80% Off
    PREMIUM
    ALL THE LINES DARK GREEN SKIRT
    New
    All The Lines Dark Green Skirt
    ₹4,594
    ₹919 (80% Off)
  16. 86% Off
    -86%
    PLAYING ON THE WINNING SIDE BLUE SKIRT
    New
    Playing On The Winning Side Blue Skirt
    ₹5,649
    ₹791 (86% Off)
  17. 85% Off
    -85%
    POLKA DOT DEEDS BLUE TOP
    New
    Polka Dot Deeds Blue Top
    ₹2,549
    ₹382 (85% Off)
  18. 86% Off
    -86%
    CHECK THE TREND PARADE GREEN CHECK DRESS
    New
    Check The Trend Parade Green Check Dress
    ₹6,499
    ₹910 (86% Off)
  19. 85% Off
    -85%
    SPRING IS COMING IN SHEEN BLUE SPAGHETTI DRESS
    New
    Spring Is Coming In Sheen Blue Spaghetti Dress
    ₹4,149
    ₹622 (85% Off)
  20. 86% Off
    -86%
    CALL ME AN OCEAN BAE BLUE DRESS
    New
    Call Me An Ocean Bae Blue Dress
    ₹6,449
    ₹903 (86% Off)
  21. 90% Off
    -90%
    WRAP THE FUN AROUND GOLDEN SPAGHETTI DRESS
    New
    Wrap The Fun Around Golden Spaghetti Dress
    ₹3,949
    ₹399 (90% Off)
  22. 86% Off
    -86%
    YOU'RE CUTE AND YOU SHOULD KNOW IT GREEN SPAGHETTI DRESS
  23. 88% Off
    -88%
    TAME ME NOT GREEN TUNIC DRESS
    New
    Tame Me Not Green Tunic Dress
    ₹3,249
    ₹399 (88% Off)