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 "Selling" 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, description, and category.
- Duplicate titles will not import.
- Header names must be in lower case. No caps.
- Each file must contain less than 50,000 unique listings. If you are loading more than 50,000 items, we recommend breaking your file up into multiple files to ensure all listings upload.
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. The end of the URL should be the image file type (.jpg, .png, etc). Any text after the image type should be removed from the end of the URL.||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 category setup 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_service||You can specify a shipping service for free, flat-rate or calculated shipping. Specify the name of the service as shown on the New Item Form or Shipping Profile (with or without the parenthetical travel times). Specify multiple services deliminated with a slash (/) character. Free shipping only allows for one service. Flat-rate shipping applies the flat-rate cost to all shipping services.||No||USPS Priority Mail/USPS First Class Mail|
|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" or "free". If using worldwide_shipping_price, "fixed" will implicitly be assumed.||No||fixed|
|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. 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. Item must have been originally updated via CSV in order to use the "Force_update" column, and the ID must be the same as the ID used during the initial upload.||No||true|
Custom Column Names
Sometimes you have an inventory file that you use for other sites, and the column names of your inventory file may not match the column names we use. 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. Individual UPCs may be included per item. For example: "[[color:red][quantity: 3][price: 5.50][upc:123456789101]] [[color:green][quantity: 1][price: 4.50][upc:109876543210]". 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).