app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Asymmetrical Dresses 128 items
  2. Beach Shorts 2 items
  3. Beach Tops 1 item
  4. Blouses 260 items
  5. Body Suits 440 items
  6. Bodycon 783 items
  7. Bracelets 21 items
  8. Caps 6 items
  9. Cover Ups 132 items
  10. Crop Tops 594 items
  11. Cropped Jeans 1 item
  12. Denim Tops 3 items
  13. Dungarees 3 items
  14. Earrings 74 items
  15. Flare Jeans 20 items
  16. Hats 4 items
  17. Jumpsuits 165 items
  18. Maxi Dresses 754 items
  19. Maxi Skirts 125 items
  20. Maxi Tops 7 items
  21. Midi Dresses 234 items
  22. Midi Skirts 74 items
  23. Necklace 19 items
  24. Nightdresses 201 items
  25. Nightwear Set 338 items
  26. Off Shoulder Tops 147 items
  27. Off-shoulder And Bandeau Dresses 430 items
  28. Pencil Dresses 49 items
  29. Pencil Skirts 15 items
  30. Pinafore 1 item
  31. Playsuits And Rompers 145 items
  32. Rings 22 items
  33. Ripped Jeans 1 item
  34. Sets 893 items
  35. Shift Dresses 53 items
  36. Shirt Dresses 32 items
  37. Shirts 156 items
  38. Short And Mini Skirts 190 items
  39. Skater Dresses 387 items
  40. Skater Skirts 41 items
  41. Skinny Jeans 2 items
  42. Straight Jeans 36 items
  43. Swimsuit 196 items
  44. T-shirts 955 items
  45. Tunic Dresses 8 items
  46. Tunic Tops 4 items
  47. Vests And Camis 907 items
  48. Gloves 1 item
  49. Hipster 30 items
  50. Bikini 50 items
  51. Boyshort 8 items
  52. Thong 183 items
  53. Boyleg 2 items
  54. Halter Neck Bra 2 items
  55. Front Open 10 items
  56. Full Figure 8 items
  57. Sports 11 items
  58. Racerback 3 items
  59. T-Shirt Bra 9 items
  60. Bralette 34 items
  61. Backless 1 item
  62. Padded 61 items
  63. Non Padded 20 items
  64. Sports Bra 4 items
  65. Collars 35 items
  66. Wrap Dresses 22 items
  67. Waist Chains 5 items
  68. Mom Jeans 3 items
  69. Baggy Jeans 4 items
  70. Boyfriend Jeans 2 items
  71. Vests 8 items
  72. Wide Leg Jeans 13 items
  73. Shawl 6 items
  74. Corsets & Tube Tops 365 items
  75. Cold Shoulder Tops 39 items
  76. Sarong 13 items
  77. Corset Dresses 60 items
  78. Dressing Gowns & Robes 73 items
  79. Full Length Sets 1 item
  80. Short Length Sets 2 items
  81. One shoulder Dresses 65 items
  82. One shoulder Tops 62 items
  83. Track Pants & Joggers 1 item
  84. Sweatshirts & Hoodies 1 item
  85. Leggings & Jeggings 1 item
  86. Swim Dress 7 items
Colour
Colour
  1. Beige 270 items
  2. Black 1176 items
  3. Blue 490 items
  4. Brown 459 items
  5. Gold 15 items
  6. Green 324 items
  7. Grey 368 items
  8. Maroon 3 items
  9. Multi 339 items
  10. Orange 75 items
  11. Pink 402 items
  12. Purple 107 items
  13. Red 253 items
  14. Silver 12 items
  15. White 973 items
  16. Yellow 125 items
Less
Size
Size
  1. 0Y-1Y 1 item
  2. 1XL 37 items
  3. 1Y-2Y 1 item
  4. 2XL 236 items
  5. 2Y-3Y 1 item
  6. 3XL 146 items
  7. 3Y-4Y 1 item
  8. 4XL 35 items
  9. 5XL 7 items
  10. 70A 9 items
  11. 70ABC-S 3 items
  12. 70B 10 items
  13. 70C 8 items
  14. 70D 7 items
  15. 70E 4 items
  16. 75A 9 items
  17. 75ABC-M 6 items
  18. 75B 10 items
  19. 75C 10 items
  20. 75D 8 items
  21. 75E 4 items
  22. 80A 7 items
  23. 80ABC-L 6 items
  24. 80B 10 items
  25. 80C 10 items
  26. 80D 8 items
  27. 80E 4 items
  28. 85B 10 items
  29. 85C 10 items
  30. 85D 8 items
  31. 85E 4 items
  32. 90C 5 items
  33. 90D 5 items
  34. 95C 5 items
  35. 95D 5 items
  36. FS 115 items
  37. L 1709 items
  38. M 1737 items
  39. S 1476 items
  40. XL 758 items
  41. XS 71 items
  42. XXL 148 items
  43. XXS 1 item
  44. 0XL 7 items
Less
Price
Price
  1. Rs. 0 - 200 2 items
  2. Rs. 200 - 400 10 items
  3. Rs. 400 - 600 42 items
  4. Rs. 600 - 800 86 items
  5. Rs. 800 - 1000 194 items
  6. Rs. 1000 - 1200 111 items
  7. Rs. 1200 - 1400 245 items
  8. Rs. 1400 - 1600 241 items
  9. Rs. 1600 - 1800 232 items
  10. Rs. 1800 - 2000 231 items
  11. Rs. 2000 - 2500 527 items
  12. Rs. 2500 - 3000 259 items
  13. Rs. 3000 - 3500 7 items
  14. Rs. 3500 - 4000 1 item
  15. Rs. 4000 - 4500 1 item
  1. Skater Skirts Remove This Item
  2. Sets Remove This Item
  3. T-shirts Remove This Item
  4. Blouses Remove This Item
  5. White 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_67b5388fe53057_06574725` 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

2149 styles found
  1. 60% Off
    -60%
    Black Sheer Full Sleeve Blouse Top
  2. 60% Off
    -60%
    White Sheer Full Sleeve Blouse Top
  3. 60% Off
    -60%
    Polyamide Blend V-neck Black Tee
  4. 60% Off
    -60%
    Black Beachwear Slit Top & Skirt
  5. 60% Off
    -60%
    Black Swim Dress & Beachwear Bottoms
  6. 60% Off
    -60%
    White 3pc Beachwear Set
  7. 60% Off
    -60%
    White Textured Bikini Top & Bottoms
  8. 60% Off
    -60%
    Black Bikini Top & Bottoms
  9. 60% Off
    -60%
    Black Strappy Bikini Top & Bottoms
  10. 60% Off
    -60%
    Black Free Size Full Sleeve Blouse
  11. 60% Off
    -60%
    Free Size Full Sleeve Blouse