Overview
The Inventory Import tool allows you to quickly bring in multiple items from an Excel spreadsheet into your inventory system, either for future allocation or direct placement into an auction. You can also associate items with consignors and images during the import process.
Step-by-Step: Importing Inventory from a Spreadsheet
1. Prepare Your Spreadsheet
Create and save your Excel file.
Include the following required columns:
Consignor Code (must already be set up in Auction Flex)
Inventory Number (if not assigning lot numbers)
Lot Number (if importing directly into an auction)
Optional columns may include:
Lead (title), Description, Quantity, Reserve, Estimates, etc.
Image filenames should match the lot/inventory number.
💡 Tip: If you receive errors using .xls, save your file as .csv and retry the import.
2. Launch the Import Tool
Open Auction Lots & Preview from the Easy Navigator
Click Import Lots
3. Select Your Spreadsheet
Click the ellipses button to browse and select your file.
Click Next Step (
610_cmd_NextStep)
4. Map Your Fields
Match your spreadsheet columns (A, B, C, etc.) to Auction Flex fields.
Click Next Step
🧭 Reminder: Spreadsheets are read left to right; Auction Flex maps fields top to bottom.
5. Verify Import Settings
Confirm that all fields are matched correctly.
If your spreadsheet includes headers, check "Skip First Row When Importing".
Click Next Step
6. Choose Target Auction or Inventory
If your spreadsheet includes Lot Numbers, choose the auction to import to.
If no Lot Numbers are present, items will be added to inventory for future use.
7. Import Images (Optional)
Ensure image files are in the same folder as your spreadsheet.
Images must be named to match Lot or Inventory Numbers
8. Finalize Import
Click Next Step, then Import Inventory to complete the process.
Troubleshooting Tips
If formatting errors occur with
.xlsfiles, save as .csv and retry.Confirm that consignor codes exist in Auction Flex before importing.
Verify that images are correctly named and in the proper folder.