2. Custom SQL

fmCustomSQL, fmAddNewSQLDialog, fmEditExistSQLDialog - Custom SQL Section

This section can be used to work with your store DB, fetching data easier and faster. You can create and execute SQL queries and bulk update CubeCart data instantly. Note that it requires the above average skills as it may be destructive if performed incorrectly. It is strongly recommended to make full Database backup before executing any query.

Custom SQL section has 2 tabs: Edit and Logs

Edit tab has two sections: the top one is showing the query content (SQL text), and the bottom one lists all available queries.

Once you create and execute any SQL query in the edit tab, you'll see the logs tab. It shows if any error occurs while executing the query. Please note that it is strongly recommended to make database backup before executing any query.

In Custom SQL context menu or toolbar you can find the following options: