Bulk Importing Auction items
Instructions to bulk upload auction items with image
Our auction campaign supports bulk importing of the items along with images.
Step 1: Prepare the template to upload
Go to Campaigns from the left menu
Click edit for the silent auction campaign.
Select the "Auction Items" tab from the top.
Click on the "Bulk Upload" button.
Click "Download Template" to download the Excel template file.
The template file has the following columns:
Column Name | Required | Description | Note |
---|---|---|---|
Option name | required | Name of the Item | Full Name of Item (127 characters max) |
Image Url | optional | Name of the image file name | Full Name of Image File |
Additional Image URLs | optional | List of Image file names | If more than one, comma-separated |
Total Item Count | required | Total Item Count | Total Item Count |
Min Bid | required | Min Bid | Min Bid |
Bid Increment | required | Bid Increment | Bid Increment |
Value of goods or services provided, if any! | optional | Value of goods or services provided, if any! | By default 0 |
Enable Buy it Now | required | Enable But it Now | Enable But it Now (yes or no) |
Buy it Now Amount | optional | Min value 1, Max 400,000 | Required if "Enable But it Now" is true |
Collect sales tax for this item | required | Collect sales tax for this item | Collect sales tax for this item(yes or no) |
Percentage Sales Tax | optional | The value should be from 0.01 to 100 | Required if "Collect sales tax for this item" is true |
Categories | optional | Categories | If multiple, comma-separated. |
Description | optional | Description | Description (2048 characters max) |
Memo | optional | Memo | Memo (2048 characters max) |
Featured | optional | Featured Item | Featured Item (can be true or false) |
Donated By Name | optional | Donated By Name | Donated By Name (64 characters max) |
Display Donated By | optional | Display Donated By | Display Donated By (can be true or false) |
Item Code | optional | Item Code | Item Code (32 characters max) |
Display To Donors | optional | Display To Donors | Display Item Code to donors (may be true or false) |
Add Video | optional | Add Video | Add Video (can be true or false) |
Video Provider | optional | Video Provider | Video Provider must be entered as a number: 1 for YouTube, 2 for Vimeo, 3 for Facebook, and 0 for Other (set to Other by default) |
Video Provider Url | optional | Video Provider Url | The Video Provider URL must be entered as an embed link (128 characters max) |
Note which columns are required and which are optional.
Step 2: Upload with images
Once you have all the data in this file and all the images ready.
Add all the images to a folder on your computer. Not needed if you are using URLs for images
Go to Campaigns from the left menu
Click edit for the silent auction campaign.
Select the "Auction Items" tab from the top.
Click on the purple "Bulk Upload" button.
Drag and drop or select the file to upload.
Click next, if any error is reported fix and upload it again.
On the next screen click on "Choose Images", either select a few images or drag and drop the entire folder.
Click "Upload"
Let the image upload finish and then click confirm and all the items will be added.
Once uploaded you can check the items individually to make sure they are good and there was no image mismatch etc.
Save Campaign from the top. Click on the QR code next to the campaign to preview the items.
Last updated