You can import auction lotting data from an outside Excel type file format into the CUS Inventory System. From there, you will be able to transfer it to an auction. Your Excel file needs to contain the data fields that you want to import with a header row containing the correct CUS field names. No commas or double quote marks are allowed. You can use Excel’s Find/Replace feature to replace commas with semi-colons. Save the file as a comma delimited (.csv) file format with a simple file name (usually the auction name). The best place to save the file is in the aucinv directory either on your local C: if you’re on a single user or your network drive, usually F:
Once the file is saved, close it and go into the Inventory System. Go to Utility Menu, ASCII file import. Enter the location of the file you saved or use the drop down arrow to find it. Enter the name of the auction that these items will be assigned to. The data will be imported into your Main Inventory file with the auction name assigned to each lot. You’re ready to transfer the lots into your auction.