Zen Cart Reports
It's important to stay up to date with the overall performance of the business. In Zen Cart reports section allows a store owner to view information about customers' behavior on the website.
The following articles describe how to work with different kinds of reports:
- Zen Cart General Reports
- Zen Cart Additional Reports
- Zen Cart Custom Reports
- Zen Cart Reports Over Time
All reports in Store Manager for Zen Cart can be customized, you can change report layout, insert pictures (logos), add and remove fields etc.
Every report consists of two major parts:
- Report template
- Report queries
Report templates stored in .fr3 files they contain report layout information. Report queries stored in .sql files, they contain SQL queries to retrieve data required for report.
You can find report files under "Application Data" directory shortcut:
Start -> All Programs -> MagneticOne -> Store Manager for ... -> Application Data.
By default Store Manager "Application Data" directory looks like this:
Report section helps by automatically calculating hourly, daily, weekly, monthly and yearly data for your store.
Four types of reports are available in Store Manager:
- General Reports,
- Additional Reports,
- Custom Reports and
- Reports Over Time.
These two types are almost identical, the only difference is that custom reports can be modified within Store Manager, you can add new custom reports or remove existing, whereas default Zen Cart reports should be modified with external program called Report Tool (rptviewer). You can find Report tool in application program group along with other program shortcuts:
To edit one of report templates run Report Tool and open appropriate file.
Default report templates are stored in Start -> All Programs -> MagneticOne -> Store Manager for ... -> Application Data -> Reports, English sub-directory in .fr3 files.
Remember that every report besides of its template needs some data to be displayed. To customize data for a report you have to modify its .sql files. SQL files are stored in Reports\SQL sub-folder.
Download User's Manual to learn more about editing Zen Cart reports.
By each report name you can identify its purpose and information it contains. Comparing reports' data allows you to see if you need to make any changes in pricing or description. For some reports you need to specify the report dates before the report is generated.
Once you open the report, the following options are available: print, save, see the report outline, thumbnails, choose page settings and edit page (report). There are also numerous export options available. You can save current report as an image file, PDF file or a table and open it later using some application. This can be a big help when it comes time to fill out your tax report, since you can import it directly into an Excel spreadsheet.
There are many ways to customize a specific Report. Just go to Edit page by clicking corresponding icon. There you'll see "Designer's" toolbar, “Standard” toolbar, “Text” toolbar, “Frame” toolbar, “Align” toolbar. Download User's Manual to get a complete description of this page.
If you have any suggestions on Zen Cart Reports, you're welcome to contact our support team.