How can I edit/customize reports in Store Manager?

How can I edit/customize reports in Store Manager?

This article contains general information on how to customize reports with Store Manager for Prestashop as an example.

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 report.

You can find report files here: C:\Users\%USERNAME%\AppData\Local\eMagicOne Store Manager for PrestaShop\Reports

The program has two types of reports:

1. Default reports
2. Custom reports

Such reports as Best Customers, Best products, Best vouchers, Best categories, Best suppliers and Customers without shipping are default. Custom reports include samples of the following reports: Product List, Customers Report, Combinations Barcode Labels, Best Customers - Timeline and Barcode Labels.

Default report temlplates are stored in C:\Users\%USERNAME%\AppData\Local\eMagicOne Store Manager for PrestaShop directory.

The reports can be modified within Store Manager, you can add new custom reports or remove existing ones, with the help of external program called Fast Report Tool.
To edit one of these templates, select the needed report and hit Edit button from the context menu: 

Each report consists of two sections: SQL Editor and Report Designer. More information on how to edit reports please, check Fast Report Tool documentation: