Please review this article: https://www.superspeedyplugins.com/2018/06/30/wordpress-performance-quick-start-guide/

It will help you figure out where your slow performance is coming from. Hundreds of variations is not so many, so Scalability Pro + Redis object cache can help, but maybe you mean hundreds of variation options and underneath in the database this is actually 1000s of variations?

If so, then you should consider reworking your product variations. I had a look at this URL: https://myskincolombia.com/product/skin-adhesivo-premium-matrix-black-3m-para-celular/

https://i.imgur.com/uwUMNUz.png

It looks like you’re providing customisation options for the product purchased but it also looks like the product price does not change, nor does the image, so you should avoid using variations for these. Instead, you should use any of the Product Addons or Product Options plugins – these allow you to keep your product as a SIMPLE product and the options get submitted along with the order – that’s ideal for what you’re doing and will massively speed up your site.

You can see my similar answer here: https://www.superspeedyplugins.com/question/woocommerce-store-with-large-amount-of-variations/ – if you scroll to my latest comment on that answer you’ll see 4 or 5 plugin options to use addons or options instead of variations.