Reports

fmReports, fmCustomReportsForm, fmAddNewReportDialog

fmReportEditDialog, fmAddNewSQLDialog, frxPreviewForm , fmParamsFill, fmQuickSendMessageDlg


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 Magento -> Application Data

By 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. General reports (Currently there are five reports available by default)
  2. Custom reports (You can create them manually)

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 external program called Report Tool (rptviewer). 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

rptviewer3 file

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)
Reports folder

 
and Custom Reports sub-directory 
(for Custom reports).

Custom Reports folder


Also you can find it in 
C:\Documents and Settings\Your_User\Local Settings\Application Data\eMagicone Store Manager for ...\Reports\English\ or Custom Reports sub-folder.

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\SQL sub-folder. Please note that this requires some SQL skillsPlease 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). 


Order Report Development

In case you need to design your own reporting document with the specific data in it, press the option in the top toolbar and you will get to the page, where the appropriate report design can be ordered. 

Order Development Report

The report's price may change depending on the complexity of the request, so it would be better to fill the form in the page below and specify all your requirements and interesting questions. 

Specify your request in the Request form

You will get the answer from our Managers during 24 hours after checking your request with Tech engineers.


Send E-Mail

Before starting, make sure you have properly configured the SMTP server details to provide the direct mailing from the Store Manager.


Go to Preferences->E-Mail Settings->Switch to Advanced Settings and fill the necessary fields .

SMTP settings form

Press option to verify:

Test E-Mail button

Current feature is used for the internal correspondence in the Reports section.


To be able to send an email with the chosen report details to the admin or manager of the store (the email address which is specified in the SMTP settings form here) select the report you want to forward from General or Custom Reports sections. Then use 'Send E-Mail' option in the top toolbar:


- General Reports section:


General reports section

- Custom Reports section:


Сustom reports section

It opens the window for quick mailing. In the upper side you can check the email address on which the following message will be sent.


Check email checkbox

The template list of the email message, the subject field, the content of the template you can see below.

Use template from a list

In the right panel there is the Attachments sector. You can see the selected report in the file of the pdf format assigned to the message.

Attachments area

The additional information placed separately in external or internal sources can be added by using the 'Add' button here (see an illustration above).


To preview message via default email program ( like Mozilla Thunderbird, Opera, Mailbird etc. ) before sending hit the option in the toolbar of the form:


Preview email button

Once the preparatory actions are done you can start forwarding to.

Send email button

'Send E-Mail’ button transfers message to the recipient which email address is checked above.


The all outgoing correspondence of your store can be checked in the appropriate sector of Store Manager.


Automated Email Send

To automate sending from the General or Custom Reports sections, open the list of the scheduled tasks and click on the button to add a new action.


Show scheduled tasks and 'Add Task' option


Make the following actions in the form which appears:


- task name field - specify unique task name to be able to add it to the existing ones;


- task type - choose from a list the task on the specific sector you want to schedule:


Task type field


- task configuration - select one from the list of the previously saved or create the new configuration by pressing the button on the right - 'Create or Modify Configuration'


Task configuration field

The mailing form requires the following details:


1) depending on which task you have chosen above (reports or custom reports) you will see the list of the appropriate sector of the Reports page:


- General Reports list

Choose report field

- report config - this field should to be saved previously in the Reports page of Store Manager.


Report config field

If keep it unfilled you will get the following message:

Choose valid report configuration


- email template - indicate the template of the message:


Email template field

- email -  specify the email address of the recipient.  


Add email address

Type the configuration's name in the field below and save it by pressing the 'Save Settings' button.


Save configuration to a file

The current option helps to keep settings directly or separately (in case you choose an action to transfer them to s file).  All filled details will be saved and at the next time you can upload them by using the option - 'Load Settings'

to fill the form automatically.

Load Settings option

Press ‘OK’ option to keep this entry.


Specify the date and the time for the current operation performance in the Schedule area:


Schedule area

To save the task do not forget to press ‘OK’ button.


For detailed information concerning the service, please visit our page

Find more information on Report Development and Management in our page of useful articles, i.e. take into account the following tutorials:

Magento Report Features and Usage

Magento General Reports

Magento Report - Latency Matrix

Magento Report - Recency, Frequency, Monetary

Magento Report - One-time Buyers

Magento - Custom Reports

Magento Barcode Labels: Create and Print






You're welcome to contact us for additional consultations.

By eMagicOne Inc.

Comments