app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Asymmetrical Dresses 110 items
  2. Beach Shorts 1 item
  3. Beach Tops 1 item
  4. Blouses 121 items
  5. Body Suits 326 items
  6. Bodycon 630 items
  7. Caps 8 items
  8. Cover Ups 114 items
  9. Crop Tops 396 items
  10. Cropped Jeans 1 item
  11. Denim Dresses 1 item
  12. Denim Tops 3 items
  13. Dungarees 4 items
  14. Flare Jeans 15 items
  15. Hats 6 items
  16. Jumpsuits 153 items
  17. Maxi Dresses 479 items
  18. Maxi Skirts 57 items
  19. Maxi Tops 4 items
  20. Midi Dresses 182 items
  21. Midi Skirts 64 items
  22. Nightdresses 67 items
  23. Nightwear Set 165 items
  24. Off Shoulder Tops 69 items
  25. Off-shoulder And Bandeau Dresses 229 items
  26. Pencil Dresses 57 items
  27. Pencil Skirts 6 items
  28. Playsuits And Rompers 106 items
  29. Ripped Jeans 1 item
  30. Sets 800 items
  31. Shift Dresses 26 items
  32. Shirt Dresses 14 items
  33. Shirts 58 items
  34. Short And Mini Skirts 94 items
  35. Skater Dresses 163 items
  36. Skater Skirts 27 items
  37. Skinny Jeans 2 items
  38. Straight Jeans 45 items
  39. Swimsuit 173 items
  40. T-shirts 630 items
  41. Tunic Dresses 6 items
  42. Tunic Tops 4 items
  43. Vests And Camis 535 items
  44. Wayfarers And Square Frame Sunglasses 1 item
  45. Gloves 3 items
  46. Hipster 19 items
  47. Bikini 36 items
  48. Boyshort 15 items
  49. Thong 158 items
  50. Boyleg 3 items
  51. Sports 9 items
  52. Racerback 1 item
  53. T-Shirt Bra 3 items
  54. Bralette 19 items
  55. Padded 3 items
  56. Non Padded 2 items
  57. Sports Bra 4 items
  58. Collars 40 items
  59. Wrap Dresses 19 items
  60. Mom Jeans 2 items
  61. Baggy Jeans 4 items
  62. Vests 2 items
  63. Wide Leg Jeans 11 items
  64. Neck Warmer 1 item
  65. Shawl 4 items
  66. Corsets & Tube Tops 315 items
  67. Cold Shoulder Tops 10 items
  68. Sarong 11 items
  69. Corset Dresses 56 items
  70. Dressing Gowns & Robes 10 items
Colour
Colour
  1. Beige 19 items
  2. Black 147 items
  3. Blue 60 items
  4. Brown 28 items
  5. Gold 2 items
  6. Green 31 items
  7. Grey 20 items
  8. Maroon 1 item
  9. Multi 18 items
  10. Orange 6 items
  11. Pink 55 items
  12. Purple 14 items
  13. Red 45 items
  14. Silver 6 items
  15. White 83 items
  16. Yellow 9 items
Less
Size
Size
  1. 1XL 1 item
  2. 2XL 5 items
  3. 3XL 1 item
  4. FS 8 items
  5. L 248 items
  6. M 239 items
  7. S 230 items
  8. XL 67 items
  9. XS 27 items
  10. XXL 14 items
  11. XXS 2 items
Less
Price
Price
  1. Rs. 200 - 400 8 items
  2. Rs. 400 - 600 14 items
  3. Rs. 600 - 800 1 item
  4. Rs. 800 - 1000 5 items
  5. Rs. 1000 - 1200 7 items
  6. Rs. 1200 - 1400 22 items
  7. Rs. 1400 - 1600 36 items
  8. Rs. 1600 - 1800 34 items
  9. Rs. 1800 - 2000 28 items
  10. Rs. 2000 - 2500 70 items
  11. Rs. 2500 - 3000 35 items
  12. Rs. 3000 - 3500 6 items
  13. Rs. 3500 - 4000 4 items
  14. Rs. 4000 - 4500 4 items
  15. Rs. 4500 - 5000 1 item
  1. Skater Skirts Remove This Item
  2. Hipster Remove This Item
  3. Off-shoulder And Bandeau Dresses Remove This Item
  4. White Remove This Item
  5. Red Remove This Item
  6. Black 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_6692509369f7c1_07516294` 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` ASC, `e`.`entity_id` DESC LIMIT 24

275 styles found
  1. 80% Off
    -80%
    Side Zipper White Skater Skirt
  2. 60% Off
    -60%
    Red Low-waisted Hipster
  3. 60% Off
    -60%
    White Low-waisted Hipster
  4. 60% Off
    -60%
    Black Low-waisted Hipster
  5. 85% Off
    -85%
    ROSE-RED OFF-SHOULDER SLIM DRESS