• OpenCart Manager RSS
  • OpenCart Manager YouTube
  • Follow OpenCart Manager on Twitter
  • Google+
  • OpenCart Manager on Blogger
  • OpenCart Manager on FaceBook
1-855-814-4511
8 AM - 7 PM (GMT) / 3 AM - 2 PM (EST)
1-855-810-5797
8 AM - 7 PM (GMT) / 3 AM - 2 PM (EST)

OpenCart Reports

Date: May 2nd, 2014

Let’s face it, you cannot effectively and efficiently conduct business without keeping an eye on what’s going on at your OpenCart store.

To successfully grow and manage increasingly complex multiple operations taking place at your online shop, you need to have statistics represented visually to see clear and complete picture of your online shop’s performance.

How many customers have purchased the product? How many products were bought in a week? That are the questions for which merchants always want to know answers.

With OpenCart reports you can drill into various aspects of your online shop's activities. You can measure your sales, abandon rates, find out most popular products in the catalog. With this useful information you can better draw conclusions about the status of your business.

Store Manager for OpenCart allows you to get to know exactly what need to be done, where and when. With the application it is possible to generate reports using built-in samples (for most common needs of analytics) as well as custom reports (for users with tech knowledge to adapt reports to their needs).

In Store Manager there is the separate section for reports on Ribbon Menu. Opening it you will see a few ready-made reports you can use or create/edit the one in correspondance to your needs.


General OpenCart Reports

Already available reports you can simply use and get statistics with your data. You will be able to modify some details listed, if necessary, and then save at your PC, export to PDF or other supported format or right away print it out. You can not only modify the data within your report, but its general look like its layout, logo, data fields to be included.


However, in case report slightly differs from the one you would like to get and you need to adjust template for it to be used further, it is possible with free report tool available in Store Manager. To do that go to Start ->All Programs -> Store Manager for OpenCart -> Application Data -> Custom Reports subdirectory and choose sample to be modified. Please note, this section requires from you knowledge of SQL to implement changes.


Custom reports

If you have some specific requirements to information included in report, you can create your own report that fully corresponds to your needs.

For that you need to press “New report” button from the menu and after new form will be opened there you can add SQL queries responsible for data selection. Moreover, you can design your report in the way you like.


Everything you add to report can be saved at your computer for further usage: layout information in the files of .fr3 format and SQL queries in .sql format correspondingly.


Pay Attention:

  • If you need to change logo there is no need to deal with SQL queries, it is enough only to modify template.
  • SQL files should be used or changed only in case you need to add/edit report where special selections of data should be applied.
  • In case there are no data displayed in report, check time period (if possible to select any) and if you have corresponding information in your database.
  • If you have no idea of SQL, but need special report, we offer it as a service. Send us your requirements and we will estimate approximate time and cost of its development. This way you will be 100% sure that you get best result with no risks to your store.

Maximize your organization’s profitability! Prioritize the statistics which are important to you using reports functionality of Store Manager for OpenCart!


By Maria Kvasnytska