The attached CSV spreadsheet file is the input file to our online shop product importer.
The attached PDF file contains around 60 products (from a quick count) which are each to become a row in the said CSV file.
The website - [url removed, login to view] - also contains products details for each product in the CSV we are licensed as an onseller/vendor to also take products details verbatim from there.
So the job is to populate the 60ish products from trhe PDF file and nitecore website, into the CSV file.
The description fields (short and long) will need HTML5 formatting (ie: for new line and so on) as they will be displayed in webpages. If you use firebug or some other DOM analyzer then you may be able to copy/paste from the nitecore website).
The meta_description field is to be populated with the product title and short description, and the meta key_words field will contain some related keywords taken from the title and description fields.
The price field is to be taken from the RRP in the PDF and subjected to the following formula for tax, then rounded to 5 decimal places: -
product_price = ((RRP_from_PDF / 11) * 10)
So 100 bucks becomes 90.90909
Never Mind the various ID fields I will fill those.
The SKU must be unique, probably use the model number.
Never mind the images however after this I will pay someone to make 60 slides by chopping and cropping images from the PDF and the website so if your also a gun image editor we may be able to add that to this job. Or maybe even just pay you extra to collect the images for each products as you work on the CSV??
Also, ppl with the following skills are priceless to me and if you have any or all that will help my decision to hire you: -
- image manipulation ?
- programming skills ?
- database skills ?
- linux terminal (including via ssh client) ?
- HTML ?
- css ?
- Joomla ?
- eCommerce ?
Please only apply if you speak, read, and write fluent English.
Fix 2 hours at agreed rate, a good data entry person should smash this out easily in that time.
Thank you and regards,