We have a client with about 1 million SKUs in their catalog.
The challenge we are facing is how we can import/update this huge number of products in most effiicent way.
With initial running of our custom product import tool in the development environment, it takes 1 second to insert\update 2 SKUs. This means we need about 6 days to update the catalog :)
I will be optimistic and say that it would take 1 second to update 4 SKUs on production. Still, we will need about 3 days to update the whole catalog!
Our custom tool uses IContentRepository to create/update products.
We do not use CatalogEntryDto but VariationContent.
My questions are:
Did you read this blog post the other day https://world.episerver.com/blogs/Quan-Mai/Dates/2019/10/new-simple-batch-saving-api-for-commerce/?
Thanks Johan for your reply!
Unfortunately, this project is on version 12.17.2.
Now you have a reason to upgrade, or are you somehow locked to that specific version?
Agree with Johan. You have two choices, either use the CatalogImportExport which has unparellel import performance, or upgrading to 13.9 and use the new API. There is no other in-between options
Thank you both - I wanted to make sure there is no other alternatives.