OpenCart provides analytics, but it is implemented in such a basic form that it will not be enough even for a small store.
However, for many questions, you can find a solution using this module IMReport - Extended reporting of sales and orders (Report "Hot Selling", "Customer Group", "Orders by region (delivery)", "Manufacturers (volume of products)" and etc).
Advantages
1. Normal calculation of the amount. In the standard analogue "Report on purchased goods", the amount is calculated incorrectly.
2. Ability to upload data to CSV files.
3. Powerful advanced filters (customers, customer groups, categories, manufacturers and so on)
4. Each of the reports is tailored for solving the most important tasks, so you do not need to "rummage through configurations and invent something" (and the client report has as many as 3 unique modes). In simple words, a tool for people. Open and use.
5. Filtering and paging is done on the JS client side. Filtered the data once and "twist and rotate it as you like" (this approach in practice turns out to be more profitable than server filtering, sorting and paging, since the data is transmitted once, and JS performs filtering and paging very quickly; in addition, in the case of a conventional server-side approach, filtering and paging blocks the main database tables, which, with large amounts of data, will cause unnecessary slowdown in your online store customers).
6. Ajax data loading - no need to reload the form every time. Everything is done quickly and conveniently.
7. And many other "snacks".
Hot Selling Report
As the name suggests. This report allows you to analyze all products sold for their popularity. A very convenient report for those who need the strengths and weaknesses of the entire turnover.
"Products by Options"
report This is an extended version of the "Hot Selling" report, where all purchases of an item are broken down by their configuration in options. In other words, you can find out how many computers were in circulation, computers with added 8GB RAM, computers with a non-standard case, computers with memory and with a case, and so on.
This report is especially useful for those who have options that strongly influence product sales. For example, textiles (like clothing), appliances (like computers), food (like
pizza shop), and so on.
"Stock balance"
report This report allows you to find out the stock&nbsp;<strong>balance</strong>&nbsp;for a specified category, manufacturer and the filter of the date of adding an item.&nbsp;A special feature is that the report presents the balance both for the product itself and for its individual options.
This report is especially useful for those who have an online store associated with a real store.&nbsp;Or, an online store is an intermediary between various suppliers and the end customer.
Keep in mind that the capabilities of the browser are not as great as those of Excel or OpenCals.&nbsp;It is quite difficult for the browser to display thousands of positions.&nbsp;Therefore, if you need to analyze a sufficiently large volume of goods, for example, all products from 20,000 positions (including options), then it is better to use the upload to a CSV file, since Excel and OpenCalc can easily cope with such loads.
Inventory control
report This report allows you to quickly find out what goods are in short supply in the warehouse and must be ordered from suppliers.&nbsp;The report is used in two stages.
First.&nbsp;On the "Control of stocks (settings)" tab, you must set the minimum stocks for goods and their options.&nbsp;Please note that if the value is specified as negative, then such a product will be shown in accordance with the report settings.&nbsp;If a specific value of the minimum required balance is specified for a product or a product option, then such a product or option will be displayed in accordance with whether there are enough of them in the warehouse or not.&nbsp;If you want to hide a product or an option from the report altogether, then it is enough to specify the value 0 (there cannot be less than zero residuals).
Second.&nbsp;Once you have specified the settings, you can use the report.&nbsp;For all products or options that have negative or no residuals specified, the "Minimum quantity (default)" filter value is applied.&nbsp;So if you have the majority of the products or their options must be presented in the same quantity, then they do not have to be specified.
Note.&nbsp;To simplify the process, the initial minimum quantity is specified in the localization file.&nbsp;The "default_min_need_quantity" parameter.
Note: It is possible to quickly edit values directly from the report.
Order turnover report
This report allows you to get a monthly report for the period for orders.&nbsp;If it's a little simpler, then for the selected period orders with the specified filters are grouped by month, while their quantity and total amount are calculated.
It is also possible to search only for those orders that have goods from the specified categories for the specified manufacturers.
and many more...
However, for many questions, you can find a solution using this module IMReport - Extended reporting of sales and orders (Report "Hot Selling", "Customer Group", "Orders by region (delivery)", "Manufacturers (volume of products)" and etc).
Advantages
1. Normal calculation of the amount.&nbsp;In the standard analogue "Report on purchased goods", the amount is calculated incorrectly.
2. Ability to upload data to CSV files.
3. Powerful advanced filters (customers, customer groups, categories, manufacturers and so on)
4. Each of the reports is tailored for solving the most important tasks, so you do not need to "rummage through configurations and invent something" (and the client report has as many as 3 unique modes).&nbsp;In simple words, a tool for people.&nbsp;Open and use.
5. Filtering and paging is done on the JS client side.&nbsp;Filtered the data once and "twist and rotate it as you like" (this approach in practice turns out to be more profitable than server filtering, sorting and paging, since the data is transmitted once, and JS performs filtering and paging very quickly; in addition, in the case of a conventional server-side approach, filtering and paging blocks the main database tables, which, with large amounts of data, will cause unnecessary slowdown in your online store customers).
6. Ajax data loading - no need to reload the form every time.&nbsp;Everything is done quickly and conveniently.
7. And many other "snacks".
Hot Selling Report
As the name suggests.&nbsp;This report allows you to analyze all products sold for their popularity.&nbsp;A very convenient report for those who need the strengths and weaknesses of the entire turnover.
"Products by Options"
report This is an extended version of the "Hot Selling" report, where all purchases of an item are broken down by their configuration in options.&nbsp;In other words, you can find out how many computers were in circulation, computers with added 8GB RAM, computers with a non-standard case, computers with memory and with a case, and so on.
This report is especially useful for those who have options that strongly influence product sales.&nbsp;For example, textiles (like clothing), appliances (like computers), food (like
pizza shop), and so on.
"Stock balance"
report This report allows you to find out the stock&nbsp;<strong>balance</strong>&nbsp;for a specified category, manufacturer and the filter of the date of adding an item.&nbsp;A special feature is that the report presents the balance both for the product itself and for its individual options.
This report is especially useful for those who have an online store associated with a real store.&nbsp;Or, an online store is an intermediary between various suppliers and the end customer.
Keep in mind that the capabilities of the browser are not as great as those of Excel or OpenCals.&nbsp;It is quite difficult for the browser to display thousands of positions.&nbsp;Therefore, if you need to analyze a sufficiently large volume of goods, for example, all products from 20,000 positions (including options), then it is better to use the upload to a CSV file, since Excel and OpenCalc can easily cope with such loads.
Inventory control
report This report allows you to quickly find out what goods are in short supply in the warehouse and must be ordered from suppliers.&nbsp;The report is used in two stages.
First.&nbsp;On the "Control of stocks (settings)" tab, you must set the minimum stocks for goods and their options.&nbsp;Please note that if the value is specified as negative, then such a product will be shown in accordance with the report settings.&nbsp;If a specific value of the minimum required balance is specified for a product or a product option, then such a product or option will be displayed in accordance with whether there are enough of them in the warehouse or not.&nbsp;If you want to hide a product or an option from the report altogether, then it is enough to specify the value 0 (there cannot be less than zero residuals).
Second.&nbsp;Once you have specified the settings, you can use the report.&nbsp;For all products or options that have negative or no residuals specified, the "Minimum quantity (default)" filter value is applied.&nbsp;So if you have the majority of the products or their options must be presented in the same quantity, then they do not have to be specified.
Note.&nbsp;To simplify the process, the initial minimum quantity is specified in the localization file.&nbsp;The "default_min_need_quantity" parameter.
Note: It is possible to quickly edit values directly from the report.
Order turnover report
This report allows you to get a monthly report for the period for orders.&nbsp;If it's a little simpler, then for the selected period orders with the specified filters are grouped by month, while their quantity and total amount are calculated.
It is also possible to search only for those orders that have goods from the specified categories for the specified manufacturers.
and many more...
