2.1 Сustom SQL linked to Products, to Categories
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:
For example, create the query that would delete the gift card account with zero balance.
Go to the main product page. In the top panel, you can see the Custom SQL option.
Select the products and for activation the necessary SQL command use the browse button which opens the drop-down list.
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: