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

Special Prices

Upto 90% Off

Sale Ends In
Hours
:
Mins
:
Secs
  • 24 - Hours - Only

Special Prices

Filter
Shopping Options
Brand
Brand
  1. LULUANDSKY 17 items
Styles
Styles
  1. Asymmetrical Dresses 1 item
  2. Blouses 7 items
  3. Bodycon 8 items
  4. Dungarees 0 items
  5. Jumpsuits 1 item
  6. Maxi Dresses 5 items
  7. Midi Dresses 3 items
  8. Midi Skirts 3 items
  9. Mini Skirts 3 items
  10. Ripped Jeans 1 item
  11. Sets 1 item
  12. Shift Dresses 8 items
  13. Shirt Dresses 1 item
  14. Skater Dresses 2 items
  15. Straight Jeans 2 items
  16. T-shirts 8 items
  17. Tunic Dresses 2 items
  18. Tunic Tops 2 items
  19. Vests And Camis 0 items
Colour
Colour
  1. Black 3 items
  2. Blue 2 items
  3. Green 4 items
  4. Grey 1 item
  5. Multi 2 items
  6. Orange 1 item
  7. Pink 1 item
  8. Purple 1 item
  9. Red 1 item
  10. White 1 item
Less
Size
Size
  1. 10 0 items
  2. 2XL 1 item
  3. 30 0 items
  4. L 22 items
  5. M 17 items
  6. S 20 items
  7. XL 31 items
  8. XXL 10 items
Less
Price
Price
  1. Rs. 0 - 1,500 16 items
  2. Rs. 1,501 - 3,000 2 items
  1. LULUANDSKY Remove This Item
  2. Maxi Dresses Remove This Item
  3. Vests And Camis Remove This Item
  4. Dungarees Remove This Item
  5. Tunic Dresses Remove This Item
  6. Tunic Tops Remove This Item
  7. Bodycon Remove This Item
  8. 10 Remove This Item
  9. 30 Remove This Item
  10. M Remove This Item

SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `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`, `at_special_price`.`value` AS `special_price` FROM `catalog_product_entity` 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=642 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_62f924526050a4_18585018` AS `search_result` ON e.entity_id = search_result.entity_id LEFT JOIN `catalog_product_entity_decimal` AS `at_special_price` ON (`at_special_price`.`entity_id` = `e`.`entity_id`) AND (`at_special_price`.`attribute_id` = '76') AND (`at_special_price`.`store_id` = 0) WHERE (stock_status_index.stock_status = 1) ORDER BY `special_price` DESC, `e`.`entity_id` DESC LIMIT 24

17 styles found
  1. 95% Off
    -95%
    CUT-OUT PRINTED BLACK MAXI DRESS
    New
    Cut-out Printed Black Maxi Dress
    ₹5,899
    ₹295 (95% Off)
  2. 95% Off
    -95%
    GOOD OLD DAYS ORANGE DRESS
    New
    Good Old Days Orange Dress
    ₹5,899
    ₹295 (95% Off)
  3. 95% Off
    -95%
    BLOWING MY MIND PINK DRESS
    New
    Blowing My Mind Pink Dress
    ₹5,899
    ₹295 (95% Off)
  4. 95% Off
    -95%
    ABSTRACT DESIGNS GREEN DRESS
    New
    Abstract Designs Green Dress
    ₹5,899
    ₹295 (95% Off)
  5. 95% Off
    -95%
    BRUNCH WITH ME MULTICOLOR DRESS
    New
    Brunch With Me Multicolor Dress
    ₹5,899
    ₹295 (95% Off)
  6. 95% Off
    -95%
    LITTLE DRAMATIC PURPLE PRINTED DRESS
    New
    Little Dramatic Purple Printed Dress
    ₹5,899
    ₹295 (95% Off)
  7. 95% Off
    -95%
    EASY ON ME LIGHT GREEN DRESS
    New
    Easy On Me Light Green Dress
    ₹5,899
    ₹295 (95% Off)
  8. 95% Off
    -95%
    SERENE LIKE LILLIES BLACK BODYCON DRESS
    New
    Serene Like Lillies Black Bodycon Dress
    ₹5,249
    ₹262 (95% Off)
  9. 95% Off
    -95%
    SUBTLE AND SUMPTUOUS PINK DRESS
    New
    Subtle And Sumptuous Pink Dress
    ₹5,249
    ₹262 (95% Off)
  10. 95% Off
    -95%
    SERENE LIKE LILLIES WHITE BODYCON DRESS
    New
    Serene Like Lillies White Bodycon Dress
    ₹5,249
    ₹262 (95% Off)
  11. 95% Off
    -95%
    CHECK ME OUT PLAID BODYCON DRESS IN BLACK
    New
    Check Me Out Plaid Bodycon Dress In Black
    ₹4,499
    ₹225 (95% Off)
  12. 96% Off
    -96%
    SLIP INTO THE SLINK DRESS IN GREY
    New
    Slip Into The Slink Dress In Grey
    ₹4,949
    ₹199 (96% Off)
  13. 96% Off
    -96%
    SLIP INTO THE SLINK DRESS IN GREEN
    New
    Slip Into The Slink Dress In Green
    ₹4,949
    ₹199 (96% Off)
  14. 96% Off
    -96%
    SLIP INTO THE SLINK DRESS IN BLACK
    New
    Slip Into The Slink Dress In Black
    ₹4,949
    ₹199 (96% Off)
  15. 90% Off
    -90%
    MY PRETTY BUDS BLACK TUNIC DRESS
    New
    My Pretty Buds Black Tunic Dress
    ₹2,049
    ₹199 (90% Off)
  16. 97% Off
    -97%
    BRING ON THE GAME ARMY GREEN TOP
    New
    Bring On The Game Army Green Top
    ₹3,099
    ₹99 (97% Off)
  17. 96% Off
    -96%
    ALONG THE WAVES BLUE ASYMMETRICAL  TUNIC TOP
    New
    Along The Waves Blue Asymmetrical Tunic Top
    ₹2,299
    ₹99 (96% Off)