How can I edit/customize reports? - Store Manager for PrestaShop
20% coupon on Store Manager PRO Pack!
Limited discount, can can be applied to products only
Rating 5.00 stars - 3 votes

How can I edit/customize reports?

This article contains general information on how to customize reports in Store Manager.
If you haven’t installed Store Manager yet, download the free trial and connect the application to your store database using the wizard inside. Read about other Store Manager tools to simplify and speed up PrestaShop store management

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:

  1. Report template
  2. 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:

Edit Reports In PrestaShop Store Manager

The program has two types of reports:

  1. Default reports
  2. Custom reports

Store Manager for PrestaShop 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:

Store Manager Report Tool

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:

Default Report Templates in Store Manager for PrestaShop

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:

Manage Default Reports SQL and fr Files with Store Manager for PrestaShop

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:

Manage Store Manager for PrestaShop Report Fields

Doubleclick some field to get the following screen:

Edit Report Field via PrestaShop Store Manager

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.

Be the first to comment.