Opencart Reporting

In Opencart 3, we can get reports, who’s online, and statistics for sales report, customer transaction report, customer activity report, customer orders report, customer searches report, tax report, shipping report, return reports, sales report, coupons report, products viewed reports, and products purchased report. Login into the admin section and in the left menu you have the Reports menu item, click it and you will see reports page where you can choose the report type and see the data.

Reports

Reports in Opencart

You can choose the following report type:

  • Customer Transaction Report
  • Opencart Customer Activity Report
  • Customer Orders Report
  • Opencart Customer Reward Points Report
  • Customer Searches Report
  • Tax Report
  • Shipping Report
  • Returns Report
  • Sales Report
  • Coupons Report
  • Products Viewed Report
  • Products Purchased Report

Customer Transaction Report

Customer Transaction Report Opencart

In the Customer Transaction report, you can see all the sales reports by customer name, email, customer group, status, and total. You can filter it with Date Start, Customer Name, and Date End.

Customer Activity Report

When you enabled the track customers’ activity via the customer reports section at admin >> System >> Settings >> edit the store >> then in the Options tab >> find the Customers Activity and select Yes, then it starts to log the customer activity in the report sections. Checking the code at catalog/controller/event/activity.php, we can see that they add the following comment, IP and date added for following:

  • Added or registered customer then it logs with key as “register”
  • Edit customer then it logs with key as “edit”
  • Edit password when the customer is logged in with key as “password”
  • Reset password when the customer is not logged in with key as “reset”
  • Login by the customer with key as “login”
  • Forgotten password request by the customer with key as “forgotten”
  • The transaction is added for the customer then it logs with key as “transaction”
  • If the customer is added as Affiliate then it logs with key as “affiliate_add”
  • When you edit the affiliate information then it logs with key as “affiliate_edit”
  • If an address is added for the customer then it logs with key as “address_add”
  • When the address is edited for the customer then it logs with key as “address_edit”
  • When the address is deleted for the customer then it logs with key as “address_delete”
  • Return is added by the customer then it logs with key “return_account”
  • Return is added by the guest buyer then it logs with key “return_guest”
  • The order added by the customer then it logs with key as “order_account”
  • The order added by the guest buyer then it logs with key “order_guest”

The database table “oc_customer_activity” will have data like below:

Customer activity database Opencart

In the report section, you can see the customer activity report as below image:

Customer activity report opencart

Customer Orders Report

You can see the Customer orders report in Opencart, where you can filter out with date start, customer, date end and status of orders.

Customer Order report opencart

Customer Reward Points Report

Read the post of how reward works in Opencart. Once the reward is applied to the customer then you can see the customer reward points report. The report looks like below where you can filter out by data start, customer and date end:

customer reward report Opencart

Customer Searches Report

In the “customer searches report” you can see what customers are searching for. You can filter the report by date start, customer, date end, IP and keyword.

Customer research report

Tax Report

You can get the tax report in Opencart. Go to admin >> Reports >> then choose the Tax report where you will see all the tax details. You can filter out by date start, date end, group by days or weeks or months or years and status.

Tax report Opencart

Shipping Report

You can see the shipping report which you can filter out by date start, date end, group by days or weeks or months or years and status.

Shipping report Opencart

Returns Report

You can see the post for how product returns are handled in Opencart 3, you can see the returns report and filter out with date start, date end, group by days or weeks or months or years and status.

Return reports Opencart

Sales Report

You can see the sales report on Opencart 3. You can filter out by date start, date end, group by days or weeks or months or years and status.

Sales report Opencart

Coupon Report

You can see the coupons report on Opencart 3. You can filter out by date start and date end.

Coupon report Opencart

Products Viewed Report

You can see a Products Viewed Report.

Products viewed report Opencart

Products Purchased Report

You can see a report of products purchased. You can filter it out with date start, date end and status.

Products purchased report opencart

Who’s Online

You can track customers online via the customer reports section and see who is online right now. To activate the customer online report go to admin >> System >> Settings >> Option tab >> Account section and select Yes for customers online.

who is online opencart settings

Once you enabled then the reports start showing at admin >> Reports >> Who’s online

who is online opencart report

Statistics

You can see the overall statistics of the order sales, order processing, orders complete, returns, out of stock products and pending reviews at statistics report.

Statistics report

Opencart 3 has lots of reportings, it is in the Reports section and some are available in the admin dashboard as well. But still, there are some functionalities that are missing like exporting on CSC or excels, reporting on charts and sometimes the best report of what visitors are doing on your website are tricky, however, to get the best reporting we would recommend you use google analytics enhanced reporting as well so that you can analyze what visitors and customers are doing in your website and get best decisions. In this way, you can see reporting in Opencart 3. Please don’t forget to post your questions or comments so that we can add extra topics. You can follow us at our twitter account @rupaknpl, subscribe to our YouTube channel for Opencart tutorials, and click to see all Opencart user manual.

LEAVE A REPLY

Please enter your comment!
Please enter your name here