I have a CSV file with around 3500 product lines.
Each line in the CSV file is a variation of a product. The hierarchy is something like this:
--Size 32 Red Jacket
--Size 34 Red Jacket
--Size 36 Red Jacket
--Size 32 Blue Jacket
--Size 34 Blue Jacket
--Size 36 Read Jacket
...and so on.
So each line will be a different SKU, for example:
123456, Jacket, Blue, 32
123457, Jacket, Blue, 34
123458, Jacket, Blue, 36
...and so on
Each line in the CSV file needs stock control.
I need visitors to go to the Jacket product, select a colour and size. They should only be able to add the product to the cart if that permutation is in stock.
What I would like is for someone to import the CSV file so that Virtuemart is populated with all the products with their stock levels.
This part will be a one off exercise but then there will be some further work afterwards to ensure that the stock levels are synchronised with their EPOS software.
The attached file shows the structure of the CSV. This MIGHT change slightly but shows sufficient details for scoping this project.
I'm looking to get started in this right away but I need to be 100% sure that whoever applies can get this done in a timely manner.