7. Reports

fmReports - Reports FeaturefmStringDialogfmReportCount

It's important to stay up-to-date with the overall performance of the business. Reports section allows the store owner to view information about customers' behavior on his/her website.

We are glad to offer our help and create reports personally for you, following all your requirements and needs. Please contact us today with a sample of your report and we'll provide you with estimated time and cost.

General Information

Comparing reports' data allows you to see if you need to make any changes in pricing or product descriptions. For some reports, you need to specify the report dates before the report is generated. Once you open any report, the following options are available:

  • Print

  • Save

  • See the report outline

  • Thumbnails

  • Choose page settings

  • Edit page (report)

There are also numerous export options available. You can save the 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 to filling out your tax report, since you can import it directly into an Excel spreadsheet.

All reports in Store Manager can be customized - you can change report layout, insert pictures (logos), add and remove fields etc. There are many ways to customize a specific report. Go to "Edit" page by clicking the corresponding icon. There you'll see "Designer's" toolbar, “Standard” toolbar, “Text” toolbar, “Frame” toolbar, “Align” toolbar.

Also, you can create your own reports. By each report name you can identify its purpose and information it contains.

Each report has two parts:

  • Report template - 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:

Start-> eMagicOne -> Store Manager forPrestaShop Application Data (C:\Users\YOURCURRENTUSER\AppData\Local\eMagicOne Store Manager for PrestaShop)

By default, the Store Manager "Application Data" directory looks like this:

Report Types

Report section helps by automatically calculating hourly, daily, weekly, monthly and yearly data for your store. The program has two types of reports:

  1. Default reports

  2. 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, whereas default reports should be modified with the external program called Report Tool (rpt.viewer).

Note: You do not need to download this tool from the external resources.

You can find Report Tool in application program group along with other program shortcuts:

Local Disk (C)/Program Files(x86)/eMagicone/Store Manager for.../rptviewer3

Report Editing

Store Manager allows you to work with a third-party program (Report Tool) for report developing and editing. Check the User's Manual to learn more about this tool.

In case you want to add some logo or change text format for some columns, you need to modify the report template (you do not need to modify SQL files).

To edit one of the report templates follow few steps:

  1. Run Report Tool:

Local Disc C -> ProgramFiles (x86) -> eMagicOne -> Store Manager for PrestaShop -> rptviewer3 (C:\Program Files (x86)\eMagicOne\Store Manager for PrestaShop)

2. Open Report Template (.fr3 file) in the Report Tool:

Start -> eMagicone -> Store Manager for PrestaShop Application Data -> Reports -> BestCategories sub-directory (for default reports like Invoices, etc) and Custom Reports sub-directory (for Custom reports)

Also you can find it in:

C:\Users\$USERNAME$\AppData\Local\eMagicOne Store Manager for PrestaShop\Reports\ or \Custom Reports\

For example, following this path (see an illustration below) you move to your Reports directory that consists of a list of all existing Reports Templates from the Reports section of Store Manager.

By clicking the relevant folder, you are able to enter the necessary file with the report template. To find and preview the BestCategories report template and choose the Best Categories folder and open the same-named .rptviewer3File:

Remember that every report, besides of its template, needs some data to be displayed. To customize the data for any report (in case you would like to add some additional information to your report), you have to modify .sql files.

SQL files are stored in Reports or Custom Reports folder. Select the report type you want to customize, e.g. invoice, and click the corresponding folder. In the list, which appears, you are able to see an SQL file corresponds to the selected report template.

Please note that this requires some SQL skills.

Please also note that the modification of the report is not a feature of Store Manager itself and we do not provide support for the third-party application (Report Tool).

Since the last program update, you can find all your pre-saved report files in the folders, by following this path:

C:\Users\$USERNAME$\AppData\Local\eMagicOne Store Manager for PrestaShop\Custom Reports

In addition, note following, in the "Advanced" section of Store Manager there is the field for specifying the path to the Reports - you can choose your Reports location.

There you can save and edit only reports that were separately created not in Store Manager. All Reports created in the program you can find by following this path at the computer:

C:\Users\$USERNAME$\AppData\Local\eMagicOne Store Manager for PrestaShop\Reports

and

C:\Users\$USERNAME$\AppData\Local\eMagicOne Store Manager for PrestaShop\Custom Reports

You may find other useful information here:

How to Create a Simple Type of Report

PrestaShop – Reports

You're welcome to contact us for additional consultations.