Open topic with navigation

Import Excel Document Dialog

What is the dialog used for?

By default, the Merge option is selected for all the data sets.

Field Calculate profit margins: Check if the import process should calculate the profit margins for the retail items.

Available import options:

• Insert if not exists: Only attempt to insert records if they do not exist in the Site Manager.
• Merge: Does a smart merge if a record exists in the Site Manager. Existing records rule over an empty field from Excel.
• Override if exists: Overrides existing records if they already exist in the Site Manager.
• Ignore: Ignores the table and imports nothing.

After the OK button is pressed the Site Manager will display an import report, where explanations are listed if something could not be imported.