Instructions: Bulk Upload Auction Items
You may upload a CSV (Comma Separated Values) file to import items in bulk.
Please ensure all double-quotes (") are replaced by two single quotes (''), should you want to specify things like "inches".
Items are uploaded from the left-side menu >> Items >> Gear symbol >> Bulk upload. A sample file is available on that page.
| Column Header | Description |
| TYPE | Required - the item type, must be one of SILENT, LIVE, or MULTI |
| LOTNUMBER | Required - The unique lot number of the item, best to use the same number of digits for all of them |
| DONOR | Optional - the donor or supplier of the item |
| URL | Optional - a URL to more information on the item (must include http:// or https://) |
| TITLE_EN | The title of the item (required if language is English and system is bilingual - may be shortened to TITLE if your system is English-only.) |
| DESCRIPTION_EN | A description of the item (required if language is English and system is bilingual - may be shortened to DESCRIPTION if your system is English-only.) |
| VALUATION_EN | Optional - can be a short description, or a dollar amount (English, e.g. "Priceless" or "$1500" - what you type is what patrons see) - Not to be confused with COST. (May be shortened to VALUATION if your system is English-only.) |
| TITLE_FR | The title of the item (French) - optional if your account is unilingual in English |
| DESCRIPTION_FR | A description of the item (French) - optional if your account is unilingual in English |
| VALUATION_FR | Optional - can be a short description, or a dollar amount (French) - optional if your account is unilingual in English - Not to be confused with COST |
| STARTBID | The starting bid ($, required for type=SILENT only) |
| INCREMENT | The minimum bidding increment ($, required for type=SILENT only) |
| COST | Optional - the $-cost of the item (or unit of items), used for calculating and reporting profit margin generated ($) - Not to be confused with VALUATION |
| PRICE | The price per unit of multi-sale items ($, required for type=MULTI, leave blank for other types) |
| QUANTITY | The number of units available for multi-sale items (required for type=MULTI, leave blank for other types) |
| MAXPERPATRON | The maximum number of multi-sale units an individual patron can purchase (required for type=MULTI, leave blank for other types) - if no maximum, set the same as QUANTITY |
The columns can be in any order, and can be mixed case.
If an item with a lot number already exists in the database, uploaded items with the same lot number will create an error message - you will need to fix the duplicates in your upload file.
SIMPLE VERSION:
Just want the basics for a silent auction? These are the bare minimum headers you need:
| Column Header | Description |
| TYPE | Required - the item type, must be one of SILENT, LIVE, or MULTI |
| LOTNUMBER | Required - The unique lot number of the item, best to use the same number of digits for all of them |
| TITLE | Required - The short title of the item, that will be shown in the list of items. |
| DESCRIPTION | Required - A longer description of the item. |
| STARTBID | The starting bid ($, required for type=SILENT only) |
| INCREMENT | The minimum bidding increment ($, required for type=SILENT only) |