Close Extra 5% OFF* On App Only
Use Code: APP5
MIN 90-95% OFF ON EVERYTHING | Till noon 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 28 items
  3. Body Suits 1 item
  4. Bodycon 49 items
  5. Crop Tops 22 items
  6. Cropped Jeans 6 items
  7. Denim Dresses 4 items
  8. Dungarees 6 items
  9. Flared Jeans 19 items
  10. Jumpsuits 12 items
  11. Maxi Dresses 13 items
  12. Maxi Skirts 4 items
  13. Midi Dresses 7 items
  14. Midi Skirts 21 items
  15. Mini Skirts 16 items
  16. Nightwear Set 22 items
  17. Off Shoulder Tops 2 items
  18. Off-shoulder And Bandeau Dresses 7 items
  19. Pencil Dresses 1 item
  20. Playsuits And Rompers 2 items
  21. Ripped Jeans 3 items
  22. Sets 19 items
  23. Shift Dresses 77 items
  24. Shirt Dresses 6 items
  25. Shirts 21 items
  26. Skater Dresses 9 items
  27. Skater Skirts 2 items
  28. Skinny Jeans 14 items
  29. Straight Jeans 36 items
  30. Swimsuit 23 items
  31. T-shirts 41 items
  32. Tunic Dresses 5 items
  33. Tunic Tops 0 items
  34. Vests And Camis 11 items
  35. Hipster 12 items
  36. Bikini 25 items
  37. Boyshort 20 items
Colour
Colour
  1. Beige 3 items
  2. Black 22 items
  3. Blue 18 items
  4. Brown 8 items
  5. Gold 1 item
  6. Green 6 items
  7. Grey 5 items
  8. Maroon 3 items
  9. Multi 2 items
  10. Orange 1 item
  11. Pink 3 items
  12. Purple 1 item
  13. Red 8 items
  14. White 7 items
  15. Yellow 7 items
Less
Size
Size
  1. 25 1 item
  2. 26 2 items
  3. 27 1 item
  4. 28 1 item
  5. 29 1 item
  6. 2XL 7 items
  7. 30 1 item
  8. 31 1 item
  9. L 22 items
  10. M 21 items
  11. S 21 items
  12. XL 18 items
  13. XS 2 items
  14. XXL 3 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. Ripped Jeans Remove This Item
  5. Green Remove This Item
  6. Blue Remove This Item
  7. L Remove This Item
  8. M Remove This Item
  9. 30 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_628af2a39ed4f5_32030063` 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

24 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. 90% Off
    -90%
    MADE TO BE ADMIRED BLUE STRIPED SKIRT
    New
    Made To Be Admired Blue Striped Skirt
    ₹4,549
    ₹455 (90% 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. 80% Off
    PREMIUM
    ELONGATE YOUR STYLE BLUE JEANS
    New
    Elongate Your Style Blue Jeans
    ₹10,659
    ₹2,132 (80% Off)
  17. 90% Off
    -90%
    PLAYING ON THE WINNING SIDE BLUE SKIRT
    New
    Playing On The Winning Side Blue Skirt
    ₹5,649
    ₹565 (90% Off)
  18. 90% Off
    -90%
    I'LL CART IT LIGHT BLUE JEANS
    New
    I'll Cart It Light Blue Jeans
    ₹4,899
    ₹490 (90% Off)
  19. 90% Off
    -90%
    RIP MY STYLE BLUE JEANS
    New
    Rip My Style Blue Jeans
    ₹4,599
    ₹460 (90% Off)
  20. 90% Off
    -90%
    CHECK THE TREND PARADE GREEN CHECK DRESS
    New
    Check The Trend Parade Green Check Dress
    ₹6,499
    ₹650 (90% Off)
  21. 90% Off
    -90%
    SPRING IS COMING IN SHEEN BLUE SPAGHETTI DRESS
    New
    Spring Is Coming In Sheen Blue Spaghetti Dress
    ₹4,149
    ₹415 (90% Off)
  22. 90% Off
    -90%
    CALL ME AN OCEAN BAE BLUE DRESS
    New
    Call Me An Ocean Bae Blue Dress
    ₹6,449
    ₹645 (90% Off)
  23. 90% Off
    -90%
    YOU'RE CUTE AND YOU SHOULD KNOW IT GREEN SPAGHETTI DRESS
  24. 90% Off
    -90%
    TAME ME NOT GREEN TUNIC DRESS
    New
    Tame Me Not Green Tunic Dress
    ₹3,249
    ₹325 (90% Off)