I am reposting this as got a little confused. PLEASE VIEW THE CSV FIRST.
PLEASE ALSO NOTE I DON'T MIND WHETHER THERE IS A SCRIPT OUTSIDE OF WORDPRESS WHICH MODIFIES THE CSV WHICH IS THEN IMPORTED VIA WORDPRESS I JUST NEED A SOLUTION THAT WORKS AND IS SENSIBLE TO USE ON A DAILY BASIS.
I have an excel spreadsheet (csv) file which has a line with the main product with 16 columns, there is then lines below the main line with the variations. So for example a pair of shoes that sells in 6 sizes will be on seven lines. The first line will have the main information and then the six below would then have the individual sku code and the size and stock qty available.
I basically need all of this imported into woo commerce with each product becoming a variable product if required. (some products may just be one size)
As many as 3 of the columns will hold image URL which I will need to import into our system.
This will need to be able to be updated for stock qty on a regular basis as much as once per day so I need a system that will work like this.
I have already purchased the official import plugin that comes with woo commerce so I guess it needs to work with that in terms of mapping columns etc...
I need this project to be concluded and for full instructions on how to use the program to be written.
Any clarification required please ask