We currently have a web site that needs updating. The way it is updated is via a csv file (attached). There are close to 100 manufacturers that have thousands of products. Each manufacturer is split up into its own spreadsheet. In the spreadsheet example provided, you will see what you will start with and how we need the file to be returned to us. References for the numbers' values will be provided (This will tell you the numeric value of a name,; after viewing the attached file, it'll make sense).
Another part of this project is that there are product names which need to be replicated, but the model number and option (color, size, etc) needs to be removed.
Example: Product Name modelnumber-1a Black product
Product Name modelnumber-1b White product
Result: Product Name modelnumber product
(A better example is in the attached file)
You must have experience with this. It is simply a matter of filtering columns and replacing a word with a number. Turn around time for each file should be, at most, 3 days. Over the length of time, there will be many files, so if you do a good job and are fast and accurate at this, then you will be awarded all data entry projects for the future.