5.3 Import Users

fmUsers

Please note, before import implementation, in case you perform it at the first time, we strongly recommend to make a backup of your store database!

You can make a backup using Tools -> Database Backup/Restore

Database backup

Open the Import wizard from the top toolbar of the Users page.

Import Users Data

or call the context menu vith the right-click:

Import Users from Context Menu

The first step of the wizard requires specifying the filename and the file path in the upper field. For more convenience, use the browse button.

Browser button in Select Source File

Take into account the "Select import source" area. There are three variants of the possible location of a file:

  • "Local file" in case your import file is placed on your computer and you can specify the local direction to it.
  • "HTTP URL to file" - your file is on a web-server and you have access to that server and its directories.
HTTP URL to a file

First of all, check URL in your browser. If you have the opportunity to open and preview the file by using current file URL path - it is available and you can proceed with the import.

  • "FTP URL to file" - this field serves to specify the file path located on a FTP server. Check your FTP credentials before filling the form shown below:
FTP URL to a file

Go to Preferences - > FTP and press the [Test Connection] button to verify settings. If you get the following message:

FTP test connection

You have an opportunity to specify FTP details and FTP directory in the current form. Otherwise, you should contact your hosting company to clarify your FTP access details.

To move to the next step of import click the [Next (Page Down)] button at the bottom. In order to move to the import step you need, without going through all the steps gradually, use the numbered boxes with the names of the import steps inside on the left.

Numbered boxes and Next button

2. Select fields delimiter and quote characters page contains some important settings to separate data.

Select delimiter character

The typical delimiters are the comma (,), semicolon (;) and tab character ( ), however other symbols can be used as well.

On the preview table, as shown below, you can see how selected delimiter affects the data displaying.

Table Preview during Delimiter selecting

"Quote string values with" specifies the character used to separate strings in the CSV file. Leave this field unchanged.

In case there are the field names in the first row of import file (see an illustration below),

Table with the field names in the first row

do not forget to select the corresponding checkbox at this step of import.

First row contains fields names but not values

If your file looks like on the image below you should leave this field unselected:

The values name in the first row of a file

3. Fields linking is the most important step of the whole import process and requires to assign the columns from a file to the relevant fields in your store database.

Use the drop-down list to find the necessary source field:

Choose fields to link

Or select the field on the left and double-click the corresponding columns on the right to make it assigned to the selected position.

"Identification Fields" in import. Select the necessary positions by which the WooCommerce import will search for a user. The users will be modified, if found, if not - new user will be added.

Identification fields to import

By using the top toolbar you can facilitate the linking procedure.

Linking step's top toolbar

[Auto Link All] helps to link all possible columns from a source file to the most suitable fields from the store database. Please note, it works only when the file columns names are the same as the store database fields.

[Unlink All] clears all "csv col" values at the left pane.

Link/Unlink selected positions

< - Use these options to link or unlink the selected positions separately.

Check if all necessary data is linked with the relevant columns from a source file.

Note: the fields that have the relevant CSV columns assigned, will be updated, and all the others - unassigned - will not be changed.

You also have the possibility to extend the current import functionality by adding the appropriate formula - expressions. With the simple expression, you can combine some values positions in the relevant fields of the store database or add additional data to your imported details. For example, if the Website name is not specified in your import file, it can be added by executing the following expression:

CONCAT('Your_Website_Name',[CSV_COL(x)])

where COL(x) refers to the column's number in the CSV file that matches the website information:

Example of simple expression formula

Press the [Insert value from import source] button on the toolbar to select the necessary fields value from the drop-down list.

&#39;Insert values...&#39;  option in Expression Editor form

To check the correctness of this formula press the [Execute Expression] button. You will get the result in a lower pane of the editor form.

Execute Expression Option

If you want to add more complex transformation to your imported data, for example, extract certain positions from the database or group data by a certain position, add a condition, under which the data will automatically change their values, etc. This is possible, provided queries to the database tables. It requires some SQL skills. Please check the following chapter about the Custom SQL section of Store Manager.

To create the appropriate query open the Editor form with the [Add Custom SQL] button.

Add Custom SQL button

To delete the extended formula from the SQL list, use the button for removal:

Delete Selected Custom SQL

A separate part of the current window occupies an area to create the skip rules. In other words, conditions under which the import data will be skipped - not be imported.

Skip Rules Area

By using the sign with the plus, you can create as many rules as you need. To remove selected rules from the list, press the minus sign. Then fill the form that appears:

Skip Rules form
    • Specify the rule’s type value - from resource file, from store database or from the expression.
    • Indicate the value which will be used for your rule.
    • Clarify the equation sign between the two parts of the rule.

If you use the expression formula, you should specify the value to which this expression will be used. You can take if from the store database or from a file’s data.

Use expression in Skip Rules Form

If the main actions on this step are done, you can go to the final page of import process - "Options."

4. Select the necessary method for processing import data at the top:

  • To add new item, if it is not already in your store database, and modify the existing ones, select "Add and Modify"
  • Add only new records without any additional changes in the store - "Add Only"
  • Only update the existing items but not add new ones, even if the importing products do not currently exist in the store database - "Modify Only"
  • The last option - "Just Add" allows to add the products from a file as a NEW without searching or validating existing data. Be careful, this action can lead to the duplicate records at your database!

Press the [Show advanced options] button and you will see the base date/time formats and value’s separators.

Show Advanced Options form

You can specify the row number, from which you want to start importing, and the row number, to which the data will be used in the process.

The fields already contain default values, which may be changed, if necessary. You can set the default settings on this step after pressing the [Set Default] button.

Please take into account!

One of the latest updates in Store Manager for WooCommerce (starting from ver. 1.15.0:979) passwords of users may not be rehashed after importing. There is a corresponding condition available in the Advanced Options form of the Import wizard:

Do not re-hash users password condition

To check the data for import before the start of transmission, click the [Preview import data] option . You will see the preview table in a separate window:

Preview Import Data

Attention! The import process will start, when you press the [Import] button!

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

Preview Import Results

To use these configuration settings in the future, save them directly to the wizard, or to a separate file, by clicking the corresponding button.

To have an opportunity to use current import settings in the next import processes, save them to a separate file or directly to the wizard list:

Save configuration option

You can also remove selected configuration or clear all configurations at once with one-mouse-click on the corresponding option from the drop-down menu.

Delete or Clear Configurations

The [Finish] button allows to exit the wizard and check data after import at your store.