DialogsImport Orders

Import Orders from File
Easily import orders from .csv, .xls, .txt, .tab or .xlsx files, using a template that can be saved. You can have as many templates as you need for each source of import. To Import orders: in the Records Tab click Records>Import from File.

Template



Open
Open a previously saved template.
Save
Save the current import settings as a template.
File
Shows the name of the currently open template.

Import settings

Seller

Seller Id
Default Seller Id if it is missing from the file.
Channel
Default Channel if it is missing from the file.
Currency
Default Currency if it is missing from the file.
Date Order
Order of the Date, Month and Year in the Sale Date column.
First line is a header
Skips the first line of the file if it is a header row.

Column mapping

Shows the first five rows of the import file, so you can map the columns.
To map a column, click the drop-down menu at the top of each column and select the field that column should be mapped to.
Use the arrow buttons on the left and right of the drop-down menus to scroll the columns.

Importing

Once you have mapped all the columns, save the template and click Import. Any issues or errors will be shown before importing. After importing you will be asked to confirm import of the orders.