All reports in Store Manager 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 are stored in .fr3 files they contain report layout information. Report queries are stored in .sql files, they contain SQL queries to retrieve data required for the report.
You can find report files under the “Application Data” directory shortcut: C:\Users\User\AppData\Local\eMagicOne Store Manager for PrestaShop
By default Store Manager “Application Data” directory looks like this:
The program has two types of reports:
- Default reports
- Custom reports
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 ones, whereas default reports should be modified with an external program called Report Tool. You can find the Report tool in the application program group along with other program shortcuts:
Such reports as Invoice, Packing Slip, and Order are default. Default report templates are stored in C:\Users\User\AppData\Local\eMagicOne Store Manager for PrestaShop\Reports folder. There you can find separate folders for each report:
To edit one of these templates run Report Tool and open the appropriate file. Download User’s Manual to learn how to edit report templates.
Remember that every report needs some data (as well as a template) in order to be displayed. To customize data for a report you have to modify its .sql files. SQL files are stored under Reports folder, specific report subfolder, for example, under ‘Best Categories’ subfolder:
The report can use one or more .sql files whereas one .sql file may be used in one or more reports. For example Order, Invoice, and Packing Slip are very similar reports, and they use the same queries to retrieve data.
To figure out which .sql is used in a report open this report using Report Tool and see fields:
Doubleclick some field to get the following screen:
The entire report field enclosed in square brackets [ ]. The first part (before dot symbol) is .sql file name where “SQL” is a part of the name replaced with “DBDataSet”. The second part (after dot symbol) is the field name quoted with ” “.
For more information on how to edit reports download this User’s Manual.