ADV Products Purchased Report v3.1 [OC v1.5.x]
||v1.5.3.x, v1.5.4.x, v1.5.5.x, v1.5.6.x
This Advanced Products Purchased Report is must-have for all sellers who is looking for accurate products purchased report. The supplied Products Purchased Report was completely rewritten, so if products have product options, report is divided by product options for particular product. There is possibility to enable/disable grouping results by product options to see the total value and purchased quantity for a product regardless of options. In main view there are columns for Product Image, SKU, Product Name (with bought product options), Model, Category, Manufacturer / Brand, Attribute, Status, Stock Quantity, Sold [Qty], Sold [%], Product Tax and Product Total for particular product and selected date or statistics range.
Main functionality of report is enhanced by possibility to generate report by Products, Manufacturers or Categories so it is possible to show sales data, cost and profit for every product, manufacturer or category.
Very important functionality of this report is details view. It is possible to choose between No Details (for quicker report generating), Order List, Product List and Customer List.
By choosing Order List in report by Products you can view detailed list of all orders for selected date range or statistics range, there are columns for Order ID, Order Date, Invoice No., Customer Name / Company, Email, Customer Group, Shipping Method, Payment Method, Order Status, Store Name, Currency, Price, Quantity, Tax and Total for particular product in particular order ID and product.
By choosing Customer List in report by Products you can view detailed list of all customers for selected date range or statistics range. There are columns for Order ID, Order Date, Invoice No., Customer ID, complete Billing Address, Telephone and complete Shipping Address.
By choosing Product List in report by Manufacturers or by Categories you can view detailed list of all ordered products for selected date range or statistics range. There are columns for Order ID, Order Date, Invoice No., Product ID, SKU, Model, Product Name, Options, Attributes, Category, Manufacturer / Brand, Currency, Price, Quantity, Tax and Total for particular ordered product.
Report can be generated by Product Options, grouped by Years, Quarter, Months, Weeks, Days, Orders or No Grouping and sorted by all columns in main view.
Report have lot of filtering options and supports table export to excel .xls file, .html file or .pdf file. There are 7 options for export function: export products report with No Details, with Order List and with Customer List, export manufacturers report with No Details and Product List, export categories report with No Details and Product List. Export function supports multi language in all fields with UTF-8 encoding so it should work in all languages.
Notice to existing users:
Please do not post any code related to the extension or questions related to issues with installation that you may have in the comments area or forum. Read the detailed installation instructions and if you still can't find a resolution please send me an email with full details of issue.