We have a website that sells jewelry, and on this website, we have approximately 20,000 products. For each product, there are approximately 10,000 variants, such as:
Color: Blue, Black, Red, Pink, Purple
Size: S, M, L, XL, XS
Number: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30
When we try to create about 10,000 variants for one product as a customizable option, we encounter a timeout error.
To overcome this issue, what should we do?
Additionally, we have considered the following: We can open customizable options within the product, allowing users to make selections. However, when we add customizable options for one product, we still need to do it individually for other products. How can we do this more efficiently?
I have been experiencing the same problem for a long time. I sell jewelry with gemstone variations, and one of my products has 17,000 variants. No matter what I do, I can't upload the product.
To overcome timeout errors and manage product variants more efficiently:
10 000 variants is A LOT. Are you creating custom options on a simple product or a configurable product with simple products as variants?
Have you tried increasing your max_input_time, max_input_vars and post_max_size settings of your server (in php.ini)?
We create products as configurable product. Then we add other features of the product by saying create configuration below. This creates thousands of products in magento. We want to add options like enamel color, mineral color and size of a product. We increased max_input_time, max_input_vars and post_max_size values on the server. Although these helped us reduce processing times and speed up, they did not completely solve the timeout problem. I don't have a problem with the magento system I installed locally. By the way, the maximum number of products we see when adding variants is 16000. We also use nginx server on debian 11. Dns is routed through cloudflare. We still haven't solved the problem completely.
Oh you're making configurable products, not just custom options on a simple product... The thing is 20k products * 10k variants is really close to the recommended limit of effective SKUs you can have for Magento 2. - https://support.magento.com/hc/en-us/articles/360045066791-Product-limits-best-practice
If you have multiple websites or multiple customer groups that ads another multiplier to this number.
It's not impossible to run even 10x or 100x what you're attempting to do, but that will require some serious optimization on the code and infrastructure level to make it work.