One for the EpiServer Commerce team - are there any recommended limits with regards to the amount of data Episerver Commerce can hold? 50,000 or 500,000 or 1million +? Obviously a lot depends on implementation of front-end/backend code but looking for information on how it scales?
There are no hard "product data limits." Many customers have live implementations that range upwards to 500k and above catalog entries. However, if you're going to have a large catalog, around 500k or more, there are performance considerations.
Here are a few general guidelines you can follow:
In addition to what Richly has already stated, you should also ensure that you have a good maintenance plan in place.
If you are dealing with a large number of products and their associated data you may want to investigate whether table partitioning will help improve performance.