I replied to your other question before reading this one.
Hello unfortunately Ray passed away at the end of 2023 read the post https://www.webassist.com/forums/posts.php?id=47097 the forums and help are now just up to the community members on these forums. I just develop sites and have been working with WebAssist software for years. Ray always helped me as well as others. So am trying to help out when I can. I have used ecart software for a long time and I am very familiar with it. I have always used it with databases never static. What you're asking about the sizes can absolutely be corrected and done. I went to your site and tried to add multiple products and saw the problem you're having when changing sizes. Can you attach you store pages code, removing all personal info so the community can have a look and try to help.