2.1 Сustom SQL linked to Products, to Categories

fmCustomSQL, fmMySQLHelp

Custom SQL section of Store Manager allows to link products or categories to a specific SQL that was previously created and run SQL commands directly on the main product page.

To perform this, during SQL query creation in Custom SQL section choose 'Linked to Products' or ‘Linked to Categories’ selection:

Linked to Products

For example, create the query that would delete the gift card account with zero balance.

Linked to products

Go to the main product page. In the top panel, you can see the Custom SQL option.

Custom SQL in Product Page

Select the products and for activation the necessary SQL command use the browse button which opens the drop-down list.

Activate SQL command

You can create as many commands as you need. Do not forget to link your SQLs to products or categories and you will be able to choose the necessary query on the product page.

To get more information about linking Custom SQL(s) to the Products or Categories look through this guide:

By eMagicOne Inc.