app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Asymmetrical Dresses 92 items
  2. Blouses 114 items
  3. Body Suits 283 items
  4. Bodycon 566 items
  5. Caps 12 items
  6. Cover Ups 28 items
  7. Crop Tops 351 items
  8. Cropped Jeans 1 item
  9. Denim Dresses 2 items
  10. Denim Tops 3 items
  11. Dungarees 1 item
  12. Flare Jeans 18 items
  13. Hats 6 items
  14. Jumpsuits 141 items
  15. Maxi Dresses 361 items
  16. Maxi Skirts 48 items
  17. Maxi Tops 1 item
  18. Midi Dresses 184 items
  19. Midi Skirts 62 items
  20. Nightdresses 70 items
  21. Nightwear Set 163 items
  22. Off Shoulder Tops 59 items
  23. Off-shoulder And Bandeau Dresses 216 items
  24. Pencil Dresses 79 items
  25. Pencil Skirts 7 items
  26. Playsuits And Rompers 92 items
  27. Ripped Jeans 1 item
  28. Sets 851 items
  29. Shift Dresses 31 items
  30. Shirt Dresses 23 items
  31. Shirts 70 items
  32. Short And Mini Skirts 57 items
  33. Skater Dresses 130 items
  34. Skater Skirts 28 items
  35. Skinny Jeans 1 item
  36. Straight Jeans 29 items
  37. Swimsuit 169 items
  38. T-shirts 646 items
  39. Tunic Dresses 11 items
  40. Tunic Tops 5 items
  41. Vests And Camis 329 items
  42. Wayfarers And Square Frame Sunglasses 2 items
  43. Gloves 2 items
  44. Hipster 26 items
  45. Bikini 62 items
  46. Boyshort 21 items
  47. Thong 306 items
  48. Cycling Short 1 item
  49. Boyleg 5 items
  50. Sports 14 items
  51. Racerback 2 items
  52. T-Shirt Bra 3 items
  53. Bralette 17 items
  54. Padded 3 items
  55. Non Padded 2 items
  56. Sports Bra 4 items
  57. Collars 45 items
  58. Wrap Dresses 12 items
  59. Mom Jeans 2 items
  60. Baggy Jeans 3 items
  61. Vests 1 item
  62. Wide Leg Jeans 15 items
  63. Neck Warmer 1 item
  64. Shawl 5 items
  65. Thongbody 1 item
  66. Corsets & Tube Tops 265 items
  67. Cold Shoulder Tops 11 items
  68. Sarong 12 items
  69. Corset Dresses 56 items
  70. Dressing Gowns & Robes 9 items
Colour
Colour
  1. Beige 52 items
  2. Black 418 items
  3. Blue 99 items
  4. Brown 87 items
  5. Gold 14 items
  6. Green 83 items
  7. Grey 60 items
  8. Maroon 4 items
  9. Multi 40 items
  10. Orange 22 items
  11. Pink 96 items
  12. Purple 28 items
  13. Red 96 items
  14. Silver 23 items
  15. White 132 items
  16. Yellow 14 items
Less
Size
Size
  1. 1XL 17 items
  2. 2XL 25 items
  3. 3XL 21 items
  4. 4XL 11 items
  5. FS 12 items
  6. L 608 items
  7. M 600 items
  8. S 614 items
  9. XL 149 items
  10. XS 48 items
  11. XXL 6 items
  12. XXXL 1 item
Less
Price
Price
  1. Rs. 600 - 800 5 items
  2. Rs. 800 - 1000 22 items
  3. Rs. 1000 - 1200 56 items
  4. Rs. 1200 - 1400 71 items
  5. Rs. 1400 - 1600 111 items
  6. Rs. 1600 - 1800 96 items
  7. Rs. 1800 - 2000 89 items
  8. Rs. 2000 - 2500 141 items
  9. Rs. 2500 - 3000 68 items
  10. Rs. 3000 - 3500 20 items
  11. Rs. 3500 - 4000 8 items
  12. Rs. 4000 - 4500 3 items
  13. Rs. 4500 - 5000 1 item
  14. Rs. 5000 - 5500 1 item
  1. Skater Skirts Remove This Item
  2. Bodycon Remove This Item
  3. Playsuits And Rompers Remove This Item
  4. White Remove This Item
  5. Red Remove This Item
  6. Black Remove This Item
  7. Multi 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`, `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_6605e1f6424cc2_38812693` 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

681 styles found
  1. 75% Off
    -75%
    HUGS PLEASE BLACK BODYCON DRESS
  2. 58% Off
    -58%
    A CASUAL ERRAND BLACK JUMPSUIT
  3. 58% Off
    -58%
    MOONLIGHT SEQUINED WHITE DRESS
  4. 58% Off
    -58%
    BODYCON RUCHED DETAIL RED PU DRESS
  5. 58% Off
    -58%
    POLYESTER MAXI BODYCON BLACK DRESS
  6. 58% Off
    -58%
    BACKLESS BLACK MAXI BODYCON DRESS
  7. 58% Off
    -58%
    MESH-WAIST BLACK BODYCON DRESS
  8. 58% Off
    -58%
    PU ONE-SHOULDER-STRAP BODYCON DRESS
  9. 75% Off
    -75%
    LET'S GO OUT BLACK JUMPSUIT
  10. 60% Off
    -60%
    PARTY HOURS BLACK BODYCON DRESS
  11. 58% Off
    -58%
    RED HALTER STRAP BODYCON DRESS
  12. 58% Off
    -58%
    SEQUIN RED LACE-UP BODYCON DRESS
  13. 60% Off
    -60%
    SATIN WHITE COWL-NECK BODYCON DRESS
  14. 60% Off
    -60%
    SATIN RED COWL-NECK BODYCON DRESS
  15. 60% Off
    -60%
    SATIN COWL-NECK BLACK BODYCON DRESS
  16. 58% Off
    -58%
    SLIM WHITE SEAMLESS PLAYSUIT
  17. 58% Off
    -58%
    PLUNGING LACE-UP BODYCON WHITE DRESS
  18. 59% Off
    -59%
    BLACK 3D PRINT MAXI BODYCON DRESS