I recently posted about parsing text from a woocommerce invoice into FM pro but have realized after talking with a few people that it would be much more efficient to import order data through a csv file instead.
The problem i am having - which i imagine is easily solvable when you know how - is that in my csv file (see below) there are many records for each order, so when i import it, i have e.g. 20 records of order number 2773.
What i need is to import the data and to have one record per order which then tells me all of the different products (SKUs) and the quantity and cost of each. Each SKU has a record in the database which then needs to be updated to the correct stock level.
Can anybody help me with this?