I did run that command in our environment and database but issue remains with not able to add products to cart. I can randomly add some product but then it just wont work anymore.
Please pick a variable product and do the following:
During my tests I used Nutrolin® Puppy & Mom - 150ml and 265ml, you can try these steps with the 1000ml
1. Go to products
2. Edit a variable product ex. Nutrolin® Puppy & Mom
3. View the variables
4. switch from Set prices in other currencies manually (265ml $24.90) to Calculate prices in other currencies automatically and update the product (important to update the product)
5. Now try to add the product and it is added. (make sure you test with the variation you did the above switch to)
No effect. I tested this with puppy&mom as well the skin&coat. Original was manual price and I changed it to automatic and could not add the skin&coat.
I did some tests and everything worked fine until I changed the theme back to Flatsome. All plugins were in same "minimal" setup as left by you. So there is some issue with your plugin and Flatsome theme. Do note that the issue affects only your multicurrency plugin. They have updated near the date issue started appearing:
ENHANCEMENT: Added check for global $product object existence in flatsome_sticky_add_to_cart_template function.
ENHANCEMENT: Improved WPML configuration.
FIXED: Improved handling of non-existent attachment images.
FIXED: Shop category header title color with dark content.
FIXED: Undefined array key "limit" PHP warning in some cases.
UPDATED: Google Fonts list.
UPDATED: Language files.
I have escalated this to our second tier team, as I cannot locate a specific plugin causing this.
So far the only guess I can make based on all these steps we have taken is that the add-to-cart behavior works well when there are less plugins enabled (better performance ) but let's wait for our second tier team to take a look and i will update as soon as I have more information.
