4.5 Import Orders
Find necessary option in the top toolbar of Orders page
By helping with right-mouse clicking open the context menu and select the necessary command from a drop-down list:
1. On the first step specify the import data destination. You have three variants below:
- if you use local file - check the first checkbox - 'Local file' - and use the browse button to open the local drive system at your computer. Please note, selected file should be openable and readable.
- HTTP URL to file - this position means you have an access to the web-server where your data to import are.
First of all, try to open that file in your web browser by specifying the full URL path in the search box.
- FTP URL to file - this position allows to upload the data from the FTP server
Make sure you use the properly FTP settings firstly. Go to the Preferences section of Store Manager and open the FTP settings page - press 'Test Connection' button to verify the correctness of your FTP credentials.
If you get such message as in the example above you can proceed with the importing from the FTP.
In case your details are not correct - contact with the hosting company to agree the main details.
Load configuration field helps to use the previously saved import configurations during the current process. This significantly speed up the passage of the following steps of import.
To delete the existing export configuration choose the appropriate position or to clear the whole configuration list at once press the corresponding button from the drop-down menu:
2. Select fields delimiter and quote characters page contains some important settings to separate data.
The typical delimiters are the comma (,), semicolon (;) and tab character ( ), however other symbols can be used as well.
Quote string values - specifies the character used to separate strings in the CSV file. Please note, current option should to be checked to process data properly.
3. Next step - 'Fields Links' - divided into two panes - The left pane "Database Fields" shows the list of fields in your database that can receive import data.
To assign .csv column to database field you should select a field at the left and then click a column at the right pane.
Identification fields in import - check the necessary positions from a drop-down list.
Use the top toolbar to facilitate the linking process.
To be able to auto fill/unlink the selected columns on the left side - use the corresponding buttons on the toolbar:
In case you need to use some special formula for the appropriate data - open the Expression Editor form.
Use upper tools to build the correct formula and be able to transform data properly as the result:
To insert the extended formula during importing - press the button from the lower part of the left pane:
Please note, you should have some SQL skills to generate the properly query.
To delete the previously created SQL commands use the option for removal.
On the right pane you can create the special skip rules - special conditions at which data covered by them will not be taken into account while importing (i.e.will be skipped).
By using the ‘plus’ sign you can create the rule as you need. Fill the form which appears:
To activate the drop-down list with the fields each column, select the necessary one and press the arrow button which appears:
Use the suggested options to prescribe the necessary data for the future rule.
In case some data transformation use the ‘Expression’ position to be able to activate the formula in the current skip rule:
It should be uploaded in the next column as in the screen-capture below:
To delete the selected skip rule - press the option for removal:
Before moving to the next step of import process make sure all necessary data are linked with the appropriate columns from a source file.
Important, only the fields with assignment will be imported and the un-linked data will be skipped.
If all required data with the selected identification fields are not assigned - you will receive the following message:
Check the assignment between the fields to be able to proceed.
‘Options’ step allows selecting the one of the suggested import methods:
The fields are already contain default values, which may be changed, if necessary. You can use the default settings after pressing the corresponding button:
Before start importing you are able to preview the data by pressing the appropriate button:
Note, import process starts, when you press "Import" button! If you see any errors on Import Preview Step - return to the previous stage for correction.
The last stage of WooCommerce Import Wizard displays results and errors, if any emerged in the course of the import process.
To use current configuration details in the future - save them directly to the Wizard - press ‘Save configuration’ button or separately - click on the arrow next to the ‘Save configuration’ option:
The command from the drop-down list allow performing the additional actions as:
- Delete selected configuration from the Wizard list
- Clear all wizard list at once.
Note, these operations are irreversible and the removed data cannot be restored.
To avoid this, we recommend to save configuration to a file :