Hello, it seems my products won’t show up on the website even if they are visible into the editor mode, it seems that after i take the product, remove it category, then update it back it will show up but I have a few hundreds of products..
Please deactivate all the 3rd party plugins and activate only theme-required plugins on the site and then check the issue. I am sure your issue will be solved. Then Activate the 3rd party plugins one by one and check which plugin is creating the issue for you.
Otherwise, if the issue still exists then keep the 3rd party plugins deactivated and let me know I will further check on your site and give you a possible solution.