In this article, we will provide you with a guide on how to request auction items and sponsor bulk upload.
1. Ensure your auction is enabled on your builder and your auction settings are complete.
We cannot complete a bulk upload if your auction is disabled.
This is also a good time to double check that your auction start and end date are correct.
2. Download a copy of our bulk upload templates.
You cannot use your own template, we only accept the following templates:
PLEASE READ - IMPORTANT NOTES BELOW:
- Do not change the header titles or add any rows or columns other than your listings.
- No other auction information can be automatically uploaded aside from the ones that are already on the template. If there's anything else you need to add, you will have to manually add that.
- We do not do bulk uploads of images.
- If your item description is a list of different items, please make sure that you use numbers or bullets to list the items down.
- Sponsors can only be linked to one item.
- Adding text formatting to your template will not reflect in the upload e.g. making text, bold, italic, hyperlinked, etc.
- We can only do new bulk uploads and we cannot bulk edit existing ones.
3. Strictly follow the format below while entering your data into the template.
If you do not follow the format, your file will encounter an error and we will return your file for you to fix.
Auction Items Bulk Upload |
||
| Field Name | Description | Mandatory?(Cannot be left blank) |
| Listing ID | This is your item number. You may use S-1, S-2, S-3 or just 1, 2, 3,.. | Yes - Text format |
| Listing Name | Recommended character is but not limited to 40. Refer to below accepted special character only |
Yes - Text format |
| Offering Type | Please exactly type either of the following:
|
Yes |
| Item Description | Recommended character is but not limited to 250. |
Yes - Text format *if you do not have the info just enter "TBD" |
| Monetary Value of Item | This is your item's retail or market value. | Optional - Number format |
| Purchase Price | If you allow your participants to buy out your item right away this is where you indicated the buy now price. | Optional - Number format |
| Minimum/Starting Bid | This is the minimum starting bid amount. | Yes - Number format *if you do not have the info just enter $1 |
| Minimum Bidding Increment | This is the minimum bidding increment amount. | Yes - Number format *if you do not have the info just enter $1 |
| Item Value Title | This field is displayed before the monetary value amount. Please choose one of the following:
|
Optional - Text format |
| Pickup Information | Recommended character is but not limited to 250. Refer to below accepted special character only |
Optional - Text format |
| Tags/Categories | Tags/Categories can be "Gift Cards", "Experience", "Dining", etc. If an item has multiple tags, please use a comma then a space as the separator. For example Experience, Travel |
Optional - Text format |
| Auction Items Sponsor Bulk Upload | ||
| Sponsor Title | You may indicate here "Sponsored by:", "Donated by:" or if it's an art piece donated by an artist you may use "Created by:" | Yes |
| Sponsor Name | The name of the sponsor | Yes |
| Sponsor Website | The website URL of the sponsor | Optional |
| Sponsor Description | A short description of the sponsor | Optional |
| Auction Item Number | The listing number of the item this sponsor donated(first column from your auction item bulk upload template) | Yes |
4. Save the file in the below format so we know which fundraiser to upload this file to.
- Auction Items Bulk Upload <insert your fundraiser name>.csv
- Auction Items Sponsors Bulk Upload <insert your fundraiser name>.csv
5. Send it to support@trellis.org with your fundraiser's name, date, and start time.
Please note bulk uploads have a two business days turnaround time.
Here's what your auction items will look like on Trellis:
We also have a video that can walk you through how to request an auction bulk upload:
Did this answer your question? If not, please vote no on this article and reach out to support@trellis.org - we would be happy to assist.