AnsweredAssumed Answered

Importing orders csv from Woocommerce

Question asked by vitalseeds on Dec 3, 2018
Latest reply on Dec 4, 2018 by DonCollier

Hello Filemakers

 

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?

 

Many thanks

 

Fred

 

 

 

consistent and reliable way of doing it.CSV orders.JPG

Outcomes