Generating variants
The problem: As soon as you have to generate more than 1000 variants in the Administration, it always terminates with the error message Serialization failure: 1213 Deadlock found when trying to get lock . The problem can be found via Google very often in relation to Shopware 6 also, that if you ever want to generate more than 1000-2000 variants, it constantly aborts because of a database error.
It would be great if you can outsource the variant generation in the message queue, so that you do not have to actively leave the page open for hours for 100k products.
Maybe it would also be a possibility to save the generation as a kind of "order" and then trigger it via the console.
Not enough interest
We’re closing this idea because it has not received significant interest or activity over the past 12 months. This helps us keep the idea portal focused on the topics that are most relevant to our community.
Thank you for taking the time to submit and support it. We’ll continue to monitor customer needs and may reconsider the topic if interest grows in the future.