2.2 Custom SQL linked to Products Import

fmCustomSQL, fmDialogCustomSqlEditor

You may use SQL commands in Product Import, by making the appropriate selections, within the Custom SQL interface section.

Linked to Products Import

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

Custom SQL in import step

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

Add new SQL

The form is identical to the choices in the Custom SQL section of Store Manager. Containing three tabs, the first, 'Edit' allows for manually entering the relevant SQL Statements, 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 from the Editor form.

The 'Customize Parameters' button allows for modification of a previously created SQL Statement,

Customize Parameters button

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

Cannot customize SQL message

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?

By eMagicOne Inc.