There are some sites with a large amount of products but I would have to seach for them. Quote: on a basic level, WooCommerce can hold 1 million products with some changes to storage.
The real question you want to ask is around order processing.
You can have 1 million products loaded on your site and 1 sale a day, your site will have hardly any problems as long as you don’t load many products on each page the customer visits.
In other words my question could be if I have one million photos and a few orders per day, would this be doable?