Inventory Import

Top  Previous  Next

The Inventory Import form allows you to easily import items from one spreadsheet to multiple consignors.

 

1.  Create and save your Excel spreadsheet.(Tip:  Include lot numbers if you want items imported into an auction.  If there are no lot numbers, items will be imported into inventory for use in a future auction. )(Tip:  If you include a column for consignor codes and pre-enter those consignors in Auction Flex, a list of items will be created for each consignor.)

5_ExcelInventoryImportNew

2.  Click the Consignments Drop Down menu and choose Consignment Order Maintenance, or click the Consign Order button 610_cmd_COMaint on the Navigator Toolbar.  You can also import from Auction Lots using the Import button found within the Advanced tab.

 

3.  If you have previously entered the CO, use the navigation buttons 610_cnt_StandardControls

 

to locate it; otherwise, click the New button 610_cmd_New to create a new CO.

 

4. Click the  610_pag_Advanced tab and then click  610_cmd_ImportLots

If you are in Auction lots & Preview. Click the import button if you are in Consignment Order Maintenance.

 

 

 

5.  Assuming you have already created your Excel spreadsheet with your inventory, click the ellipses button 5_cmd_PathButton to locate your file.

 

6.  Click the 610_cmd_NextStep button.  Double click each field in the order that it occurs on your spreadsheet.

 

610_pag_InvImpFieldMap

 

7.  Click the 610_cmd_NextStep button.  Verify that your fields are correctly matched.  If your spreadsheet has headings, check the "Skip First Row When Importing" checkbox. 

 

610_pag_InvImpFieldReview

 

8.  Click the 610_cmd_NextStep button.  Since we included lot numbers, we will choose the auction that the items will be imported to.  If you did not include lot numbers, the items will be imported into inventory for future allocation to a future auction.

 

610_pag_InvImpMisc

 

 

 

9.  Click the 610_cmd_NextStep button. From this section, you can choose to import images.  Make sure the images are in the same folder as the spreadsheet, and named the same as the lot/inventory number.

 

610_pag_InvImpImage

 

10.  Click the 610_cmd_NextStep button.  Click the "Import Inventory" button 610_cmd_ImportInv.