Project Detail

.CSV Format needs Modifying for Ebay/Ioffer.com listings  

.CSV Format needs Modifying for Ebay/Ioffer.com listings is project number 458989
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: MustafaSR

Budget: $30-250

Created: 06/27/2009 at 22:45 EDT

Bid Count: 14

Average Bid:
$ 114

06/28/2009 at 22:45 EDT

Project Creator: jwaggene1
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (3 reviews)

Bid On This Project
 

Description

I have a .csv file for my ebay listings. I created it with turbolister.
I don't know how to change it to something that I can use with ioffer.com and use their bulk uploader. I need to get the .csv in here. Does anybody know if the modifying can be done for the .csv file I have, its like 70mb and contains 835 active Ebay listings all there, just not the way I need it. I can somebody if they can help me resolve this and can offer me the answer/solution to my problem.
If you need to see what I have, we can work something out and I can send it to you and you can upload and see if it is possible to do. I have it saved or maybe I can work out something where you can get my information through my account.

Using a spreadsheet application, such as Microsoft Excel, makes it even quicker:
From the File menu select Save As.
In the Save as type pull-down menu, select CSV (Comma Delimited).
Enter a file name and click Save. Make sure you remember where the file is saved.

The first row must have the following required headers:
Header Name Value
category Category ID number that specifies the category on iOffer. Click here to find the correct category ID number.
title Descriptive item listing title (55 character limit)
description Detailed item description (HTML supported)

Note: The Bulk Uploader is case sensitive. Make sure your category headers are lower case and use an underscore for spaces.

These headers are highly recommended:
Header Name Value
price Asking price per item (Make Offer if left blank)
quantity Quantity of the item for sale (single quantity if left blank)
shipping Shipping cost within United States (See Description if left blank)
shipping_profile Name of the shipping profile for the item. Learn more
brand Brand of the item (i.e. Sony, Samsung, Microsoft)
condition Condition of the item (needs to be either new, used, or refurbished)
product_type Type of product (i.e. camera, chair, video game)
image1 Hosted image URL of the first image
image2 Hosted image URL of the second image
image3 Hosted image URL of the third image
keyword1 Item-related keyword (2 word maximum)
keyword2 Item-related keyword (2 word maximum)
keyword3 Item-related keyword (2 word maximum)
keyword4 Item-related keyword (2 word maximum)

What is the Bulk Uploader?

The Bulk Uploader lets you upload multiple items to your iOffer store. Simply create and upload a comma separated values (.CSV) file with all the information for your items. Your items will be processed and become available within 24 - 48 hours.

How do I start using the Bulk Uploader?

In order to use the Bulk Uploader, a seller account is required. If you have not done so, please upgrade to a seller account by placing a credit card on file or pre-paying $20.00 from your PayPal account for verification purposes.

Once you have a seller account, create and upload a .CSV file with the information for your items. The Bulk Uploader reads the file and creates item listings according to the information in the file.

What is a .CSV file?

A comma separated values (.CSV) file is a specially formatted spreadsheet file created in applications like Excel. It is often used to transfer a large volume of data, containing multiple records and fields separated by commas.

In your .CSV file, the first row is reserved for category headers (i.e. Title, Description, Price). Starting with the second row, each row represents an item and each column represents a category.

Download a sample .CSV file

What are the rules for a .CSV file?

If you're using a standard spreadsheet application like Excel, the formatting rules will be set. You only need to save it as a .CSV file.

If you're using a text editor that doesn't format automatically, you need to follow these rules:

All fields for each item must be separated by commas.
If you have commas within a field, you need to separate that field with double quotes (i.e. One,Two,"Three,Four,Five",Six).
If you don't have any commas in a field, double quotes is not necessary.
If there are quotes within a field, the entire field needs to be quoted. An extra set of quotes for the quoted data is required also (i.e. A,B,"C ""Special Edition""",D).
If you leave a field blank, make sure there is an extra comma as a placeholder (i.e. 1,2,,4).
Remember, each item must be on their own line.

What are the required category headers in my .CSV file?

The following category headers are required on the first row:

category - category ID number that specifics the category on iOffer
title - descriptive item listing title (55 character limit)
description - detailed item description (HTML supported)
NOTE: The Bulk Uploader is case sensitive. Make sure your category headers are lower case and use an underscore for spaces.


What are the recommended category headers in my .CSV file?

price - asking price per item(Make Offer if left blank)
quantity - quantity of the item for sale (single quantity if left blank)
shipping - shipping cost within the United States (See Description if left blank)
brand - item brand (i.e. Sony, Apple, Microsoft)
condition - item condition (new, used, or refurbished)
product_type - type of product (i.e. camera, chair, video game)
image1 - hosted image URL of the first image
image2 - hosted image URL of the second image
image3 - hosted image URL of the third image
keyword1 - item-related keyword (2 words maximum)
keyword2 - item-related keyword (2 words maximum)
keyword3 - item-related keyword (2 words maximum)
keyword4 - item-related keyword (2 words maximum)
NOTE: The Bulk Uploader is case sensitive. Make sure your category headers are lower case and use an underscore for spaces.




How do I find the category ID for each item?

