We are updating our inventory management system, and need to create individual SKU's for each colour a product is available in. We currently use a generic SKU which gets edited to input the colour.
The SKU's are exported in a csv file, and edits are to be made in excel.
We are looking for a freelancer to use the csv file we provide with the product SKU's, and duplicate the SKU's for each individual product. There are 5 lists left to be done, each with 150-1000 original SKU's. Each orginal SKU could have 5-30 different colours that need to be created.
Example shown in attached image, as well as CSV file that would be used.