--- title: How to Request an Auction Item and Sponsor Bulk Upload description: In this article, we will provide you with a guide on how to request auction items and sponsor bulk upload. --- [Skip to content](https://help.trellis.org/auction-items-and-sponsors-bulk-upload#main-content) English Show submenu for translations ![Trellis-MainLogo-AllWhite-01.png\]](https://help.trellis.org/hs-fs/hubfs/Trellis-MainLogo-AllWhite-01.png?height=40&name=Trellis-MainLogo-AllWhite-01.png) Open main navigation Close main navigation - English Show submenu for translations - [Raise an urgent issue (out of office hours)](https://formcrafts.com/a/urgentform) [Raise an urgent issue (out of office hours)](https://formcrafts.com/a/urgentform) Help & Learning - There are no suggestions because the search field is empty. 1. [Help & Learning](https://help.trellis.org/?hsLang=en) 2. [Silent & Live Auctions](https://help.trellis.org/silent-live-auctions?hsLang=en) 3. [Set Up Your Auction](https://help.trellis.org/silent-live-auctions?hsLang=en#set-up-your-auction) # How to Request an Auction Item and Sponsor Bulk Upload ## In this article, we will provide you with a guide on how to request auction items and sponsor bulk upload. ### **Step 1. Enable Your Auction and Check Your Auction Settings** Before submitting a bulk upload request, make sure your auction is enabled and your settings are complete. Bulk uploads cannot be processed for disabled auctions. 1. In your Builder, navigate to **Silent & Live Auctions** in the sidebar. 2. Toggle on **Enable Auctions**. 3. Go to **Auction Settings** to confirm your auction start and end dates are correct. 4. Click **Publish Changes**. --- ### **Step 2. Make a Copy of the Bulk Upload Template** You cannot use your own template, please **download one of the following templates**: - **[Click here for the Auction Items Bulk Upload Template](https://docs.google.com/spreadsheets/d/1zqC9rKS0MXB0BOiFQT1GQCL7iiCGqjJrqGm1vbX4gd0/edit?gid=1214563817#gid=1214563817)** - **[Click here for the Auction Sponsors Bulk Upload Template](https://docs.google.com/spreadsheets/d/1LPqPlzBRSrEMhldqF-9wT3smBUxRMKw-SGjAYmBRGdM/edit?gid=2126241708#gid=2126241708)** - [**Click here for the Auction Items Bulk Upload Template (British Columbia)**](https://docs.google.com/spreadsheets/d/1R4R1bflM85mKbO_i_ycwuBhp8LeQPquZpgMlsLIBf9U/edit?gid=709969620#gid=709969620) All **mandatory fields** are **bolded** within the template. **Important Notes:** 1. **Do not change the header titles or add extra columns.** 2. **No other information** can be uploaded aside from the columns in the template. You will need to manually add anything else (such as images, email attachments, additional fees, etc). 3. We **cannot bulk upload images.** 4. If your item description is a list of different items, please make sure that you **use numbers or bullets to list the items**. 5. **Sponsors can only be linked to one item.** 6. **Any text formatting will not upload** (e.g. making text, bold, italic, hyperlinked, etc.) 7. We can only do new bulk uploads and **we cannot bulk edit existing** items. 8. If you're uploading both auction items and sponsors, please submit **both files together**. Auction items must be uploaded **before** sponsors to automatically link them. 9. If you are running an auction in British Columbia, **you must use the British Columbia template** with PST values. We will not accept the regular template - these columns are required. --- ### **Step 3. Fill Out 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 Template Fields** | | | | --- | --- | --- | | **Field Name** | **Description** | **Mandatory?*(Cannot be left blank)*** | | Offering Type | Please exactly type either of the following: - **Silent Auction Listing** - **Live Auction Listing** | **Yes** | | Listing Name | Recommended character is but not limited to 40. Refer to below accepted special character only | **Yes - Text format** | | Listing ID | This is your item number. You may use S-1, S-2, S-3 or just 1, 2, 3,.. | **Yes - Text 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: - **Retail Value** - **Value** - **Estimated Value** - **Priceless** | Optional - Text format | | Monetary Value of Item | This is your item's retail or market value. | Optional - Number format | | Item Description | Recommended character is but not limited to 250. | **Yes - Text format** *\*If you do not have the info just enter "TBD"* | | 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 | | 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 | | Pickup Information | Recommended character is but not limited to 250. | Optional - Text format | | **BC Only Auction Items Template Fields** | | | | Total Fair Market Value *(BC ONLY)* | The fair market value of the entire auction item. Used to calculate PST and is mandatory in British Columbia. | **Yes - Number format.** *\*Cannot be "0"* | | Liquor Fair Market Value *(BC ONLY)* | If there is liquor, the fair market value of the liquor portion of the item. | **Yes - Number format.** *\*Enter "0" if no liquor* | | Accommodation Fair Market Value *(BC ONLY)* | If there is BC- based accommodation, enter the fair market value of the accommodation portion of the item. | **Yes - Number format.** *\*Enter "0" if no accommodation.* | | Non-Taxable Values*(BC ONLY)* | The value of any non taxable parts of this auction item. Amount will be exempt from PST calculations in British Columbia. | **Yes - Number format.** *\*Enter "0" if no accommodation* | | Municipal and Regional District Tax (MRDT) *(BC ONLY)* | If the BC-based accommodation is located in an area with MRDT, select the rate. Use [BC's MRDT Map](https://municipal-regional-district-tax-map.apps.gov.bc.ca/) to find the rate. Values can only be: - **0** - **2** - **3** - **5.5** | **Yes - Number format.** | | **Auction Sponsors Template Fields** | | | | 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 Numbers | The listing number of the item this sponsor donated (first column from your auction item bulk upload template). Please note, sponsors can only be assigned to one auction item for bulk uploads. You can manually attach them to multiple auction items via the Builder. | **Yes** | --- ### **Step 4. Save your File** Name your file using the formats below so our team knows which fundraiser it belongs to: - Auction Items Bulk Upload \.csv - Auction Items Sponsors Bulk Upload \.csv --- ### **Step 5. Submit Your Auction Item and Sponsor Bulk Upload Request Form** Fill out your **Auction Item and Sponsor Bulk Upload Request form**. The form can be [found here.](https://3mu1j.share.hsforms.com/2frplflUbSwev-HpJV6nTXA) Please note bulk uploads have a **two business days** turnaround time. --- ### **Frequently Asked Questions** **What special characters can I use?** We recommend sticking to letters, numbers, and hyphens. **Can I update my auction items after the bulk upload is complete?** Yes, you can make any changes necessary to your auction items in your Builder after the bulk upload is complete **Can I reorder my auction items after the bulk upload is complete?** Yes, use the **6-dot drag handle** in your Builder to reorder auction items in your Builder. **Can I change the Listing ID after the bulk upload is complete?** Yes, you can update the Listing ID at any time in your Builder after the bulk upload is complete. **What will my auction items look like on Trellis?** Here's what your auction items will look like on Trellis:   ![](https://help.trellis.org/hs-fs/hubfs/Screenshot%202023-03-28%20at%204-00-38%20PM-png.png?width=459&height=392&name=Screenshot%202023-03-28%20at%204-00-38%20PM-png.png) ![](https://help.trellis.org/hs-fs/hubfs/Screenshot%202023-03-28%20at%204-00-44%20PM-png.png?width=466&height=355&name=Screenshot%202023-03-28%20at%204-00-44%20PM-png.png)   - [Admin & Reporting](https://help.trellis.org/admin-reporting?hsLang=en#main-content) - [Welcome to Trellis](https://help.trellis.org/admin-reporting?hsLang=en#welcome-to-trellis) - [Understanding Fees](https://help.trellis.org/admin-reporting?hsLang=en#understanding-fees) - [Understanding British Columbia Provincial Sales Tax](https://help.trellis.org/admin-reporting?hsLang=en#understanding-british-columbia-provincial-sales-tax) - [Reports & Exports](https://help.trellis.org/admin-reporting?hsLang=en#reports-exports) - [Troubleshooting](https://help.trellis.org/admin-reporting?hsLang=en#troubleshooting) - [Set Up and Manage Your Banking](https://help.trellis.org/set-up-and-manage-your-banking?hsLang=en#main-content) - [Add Your Banking Details](https://help.trellis.org/set-up-and-manage-your-banking?hsLang=en#add-your-banking-details) - [Understanding Your Payouts](https://help.trellis.org/set-up-and-manage-your-banking?hsLang=en#understanding-your-payouts) - [Tax Receipts](https://help.trellis.org/tax-receipts?hsLang=en#main-content) - [Set Up Your Tax Receipts](https://help.trellis.org/tax-receipts?hsLang=en#set-up-your-tax-receipts) - [Manage Your Tax Receipts](https://help.trellis.org/tax-receipts?hsLang=en#manage-your-tax-receipts) - [Build and Design Your Fundraiser](https://help.trellis.org/build-and-design-your-fundraiser?hsLang=en#main-content) - [Build Your Fundraiser](https://help.trellis.org/build-and-design-your-fundraiser?hsLang=en#build-your-fundraiser) - [Fundraiser Settings](https://help.trellis.org/build-and-design-your-fundraiser?hsLang=en#fundraiser-settings) - [Manage Your Fundraiser](https://help.trellis.org/build-and-design-your-fundraiser?hsLang=en#manage-your-fundraiser) - [Live Event Views](https://help.trellis.org/build-and-design-your-fundraiser?hsLang=en#live-event-views) - [Messaging & Campaigns](https://help.trellis.org/messaging-campaigns?hsLang=en#main-content) - [Automated Messages](https://help.trellis.org/messaging-campaigns?hsLang=en#automated-messages) - [Creating Messaging Campaigns](https://help.trellis.org/messaging-campaigns?hsLang=en#creating-messaging-campaigns) - [Manage Your Messaging Campaigns](https://help.trellis.org/messaging-campaigns?hsLang=en#manage-your-messaging-campaigns) - [Analyze Your Messaging Campaigns](https://help.trellis.org/messaging-campaigns?hsLang=en#analyze-your-messaging-campaigns) - [Donor Experience](https://help.trellis.org/messaging-campaigns?hsLang=en#donor-experience) - [Event Ticketing](https://help.trellis.org/event-ticketing?hsLang=en#main-content) - [Set Up Your Event Tickets](https://help.trellis.org/event-ticketing?hsLang=en#set-up-your-event-tickets) - [Manage Your Attendees](https://help.trellis.org/event-ticketing?hsLang=en#manage-your-attendees) - [Post-Event Management](https://help.trellis.org/event-ticketing?hsLang=en#post-event-management) - [Donor Experience](https://help.trellis.org/event-ticketing?hsLang=en#donor-experience) - [Sponsorships](https://help.trellis.org/sponsorships?hsLang=en) - [Silent & Live Auctions](https://help.trellis.org/silent-live-auctions?hsLang=en#main-content) - [Set Up Your Auction](https://help.trellis.org/silent-live-auctions?hsLang=en#set-up-your-auction) - [Manage Your Auction](https://help.trellis.org/silent-live-auctions?hsLang=en#manage-your-auction) - [Auction Close](https://help.trellis.org/silent-live-auctions?hsLang=en#auction-close) - [Donor Experience](https://help.trellis.org/silent-live-auctions?hsLang=en#donor-experience) - [Donations](https://help.trellis.org/donations?hsLang=en#main-content) - [Set Up Your Donations](https://help.trellis.org/donations?hsLang=en#set-up-your-donations) - [Donor Experience](https://help.trellis.org/donations?hsLang=en#donor-experience) - [Items for Sale](https://help.trellis.org/items-for-sale?hsLang=en#main-content) - [Set Up Your Items for Sale](https://help.trellis.org/items-for-sale?hsLang=en#set-up-your-items-for-sale) - [Raffles & 50/50](https://help.trellis.org/raffles-50-50?hsLang=en#main-content) - [How to Run a Raffle](https://help.trellis.org/raffles-50-50?hsLang=en#how-to-run-a-raffle) - [Running a Raffle in the USA](https://help.trellis.org/raffles-50-50?hsLang=en#running-a-raffle-in-the-usa) - [Managing Your Raffle](https://help.trellis.org/raffles-50-50?hsLang=en#managing-your-raffle) - [Draw Winner & Reporting](https://help.trellis.org/raffles-50-50?hsLang=en#draw-winner-reporting) - [Donor Experience](https://help.trellis.org/raffles-50-50?hsLang=en#donor-experience) - [Raiser's Edge NXT Integration](https://help.trellis.org/raisers-edge-nxt-integration?hsLang=en#main-content) - [Integration Set Up](https://help.trellis.org/raisers-edge-nxt-integration?hsLang=en#integration-set-up) - [How the Integration Works](https://help.trellis.org/raisers-edge-nxt-integration?hsLang=en#how-the-integration-works) - [Constituent Matching](https://help.trellis.org/raisers-edge-nxt-integration?hsLang=en#constituent-matching) - [Gift Sync](https://help.trellis.org/raisers-edge-nxt-integration?hsLang=en#gift-sync) - [Event Participation Sync](https://help.trellis.org/raisers-edge-nxt-integration?hsLang=en#event-participation-sync) - [Sales Entry System (SES)](https://help.trellis.org/sales-entry-system-ses?hsLang=en) - [Check-In Tool](https://help.trellis.org/check-in-tool?hsLang=en#main-content) - [Introduction to the Check-In Tool](https://help.trellis.org/check-in-tool?hsLang=en#introduction-to-the-check-in-tool) - [Managing Attendees](https://help.trellis.org/check-in-tool?hsLang=en#managing-attendees) - [Event Day](https://help.trellis.org/check-in-tool?hsLang=en#event-day) - [Post-Event Management](https://help.trellis.org/check-in-tool?hsLang=en#post-event-management) - [Fund-a-Need](https://help.trellis.org/fund-a-need?hsLang=en#main-content) - [Set Up Your Fund-a-Need](https://help.trellis.org/fund-a-need?hsLang=en#set-up-your-fund-a-need) - [Manage Your Fund-a-Need](https://help.trellis.org/fund-a-need?hsLang=en#manage-your-fund-a-need) - [Manage Pledges Post-Event](https://help.trellis.org/fund-a-need?hsLang=en#manage-pledges-post-event) - [Security, Privacy & Technology](https://help.trellis.org/security-privacy-technology?hsLang=en) - [New Features!](https://help.trellis.org/new-features?hsLang=en) - [Resources for a Successful Fundraiser](https://help.trellis.org/resources-for-a-successful-fundraiser?hsLang=en#main-content) - [Pre-Event Planning](https://help.trellis.org/resources-for-a-successful-fundraiser?hsLang=en#pre-event-planning) - [Trellis Feature Spotlight](https://help.trellis.org/resources-for-a-successful-fundraiser?hsLang=en#trellis-feature-spotlight) - [Support Resources for Donors](https://help.trellis.org/support-resources-for-donors?hsLang=en#main-content) - [Getting Started](https://help.trellis.org/support-resources-for-donors?hsLang=en#getting-started) - [Checkouts](https://help.trellis.org/support-resources-for-donors?hsLang=en#checkouts) - [Participating in an Auction](https://help.trellis.org/support-resources-for-donors?hsLang=en#participating-in-an-auction) [![Chill listening crop-3](https://help.trellis.org/hs-fs/hubfs/Trellis-MainLogo-LightGreenLeaf-01.jpg?width=117&height=55&name=Trellis-MainLogo-LightGreenLeaf-01.jpg "Chill listening crop-3")](https://trellis.org) Copyright © 2026, Trellis Social Enterprise