app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Asymmetrical Dresses 35 items
  2. Blouses 71 items
  3. Body Suits 100 items
  4. Bodycon 228 items
  5. Bracelets 1 item
  6. Caps 10 items
  7. Cover Ups 27 items
  8. Crop Tops 191 items
  9. Cropped Jeans 1 item
  10. Culottes 1 item
  11. Denim Dresses 12 items
  12. Denim Tops 8 items
  13. Dungarees 3 items
  14. Earrings 5 items
  15. Flare Jeans 44 items
  16. Hats 4 items
  17. Jumpsuits 64 items
  18. Maxi Dresses 179 items
  19. Maxi Skirts 29 items
  20. Maxi Tops 1 item
  21. Midi Dresses 103 items
  22. Midi Skirts 41 items
  23. Necklace 6 items
  24. Nightdresses 32 items
  25. Nightwear Set 90 items
  26. Off Shoulder Tops 37 items
  27. Off-shoulder And Bandeau Dresses 106 items
  28. Pencil Dresses 28 items
  29. Pencil Skirts 5 items
  30. Pinafore 1 item
  31. Playsuits And Rompers 56 items
  32. Ripped Jeans 3 items
  33. Sets 443 items
  34. Shift Dresses 14 items
  35. Shirt Dresses 15 items
  36. Shirts 50 items
  37. Short And Mini Skirts 33 items
  38. Skater Dresses 64 items
  39. Skater Skirts 19 items
  40. Skinny Jeans 3 items
  41. Straight Jeans 141 items
  42. Swimsuit 82 items
  43. T-shirts 412 items
  44. Tunic Dresses 4 items
  45. Tunic Tops 4 items
  46. Vests And Camis 223 items
  47. Gloves 3 items
  48. Hipster 11 items
  49. Bikini 26 items
  50. Boyshort 8 items
  51. Thong 127 items
  52. Cycling Short 1 item
  53. Boyleg 2 items
  54. Sports 14 items
  55. Racerback 1 item
  56. T-Shirt Bra 1 item
  57. Bralette 8 items
  58. Padded 1 item
  59. Non Padded 1 item
  60. Sports Bra 4 items
  61. Collars 30 items
  62. Wrap Dresses 4 items
  63. Mom Jeans 3 items
  64. Baggy Jeans 17 items
  65. Vests 1 item
  66. Wide Leg Jeans 59 items
  67. Boot Cuffs 1 item
  68. Neck Warmer 1 item
  69. Shawl 4 items
  70. Corsets & Tube Tops 111 items
  71. Cold Shoulder Tops 3 items
  72. Sarong 3 items
  73. Corset Dresses 18 items
  74. Dressing Gowns & Robes 5 items
Colour
Colour
  1. Beige 57 items
  2. Black 286 items
  3. Blue 86 items
  4. Brown 112 items
  5. Green 66 items
  6. Grey 58 items
  7. Maroon 3 items
  8. Multi 27 items
  9. Orange 7 items
  10. Pink 72 items
  11. Purple 11 items
  12. Red 33 items
  13. Silver 20 items
  14. White 175 items
  15. Yellow 9 items
Less
Size
Size
  1. 2XL 7 items
  2. 3XL 2 items
  3. 4XL 2 items
  4. 5XL 1 item
  5. FS 34 items
  6. L 264 items
  7. M 271 items
  8. S 274 items
  9. XL 62 items
  10. XS 30 items
  11. XXL 2 items
Less
Price
Price
  1. Rs. 400 - 600 6 items
  2. Rs. 600 - 800 16 items
  3. Rs. 800 - 1000 42 items
  4. Rs. 1000 - 1200 67 items
  5. Rs. 1200 - 1400 53 items
  6. Rs. 1400 - 1600 23 items
  7. Rs. 1600 - 1800 31 items
  8. Rs. 1800 - 2000 24 items
  9. Rs. 2000 - 2500 23 items
  10. Rs. 2500 - 3000 16 items
  11. Rs. 3000 - 3500 13 items
  12. Rs. 3500 - 4000 1 item
  1. Skater Skirts Remove This Item
  2. Bracelets Remove This Item
  3. Vests And Camis Remove This Item
  4. Shift Dresses Remove This Item
  5. Maxi Skirts Remove This Item
  6. Short And Mini Skirts Remove This Item
  7. White Remove This Item
  8. Blue Remove This Item
  9. Grey 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_662293939e2ec2_43143271` 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

319 styles found
  1. 60% Off
    -60%
    RIPPED BLUE CENTER SLIT DENIM SKIRT
  2. 60% Off
    -60%
    FLOWERS ON ME BLUE DRESS
  3. 58% Off
    -58%
    LACE-TIE BLUE DENIM MINI SKIRT
  4. 60% Off
    -60%
    HIGH SLIT LIGHT BLUE DENIM SKIRT
  5. 60% Off
    -60%
    HIGH SLIT BLUE DENIM MAXI SKIRT
  6. 59% Off
    -59%
    DENIM MINI WHITE SIDE-ZIPPER SKIRT
  7. 59% Off
    -59%
    DENIM MINI BLUE SIDE-ZIPPER SKIRT
  8. 60% Off
    -60%
    Irregular Gradient Denim Blue Skirt
  9. 60% Off
    -60%
    LIGHT GREY CONTRAST CAMI TOP
  10. 60% Off
    -60%
    PRINTED BLUE COTTON VEST TOP
  11. 60% Off
    -60%
    A-line Short Pu Leather Grey Skirt
  12. 60% Off
    -60%
    Grey Colourblock Y2k Irregular Skirt
  13. 60% Off
    -60%
    Contrasting Grey Mini Skater Skirt