7.2.2. Custom SQL Linked to Products Import

fmCustomSQL, fmDialogCustomSqlEditor

You may use SQL commands in Product Import within the "Custom SQL" interface section.

Custom SQL section

In the "Import Options" dialog, select the field(s) (buttons and check boxes) relevant to the SQL queries that are to be performed.

Run custom sql section in Import wizard

To create a new SQL statement, press the [Add New SQL] button, which opens the "Custom SQL Editor" form:

Add Custom SQL Editor from Import Wizard

The form is identical to the choices in the Custom SQL section of Store Manager. It contains three tabs: "Edit", "Results" and "Logs".

The "Edit" tab allows to enter relevant SQL Statements manually, or, you may launch Visual Query Builder, to facilitate interactive entering of commands. After checking the "Execute SQL" option, be sure to check the results within the tab. If there are any resulting errors, open the "Logs" tab, to preview them.

Click [OK], to store the created query and to exit the "Editor" form.

The [Customize Parameters] button allows to modify previously created SQL Statement:

Customizate SQL parameters

Usually, this option is unavailable for current usage, and selecting it will result in the following error message:

Customize parameters pop-up

Customization is possible for certain types of commands, but should only be performed by data specialists possessing the relevant MYSQL/Database programming, and, or, manipulation skills.

Please contact us, if necessary. We will gladly assist in the construction of the appropriate SQL command(s) to modify your data, after import, for a reasonable additional, fee.

Use following guide if you need to get more information about this feature in Store Manager - it could be helpful for you:

What Is Custom SQL? How to Use Magento Custom SQLs for Data Management?