Hello,
We present you a new extension to CS-Cart and Multi-Vendor which allows generating sales reports basing on categories, products or customer in CSV format.
We start from installing an extension:
Add-on configuration contains two options:
- Order statuses counted towards statistics: select order statuses, that are taken into raports. With this option you can, for example, generate statistics about most frequently returned products.
- CSV file separator: select char which is used to separate records in CSV file.
Reports configuration is available in menu Website -> Manage reports.
Menu displays all available raport and basic information about them. New raport can be created with + button in upper right corner.
During raport creation, the following options are available:
- Raport name: identifies record on the list of reports. Does not affect raport content.
- Data source: which raport should be generated. Four options are available:
- Products: raport shows sale of selected products, defined in "Products" field later.
- Categories: raport shows sale of products from selected categories. Each category has a separate record. Categories are selected in field "Categories" later.
- Products in categories: same as "Products", but instead of pre-defined list of products, they are propagated basing on categories selected in field "Categories".
- Customers: raport shows sales generated by customers, given in field "Customers" later.
- Products, Categories, Customers: fields used as a source of data for generating raports.
- Period - from / Period - to: fields defining range of dates, which should be used to download orders.
After preparing report, under the rack there are two options of raport generation available:
- Preview raport: generates simple table with raport results and displays it in administration panel.
- Download as CSV: raport is generated as CSV file (with separator defined in add-on configuration) and is instantly ready to download.
On the below example, we generate raport for certain products, over the whole period of store existence:
Raport contains name of record (category, product, customer), generated sale and additional info - for categories its amount of subcategories, for products - product code, and for customers - their e-mail address.
Raport in CSV format has a name matching day of generation and its content.
Features:
- no core file changes
- Compatibility CS-Cart and Multi-Vendor version 4.0.x, 4.1.x, 4.2.x, 4.3.x, 4.4.x, 4.5.x, 4.6.x, 4.7.x, 4.8.x, 4.9.x, 4.10.x, 4.11.x, 4.12.x
Please, do not hesitate contact us if you have any additional questions.
Link to addon
See our other addons in Marketplace.