Missing data when importing flat file
I am facing an issue when it comes to a data import. I want to build lists based on a flat file, and I get the file from another system, so I do not have option to modify the source file.
The file structure is like the one below:
|Catregory A||Product A|
|Category B||Product D|
|Category C||Product G|
Where Product A-C belongs to Category A, Product D-F to Category B and G-H to Category C.
My idea is to use product as unique identifier when importing into a technical import list, and then I have an import module where I import the data, to basically get the view above.
However, I need a way to assign the correct product category to the products where it is missing.
Would anyone know the best way to do this? Any help is appreciated 🙂
Thanks a lot!