Embedded Files
Before navigating to the Import Lots section it is important to cover what needs to be included on the spreadsheet you are about to import. The information that can be imported is below:
- Bidder Number
- Clerk Status
- Description
- Hammer Price
- Lot Number
- Pre Sale Estimate Maximum
- Pre Sale Estimate Minimum
- Quantity
- Quantity Sold
- Reserve Each
- Sale Order
- Start Bid Each
- Title
- Seller Code
While all of these fields CAN be imported, the only mandatory fields are Lot Number, Seller Code, and Title. If you are unfamiliar with the Seller Codes that the system is asking for please refer to the Customers section.
Below is an example layout of an imported spreadsheet. In this example we're including Lot#, Seller Code, Quantity, Title, Group, Description, Reserve, and Start Bid. This is a fairly common set of information to include. Keep in mind your sheet does not need to be in this exact order.
To import lots into 360, click the Import Lots button located above the list of lots.
STEP 1
STEP 2
A window will appear with the option to Choose File. Clicking this button will open a navigation window on your computer. Use this to navigate to the spreadsheet you want to import.
Once you have the correct file chosen and click the Open button, the name of your spreadsheet will appear in Auction Flex next to the "Choose File" button.
Once the file is selected click the "Go to Next Step" button in the bottom right corner.
STEP 3
STEP 4
The next step will direct you to the Field Mapping window.
This window is where you tell Auction Flex how to assign the information in your spreadsheet with the correct fields on a lot.
The words to the left of the Drop Down menus will reflect the words in your spreadsheet's header.
Using the drop down menus, select the appropriate option that correlates with the words you used on your spreadsheets header.
There is also a preview section underneath the drop down menus you can refer to in order to make sure each column on the spreadsheet if receiving the correct information.
In our example we have a column that needs to be skipped. This is the column labeled "Group." You'll notice that the Group option has 'no mapping' in the drop down menu next to it. Anything with the 'no mapping' option next to it will be ignored during the import process.
When you have your mapping finished click the Next button in the bottom right corner.
The next step will give you an option to overwrite existing data. This box should only be checked if the spreadsheet you are importing will be overwriting any existing lots that you already have cataloged. When you are ready to proceed click the 'Import' button in the bottom right corner.
This will bring you to another window that will count up as the system progresses through the import.
It will inform you:
- When it is finished
- How many successful lots were imported
- If there were any duplicate lots in the spreadsheet
- Any failed rows
After it is complete, click the Close button in the bottom right corner.
You will be directed back to the Lot List page where you should see every successfully imported lot.
Google Sites
Report abuse