Close Extra 5% OFF* On App Only
Use Code: APP5
CLEARANCE SALE - UPTO 95% OFF ON BAGS | Till 9pm 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 33 items
  2. EAVAN FASHIONS 1 item
Styles
Styles
  1. Asymmetrical Dresses 6 items
  2. Blouses 26 items
  3. Body Suits 2 items
  4. Bodycon 66 items
  5. Crop Tops 40 items
  6. Denim Dresses 4 items
  7. Dungarees 6 items
  8. Flared Jeans 5 items
  9. Jumpsuits 15 items
  10. Maxi Dresses 19 items
  11. Maxi Skirts 5 items
  12. Midi Dresses 20 items
  13. Midi Skirts 22 items
  14. Mini Skirts 23 items
  15. Nightwear Set 22 items
  16. Off Shoulder Tops 4 items
  17. Off-shoulder And Bandeau Dresses 9 items
  18. Pencil Skirts 1 item
  19. Playsuits And Rompers 3 items
  20. Ripped Jeans 1 item
  21. Sets 33 items
  22. Shift Dresses 93 items
  23. Shirt Dresses 10 items
  24. Shirts 17 items
  25. Skater Dresses 19 items
  26. Skater Skirts 4 items
  27. Skinny Jeans 2 items
  28. Straight Jeans 25 items
  29. Swimsuit 9 items
  30. T-shirts 60 items
  31. Tunic Dresses 8 items
  32. Tunic Tops 2 items
  33. Vests And Camis 14 items
  34. Hipster 15 items
  35. Bikini 32 items
  36. Boyshort 28 items
Colour
Colour
  1. Beige 5 items
  2. Black 42 items
  3. Blue 31 items
  4. Brown 9 items
  5. Gold 1 item
  6. Green 14 items
  7. Grey 5 items
  8. Maroon 2 items
  9. Multi 6 items
  10. Orange 2 items
  11. Pink 10 items
  12. Purple 2 items
  13. Red 16 items
  14. White 18 items
  15. Yellow 12 items
Less
Size
Size
  1. 2XL 20 items
  2. 3XL 6 items
  3. L 55 items
  4. M 52 items
  5. S 50 items
  6. XL 48 items
  7. XS 3 items
  8. XXL 7 items
  9. XXXL 1 item
Less
Price
Price
  1. Rs. 0 - 1,500 15 items
  2. Rs. 1,501 - 3,000 3 items
  1. Tunic Dresses Remove This Item
  2. Tunic Tops Remove This Item
  3. Mini Skirts Remove This Item
  4. Midi Dresses Remove This Item
  5. Green Remove This Item
  6. Blue Remove This Item
  7. Grey Remove This Item
  8. Orange Remove This Item
  9. Gold Remove This Item
  10. S Remove This Item
  11. 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_62922bbf487134_54368709` 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

Page
53 styles found
  1. 60% Off
    -60%
    GIRLY GIRL BLUE DRESS
    New
    Girly Girl Blue Dress
    ₹4,020
    ₹1,608 (60% Off)
  2. 60% Off
    -60%
    FAIRYTALE COME TRUE GREEN DRESS
    New
    Fairytale Come True Green Dress
    ₹2,356
    ₹942 (60% Off)
  3. 60% Off
    -60%
    RUFFLES AND FLOWERS BLUE DRESS
    New
    Ruffles And Flowers Blue Dress
    ₹3,056
    ₹1,222 (60% Off)
  4. 60% Off
    -60%
    RUFFLES AND FLOWERS GREEN DRESS
    New
    Ruffles And Flowers Green Dress
    ₹3,056
    ₹1,222 (60% Off)
  5. 60% Off
    -60%
    SUMMER'S CALLING BLUE DRESS
    New
    Summer's Calling Blue Dress
    ₹2,757
    ₹1,103 (60% Off)
  6. 60% Off
    -60%
    SUMMER'S CALLING GREEN DRESS
    New
    Summer's Calling Green Dress
    ₹2,757
    ₹1,103 (60% Off)
  7. 60% Off
    -60%
    THE RIGHT REASON GREEN DRESS
    New
    The Right Reason Green Dress
    ₹3,042
    ₹1,217 (60% Off)
  8. 60% Off
    -60%
    THE RIGHT REASON BLUE DRESS
    New
    The Right Reason Blue Dress
    ₹3,042
    ₹1,217 (60% Off)
  9. 60% Off
    -60%
    FEELING FLOWERY BLUE DRESS
    New
    Feeling Flowery Blue Dress
    ₹3,514
    ₹1,406 (60% Off)
  10. 60% Off
    -60%
    PLEATS PLEASE BLUE DRESS
    New
    Pleats Please Blue Dress
    ₹3,449
    ₹1,380 (60% Off)
  11. 60% Off
    -60%
    PLEATS PLEASE ORANGE DRESS
    New
    Pleats Please Orange Dress
    ₹3,449
    ₹1,380 (60% Off)
  12. 60% Off
    -60%
    CLASSY FASHION GREY SKIRT
    New
    Classy Fashion Grey Skirt
    ₹2,151
    ₹860 (60% Off)
  13. 60% Off
    -60%
    RUGGED CUTE DENIM SKIRT
    New
    Rugged Cute Denim Skirt
    ₹3,031
    ₹1,212 (60% Off)
  14. 60% Off
    -60%
    DENIM DAYS MINI SKIRT
    New
    Denim Days Mini Skirt
    ₹3,305
    ₹1,322 (60% Off)
  15. 60% Off
    -60%
    FLOSS FASHION BLACK SKIRT
    New
    Floss Fashion Black Skirt
    ₹3,620
    ₹1,448 (60% Off)
  16. 60% Off
    -60%
    COLOR POP MULTICOLORED MIDI DRESS
    New
    Color Pop Multicolored Midi Dress
    ₹2,371
    ₹948 (60% Off)
  17. 59% Off
    -59%
    EAVAN PISTA GREEN CUT WORK DRESS
    New
    Eavan Pista Green Cut Work Dress
    ₹2,399
    ₹983 (59% Off)
  18. 80% Off
    -80%
    PICNIC WITH ME SKY BLUE PRINTED SKIRT
    New
    Picnic With Me Sky Blue Printed Skirt
    ₹4,514
    ₹903 (80% Off)
  19. 80% Off
    -80%
    PICNIC WITH ME NAVY PRINTED SKIRT
    New
    Picnic With Me Navy Printed Skirt
    ₹4,514
    ₹903 (80% Off)
  20. 80% Off
    -80%
    CLASSIC COMFORT DARK GREY DENIM SKIRT
    New
    Classic Comfort Dark Grey Denim Skirt
    ₹4,978
    ₹996 (80% Off)
  21. 80% Off
    -80%
    CLASSIC COMFORT DARK BLUE DENIM SKIRT
    New
    Classic Comfort Dark Blue Denim Skirt
    ₹4,978
    ₹996 (80% Off)
  22. 80% Off
    -80%
    CLASSIC COMFORT LIGHT BLUE DENIM SKIRT
    New
    Classic Comfort Light Blue Denim Skirt
    ₹4,978
    ₹996 (80% Off)
  23. 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)
  24. 85% Off
    -85%
    PLAY DATE GREEN CHECK MIDI DRESS
    New
    Play Date Green Check Midi Dress
    ₹5,949
    ₹892 (85% Off)
Page