We need somebody to work on a database we have of our products which we sell online. Please read this fully including the payment details below.
You will be supplied with the following:
1. A CSV file with three columns: EAN, manufacturer and name.
The manufacturer fields will be empty. 2951 EAN fields will be empty (ie, 201 will be filled). The name fields will all be filled with product name and manufacturer.
2. A CSV file with two columns: a list of manufacturer names and their code
1. Go through each product and remove the manufacturer from the name but add in the manufacturer code in the manufacturer column. If the manufacturer does not exist in the other list, add it in and create a code for it.
2. Go through each product that does not have an EAN-13 code and find one online and add it in. Sources include Google product search, Amazon and other EAN-13 databases. You won't find all of them, but a lot will be easy to get.
Your bid should be $30 - $75, but we will pay you much more than your bid.
For task 1 (sorting out the manufacturers) you will be paid your bid
For task 2, (finding the EANs) you will be paid your bid for every 500 EANs you find or part thereof.
Eg, if you bid $40 and do task 2 fully and then find 1350 EANs for task 2 you will be paid $40 + $40 + $40 + (350/500)*$40 = $148
If you have any questions please ask. Please also send a PM with your bid explaining how you will find the EANs and confirming you understand the payment structure. Further guidance (eg, specific examples from our data) will be provided to the winner.