• Google+
  • Zen-Cart Manager RSS
  • Zen-Cart Manager YouTube
  • Follow Zen-Cart Manager on Twitter
  • Zen-Cart Manager on Blogger
  • Zen-Cart Manager on FaceBook
1-855-814-4511
8 AM - 7 PM (GMT) / 3 AM - 2 PM (EST)
1-855-810-5797
8 AM - 7 PM (GMT) / 3 AM - 2 PM (EST)

Zen Cart 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.

We recommend you to read our full updated documentation for Store Manager for Zen Cart here

Privacy Preference Center

Strictly Necessary

These cookies are necessary fro the site ot function.

woocommerce_cart_hash, woocommerce_items_in_card, wp_woocommerce_session_{hash}

Performance

These are used to track user interaction and detect potential problems. These help us improve our services by providing analytical data on how users use this site.

_ga, _gid, _gat-_UA-326982215-25, LaSID, LaVisitorId, __utma, __utmc, __utmv, __utmz

Close your account?

Your account will be closed and all data will be permanently deleted and cannot be recovered. Are you sure?