app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Asymmetrical Dresses 123 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 244 items
  27. Pencil Dresses 58 items
  28. Pencil Skirts 8 items
  29. Playsuits And Rompers 110 items
  30. Ripped Jeans 1 item
  31. Sets 855 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 679 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 136 items
  2. Black 787 items
  3. Blue 246 items
  4. Brown 193 items
  5. Gold 17 items
  6. Green 229 items
  7. Grey 77 items
  8. Maroon 5 items
  9. Multi 149 items
  10. Orange 71 items
  11. Pink 271 items
  12. Purple 73 items
  13. Red 228 items
  14. Silver 31 items
  15. White 381 items
  16. Yellow 72 items
Less
Size
Size
  1. 1XL 34 items
  2. 2XL 72 items
  3. 3XL 50 items
  4. 4XL 26 items
  5. 5XL 12 items
  6. FS 35 items
  7. L 1217 items
  8. M 1198 items
  9. S 1190 items
  10. XL 303 items
  11. XS 81 items
  12. XXL 52 items
  13. XXXL 8 items
  14. 0XL 7 items
Less
Price
Price
  1. Rs. 200 - 400 5 items
  2. Rs. 400 - 600 14 items
  3. Rs. 600 - 800 34 items
  4. Rs. 800 - 1000 64 items
  5. Rs. 1000 - 1200 39 items
  6. Rs. 1200 - 1400 94 items
  7. Rs. 1400 - 1600 183 items
  8. Rs. 1600 - 1800 182 items
  9. Rs. 1800 - 2000 192 items
  10. Rs. 2000 - 2500 345 items
  11. Rs. 2500 - 3000 147 items
  12. Rs. 3000 - 3500 64 items
  13. Rs. 3500 - 4000 28 items
  14. Rs. 4000 - 4500 4 items
  15. Rs. 4500 - 5000 1 item
  1. Skater Skirts Remove This Item
  2. Bodycon Remove This Item
  3. Blouses Remove This Item
  4. Wrap Dresses Remove This Item
  5. Maxi Dresses Remove This Item
  6. White Remove This Item
  7. Red Remove This Item
  8. 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_669f65baed6ea0_51872219` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `cat_index_position` ASC, `cat_index`.`position` ASC, `e`.`entity_id` DESC LIMIT 24

1396 styles found
  1. 60% Off
    -60%
    Black Lace-up & Cut-out Detail Dress
  2. 60% Off
    -60%
    Surplice Neck Red Sequin Drape Dress
  3. 60% Off
    -60%
    Backless Black Fishtail Sequin Dress
  4. 60% Off
    -60%
    Black Embellished Cut-out Dress
  5. 60% Off
    -60%
    Red Printed U-neck Lace-trim Dress
  6. 60% Off
    -60%
    Black Drop Waist Bubble Dress
  7. 60% Off
    -60%
    White Drop Waist Bubble Dress
  8. 60% Off
    -60%
    Red Strappy Short Slip Dress
  9. 60% Off
    -60%
    Black Strappy Short Slip Dress
  10. 60% Off
    -60%
    White Strappy Short Slip Dress
  11. 60% Off
    -60%
    White Halter Draped Dress
  12. 60% Off
    -60%
    White Mandarin V-neck Top
  13. 65% Off
    -65%
    Black Asymmetric Bodycon Dress
  14. 60% Off
    -60%
    Drape-effect Plus Size Maxi Dress
  15. 60% Off
    -60%
    Dark Red Dangling Cowl Neck Dress