Suggestion: Potentially link product variants to parent grouped product by SKU in product import

6 months ago
This is really a repeat of the suggestion made here: https://www.nopcommerce.com/boards/t/46520/issue-importing-grouped-products-and-proposed-possible-solution.aspx

The issue is that it is not possible to import new grouped products and new product variants in the same import file because the product variants require the id of the parent grouped product and you do not currently have this information available.

The relevant import fields we have (in the xlsx file are):
ProductId
ProductType ('Grouped Product' or 'Simple Product')
ParentGroupedProductId

As the link suggests, the workaround is to import the grouped product first, followed by importing the product variants in a separate file (after you have established the parent product id).

And as the link suggests, one possible solution could be to look up products instead by 'ParentGroupedProductSku' instead of 'ParentGroupedProductId' as you will have the SKU available at the time of compiling the complete import.
6 months ago
Thanks for the suggestion. Here is a work item.