Bulk import items
Before adding any exhibitor / sponsor item, an exhibitor / sponsor must be present in the system. If not present, this will result in orphaned items, this items will fail when trying to import.
Please ensure you have added your exhibitors / sponsors before adding items.
The bulk import allows you to use a spreadsheet to import your exhibitors / sponsors items. This is a great way to import a large number of exhibitors / sponsors items at once.
You must use the correct spreadsheet template to import your exhibitors / sponsors item. You can download the template from the manage exhibitors / sponsors items page OR using the 'Download Exhibitor / sponsor items template' button at the top right of the bulk import page.
Spreadsheet template
If an exhibitor / sponsors item has an 'ID' present, the system will attempt too 'update' that exhibitor / sponsors item. If no ID is present, the system will try and insert that exhibitor / sponsors item as a new item, Parent ID must be filled in .
| Type | Value | Description |
|---|---|---|
| Name | String | The Name of the exhibitor / sponsor item |
| LiveStream_URL | URL | A valid URL that can be accessed via the web AND consumed by an iFrame (embedded) |
| Website | URL | A URL to the product detail, must be a valid URL |
| SKU | String | This can be a product SKU, ID, or Model number to help identify the product |
| Description | String | A description about the product or offering |
| Categories | Comma list | The categories section should contain a listing of 'categories', when adding a category, if there are multiple, they should be seperated by a comma eg cat1,cat2,cat3 If group is not present in the system, it will be added |
| Item_Parent | [Integer] | The parent item associated with this product. This must be the parent ID and be wrapped in brackets eg [parentid] |
| ID | [Integer] | The ID of the item. When this is present, the system will attempt to 'update' the item. Must be wrapped in brackets [ID] |
If any values are incorrect, the system will return an error with the line number of each error. Once corrected, you can upload the speadsheet again.