4.3.3. Import Orders

fmOrders

Starting from the last program update ((v. 2.29.1 Build:1683) ) there is the ability to import orders list from a separate file.

Please note, this feature is available only in Professional Edition of Store Manager!

First of all, prepare the file to import. It should contain the following required fields:

  1. "Order ID"

  2. "Order Reference"

  3. "Payment Method"

  4. "Payment Module"

  5. "Total Discount"

  6. "Total Paid"

  7. "Total Price for Products"

  8. "Total Price for Product without Tax"

  9. "Total Shipping"

  10. "Total Wrapping"

  11. "Status"

  12. "Gender"

  13. "Firstname"

  14. "Lastname"

  15. "Customer Email"

  16. "Delivery Address 1"

  17. "Delivery City"

  18. "Invoice Address 1"

  19. "Invoice City"

  20. "Product Name"

  21. "Product Quantity"

  22. "Product Price"

  23. "Product Reference"

Make sure that all of them exist in your file to run import successfully.

Launch Import Wizard by opening the "Orders" section of Store Manager and pressing the [Import/Export Oreders] buttn in the top toolbar.

Select File

After choosing the necessary action on the Welcome page, you will be moved to the next import step - "Select File". You have to specify the filename and file path in the field above. To facilitate current process press the browse button to choose the file location from the system file explorer.

There are several oprions to select file location. For example, if the details of the order are on the external server and you can access the data by using the URL path, select the checkbox and specify HTTP URL in the field below.

If you need to run import from a file located on the FTP server, select the relevant checkbox and enter required FTP access details.

Note: Make sure, you have specified the correct FTP settings. To do so previously verify them in any FTP client to get the successful connection.

At the bottom of the import window, you are able to upload import configuration directly from the wizard list or from a file, and facilitate the passage through the import steps.

Select Fields Delimiter and Quote Character

This page displays the main characters which are used to separate the fields data. In the table, as shwn on the illustration below, you see how your data looks like after choosing a delimiter from the available list.

Base Formats and Separators

This step contains the basic format of date and time display.

If you do not have any specific format of these values, you can leave these fields by default.

Assign .csv Columns to Database Fields

The next step is divided into two sections:

  1. The first one - "Identify Methods" - is intended to determine the identifier by which the program will recognize the imported data. You should choose the identifier related to the customer, customer address, order and ordered product.

  2. The second one - "Database Fields", "Field Description" and ".csv file columns" - relates to the fields linking. On the left, you can see the list of database fields which can be assigned to the appropriate columns of the file to import.

Note: Positions marked in red display the unassigned values. These fields will not be imported!

To involve expression formula, click the [Editor] button opposite to the data you want to modify and specify the expression in the "Expression Editor" form.

On the right, there is a data that is going to be imported. The columns with the red values mean that data is unparalleled among the database fields and they will be skipped (not imported) after completion of the process.

The lower option helps to perform the following additional actions:

  • Use the [Auto Fill] button at the bottom of the page to automate fill out (assign) the columns from a file with the database fields. This option works only for the identical values.

  • [Clear] cancels the previous assignments between data.

  • If you upload the import configuration and change manually some columns assignments, the [Predefined] button helps to revert to the initial settings.

Note: to be able to run import orders you have to assign all required fields. If some of them are not linked, you cannot proceed and will get the next warning message:

If all necessary fields are linked, press [Next] to continue.

Preview Import Data

On the Preview step you will see what number of orders will be imported and what details are assigned and ready to transfer. You can specify the rows from which the data will be taken during the process at the bottom of the current page.

To perform this select the field and specify the necessary position by using the scrolling arrows:

The [Next] button moves to the penultimate step of the import process and you can select one of the following import methods:

  • "Add Only" serves to add new records that don’t exist in the database and skip the existing ones.

  • "Just add" allows to fast create new records in the existing orders list without searching the already created ones.

There are some additional conditions that can be selected before import running:

  • "Import orders with missing identifiers" allows to transfer, in addition, the records that have no specified product_ID in an import file.

  • "Update product stock". In case the product, which is assigned to the order in a file, is already available at the store you can decrease its quantity exactly to the ordered amount.

Note: If there is not enough quantity of product or the product does not exist, the order will not be created.

You are able to specify the path to the logs file by using the browse button opposite the corresponding field.

The [Import] button launches the process of data transferring.

Finish

Summary results can be previewed in the separate window once the import is completed. Summary results and errors, if any, are shown in the last step of Import Wizard:

Now the orders are imported and you can close the wizard by pressing the [Finish] button