Making Woocommerce optimized for more than 500k products

Please take a look at this answer: https://wordpress.stackexchange.com/a/64593/104427

Although I personally can’t recommend Magento, It is the way to go if you have a large set of products/data. In our case, Magento is handling 300.000 products quite well.