Upload Auction Items from Spreadsheet
To upload a list of Auction Items, use the Upload Auction Items Feature found under the Dashboard > Auction Items.
Creating the Spreadsheet Template
1. Click on the Spreadsheet Template link under the upload Auction Items.
2. The document will download for you to open in Excel or Sheets, usually on the bottom left of your screen
3. Open spreadsheet template.
. Enter or arrange your information, in the order of the template
Your sheet needs to include Catalog#, Donor Display Name and FMV to upload successfully - you can change these on your MaxGiving site once uploaded.
Categories and auction types must be created on your MaxGiving Site first if you want them to upload to the correct category or you will need to adjust once uploaded.
Information not entered will be able to be entered once uploaded.
***For detailed description of fields please look at Adding Auction Items - of note Buy it Now - 0 means first bidder gets item for $0; $100,000 removes buy it now option. Certificate Redemption Instructions Write special pickup instructions you do not want included in Description or Restrictions, but you want to add to facilitate Item Redemption, this will print on Certificate only. Display as Priceless, write the word yes if you want or leave blank to ignore. Donor Display is only the display name. If you plan on using the receipting for Donors in MaxGiving you will need to add Donors Manually once uploaded.
Save the spreadsheet where you will find it, you can rename if you like or keep the default name. The Save As type defaults to CSV (comma delimited), leave as default, and save your file.
Upload data
1. Go to Auction Items
2. Click on the Upload Auction Items button
3. Find your file
4. Click Open
5. When done successfully, you will get a green upload successful message on top right of your screen.
