Find Help Topic
Everybody Wants to Know
| General FAQ All the basics |
| Selling Topics The skinny on selling |
| Buying Topics How to make an offer and more |
| Assorted Topics Various topics that don't fit into the above categories |
| Videos Quick videos on using Bonanzle |
The Lawyers Told Us So
| User Agreement Everybody loves rules! |
| Privacy Policy Secret agents! Everywhere! |
Talk to Us
| Contact Us It's been so long since we last spoke |
| Suggest an Item Trait Help build the item category catalog |
| Vote for Improvements What next, boss? |
| Report a Bug Find something wrong? Let us know! |
| Request a Feature What's your great idea? |
Topic: Selling Topics
How do I import items from an existing inventory file?
It's elementary, my dear user: often times you may keep your inventory in a spreadsheet, and spreadsheets can be saved as CSV (comma separated value) files that can be uploaded to Bonanzle.
There are three rules you need to follow for your inventory file to be successfully uploaded:
- The inventory file must have its fields separated by a comma, tab, or tilde (~). When you are on the inventory file importing page, you tell us how your fields are delimited. The default is by comma, since that's the more common format. If your file's fields are separated by tab or tilde, select that on the import page.
- You must begin your file with a header row that describes what each field contains (see example at bottom).
- You must include the required fields from the table below: title, price, and description.
Here are all possible Bonanzle column names:
| Column Name | Data expected | Required? | Also known as | Example data |
| title | The title of your item (up to 60 characters) | Yes | name | Doggie |
| description | Description of your item | Yes | desc | Small, slightly used mutt. |
| price | Price of your item, as an integer (we'll make it into an integer if it's given as a decimal) | Yes | cost | 10.0 |
| images | You can have as many images columns as necessary. Each should give a full URL (e.g., http://www.bonanzle.com/images/myimage.jpg) to an image for this item. | No | image1, image2, image, image_link | http://www.williambharding.com/images/rand11.jpg |
| id | A unique number or string to identify your item, so if you upload your file multiple times, items with identical ids will update (rather than re-add) | No | ITEM001 | |
| category | The numeric category for your item, from first and second level eBay category IDs, listed here. | No | category 1 | 1281 |
| shipping_price | The flat rate price to ship your item within the continental U.S. | No | shipping, shipping_price, shipping & handling | 3.50 |
| quantity | The number of this item that you possess. | No | 12 | |
| condition | Whether item is new or used. If condition is the word "new", the item is considered new. If it's anything else, it's considered used. | No | new | |
| upc | UPC code for the item (improves rank in Google Product search). | No | 012345029950 | |
| isbn | ISBN number for the item (improves rank in Google Product search). | No | 0-87654-321-2 | |
| mpn | Manufacturer part number for the item (improves rank in Google Product search). | No | DOGGIE12 |
Example file
Here's an example comma separated file (Excel should create something like this for you):
id,title,description,price,images,shipping_price 1,RCA Television,"A television made by the ""RCA company""",65.5,http://www.bonanzle.com/path/to/image.jpg,$5.00 2,Puppy dog,"How much is that doggie in the window? It's $50, sir.",50,http://www.bonanzle.com/path/to/image.jpg,$4.50 3,Donut,"Yum, donut.",$1 ,http://www.bonanzle.com/path/to/image.jpg,
Other Users Say
Watkins_Rep (0) wrote on July 15
Q. A lot of the other sites have a downloadable CVS file with all the headers in place already and some sample products. It would be a lot easier if you guys had that too.
A. Email us at support@bonanzle.com to get your official copy 
