app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Asymmetrical Dresses 122 items
  2. Beach Shorts 1 item
  3. Beach Tops 1 item
  4. Blouses 146 items
  5. Body Suits 341 items
  6. Bodycon 677 items
  7. Caps 8 items
  8. Cover Ups 133 items
  9. Crop Tops 429 items
  10. Cropped Jeans 2 items
  11. Denim Dresses 1 item
  12. Denim Tops 3 items
  13. Dungarees 4 items
  14. Earrings 1 item
  15. Flare Jeans 20 items
  16. Hats 6 items
  17. Jumpsuits 169 items
  18. Maxi Dresses 523 items
  19. Maxi Skirts 76 items
  20. Maxi Tops 6 items
  21. Midi Dresses 217 items
  22. Midi Skirts 71 items
  23. Nightdresses 73 items
  24. Nightwear Set 197 items
  25. Off Shoulder Tops 70 items
  26. Off-shoulder And Bandeau Dresses 243 items
  27. Pencil Dresses 58 items
  28. Pencil Skirts 8 items
  29. Playsuits And Rompers 110 items
  30. Ripped Jeans 1 item
  31. Sets 854 items
  32. Shift Dresses 29 items
  33. Shirt Dresses 21 items
  34. Shirts 60 items
  35. Short And Mini Skirts 107 items
  36. Skater Dresses 186 items
  37. Skater Skirts 28 items
  38. Skinny Jeans 3 items
  39. Straight Jeans 47 items
  40. Swimsuit 174 items
  41. T-shirts 678 items
  42. Tunic Dresses 7 items
  43. Tunic Tops 4 items
  44. Vests And Camis 620 items
  45. Wayfarers And Square Frame Sunglasses 1 item
  46. Gloves 3 items
  47. Hipster 20 items
  48. Bikini 36 items
  49. Boyshort 15 items
  50. Thong 161 items
  51. Boyleg 3 items
  52. Front Open 1 item
  53. Sports 10 items
  54. Racerback 1 item
  55. T-Shirt Bra 4 items
  56. Bralette 27 items
  57. Padded 8 items
  58. Non Padded 4 items
  59. Sports Bra 4 items
  60. Collars 41 items
  61. Wrap Dresses 22 items
  62. Mom Jeans 2 items
  63. Baggy Jeans 4 items
  64. Boyfriend Jeans 3 items
  65. Vests 1 item
  66. Wide Leg Jeans 16 items
  67. Neck Warmer 1 item
  68. Shawl 5 items
  69. Corsets & Tube Tops 347 items
  70. Cold Shoulder Tops 10 items
  71. Sarong 16 items
  72. Corset Dresses 57 items
  73. Dressing Gowns & Robes 11 items
Colour
Colour
  1. Beige 102 items
  2. Black 458 items
  3. Blue 258 items
  4. Brown 176 items
  5. Gold 6 items
  6. Green 196 items
  7. Grey 83 items
  8. Maroon 3 items
  9. Multi 221 items
  10. Orange 61 items
  11. Pink 224 items
  12. Purple 62 items
  13. Red 137 items
  14. Silver 17 items
  15. White 288 items
  16. Yellow 82 items
Less
Size
Size
  1. 1XL 13 items
  2. 2XL 49 items
  3. 3XL 29 items
  4. 4XL 26 items
  5. 5XL 9 items
  6. 70A 11 items
  7. 70ABC-S 5 items
  8. 70B 12 items
  9. 70C 10 items
  10. 70D 8 items
  11. 70E 5 items
  12. 75A 11 items
  13. 75ABC-M 8 items
  14. 75B 12 items
  15. 75C 12 items
  16. 75D 9 items
  17. 75E 5 items
  18. 80A 9 items
  19. 80ABC-L 8 items
  20. 80B 12 items
  21. 80C 12 items
  22. 80D 9 items
  23. 80E 5 items
  24. 85B 12 items
  25. 85C 12 items
  26. 85D 9 items
  27. 85E 5 items
  28. 90C 6 items
  29. 90D 6 items
  30. 95C 6 items
  31. 95D 6 items
  32. FS 14 items
  33. L 763 items
  34. M 750 items
  35. S 703 items
  36. XL 315 items
  37. XS 31 items
  38. XXL 57 items
  39. XXXL 1 item
  40. 0XL 5 items
Less
Price
Price
  1. Rs. 200 - 400 13 items
  2. Rs. 400 - 600 7 items
  3. Rs. 600 - 800 17 items
  4. Rs. 800 - 1000 38 items
  5. Rs. 1000 - 1200 22 items
  6. Rs. 1200 - 1400 76 items
  7. Rs. 1400 - 1600 130 items
  8. Rs. 1600 - 1800 104 items
  9. Rs. 1800 - 2000 86 items
  10. Rs. 2000 - 2500 165 items
  11. Rs. 2500 - 3000 123 items
  12. Rs. 3000 - 3500 65 items
  13. Rs. 3500 - 4000 26 items
  14. Rs. 4000 - 4500 5 items
  15. Rs. 4500 - 5000 6 items
  1. Skater Skirts Remove This Item
  2. Sets Remove This Item
  3. Racerback Remove This Item
  4. White Remove This Item
  5. Red Remove This Item
  6. Black 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`, `e`.`size_price`, `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=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_669f6d5e427b24_35500053` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `e`.`special_price` ASC, `e`.`entity_id` DESC LIMIT 24

883 styles found
  1. 80% Off
    -80%
    Side Zipper White Skater Skirt
  2. 80% Off
    -80%
    Side Zipper Black Skater Skirt
  3. 85% Off
    -85%
    TWO PIECE PU RED CO-ORD SET
  4. 85% Off
    -85%
    TWO PIECE BLACK SUMMER CO-ORD SET