AnsweredAssumed Answered

CSV inbound data with multiple columns per product

Question asked by kellygoldsworthy on May 9, 2018
Latest reply on May 10, 2018 by rjvkuppeveld

I have a CSV file, which contains inventory levels and stock movements by location.

The file is structured that each line contains detail by location, with multiple product headings in the columns and the volumes then in the row.

File example

How do i go about mapping this to the various entities?

I have set up a product, movement and location entitities,  but as you can see from above the data contains multiple product entries per line.

Outcomes