app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Asymmetrical Dresses 87 items
  2. Blouses 109 items
  3. Body Suits 277 items
  4. Bodycon 543 items
  5. Bracelets 1 item
  6. Caps 11 items
  7. Cover Ups 19 items
  8. Crop Tops 342 items
  9. Denim Dresses 1 item
  10. Denim Tops 3 items
  11. Dungarees 1 item
  12. Earrings 4 items
  13. Flare Jeans 18 items
  14. Hats 6 items
  15. Jumpsuits 135 items
  16. Maxi Dresses 334 items
  17. Maxi Skirts 42 items
  18. Maxi Tops 1 item
  19. Midi Dresses 164 items
  20. Midi Skirts 59 items
  21. Nightdresses 75 items
  22. Nightwear Set 130 items
  23. Off Shoulder Tops 55 items
  24. Off-shoulder And Bandeau Dresses 201 items
  25. Pencil Dresses 76 items
  26. Pencil Skirts 7 items
  27. Playsuits And Rompers 89 items
  28. Retro Sunglasses 1 item
  29. Rings 1 item
  30. Ripped Jeans 1 item
  31. Sets 745 items
  32. Shift Dresses 28 items
  33. Shirt Dresses 16 items
  34. Shirts 47 items
  35. Short And Mini Skirts 57 items
  36. Skater Dresses 117 items
  37. Skater Skirts 27 items
  38. Skinny Jeans 1 item
  39. Straight Jeans 29 items
  40. Swimsuit 127 items
  41. T-shirts 615 items
  42. Tunic Dresses 7 items
  43. Tunic Tops 4 items
  44. Vests And Camis 319 items
  45. Wayfarers And Square Frame Sunglasses 2 items
  46. Gloves 2 items
  47. Hipster 26 items
  48. Bikini 57 items
  49. Boyshort 21 items
  50. Thong 245 items
  51. Cycling Short 1 item
  52. Boyleg 5 items
  53. Sports 13 items
  54. Racerback 2 items
  55. T-Shirt Bra 3 items
  56. Bralette 17 items
  57. Padded 3 items
  58. Non Padded 2 items
  59. Sports Bra 4 items
  60. Nose Pins 1 item
  61. Collars 45 items
  62. Wrap Dresses 11 items
  63. Mom Jeans 2 items
  64. Baggy Jeans 3 items
  65. Vests 1 item
  66. Wide Leg Jeans 14 items
  67. Neck Warmer 1 item
  68. Shawl 5 items
  69. Thongbody 1 item
  70. Corsets & Tube Tops 248 items
  71. Cold Shoulder Tops 11 items
  72. Sarong 6 items
  73. Corset Dresses 56 items
  74. Dressing Gowns & Robes 10 items
Colour
Colour
  1. Beige 6 items
  2. Black 16 items
  3. Blue 6 items
  4. Brown 10 items
  5. Gold 2 items
  6. Green 2 items
  7. Grey 12 items
  8. Maroon 1 item
  9. Multi 2 items
  10. Pink 7 items
  11. Red 1 item
  12. Silver 3 items
  13. White 9 items
  14. Yellow 1 item
Less
Size
Size
  1. 2XL 3 items
  2. 3XL 1 item
  3. 4XL 1 item
  4. FS 6 items
  5. L 21 items
  6. M 18 items
  7. S 21 items
  8. XL 11 items
  9. XS 4 items
  10. XXL 1 item
Less
Price
Price
  1. Rs. 400 - 600 1 item
  2. Rs. 600 - 800 2 items
  3. Rs. 1000 - 1200 4 items
  4. Rs. 1200 - 1400 4 items
  5. Rs. 1400 - 1600 7 items
  6. Rs. 1600 - 1800 3 items
  7. Rs. 1800 - 2000 1 item
  8. Rs. 2000 - 2500 3 items
  9. Rs. 2500 - 3000 3 items
  10. Rs. 3000 - 3500 1 item
  1. Skater Skirts Remove This Item
  2. Bracelets Remove This Item
  3. White Remove This Item
  4. Red Remove This Item
  5. Gold 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_6606aa2e2e3d73_79852338` 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

Page
28 styles found
  1. 60% Off
    -60%
    MIDI PARACHUTE WHITE SKATER SKIRT
  2. 60% Off
    -60%
    Low-rise White Mock Buttons Skirt
  3. 60% Off
    -60%
    White Floral Lace Short Skater Skirt
  4. 60% Off
    -60%
    Low-rise White A-line Skater Skirt
  5. 60% Off
    -60%
    BLACK HIGH-WAIST SKATER MINI SKIRT
  6. 60% Off
    -60%
    WHITE HIGH-WAIST SKATER MINI SKIRT
  7. 60% Off
    -60%
    CONTRAST-EDGE PLEATED SKATER SKIRT
  8. 58% Off
    -58%
    A-LINE WHITE TULLE SKATER SKIRT
  9. 60% Off
    -60%
    RED HIGH-RISE SKATER SKIRT
  10. 60% Off
    -60%
    GOLD HIGH-RISE SKATER SKIRT
Page