Project Detail

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.