I'm working on a case where assortments are being imported into the Database via integration jobs.
Assortments are created in EcomAssortments, connected to the right shop in EcomAssortmentShop relations, products are added via EcomAsssormentProductRelations, and users can be assigned by EcomAssortmentPermissions
If I understand the structure correctly, the EcomAssortmentItems table wil be filled by the Build Assortments scheduled task?
We are seeing some unexpected behaviour, so my first step is to analyze if the imported data is correct, and if the build result is correct in EcomAssortmentItems.
What is the function of the AssortmentItemLanguageId column, and how is it populated? As far as I can see there is no way to influence for which languages the assortment is defined, because there is no languageId in EcomAssortmentProductRelations. I would then assume that the amount of products per LanguageId would be the same since all languages would be added, but while there are 2320 products in NLB in EcomProducts, somehow this results in 4914 records in the AssortmentItems table. For other languages there are other numbers, while in EcomProducts it is the same 2320 products in these languages.
