At the basic level technically, the Magento products database does not impose any product limits. Theoretically, Magento can handle millions of SKUs.
However, there are other considerations which may reduce the performance of the Magento database, such as:
- Number of Magento Stores
- Corresponding languages
- Range of product attributes
- Amount of configurable/bundle products
- Number of categories and depth of the category tree
- Customer groups with different product prices
- Server set up
But all in all your Magento store will safely run with following product amounts:
Magento CE 1.9.x safely manages – 10,000 – 25,000 products in most cases, without much extra care. And on another hand, with more heavy system-wide scaling, resources tuning code optimisation, it can manage 100,000 – 200,000 products.
Magento 2 CE safely manages – 100,000 – 200,000 products in most cases, without much scaling and extra care, and with proper scaling, optimisation and server resources, it can manage 400,000 – 500,000 products.
Contact firstname.lastname@example.org, if you need any help with you Magento ecommerce or web development.