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

Page
33 styles found
  1. 80% Off
    PREMIUM
    ADD A FUN TOUCH KHAKI DRESS
    New
    Add A Fun Touch Khaki Dress
    ₹13,438
    ₹2,688 (80% Off)
  2. 80% Off
    PREMIUM
    MY LAYERED BLUE DENIM SKIRT
    New
    My Layered Blue Denim Skirt
    ₹10,300
    ₹2,060 (80% Off)
  3. 80% Off
    PREMIUM
    MY OFFBEAT BLUE DENIM SKIRT
    New
    My Offbeat Blue Denim Skirt
    ₹9,258
    ₹1,852 (80% Off)
  4. 80% Off
    PREMIUM
    LET'S GET GOING BLUE SKIRT
    New
    Let's Get Going Blue Skirt
    ₹9,258
    ₹1,852 (80% Off)
  5. 80% Off
    PREMIUM
    WITH ALL COMFORT BLUE SKIRT
    New
    With All Comfort Blue Skirt
    ₹9,115
    ₹1,823 (80% Off)
  6. 80% Off
    PREMIUM
    ALL ABOUT HARMONY KHAKI WINTER DRESS
    New
    All About Harmony Khaki Winter Dress
    ₹9,048
    ₹1,810 (80% Off)
  7. 80% Off
    PREMIUM
    MAKE EVERYBODY SWOON KHAKI DRESS
    New
    Make Everybody Swoon Khaki Dress
    ₹8,402
    ₹1,680 (80% Off)
  8. 80% Off
    PREMIUM
    FLOWERS ON HEM LIGHT BLUE DENIM SKIRT
    New
    Flowers On Hem Light Blue Denim Skirt
    ₹8,321
    ₹1,664 (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
    SEQUINED COFFEE SKIRT
    New
    Sequined Coffee Skirt
    ₹7,943
    ₹1,589 (80% Off)
  11. 80% Off
    PREMIUM
    FASHIONISTA'S CHOICE BROWN SKIRT
    New
    Fashionista's Choice Brown Skirt
    ₹7,279
    ₹1,456 (80% Off)
  12. 80% Off
    PREMIUM
    CRAZY 'BOUT YOU BLUE DENIM CROP TOP
    New
    Crazy 'bout You Blue Denim Crop Top
    ₹7,149
    ₹1,430 (80% Off)
  13. 80% Off
    -80%
    A LITTLE WILD PRINTED SKIRT
    New
    A Little Wild Printed Skirt
    ₹5,043
    ₹1,009 (80% Off)
  14. 80% Off
    -80%
    CLASSIC COMFORT DARK BLUE DENIM SKIRT
    New
    Classic Comfort Dark Blue Denim Skirt
    ₹4,978
    ₹996 (80% Off)
  15. 80% Off
    -80%
    CLASSIC COMFORT LIGHT BLUE DENIM SKIRT
    New
    Classic Comfort Light Blue Denim Skirt
    ₹4,978
    ₹996 (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. 85% Off
    -85%
    LOOK AT HER ROYAL BLUE LEAF PRINT DRESS
    New
    Look At Her Royal Blue Leaf Print Dress
    ₹5,949
    ₹892 (85% Off)
  19. 85% Off
    -85%
    I?M THE ONE BLUE MIDI DRESS
    New
    I?m The One Blue Midi Dress
    ₹5,949
    ₹892 (85% Off)
  20. 90% Off
    -90%
    BLOOMINGDALE IN SPRING VIOLET MIDI DRESS
    New
    Bloomingdale In Spring Violet Midi Dress
    ₹6,349
    ₹635 (90% Off)
  21. 90% Off
    -90%
    UNDER COVER COFFEE DRESS
    New
    Under Cover Coffee Dress
    ₹6,299
    ₹630 (90% Off)
  22. 90% Off
    -90%
    IT'S ALL SHINY KHAKI SKIRT
    New
    It's All Shiny Khaki Skirt
    ₹6,049
    ₹605 (90% Off)
  23. 90% Off
    -90%
    BLOOM WHEREVER YOU GO TWIST KNOT BLUE DRESS
    New
    Bloom Wherever You Go Twist Knot Blue Dress
    ₹5,999
    ₹600 (90% Off)
  24. 90% Off
    -90%
    PLAYING ON THE WINNING SIDE BLUE SKIRT
    New
    Playing On The Winning Side Blue Skirt
    ₹5,649
    ₹565 (90% Off)
Page