Product Sales Information
By default Magento has a lack of good Sales Information, what product is your best seller and how much did I sell in the last month. Get more details on how fast your products are selling and manage your stock levels even better.
Available Sales Information
For every product you can get the number of products sold for the following periods:
- Two Weeks
- Half Year
For the customer sales the following information is available:
- Number of orders
- Avarage order value
- Total order value
How does it work
Every hour all invoices created will be recorded for sold products, this information is stored in a separate table allowing quick search and reporting on the items sold. Everytime a creditmemo is created the amount sold is decreased to keep your sales information up-to-date. The sales information is also stored at product level for quick viewing when editting a product.
Using our report function it is possible to get a list of sold items in a specified period for the selected storeview. You can choose to group the sales information by day, month or year.
With the available data it is easy to add a widget to a CMS page or Block to show on your frontend. This widget allows you to display a grid or list and specify the number of products to show, it also allows you to add an attribute to filter your collection for example to create a bestseller per brand or product type. The products shown are listed based on the sales information stored.
For more information about installation of this extension goto our Installation Guide.
If you have an installation or configuration question about this extension, please use our Contact Form to get in touch with us.
View a live working demo of this extension to check if it meets your requirements.
Frontend URL: https://salesinfo.genmato.com/
Backend URL: https://salesinfo.genmato.com/admin/
- Release notes
Version: 15.295.2, release date: 2015-10-23Added source_id field to record unique invoice/creditmemo id and changed index
Version: 15.295.1, release date: 2015-10-23Added source_id field to record unique invoice/creditmemo id and changed index
Version: 15.292.1, release date: 2015-10-20Fixed unique index combination for importing creditmemosVersion: 15.43.1, release date: 2015-02-13Added current Stock Qty to Prouct Staistics reportVersion: 15.6.1, release date: 2015-01-06Added unique index to ban duplicate reads of invoice and creditmemo data
Updated reset script to also reset product data detailsVersion: 14.283.1, release date: 2014-10-12Optimized import invoices and creditmemos from the commandline thru a shell-scriptVersion: 14.277.2, release date: 2014-10-04Refactored order date import for large amount of orders
Added option to disable the order import run thru cron (and run it in a seperate cronjob or commandline)
Added check if there is already an import for the orders running.
Limited the amount of invoices/creditmemos per run to 100Version: 14.274.1, release date: 2014-10-01Fixed registration to use the BasePrice per product so all prices are in the same valuta
Added function to reset and re-read all dataVersion: 14.259.2, release date: 2014-09-15Added function to update product sales data (aggregation)
Added function to re-create stored-procedure thru shell scriptVersion: 1.0.7, release date: 2014-06-02Fixed data aggregation one week after last sale
Fixed sales count on product duplication
Version: 1.0.5, release date: 2014-01-25Added current Stock Qty to Product Sales grid
Added option to show unsold products on Product Sales gridVersion: 1.0.4, release date: 2014-01-05