app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
  • Dresses 67 items
  • Tops 42 items
Styles
Styles
  1. Asymmetrical Dresses 81 items
  2. Blouses 86 items
  3. Body Suits 271 items
  4. Bodycon 544 items
  5. Cover Ups 22 items
  6. Crop Tops 299 items
  7. Denim Dresses 1 item
  8. Denim Tops 3 items
  9. Dungarees 3 items
  10. Flare Jeans 18 items
  11. Jumpsuits 126 items
  12. Maxi Dresses 343 items
  13. Maxi Skirts 33 items
  14. Maxi Tops 1 item
  15. Midi Dresses 148 items
  16. Midi Skirts 19 items
  17. Nightdresses 26 items
  18. Nightwear Set 89 items
  19. Off Shoulder Tops 47 items
  20. Off-shoulder And Bandeau Dresses 204 items
  21. Pencil Dresses 62 items
  22. Pencil Skirts 6 items
  23. Playsuits And Rompers 84 items
  24. Sets 635 items
  25. Shift Dresses 28 items
  26. Shirt Dresses 11 items
  27. Shirts 51 items
  28. Short And Mini Skirts 54 items
  29. Skater Dresses 119 items
  30. Skater Skirts 20 items
  31. Skinny Jeans 1 item
  32. Straight Jeans 35 items
  33. Swimsuit 120 items
  34. T-shirts 501 items
  35. Tunic Dresses 5 items
  36. Tunic Tops 2 items
  37. Vests And Camis 305 items
  38. Hipster 9 items
  39. Bikini 10 items
  40. Thong 87 items
  41. Cycling Short 1 item
  42. Sports 15 items
  43. T-Shirt Bra 3 items
  44. Bralette 16 items
  45. Sports Bra 4 items
  46. Collars 7 items
  47. Wrap Dresses 8 items
  48. Mom Jeans 3 items
  49. Baggy Jeans 5 items
  50. Vests 1 item
  51. Wide Leg Jeans 14 items
  52. Corsets & Tube Tops 274 items
  53. Cold Shoulder Tops 8 items
  54. Corset Dresses 50 items
Colour
Colour
  1. Beige 7 items
  2. Black 68 items
  3. Blue 20 items
  4. Brown 17 items
  5. Gold 2 items
  6. Green 18 items
  7. Grey 9 items
  8. Multi 9 items
  9. Orange 5 items
  10. Pink 24 items
  11. Purple 4 items
  12. Red 19 items
  13. Silver 2 items
  14. White 41 items
  15. Yellow 10 items
Less
Size
Size
  1. 1XL 2 items
  2. 2XL 3 items
  3. 3XL 1 item
  4. FS 1 item
  5. L 113 items
  6. M 113 items
  7. S 118 items
  8. XL 26 items
  9. XS 8 items
  10. XXL 1 item
Less
Price
Price
  1. Rs. 400 - 600 1 item
  2. Rs. 600 - 800 2 items
  3. Rs. 800 - 1000 1 item
  4. Rs. 1000 - 1200 9 items
  5. Rs. 1200 - 1400 10 items
  6. Rs. 1400 - 1600 16 items
  7. Rs. 1600 - 1800 18 items
  8. Rs. 1800 - 2000 24 items
  9. Rs. 2000 - 2500 28 items
  10. Rs. 2500 - 3000 11 items
  11. Rs. 3000 - 3500 5 items
  12. Rs. 3500 - 4000 1 item
  1. Asymmetrical Dresses Remove This Item
  2. Off Shoulder Tops Remove This Item
  3. White Remove This Item
  4. Red Remove This Item
  5. Black Remove This Item
  6. S Remove This Item
  7. XL Remove This Item

SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `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`, `at_special_price`.`value` AS `special_price` FROM `catalog_product_entity` 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_66224f5b2a3893_94332510` AS `search_result` ON e.entity_id = search_result.entity_id LEFT JOIN `catalog_product_entity_decimal` AS `at_special_price` ON (`at_special_price`.`entity_id` = `e`.`entity_id`) AND (`at_special_price`.`attribute_id` = '76') AND (`at_special_price`.`store_id` = 0) WHERE (stock_status_index.stock_status = 1) ORDER BY `special_price` DESC, `e`.`entity_id` DESC LIMIT 24

128 styles found
  1. 60% Off
    -60%
    EVERYTHING CLASSY RED SLIT DRESS
  2. 60% Off
    -60%
    Black Long Ruffle-detail Dress
  3. 60% Off
    -60%
    Black Asymmetrical Sequin Slim Dress
  4. 60% Off
    -60%
    Red A-line Midi Asymmetrical Dress
  5. 60% Off
    -60%
    White Bell Sleeve Asymmetrical Dress
  6. 60% Off
    -60%
    Asymmetrical Claret Long Dress
  7. 60% Off
    -60%
    Asymmetrical White Long Dress
  8. 60% Off
    -60%
    SEQUIN WHITE ASYMMETRICAL SLIM DRESS
  9. 60% Off
    -60%
    Red Plunging Irregular Hem Dress