Closed

I need products adding to a spreadsheet in correct format ready for upload to website

Existing Website - [url removed, login to view]

My client would like to upload a new selection of products to his website, we will upload this by importing a correctly formatted CSV file with all of the products on. Just to make this clear I am looking for help with creating the CSV file, not the upload.

The products that are being uploaded are all of the products from a new supplier - Draper Tools - [url removed, login to view] . They provide us with a read-only FTP link into their server where we can download all of the information, images, videos, pricing info, product database in various formats and we need all of the information taking from their provided info and adding correctly into the format needed so that we can upload onto my client website.

All of the images are correctly named and follow a single naming convention so this should be very easy to do, anyone with moderate excel/CSV skills and a basic understanding of how these type of upload sheets work will recognise that this is a simple, quick task for the right person.

Please price sensibly, I'm not after anything complex!

i have attached two files,

file 1 new client format = this is the client's format, everything above the yellow line is what an export looks like from their server

file 2 [url removed, login to view] = this is the draper file that we have been working on, the columns in green we have a match for but the columns in red we don't, this is either because it's not needed for the new format or because the data need manipulating into a suitable format. for example, we need data for the size column in the new format which is in with the description in the draper format, so we need the size pulling from the description where it's available

Also, i should just add that we are actively looking for a virtual team of people for repeat constant business in all fields.

Skills: Excel, jQuery / Prototype, MySQL, PHP, Python

See more: I need an experienced freelancer to fix some bugs on existing websites and an app, I need a Technical Content Writer for blog and website, I need someone to fix and promote my wix website, I need a freelancer to help me with PHP. My budget is around ₹1,500 - ₹12,500 INR and I need this to be done within 3 days. , I need you to write some content for a website, I need to design 3 (three) mockups for the website., what do i need to do in order to create a website of my own, i need a teacher to correct my writing, i need urgent help to complete a one-page website (pretty simple) it has a prototype currently 20% completed, i need to hire a contant writer for adsense website, i need someone to install paidtoclick script in my website, i need free professional freelance help to start a website, i need a web designer to finish my weebly website, i have an excel spreadsheet that needs some final touches to be ready i need an absolute expert at working an excel, ready upload website

About the Employer:
( 0 reviews ) Swindon, United Kingdom

Project ID: #15419219

8 freelancers are bidding on average £20 for this job

adhikarypalash9

Hello sir, I am a experienced freelancer to do any type of job I have a big team we do various types of job we also interested with data entry project. Relevant Skills and Experience *Word to excel *Spreadsheet with More

£20 GBP in 0 days
(65 Reviews)
5.4
Data1234

Hello, I have checked the attached files. But still not sure which is the template to be followed for adding products to spreadsheet. Is it above the Yellow line format which is to be followed? I have done similar wo More

£18 GBP in 5 days
(31 Reviews)
4.9
£20 GBP in 1 day
(18 Reviews)
4.7
£18 GBP in 1 day
(9 Reviews)
3.7
salneosana

The project description appears to be an exciting task, however I was unable to open the second draper file. The main thing as per instruction is to extract data from description. I am able to do this Relevant Skills More

£20 GBP in 1 day
(4 Reviews)
3.0
OLIVEFER56

Hey, I am an Academic writer, with 2 years of experience with skills at graphic design and illustration. I read your project and I believe I can help you with this task. I have notable experience in writing contents fo More

£33 GBP in 4 days
(2 Reviews)
2.7
mpunn2007

A proposal has not yet been provided

£14 GBP in 2 days
(5 Reviews)
2.7
abhay1182

Hi , Hope you are doing well. I have taken a look at your task and I have confidence that we can work together, I have lot of exp in this area. so give us a chance to work with you. Once you give as a chance to serv More

£18 GBP in 1 day
(10 Reviews)
2.3