7.2.1. Custom SQL Linked to Products, or Linked to Categories
The "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":
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 to activate 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.