You may have an administrative assistant that feels very comfortable entering items into an excel spreadsheet as they come in or it is just something your committee has always done. In that case, Auction Trak has an import items tool to take the excel spreadsheet items and quickly upload them.
1. The Item Import tool is located under Items.
2. You will need to create an excel spreadsheet and follow all instructions listed above. We created a template for you to save you some time. It should look something like this when you are ready to do the upload.
Data must be entered into any column listed with a red asterisk in the instructions. Some columns are left blank. In this example column B was left blank because it is for a new auction and no numbers have been assigned yet. If you did have Item IDs you would want to keep the box marked with a check. Be sure to have an ‘x’ in each cell for column L and also delete your header row if you used them in your creation of this spreadsheet.
Once you have completed your spreadsheet you will need to save it as a Tab Delimited .txt file.
3. You are ready to choose your file. Click on the Browse button and select the file that you just saved.
4. Choose the Import button. This can take a few minutes depending on how much data you included. See below what you will see once the upload has occurred.
If you have any errors, it will tell you which ones. If it doesn’t work at all, go back and double check your work in setting up the spreadsheet.
Congratulations! You can now begin to manage your items within Auction Trak.