Reports

fmReports - Reports Feature
fmStringDialog
fmReportCount

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 estimated time and cost.

The following topics are covered:

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 and 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 time to fill 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. Just 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 "Application Data" directory shortcut: Start -> All Programs -> eMagicOne -> Store Manager for ... -> Application DataBy default Store Manager "Application Data" directory looks like this:

Application Data

Report Types

Report section helps by automatically calculating hourly, daily, weekly, monthly and yearly data for your store. 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). 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

rptviewer tool

Report Editing

Store Manager allows you to work with a third-party program (Report Tool) for report developing and editing. Check 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 just need to modify report template (you do not need to modify SQL files). 

To edit one of report templates follow few steps:

  1. Run Report Tool - Go to Start -> All Programs ->  eMagicone  / Store Manager for... / rptviewer3 (free third-party application).
 
    2. Open Report Template (.fr3 file) in the Report Tool - Go to Start -> All Programs -> eMagicone -> Store Manager for ... -> Application Data -> Reports -> English 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 which consists of a list of all existing Reports Templates from  Reports section of Store Manager. 

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

Best Products Report Template

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 - eg invoice - and click on the appropriate folder. In the list which appears you are able to see an SQL File corresponds to the

selected report template.

SQL File in Reports

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

You should note in addition, when the current version of Store Manager was updated all your pre-saved reports files you can find in the folders dated of last program updates, following  this path 

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

Reports after last updates


In addition, note the 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.

Path to Reports Directory

Here you can save and edit only the separately created reports - not in the 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're welcome to contact us for additional consultations.

You may find other useful information here:

PrestaShop – Reports

By eMagicOne Inc.

Comments