app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Asymmetrical Dresses 175 items
  2. Beach Shorts 3 items
  3. Beach Tops 1 item
  4. Blouses 278 items
  5. Body Suits 419 items
  6. Bodycon 827 items
  7. Caps 7 items
  8. Cover Ups 143 items
  9. Crop Tops 675 items
  10. Cropped Jeans 2 items
  11. Denim Dresses 1 item
  12. Denim Tops 2 items
  13. Dungarees 9 items
  14. Flare Jeans 27 items
  15. Hats 6 items
  16. Joggers 6 items
  17. Jumpsuits 189 items
  18. Maxi Dresses 796 items
  19. Maxi Skirts 116 items
  20. Maxi Tops 7 items
  21. Midi Dresses 284 items
  22. Midi Skirts 82 items
  23. Nightdresses 86 items
  24. Nightwear Set 257 items
  25. Off Shoulder Tops 119 items
  26. Off-shoulder And Bandeau Dresses 390 items
  27. Pencil Dresses 60 items
  28. Pencil Skirts 13 items
  29. Playsuits And Rompers 146 items
  30. Ripped Jeans 1 item
  31. Sets 1088 items
  32. Shift Dresses 43 items
  33. Shirt Dresses 32 items
  34. Shirts 125 items
  35. Short And Mini Skirts 167 items
  36. Skater Dresses 336 items
  37. Skater Skirts 38 items
  38. Skinny Jeans 3 items
  39. Straight Jeans 55 items
  40. Swimsuit 178 items
  41. T-shirts 1028 items
  42. Tunic Dresses 8 items
  43. Tunic Tops 5 items
  44. Vests And Camis 930 items
  45. Gloves 2 items
  46. Hipster 49 items
  47. Bikini 51 items
  48. Boyshort 16 items
  49. Thong 204 items
  50. Boyleg 3 items
  51. Halter Neck Bra 2 items
  52. Front Open 10 items
  53. Full Figure 9 items
  54. Sports 11 items
  55. Racerback 3 items
  56. T-Shirt Bra 11 items
  57. Bralette 40 items
  58. Backless 1 item
  59. Padded 65 items
  60. Non Padded 23 items
  61. Sports Bra 4 items
  62. Collars 41 items
  63. Wrap Dresses 28 items
  64. Mom Jeans 3 items
  65. Baggy Jeans 8 items
  66. Boyfriend Jeans 3 items
  67. Vests 19 items
  68. Wide Leg Jeans 21 items
  69. Shawl 9 items
  70. Corsets & Tube Tops 420 items
  71. Cold Shoulder Tops 18 items
  72. Sarong 16 items
  73. Corset Dresses 76 items
  74. Dressing Gowns & Robes 17 items
  75. One shoulder Dresses 21 items
  76. One shoulder Tops 25 items
Colour
Colour
  1. Beige 133 items
  2. Black 613 items
  3. Blue 337 items
  4. Brown 255 items
  5. Gold 8 items
  6. Green 242 items
  7. Grey 155 items
  8. Maroon 3 items
  9. Multi 227 items
  10. Orange 71 items
  11. Pink 268 items
  12. Purple 80 items
  13. Red 169 items
  14. Silver 17 items
  15. White 390 items
  16. Yellow 100 items
Less
Size
Size
  1. 1XL 17 items
  2. 2XL 74 items
  3. 3XL 36 items
  4. 4XL 26 items
  5. 5XL 8 items
  6. 70A 10 items
  7. 70ABC-S 4 items
  8. 70B 11 items
  9. 70C 9 items
  10. 70D 8 items
  11. 70E 5 items
  12. 75A 10 items
  13. 75ABC-M 8 items
  14. 75B 11 items
  15. 75C 11 items
  16. 75D 9 items
  17. 75E 5 items
  18. 80A 8 items
  19. 80ABC-L 7 items
  20. 80B 11 items
  21. 80C 11 items
  22. 80D 9 items
  23. 80E 5 items
  24. 85B 11 items
  25. 85C 11 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 27 items
  33. L 978 items
  34. M 953 items
  35. S 904 items
  36. XL 362 items
  37. XS 39 items
  38. XXL 46 items
  39. XXS 1 item
  40. XXXL 1 item
  41. 0XL 8 items
Less
Price
Price
  1. Rs. 200 - 400 10 items
  2. Rs. 400 - 600 5 items
  3. Rs. 600 - 800 12 items
  4. Rs. 800 - 1000 21 items
  5. Rs. 1000 - 1200 39 items
  6. Rs. 1200 - 1400 90 items
  7. Rs. 1400 - 1600 139 items
  8. Rs. 1600 - 1800 142 items
  9. Rs. 1800 - 2000 97 items
  10. Rs. 2000 - 2500 265 items
  11. Rs. 2500 - 3000 202 items
  12. Rs. 3000 - 3500 92 items
  13. Rs. 3500 - 4000 40 items
  14. Rs. 4000 - 4500 10 items
  15. Rs. 4500 - 5000 5 items
  1. Skater Skirts Remove This Item
  2. Sets Remove This Item
  3. Mom Jeans Remove This Item
  4. Shift Dresses Remove This Item
  5. White Remove This Item
  6. Red Remove This Item
  7. 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_672fba42c6fd06_71024430` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `e`.`entity_id` DESC LIMIT 24

1172 styles found
  1. 60% Off
    -60%
    Black Two Piece Textured Co-ord Set
  2. 60% Off
    -60%
    Black Plus Size A-line Mini Skirt
  3. 60% Off
    -60%
    White Tube Top & Mini Skirt Set
  4. 60% Off
    -60%
    Red Tube Top & Mini Skirt Set
  5. 60% Off
    -60%
    Black Tube Top & Mini Skirt Set
  6. 60% Off
    -60%
    Black Tassel Hem Shift Dress
  7. 60% Off
    -60%
    Contrast Bow-knot Detail Shift Dress
  8. 60% Off
    -60%
    Free Size Red 2pc Upper Set
  9. 60% Off
    -60%
    Free Size Black 2pc Upper Set
  10. 60% Off
    -60%
    White Crew Neck Top & Wide Shorts
  11. 60% Off
    -60%
    Black Skater Skirt Comes W/ Belt
  12. 60% Off
    -60%
    Black Knotty Top With Pencil Skirt
  13. 60% Off
    -60%
    Red Button-up Shirt & Straight Pants
  14. 60% Off
    -60%
    Black Crop Top & Flare Pants