7.2. Custom SQL
The Custom SQL tool allows you to create SQL queries and upload queries from the file.
Examples of tasks you can perform via SQL queries:
Custom SQL tool is available with the PRO Edition of Store Manager for Magento.
In the Standart Edition, the Custom SQL section will be disabled. To use this tool, you will need to upgrade to the PRO Edition. Compare the Store Manager for Magento Plans & Pricing
Note: To use the tool, you must have extensive knowledge of building SQL queries.
SQL Editor Options
To open a custom SQL editor, click Tools > Custom SQL:
To create a query, press [New]. This and other queries that you create will be displayed in the left pane.
Open an SQL from a file
Create and Edit an SQL Query
Click the icon to open Visual Query Builder:
Within the SQL Editor, you can use the following options:
Format text according to the SQL standards
Linked to - shows to which entities the SQL can be applied:
When you open a corresponding grid or tool, linked SQL queries will be displayed in the Custom SQL drop-down:
SQL Help - open documentation :