Import Categories

fmProducts

To be able to upload data to your online store from a separate CSV file use the Import Wizard tools.

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

In the "Categories" section find the "Import Data" options, which launches the "Start" page of the import process.

Import Categories section

1. The "Source selection" step holds the section where you should specify the file, from which your data will be transferred.

Make sure that your file is readable and reachable at the current time. To check this, try to open it before importing.

Select file to import

If you would like to use the import file from HTTP URL, indicate a URL path to your file.

HTTP URL to file

If your file to import has a FTP location, select the relevant checkbox:

FTP URL to file

To verify the correctness of your FTP credentials go to Preferences -> Settings -> FTP - > and press the [Test Connection] button.

FTP connection sucessfully

At the bottom of the "Start" page there is the field where you can select previously saved import configuration:

upload previously saved configuration

The unused configurations can be removed from a list after pressing the corresponding option. To clear all configurations list at once use the "Clear list" command.

Clear and Delete saved configuration

In order to move to the next step of import, use the numbered buttons on the left or press the lower button called [Next (Page Down)]

Numbered boxes on the left and Next option

2. The "Delimiter" page shows base delimiter characters that are used to separate fields data. You can see the preview of the imported details below.

Delimiters step of importing
  • "Quote string values" specifies the character used to separate strings in the CSV file.
Quote string value

If your file contains fields name in the first row, as on the illustration below:

Fields values in rhe first row of import file

select the following checkbox on this step of import. In other cases, leave this field unselected.

First row in the csv file

3. Next button overturns you to the "Field Links" step.

  • "Identification Fields". During importing the program will search for WooCommerce categories by using the selected identifiers. You can choose the multiple identifiers at once.
identification fields

On the right upper area, you have an opportunity to set the appropriate skip rule(s) to your imported data. Press the button with the plus to be able to create your own rule:

Add skip rules option

You can create as many skip rules as you need.

Also, provided you need to use a special formula to customize your data while importing, choose the third type value - "Expression".

Press the [Edit] button to launch the Expression Editor and create a necessary expression formula.

Expression edit option

Let's see how the formula should look like:

Expression formula

The left pane "Database Fields" shows the list of fields in your database that can receive import data.

Database fields to link

The fields that have the appropriate CSV columns assigned will be updated, the rest unassigned fields will not be changed.

with the corresponding options from the toolbar you can link/unlink selected positions individually.

Link-Unlink selected fields

To add an extended formula to your imported data, which will make more complex changes in the store's data after import, you should use the custom SQL Editor and have some SQL skills to generate the properly SQL query.

Add extended formula

Check the chapter about Custom SQL section in Store Manager.

To clear the SQL list click the relevant option next to [Add Custom SQL]:

Delete Selected Custom SQL

To open the expression editor you can use the corresponding button on the top toolbar as well:

Add expresison formula

Make sure whether you have assigned all required columns and fields. Press [Next] to proceed.

4. On the "Options" page, choose one of the import methods as listed below:

Import methods

Be careful, [Just Add] can lead to duplicate records at your database!

Fields in the "Show Advanced Options" form already contain default values, which may be changed, if necessary.

Advanced option area

Specify the full path to the folder with the categories' images. Use [...] button to open the drive system and choose the necessary location.

By pressing the [Import] button you will launch the process of import. It takes some time depending on the data amount you are trying to transfer:

Finish step of importing

You can save the import configuration to be able to use it during the next import process.

Save import configuration

After pressing the [Finish] button you can exit the Wizard and continue to operate with Store Manager.

Check the following useful article for more information about import and make the process successful:

How to import WooCommerce Categories