IMReport (OC 3) - Advanced reporting of sales and orders |
OpenCart provides analytics, but it is implemented so basic that it is not enough even for a small store. Advantages 5. Filtering and paging are performed on the JS client side. We filtered the data once and "twist and turn them as you want" (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 the usual server approach, filtering and paging blocks the main database tables, which, with large amounts of data, will cause unnecessary braking for customers of your online store). Report "Marketable goods" Report "Products by options" "Stock Balance" report Keep in mind that the browser's capabilities are not as great as those of Excel or Opencal. It is quite difficult for the browser to display thousands of positions. Therefore, if you need to analyze a sufficiently large volume of goods, for example, all products from 20,000 positions (taking into account options), it is better to use uploading to a CSV file, since Excel and OpenCalc easily cope with such loads. The "Balance Control" report Second. After you have specified the settings, you can use the report. For all products or options that have negative or no balances at all, the filter value "Minimum quantity (default)" is applied. So if you have most of the goods or their options to be presented in the same quantity, then they do not have to be set. Order Turnover Report Report "Turnover of orders by day" This report allows you to get a daily report for the period on orders. To put it a little easier, for the selected period, orders with the specified filters are grouped by day, while their quantity, delivery, amount of goods (from order_total), total amount and corrector (discounts and so on; total amount minus the amount of goods and delivery) are calculated.
This report allows you to get data on customer groups for the period, taking into account the specifics of the purchased goods and their categories. Please note that in this report, the amount is also included in the delivery amount. To put it a little easier, then for each group the number of orders and the amount are displayed, taking into account filters. Report "Orders by region (delivery)" This report allows you to find out the volume of orders for each country and region for the period, taking into account the specifics of the purchased goods and their categories. Please note that in this report, the amount is also included in the delivery amount. To put it a little easier, then for each pair the country/Region (part of delivery) displays the number of orders and the amount, taking into account filters. Report "Orders (customers, delivery, payment)" This report allows you to filter all orders by customers and their used delivery and payment methods with the ability to filter by method names and codes. This report is especially useful in cases when it is necessary to analyze the most preferred payment and delivery methods for certain customers. For example, to provide better conditions for regular customers. Delivery Report This report is an extended version of the standard Sales/Delivery report. Allows you to see the popularity of various delivery methods depending on filters (payments, delivery, customers), as well as the total volume. Unlike the standard report, grouping is carried out by time, code, method and title of delivery. Report "Manufacturers (volume of products)" This report allows you to find out the volume of products sold for each Manufacturer for the period, taking into account the specifics of the purchased goods and their categories. Please note that in this report, it is the products of the category themselves that are summed up. To put it a little easier, then for each Manufacturer, the number of products and the amount are displayed, taking into account filters. Options Report This report allows you to find out the popularity of options in your orders for a certain period of time, taking into account the filter by category and manufacturer. In other words, now you can find out the most popular clothing sizes or computer modifications. The "Clients" report This is a comprehensive report that allows you to track your customers' orders. There are three types of reports in total: The first. Standard. This report displays data on customers and the number of their orders for the specified period. It contains a little more information than in a standard report on customers. However, an important feature is the ability not only to view, but also to sort, which is quite important when you have far more than one client.
Third. Search for lost clients. The essence of the report follows from its name. The report shows a list of those customers who have ever made purchases in your store, but did not buy anything during the specified period. With it, you can, for example, find out which customers did not buy anything for six months (day/month, etc.) or find out which customers did not buy anything in the last half of the year due to a decrease in demand (for example, in order to understand how dependent the product chain is on certain conditions).
Report "Goods without demand" This report allows you to find out which products are not in demand, but only occupy or occupied space in the warehouse. The report supports a lot of filters, including the ability to filter goods that are not in stock at a given time. Please note that with a large assortment, obtaining data may take time.
In some cases, reports with products may require their small main image (especially useful when printing). The display is enabled in the "Settings" tab. It is also possible to specify the dimensions in height and width of the received images. Take into account: 1. The settings are applied to all reports where products are displayed 3. Links to images are included in the CSV file only if the display is enabled Warning! You are not allowed to view this text.
Go back |
14-11-2022, 10:23 |