Find Help Topic
Everybody Wants to Know
All the basics
The skinny on selling
How to make an offer and more
Various topics that don't fit into the above categories
Q&A-style repository for your most advanced questions
Quick videos on using Bonanza
The Lawyers Told Us So
Everybody loves rules!
Secret agents! Everywhere!
Talk to Us
It's been so long since we last spoke
|Suggest an Item Trait|
Help build the item category catalog
|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 (CSV) 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 Bonanza.
There are six 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.
- Your image URL must start with "http://" and not "https://" otherwise the images will not load.
- Duplicate titles will not import.
- Header names must be in lower case. No caps.
Here are all possible Bonanza column names (read more on defining your own custom column names):
|Column Name||Data expected||Required?||Also known as||Example data|
|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). This identifier will be treated as your item SKU (meaning that it shows up in your Bonanza invoices when the item sells)||No||sku||ITEM001|
|title||The title of your item (up to 80 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.bonanza.com/images/myimage.jpg) to an image for this item.||No||image1, image2, image, image_link||http://www.williambharding.com/images/rand11.jpg|
|category||The numeric category for your item, from first and second level eBay category IDs, listed here.||No||category 1||1281|
|booth_category||The name of a custom categorysetup within a booth.||No||No||Bridal Gowns|
|shipping_price||The flat rate price to ship your item within the continental U.S.||No||shipping, shipping_price, shipping & handling||3.50|
|shipping_type||How the domestic (US) shipping is determined. The value of this should be "fixed", "calculated" or "free". If this column is not present, the assumption is that fixed price shipping will be used||No||calculated|
|shipping_lbs||If the shipping_type is "calculated," this specifies the weight in pounds of the package. Whole numbers only allowed.||Only if shipping type is "calculated"||5|
|shipping_oz||If the shipping_type is "calculated," this specifies the ounces of the package weight after entering it's pounds. For example, if a package weighs 5 lbs, 6 oz, the appropriate value for this field would be "6".||No||6|
|shipping_carrier||If the shipping type is "calculated," this specifies the carrier that should be used to compute cost. Applicable values are "ups", "usps", "fedex".||Only if shipping type is "calculated"||usps|
|shipping_package||If the shipping type is "calculated," this specifies the relative size of the package. Applicable values are "envelope", "normal", "large", and "very large".||Only if shipping type is "calculated"||normal|
|sku||See "id" field.||No||id||ITEMABCD|
|worldwide_shipping_price||Price to ship item worldwide||No||15|
|worldwide_shipping_type||Type of worldwide shipping to use. Applicable values are "fixed", "calculated", or "free". If using worldwide_shipping_price, "fixed" will implicitly be assumed.||No||calculated|
|worldwide_shipping_carrier||If using "calculated" shipping for worldwide, this specifies the worldwide shipping carrier to use. Possible values are "usps", "ups" and "fedex".||No||ups|
|quantity||The number of this item that you possess.||No||12|
|trait||A list of item traits given in the form "[[trait name: trait value]]". To determine the available traits for your item, use the category finder, which will let you view the traits for a given category. If you think your category should have a trait that it's missing, you can suggest that to us. Note that item traits will automatically be fed to Google where applicable (i.e., if you use the "UPC" trait, we will automatically tell Google the UPC code for your item, which will give you a better search ranking).||No||traits||[[material: red]] [[condition: new]] [[brand: Gucci]]|
|force_update||By default, if an inventory file is uploaded that has the same ID as an already-processed item, we will ignore the item. However, if the force_update column is set to "true" for an item, then we will refresh all of the information for the item (and add any newly mentioned pictures), so if anything has changed it will be updated.||No||true|
Custom Column Names
Sometimes you have an inventory file that you use for other sites (for example, if you use eBay's TurboLister), and the column names of your inventory file may not match the column names we use, above. No worries. There is a link from the CSV Import page to define your own custom column names. Doing this allows you to map a Bonanza column into a name of your choice.
For example, by default, we expect the "price" column to be named "price". But if your column is called "item_price", you can use the custom column mapping to tell us that the column (aka "attribute") we know as "price" is called "item_price" in your inventory file. After saving your custom mappings, we will know that any data in the "item_price" column should be used as the price of the item.
Here's an example comma separated file (Excel should create something like this for you):
id,title,description,price,images,shipping_price,category,trait 1,RCA Television,"A television made by the ""RCA company""",65.5,http://www.bonanza.com/path/to/image.jpg,$5.00,3320,[[brand: RCA]] [[condition: New]] [[type: flat-panel]] 2,Puppy dog,"How much is that doggie in the window? It's $50, sir.",50,http://www.bonanza.com/path/to/image.jpg,$4.50,, 3,Donut,"Yum, donut.",$1 ,http://www.bonanza.com/path/to/image.jpg,,,