app-download-header
24 Hours Sale - 95% Off on Everything
20% OFF on Buy 4 any items, Use Code: MERRY
20% OFF on Buy 4 any items
Use Code: MERRY
HR
:
MN
:
SC
ENDS IN

Women

Filter
Shopping Options
Category
Category
  • Dresses 20 items
Styles
Styles
  1. Asymmetrical Dresses 18 items
  2. Blouses 16 items
  3. Body Suits 49 items
  4. Bodycon 96 items
  5. Crop Tops 24 items
  6. Cropped Jeans 1 item
  7. Culottes 1 item
  8. Denim Dresses 3 items
  9. Flare Jeans 30 items
  10. Jumpsuits 7 items
  11. Maxi Dresses 34 items
  12. Maxi Skirts 2 items
  13. Midi Dresses 17 items
  14. Midi Skirts 5 items
  15. Nightwear Set 11 items
  16. Off-shoulder And Bandeau Dresses 33 items
  17. Pencil Dresses 7 items
  18. Pencil Skirts 1 item
  19. Playsuits And Rompers 4 items
  20. Ripped Jeans 3 items
  21. Sets 61 items
  22. Shift Dresses 9 items
  23. Shirts 6 items
  24. Short And Mini Skirts 11 items
  25. Skater Dresses 27 items
  26. Skater Skirts 16 items
  27. Skinny Jeans 2 items
  28. Straight Jeans 72 items
  29. Swimsuit 21 items
  30. T-shirts 47 items
  31. Tunic Dresses 0 items
  32. Tunic Tops 1 item
  33. Vests And Camis 61 items
  34. Thong 6 items
  35. Bralette 7 items
  36. Wrap Dresses 2 items
  37. Mom Jeans 1 item
  38. Baggy Jeans 1 item
  39. Wide Leg Jeans 44 items
  40. Corsets & Tube Tops 121 items
  41. Corset Dresses 18 items
Colour
Colour
  1. Beige 2 items
  2. Black 2 items
  3. Blue 2 items
  4. Brown 1 item
  5. Green 3 items
  6. Multi 1 item
  7. Pink 2 items
  8. Red 3 items
  9. Silver 1 item
  10. White 3 items
Less
Size
Size
  1. 1XL 5 items
  2. 2XL 24 items
  3. 3XL 13 items
  4. 4XL 2 items
  5. L 177 items
  6. M 178 items
  7. S 175 items
  8. XL 71 items
  9. XS 16 items
  10. XXL 3 items
Less
Price
Price
  1. Rs. 1200 - 1400 1 item
  2. Rs. 1400 - 1600 1 item
  3. Rs. 1600 - 1800 1 item
  4. Rs. 1800 - 2000 3 items
  5. Rs. 2000 - 2500 5 items
  6. Rs. 2500 - 3000 5 items
  7. Rs. 3000 - 3500 1 item
  8. Rs. 3500 - 4000 2 items
  9. Rs. 5000 - 5500 1 item
  1. Asymmetrical Dresses Remove This Item
  2. Tunic Dresses Remove This Item
  3. XS Remove This Item
  4. 4XL 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=469 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_660671b4a76107_95515103` 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` ASC, `e`.`entity_id` DESC LIMIT 24

20 styles found
  1. 60% Off
    -60%
    White Asymmetrical Beach Dress
  2. 58% Off
    -58%
    ROSE-RED HOLLOW ASYMMETRICAL DRESS
  3. 60% Off
    -60%
    SEQUIN WHITE ASYMMETRICAL SLIM DRESS
  4. 60% Off
    -60%
    Dark Green Diagonal Hem Long Dress
  5. 60% Off
    -60%
    WHO DOESN’T LOVE KHAKI WINTER DRESS