Hey Novulo, how do I import a list that contains a secondary list?
In this case, I’ve got product data, and a field with individual pros and cons for each product. So how can I import this as a list?
The other data can be mapped quite neatly on specific products
Hey Bas,
I don’t see a way to import your Excel list in one go because of its formatting.
As a rule of thumb: Every row in an Excel list refers to a record, and every column to a field of that record.
So if you want to import the pros and cons you would first need to transform the data to the following format:
Product reference (SKU) | pro_con |
CSLUDX-0000C-01 | Comfortabele professionele training
CSLUDX-0000C-01 | Minimale belsting op de gewrichten
CSLUDX-0000C-01 | Breed scala aan trainingen
I would then recommend either using sequential imports (M3624) to trigger 2 import definitions or to just manually start two imports.
So in your case, you would first import all products, and then you would import the pros/cons that would be linked to the products that have been imported earlier.
I hope this helps!
Regards
Joachim
1 Like