Home Opencart Reports, Who’s online, and Statistics reports in Opencart

Reports, Who’s online, and Statistics reports in Opencart

In Opencart 3 and 4, 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

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 the following:

  • Added or registered customer then it logs with key as “register”
  • Edit customer then it logs with the key as “edit”
  • Edit the password when the customer is logged in with the key as “password”
  • Reset the password when the customer is not logged in with the 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:

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

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 Reward Points Report

Read the post on 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 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.

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.

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.

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.

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.

Coupon Report

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

Products Viewed Report

You can see a Products Viewed Report.

Products Purchased Report

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

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.

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

Statistics

You can see the overall statistics of the order sales, order processing, orders complete, returns, out-of-stock products, and pending reviews in the 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 is 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 manuals.

NO COMMENTS

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Exit mobile version