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. Just select "Import from inventory file" from the "Sell on Bonanza" menu at the top of any page.
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 accepted||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, BuyItNowPrice||10.0|
|images||CSV file supports uploading 4 images. Each image column should give a full URL (e.g., http://www.bonanza.com/images/myimage.jpg) to an image for this item.||No||image1, image2, image3, image4, image, image_link, PicURL||http://www.williambharding.com/images/rand11.jpg|
|category||The numeric category for your item, from first and second level eBay category IDs, listed here. You may also list a full category name, as it would appear in a CSV export, e.g. "Fashion >> Women's Clothing >> T-Shirts & Tank Tops".||Yes||category 1, category_id||1281|
|booth_category||The name of a custom categorysetup within a booth.||No||booth category, BoothCategory||Bridal Gowns|
|shipping_price||The flat rate price to ship your item within the continental U.S.||No||shipping, shipping_price, shippingprice, 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||ShippingType||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"||WeightMajor||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||WeightMinor||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"||ShippingService-1:Option||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"||ShippingPackage||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). See Trait Columns below for an alternate method of specifying trait values.||No||traits, item_trait, item_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.
If you have a lot of items in different categories, then the best way to define your items' traits is by using the "trait" column as described above. However if you don't have very many categories you're working with, then an alternate way to define your trait values is by creating additional columns - one for each trait. For example, if you have items that have a "color" trait, you could create a new column titled "color" and then specify the color values for each of your item rows.
Note that the column name must match a valid trait name, and the value of each item trait must match a valid trait value. Use the category finder to see which traits and values are valid for any given item category.
If you have a single item in multiple colors or sizes, you may list these variations in the trait column. Including multiple values for a trait will automatically include multiple variations - for example: "[[color:red]] [[color:green]]" would indicate that you have two of the item - one red and one green. If you wish to specify information about the variations in more detail, you can enclose additional variation attributes (price and quantity) inside the outer set of brackets. For example: "[[color:red] [quantity: 3] [price: 5.50]] [[color:green] [quantity: 1] [price: 4.50]]" would describe an item where you have three red variations, priced at $5.50 and one green variation priced at $4.50. A maximum of two varying traits may be specified, "[[color:red] [size:small]]" is allowed, but "[[color:red] [size:small] [condition:used]]" is not allowed, because it includes more than two traits inside the variation.
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,,,