In order for the Bulk Uploader to know where to list each of your items, you need to provide a Category ID that corresponds to that category. For example, the Category ID for Women's Clothing and Accessories is 127000.

Search for the correct Category ID when you create your .CSV file.




How do I add images in my bulk upload file?

Images can be added to your bulk upload, but they must be hosted on another web server.

To add images to your item listings in your .CSV file, use the image category headers (image1, image2, image3) and add the hosted image URLs in those fields.



How do I save my file as a .CSV file?

After your spreadsheet is complete, follow the instructions below to save it as a .CSV file:

Click File and select Save As.
In the Save as type pull-down menu, select CSV (Comma Delimited).
Enter a file name and click Save. Make sure you remember where the file is saved.
A pop up message like this may appear: The selected file type does not support workbooks that contain multiple spreadsheets. Click OK.
To minimize errors, open the file in a plain-text reading program like Notepad or TextEdit. Double check your file and make sure there are no extra quotes or commas, other than between fields. Make sure category headers are lower case.




How do I upload my .CSV file?

The Bulk Uploader is located under My iOffer > Selling > Bulk Uploads.

Click Upload File.
Click Browse to locate your .CSV file.
Check Make items available immediately to automatically activate your items after they're processed.
Check Create new items only to update existing items with no buyer activity.
Submit the file.
You don't need to remain on the page for the system to process your items. Check back periodically to view the file progress.




Why is my bulk upload taking so long?

Depending on the number of bulk upload requests processed each day, there can be a delay in your bulk upload. Rest assured that your bulk upload file will be fully committed in 24 - 48 hours.




How do I avoid common mistakes using the Bulk Uploader?

One common mistake in bulk uploads is the use of duplicate titles.

Please use different titles to list your items. If you have identical item, update its quantity field.

Messages Posted:0 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

250

2 days

06-28-2009 06:27 EDT

VALUEONWEB is a customer-specific service oriented company has got a Professional and creative team. We are the Professional Web Development Company having rich experience in Web design and development. We have expertise and experience in ecommerce site development, flash and animation. Our team can work on HTML,DHTML, JAVA SCRIPT, FLASH , ASP,ASP.NET,PHP,MY SQL, SQL Server, MS SQL. Our Bid includes development , deployment and testing. We are ready to start and send daily reports. we communicate through email,messenger,phone and skype.We will a deliver a professional looking design(s) with proposed functionality to match your concept.

help

 

250

2 days

06-28-2009 03:13 EDT

Hi, I can fix it for you. Check PM

help

 

100

1 day

06-28-2009 04:00 EDT

Pls check PM

help

 

250

7 days

06-28-2009 12:31 EDT

Hi Please check pm.

help

 

229.95

4 days

06-28-2009 04:38 EDT

Greetings California from Pennsylvania.. {smile} I have extensive CSV data transformation and loading experience. I'm certain I can help. Hello my name is Bill.. I am a MsExcel, MsAccess, VB6, SQL, VB.Net, VBA, VBScript, and Windows programming Expert, Leader and Mentor [screenname:wsh2] at www.vbcity.com and www.experts-exchange.com. I have successfully completed quite a few GAF projects, so you can find additional references for me here: http://elance.com/users/feedback_172391.html I have 20+ years of hands-on Programming and Business Information System experience to include many CSV business file transformations such as yours. I have a BS in Accounting with a Marketing Minor and graduated college with the highest of honors. I am located in Easton PA USA (halfway between Philadelphia and New York City). American english is my only language. I look forward to assisting you in achieving all of your goals in this endeavor. Respectfully, Bill.

help

 

50

0 days

06-28-2009 08:55 EDT

Lets do it.

help

 

90

2 days

06-28-2009 04:37 EDT

Hi, I have strong knowledge and extensive experience in development & designing. Please check PMB to see my past experience. Regards, Williams.

help

 

30

1 day

06-28-2009 13:54 EDT

Please check PMB

help

 

60

1 day

06-28-2009 02:52 EDT

Hi Please refer my PMB Regards

help

 

150

2 days

06-28-2009 09:48 EDT

Hi, Thank you for considering our bid. We took this opportunity as long-term business vision, and to achieving sustainable growth and our clients satisfaction. We are registered member of eBay developer program. We completly understood your requirement of builk loader for uploading Ebay listings on 3rd party vendors. We can assure you to complete this job as per specifications easily and without any errors / issues. We are Tampa-Florida based Microsoft development company (.Net development). We propose solution in Asp.Net/C# with MS Sql Server as Database. We look forward to work with you. Regards, TechValens MSN: nirnaybansal skype: nirnaybansal

help

 

30

1 day

06-28-2009 04:46 EDT

(No Feedback Yet)

please check your pm.

help

 

30

2 days

06-28-2009 08:10 EDT

(No Feedback Yet)

Can do it; C++/Qt

help

 

45

2 days

06-28-2009 11:41 EDT

(No Feedback Yet)

I have much experienc converting data. I can do the job perfectly well.

help

 

30

1 day

06-28-2009 14:56 EDT

(No Feedback Yet)

quick turnaround. i can do this so that you can watch me do the conversion from your computer.

help


    Bid on this Project