Magento Advanced Management

This section was designed for users with the above-average skills. Please do not make any modifications if you’re not sure what you’re doing.

Store Configuration

On this page you can see and modify the information that is displayed in the Configuration section of your Magento store Administration.

It was designed this way, so you don’t have to go back and forth in your Magento Store Administration Panel, looking for the required data and to change it. All possible modifications can be made here. However it’s necessary to have some skills and a good understanding of possible affects of any changes made.

Raw Table Editor

This section was created to allow you to work with the database tables and fields directly.

On this page you can see 2 panes: a List of all tables available at your store on the left, and contents of the Tables selected from this list on the right. Once you’ve selected a table, it will be shown on the right within 3 tabs.

Data tab displays all data stored in table cells, showing the actual table.
DDL tab displays table’s data structure in Data Definition Language (any formal language for describing data or information structures of your Database). A subset of SQL instructions is common.

Fields tab shows a table, structured by fields.

If you select more than one table, content of each will be shown in a separate tab. No matter what tables are selected, there are some general export options available, such as Export to Excel / HTML and Edit-as-HTML option. First two options are typical in Store Manager. As to Edit as HTML option – it is active for the Data tab of the selected table. It opens HTML Editor to edit any text in table cells easier and see its actual view.

Custom SQL

Here you can create a query using SQL language. This section can be used to work with your store DB, fetching data easier and faster.

When you open Custom SQL page, you’ll see it looks a lot like the Create New Report one. This page has 2 tabs: Edit and Logs and is divided in two sections: top one is showing the query content (SQL text), and the bottom one lists all available queries. You can also open an SQL Query file that was previously saved by clicking on icon.

When creating a new query (New SQL icon), you need to specify its name and click OK. At the bottom part of the page you’ll see the query with this name created. Now you can either run a Query builder or write query text in the top part of Edit tab directly. When you’re finished with this query hit the save button. Then you can execute it by pressing the Execute SQL button. The Results tab will appear, showing the returned data, arranged according to a certain condition.

If the query wasn’t executed, you can check the Logs tab for errors. Logs tab will be cleared after you close Store Manager.

When constructing complicated queries it’s more convenient to use Visual Query Builder.

Pending (Bridge) Data

In case you’re using PHP-MySQL Bridge to work with your store DB, here you’ll find the data that hasn’t been posted to your store yet. You can check logs of the changes you’ve made since last time you’ve posted changes to the live store.

At this page you can make the changes to the future data modifications. So when you post data, it will be posted with the changes you’ve made.

Please note that any modifications done using Pending Data section won’t be displayed at your current (local) DB till the time you get data from the web again.

If you have any suggestions on Magento Store Administration you’re welcome to contact our support team.