6. Import Orders (Professional and Enterprise Edition)
From now you can not only place your orders list separately in the file but also transfer orders from a file to the store via Import wizard option in Store Manager for Magento Professional and Enterprise Editions.
Press an option from the top toolbar and choose 'Import' to move to the import steps of wizard:
or use the context menu in the Orders page and find the appropriate action from the drop-down context list.
The initial step of the wizard requires the path to the imported file to be specified. Use the browse button to find necessary allocation.
'Use Configuration' field helps to use in the process of importing the previously saved import configuration file. The triangle option opens the drop-down list with saved configurations in the Wizard directly
and 'Load Setting' button allows to upload the configuration from a separate file.
By using the same option you can also clear all configurations list or delete the one you have selected before. In case uploading file from an external source by using the full URL path, check the second action.
Make sure the HTTP URL to the import file is reachable and open-able in the web space before continuing (simply download it in the browser).
In case you try to upload the file from the FTP server - mark the third action and specify the necessary FTP details as server name, FTP username, and password.
Check if you use the correct FTP credentials in the Preferences of Store Manager - F12 keyboard - press test connection button to verify.
Make sure you use the properly protocol and port number to connect. Find the file for importing on the FTP server by using the browse button.
The second step of the wizard allows to set delimiter character between fields data - you can check its correctness in the preview table below.
If the file to import contains names in the first row such as Order_ID , State, Coupon_code etc. -
mark with the tick the following lower field:
Click 'Next' button to proceed. Select appropriate store view which you want to import data to. If the orders details are different for each store view - check the checkboxes from a list to update.
In most cases you need only the Default store view field to be checked. Move to the base formats page, where you can see the main date and time separators. Leave these fields by default.
After some values have been changed and you got an error on the following Preview step - return back to this page and press 'Set Default' option to restore default settings.
Linking page allows to assign the appropriate columns from a file with the suitable fields from your store database.
A message which you can see in the illustration above contains a warning notification on the possible incompatibility of the data which are importing from the outdated version of shopping cart.
In order to transfer all data correctly we recommend to contact our support center for further assistance. If your version of Magento shopping cart is updated the following message will be absent.
Take into account the orders identification area below:
Open the drop-down list to choose one of the following variants:
- order ID.
Note, by using the Enterprise Edition of Store Manager for Magento, the possibility to get the customer details will be available in the field below:
If you check this field you should specify the customer data identifier as well :
Important, if check 'Import customer data' in Professional Edition and import orders related to the customers which are not existing in the Customers section of Store Manager (such customers are not created ) ,
the order details will be added but non-existing customers will not be imported to the Customers list!
Specify corresponding column number opposite each store database field on the left pane.
The fields with the assignment will be imported only! Use expression formula to modify imported details:
If you need more information or any help during expression creating - click on the ‘Help’ button in the top or press F1 keyboard.
Take a note, the fields related to the orders comments can be linked and imported since the last program update (starting from ver.3.9.0:2017) :
Starting from the updated version of Store Manager for Magento (v.3.16.0.:2231) you can see a message on the compatibility of the old versions of the Magento with the new ones -
namely about the issues with some fields of the order importing details.
Recommendation: contact with our support center to get qualified assistance during the import orders process.
On the preview step, you can see the tabular data which will be transferred . You can narrow down the scale of importing, indicating the rows number of starting / ending.
Move to the last step of the wizard, where you can make the final preparation to the main process, i.e. - shutdown computer once the import is completed, cache import data, save the import configuration file to the wizard directly.
or to a separate file, remove the configuration from a list .
To start import press the button below. In the result window, you can see the report on executed procedure .