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

1. Go to Campaigns from the left menu

2. Click edit for the silent auction campaign.

3. Select the "Auction Items" tab from the top.

4. Click on the "Bulk Upload" button.

5. 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.

1. Add all the images to a folder on your computer. Not needed if you are using URLs for images

2. Go to Campaigns from the left menu

3. Click edit for the silent auction campaign.

4. Select the "Auction Items" tab from the top.

5. Click on the purple "Bulk Upload" button.

6. Drag and drop or select the file to upload.

7. Click next, if any error is reported fix and upload it again.

8. On the next screen click on "Choose Images", either select a few images or drag and drop the entire folder.

9. Click "Upload"

10. 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.