4.5 Import Orders


Find necessary option in the top toolbar of Orders page

Import data option

By helping with right-mouse clicking open the context menu and select the necessary command from a drop-down list:

Import data context menu

1. On the first step specify the import data destination. You have three variants below:

Select import spurce

- 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.

Load local file

- 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.

HTTP URL to a file

- FTP URL to file - this position allows to upload the data from the FTP server

FTP URL to file

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.

FTP test connection

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.

Load configuration button

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:

Open configuration list

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.

Preview table

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.

Fields link

To assign .csv column to database field you should select a field at the left and then click a column at the right pane.

Drop-down list from source file

Identification fields in import - check the necessary positions from a drop-down list.

Identificatiion field

Use the top toolbar to facilitate the linking process.

Autolink/Unlink All options

To be able to auto fill/unlink the selected columns on the left side - use the corresponding buttons on the toolbar:

Link/unlink the selected position

In case you need to use some special formula for the appropriate data - open the Expression Editor form.

Expression Editor form

Use upper tools to build the correct formula and be able to transform data properly as the result:

Toolbar of Expression Editor

To insert the extended formula during importing - press the button from the lower part of the left pane:

Add Custom SQL

Please note, you should have some SQL skills to generate the properly query.

Help button in SQL

To delete the previously created SQL commands use the option for removal.

Delete Selected Custom SQL(s)

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:

Add skip rule

To activate the drop-down list with the fields each column, select the necessary one and press the arrow button which appears:

Skip Rules drop-down variants

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:

Edit button in Skip Rules

It should be uploaded in the next column as in the screen-capture below:

Skip rule insert expression

To delete the selected skip rule - press the option for removal:

Delete skip rule

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:

Unassigned fields

Check the assignment between the fields to be able to proceed.

‘Options’ step allows selecting the one of the suggested import methods:

Options step

The fields are already contain default values, which may be changed, if necessary. You can use the default settings after pressing the corresponding button:

Set Default button

Before start importing you are able to preview the data by pressing the appropriate button:

Preview Import data

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.

'Back' option

The last stage of WooCommerce Import Wizard displays results and errors, if any emerged in the course of the import process.

Final step of importing

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:

Save configuration button

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 :

Save configuration to a file

‘Finish’ button allows to exit from a Wizard and check the data after import at your store Front-end.

Check the guide on the Useful Articles page to get more details on importing orders process:

WooCommerce Import Orders from CSV file

By eMagicOne Inc.