2.2 Custom SQL linked to Products Import
You may use SQL commands in Product Import, by making the appropriate selections, within the Custom SQL interface section.
In the Import Options dialog, select the field(s) (buttons and check boxes) relevant to the SQL queries that are to be performed.
To create a new SQL statement, press the 'Add New SQL' button, which opens the Custom SQL Editor form:
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,
Usually, this option is unavailable for current usage, and selecting it will result in the following error 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: