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:

1. 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.
2. You must begin your file with a header row that describes what each field contains (see example at bottom).
3. 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

No users have added approved comments to this help topic as yet.