Importing items from an Excel spreadsheet
This function is very useful to import items already existing as
The image above shows the initial import screen.
Select the file to import by clicking on the appropriate Choose File button.
After the file is selected, configure the fields as they appear in the
The information on the file shows the name, the number of records in the file (line count) and the number of fields ready to be imported. To ensure this data is correct separation information must be provided.
It is important to insert the correct information on separators in this part of the dialog. The default separators are a new line for each record and a tab for each field.
It is possible to import a new inventory erasing the old one or to merge the old inventory and the newly imported one.
Any new supplier imported from the inventory may be edited further.
The price list calculation is performed according to the default settings. This choice will determine whether the price list is computed using the average cost or using the last price and supplying the markup percentages. These percentages will remain fixed for the entire imported inventory.
If some of the fields are missing, default values can be specified.
This combo box determines which fields will be imported.
The choices are as follows: