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

Premium collection

Premium

Filter
Shopping Options
Brand Name
Brand Name
  1. LULUANDSKY 144 items
Styles
Styles
  1. Asymmetrical Dresses 3 items
  2. Blouses 33 items
  3. Body Suits 1 item
  4. Bodycon 31 items
  5. Cover Ups 5 items
  6. Crop Tops 38 items
  7. Dungarees 2 items
  8. Flared Jeans 1 item
  9. Jumpsuits 2 items
  10. Maxi Dresses 7 items
  11. Maxi Skirts 3 items
  12. Midi Dresses 3 items
  13. Midi Skirts 2 items
  14. Mini Skirts 6 items
  15. Nightdresses 1 item
  16. Off Shoulder Tops 1 item
  17. Off-shoulder And Bandeau Dresses 5 items
  18. Palazzos 1 item
  19. Pencil Dresses 2 items
  20. Sets 25 items
  21. Shift Dresses 29 items
  22. Shirt Dresses 6 items
  23. Shirts 27 items
  24. Skater Skirts 1 item
  25. Straight Jeans 2 items
  26. Swimsuit 29 items
  27. T-shirts 38 items
  28. Vests And Camis 6 items
Colour
Colour
  1. Beige 99 items
  2. Black 465 items
  3. Blue 298 items
  4. Brown 118 items
  5. Gold 10 items
  6. Green 153 items
  7. Grey 115 items
  8. Maroon 5 items
  9. Multi 65 items
  10. Orange 33 items
  11. Pink 112 items
  12. Purple 40 items
  13. Red 105 items
  14. Silver 14 items
  15. White 256 items
  16. Yellow 63 items
Less
Size
Size
  1. 25 1 item
  2. 26 1 item
  3. 27 1 item
  4. 28 1 item
  5. 29 1 item
  6. 2XL 59 items
  7. 30 1 item
  8. 31 1 item
  9. 3XL 14 items
  10. FS 27 items
  11. L 288 items
  12. M 292 items
  13. S 243 items
  14. XL 195 items
  15. XS 5 items
  16. XXL 26 items
Less
  1. White Remove This Item
  2. 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=1539 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_6288ceee0f9bb9_74898336` 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

361 styles found
  1. 80% Off
    -80%
    SOFT AESTHETIC WINE SKIRT
    New
    Soft Aesthetic Wine Skirt
    ₹5,245
    ₹1,049 (80% Off)
  2. 80% Off
    -80%
    THIS ONES FOR YOU RED T-SHIRT
    New
    This Ones For You Red T-shirt
    ₹4,258
    ₹852 (80% Off)
  3. 80% Off
    -80%
    NOT SO BASIC RED BODYSUIT
    New
    Not So Basic Red Bodysuit
    ₹4,029
    ₹806 (80% Off)
  4. 80% Off
    -80%
    BUTTERFLIES IN MY HEART RED T-SHIRT
    New
    Butterflies In My Heart Red T-shirt
    ₹4,258
    ₹852 (80% Off)
  5. 80% Off
    -80%
    BUTTERFLIES IN MY HEART WHITE T-SHIRT
    New
    Butterflies In My Heart White T-shirt
    ₹4,258
    ₹852 (80% Off)
  6. 80% Off
    -80%
    FREE BIRD WHITE T-SHIRT
    New
    Free Bird White T-shirt
    ₹4,258
    ₹852 (80% Off)
  7. 80% Off
    -80%
    THIS ONES FOR YOU WHITE T-SHIRT
    New
    This Ones For You White T-shirt
    ₹4,258
    ₹852 (80% Off)
  8. 80% Off
    -80%
    GONE BIRD WHITE T-SHIRT
    New
    Gone Bird White T-shirt
    ₹4,258
    ₹852 (80% Off)
  9. 80% Off
    -80%
    BLESS ME RED T-SHIRT
    New
    Bless Me Red T-shirt
    ₹4,258
    ₹852 (80% Off)
  10. 80% Off
    -80%
    BLESSED ME WHITE T-SHIRT
    New
    Blessed Me White T-shirt
    ₹4,258
    ₹852 (80% Off)
  11. 80% Off
    -80%
    DANCE IT OFF RED PRINTED SKIRT
    New
    Dance It Off Red Printed Skirt
    ₹5,730
    ₹1,146 (80% Off)
  12. 80% Off
    -80%
    LOVE IS LOVE WHITE T-SHIRT
    New
    Love Is Love White T-shirt
    ₹4,258
    ₹852 (80% Off)
  13. 80% Off
    -80%
    SUCH AN ANGEL WHITE T-SHIRT
    New
    Such An Angel White T-shirt
    ₹4,258
    ₹852 (80% Off)
  14. 80% Off
    -80%
    SHAKE IT OUT RED PRINTED SKIRT
    New
    Shake It Out Red Printed Skirt
    ₹5,889
    ₹1,178 (80% Off)
  15. 80% Off
    -80%
    INTO THE WIND RED SKIRT
    New
    Into The Wind Red Skirt
    ₹6,127
    ₹1,225 (80% Off)
  16. 80% Off
    -80%
    LETS HAVE FUN MAROON PANTS
    New
    Lets Have Fun Maroon Pants
    ₹6,206
    ₹1,241 (80% Off)
  17. 80% Off
    -80%
    HALTER ME IN MAROON CROP TOP
    New
    Halter Me In Maroon Crop Top
    ₹3,297
    ₹659 (80% Off)
  18. 80% Off
    -80%
    HALTER ME IN WHITE CROP TOP
    New
    Halter Me In White Crop Top
    ₹3,297
    ₹659 (80% Off)
  19. 80% Off
    -80%
    STRIPE ATTACK WHITE CROP TOP
    New
    Stripe Attack White Crop Top
    ₹3,782
    ₹756 (80% Off)
  20. 80% Off
    -80%
    CLASSIC YOU BLUE TOP
    New
    Classic You Blue Top
    ₹3,579
    ₹716 (80% Off)
  21. 80% Off
    -80%
    THROUGH THE CROWD WHITE JEANS
    New
    Through The Crowd White Jeans
    ₹8,370
    ₹1,674 (80% Off)
  22. 80% Off
    -80%
    FASHION MISSION WHITE DENIM SHORTS
    New
    Fashion Mission White Denim Shorts
    ₹4,978
    ₹996 (80% Off)
  23. 80% Off
    -80%
    EXCITING SUMMER WHITE DENIM SHORTS
    New
    Exciting Summer White Denim Shorts
    ₹4,848
    ₹970 (80% Off)
  24. 80% Off
    -80%
    THIS MOMENT WHITE DENIM SHORTS
    New
    This Moment White Denim Shorts
    ₹4,965
    ₹993 (80% Off)