app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Asymmetrical Dresses 34 items
  2. Beach Tops 1 item
  3. Blouses 68 items
  4. Body Suits 97 items
  5. Bodycon 161 items
  6. Bracelets 0 items
  7. Caps 1 item
  8. Cover Ups 65 items
  9. Crop Tops 160 items
  10. Cropped Jeans 1 item
  11. Dungarees 1 item
  12. Flare Jeans 1 item
  13. Hats 1 item
  14. Jumpsuits 31 items
  15. Maxi Dresses 150 items
  16. Maxi Skirts 25 items
  17. Maxi Tops 2 items
  18. Midi Dresses 64 items
  19. Midi Skirts 26 items
  20. Nightdresses 36 items
  21. Nightwear Set 78 items
  22. Off Shoulder Tops 32 items
  23. Off-shoulder And Bandeau Dresses 72 items
  24. Pencil Dresses 19 items
  25. Pencil Skirts 1 item
  26. Playsuits And Rompers 30 items
  27. Sets 278 items
  28. Shift Dresses 7 items
  29. Shirt Dresses 10 items
  30. Shirts 34 items
  31. Short And Mini Skirts 30 items
  32. Skater Dresses 73 items
  33. Skater Skirts 9 items
  34. Straight Jeans 9 items
  35. Swimsuit 51 items
  36. T-shirts 292 items
  37. Tunic Dresses 4 items
  38. Tunic Tops 2 items
  39. Vests And Camis 244 items
  40. Gloves 1 item
  41. Hipster 6 items
  42. Bikini 11 items
  43. Boyshort 5 items
  44. Thong 54 items
  45. Boyleg 1 item
  46. Sports 5 items
  47. Racerback 1 item
  48. T-Shirt Bra 2 items
  49. Bralette 8 items
  50. Padded 3 items
  51. Non Padded 2 items
  52. Sports Bra 1 item
  53. Collars 23 items
  54. Wrap Dresses 4 items
  55. Mom Jeans 1 item
  56. Baggy Jeans 3 items
  57. Wide Leg Jeans 3 items
  58. Neck Warmer 1 item
  59. Shawl 2 items
  60. Corsets & Tube Tops 123 items
  61. Cold Shoulder Tops 2 items
  62. Sarong 7 items
  63. Corset Dresses 14 items
  64. Dressing Gowns & Robes 6 items
Colour
Colour
  1. Beige 37 items
  2. Black 147 items
  3. Blue 76 items
  4. Brown 38 items
  5. Gold 2 items
  6. Green 44 items
  7. Grey 31 items
  8. Maroon 9 items
  9. Multi 54 items
  10. Orange 7 items
  11. Pink 98 items
  12. Purple 35 items
  13. Red 44 items
  14. Silver 2 items
  15. White 113 items
  16. Yellow 17 items
Less
Size
Size
  1. 1XL 3 items
  2. 2XL 10 items
  3. 3XL 4 items
  4. 4XL 3 items
  5. FS 13 items
  6. L 98 items
  7. M 93 items
  8. S 62 items
  9. XL 55 items
  10. XS 7 items
  11. XXL 6 items
Less
Price
Price
  1. Rs. 200 - 400 1 item
  2. Rs. 400 - 600 4 items
  3. Rs. 600 - 800 3 items
  4. Rs. 800 - 1000 7 items
  5. Rs. 1200 - 1400 11 items
  6. Rs. 1400 - 1600 14 items
  7. Rs. 1600 - 1800 13 items
  8. Rs. 1800 - 2000 18 items
  9. Rs. 2000 - 2500 19 items
  10. Rs. 2500 - 3000 8 items
  11. Rs. 3000 - 3500 13 items
  1. Skater Skirts Remove This Item
  2. Bracelets Remove This Item
  3. Midi Skirts Remove This Item
  4. Cold Shoulder Tops Remove This Item
  5. Nightwear Set Remove This Item
  6. White Remove This Item
  7. Gold 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=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_669f159f440dc7_08099113` 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

115 styles found
  1. 60% Off
    -60%
    White Tiered Mid-length A-line Skirt
  2. 60% Off
    -60%
    Off-white Nightdress & Robe Set
  3. 60% Off
    -60%
    Off-white A-line Polyester Skirt
  4. 60% Off
    -60%
    White Crinkled 2pc Loungewear Set
  5. 60% Off
    -60%
    White Nightdress & Robe Set
  6. 60% Off
    -60%
    White Mid-length Denim Skirt
  7. 60% Off
    -60%
    White Pyjama Blouse & Pants
  8. 60% Off
    -60%
    Off-white Pyjama Blouse & Pants
  9. 63% Off
    -63%
    White Nightwear Two Piece Pyjama Set
  10. 60% Off
    -60%
    White Contrast Applique Tiered Skirt
  11. 60% Off
    -60%
    Off-white Crinkle-effect Midi Skirt
  12. 60% Off
    -60%
    White Motif Print A-line Midi Skirt
  13. 60% Off
    -60%
    White 2pc Motif Print Pyjama Set
  14. 63% Off
    -63%
    Off-white Side-slit Midi Slip Skirt
  15. 60% Off
    -60%
    White Pyjama Shirt And Shorts Set
  16. 58% Off
    -58%
    SATIN WHITE DRAPED MIDI SKIRT
  17. 58% Off
    -58%
    LACE-UP WHITE JACQUARD MIDI SKIRT