To create a spreadsheet template in Microsoft Excel that I can save as a CSV file in order to upload the data to Ebay UK with their bulk listing tool Turbo Lister. At the moment I am using a template that will hold 1500 stock items in each batch which seems to work well.
We are an online Music Seller and well sell Vinyl records, CD's and Music Magazines. For these items Ebay require 'Item Specifics' and a Condition field.
This involves exporting an item (one of my listings) from Turbo Lister as a CSV file - which will have all the required fields and information present and then using this information as the required template.
This is what I want to do ....
(1) Export my data (stock list) from my database as a text file.
(2) Import the data into an Excel spreadsheet (This is easily done by myself)
Then I need to get the data into the required format to fit the Turbo Lister template, which means making some changes to the data in Excel - such as concatenating some cells together, adding a further description. Then I need to save the Excel worksheet as a CSV file and import it into Turbo Lister ready to upload.
I do have a simple template that I created myself, but since Ebay made some changes to their Item Specifics and Condition fields, I have not been able to upload due to file errors, despite the information being in the CSV file, in the format that Turbo Lister requires!
I can send a copy of my current template on request.
We are ready to work on this project and to start immediately We have the requirements(tubo listing) to handle this project effectively and timely too.