[RELEASED] ADV Products Purchased Report v3.1

ADV Products Purchased Report v3.1 for OC v1.5.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, Product Price, Product Quantity, Product Tax and Product 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, Product Price, Product Quantity, Product Tax and Product 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 filtering options by Purchased Date (with Date Picker) or Statistics Range, Order Status or Status Changed (with Date Picker), Order ID Range, Store, Currency, Tax Name, Tax Class, Geo Zone, Customer Group, Customer Name, Customer Email, Telephone, Customer IP, Billing & Shipping Company, Billing & Shipping Address, Billing & Shipping City, Billing & Shipping Region / State, Billing & Shipping Postcode, Billing & Shipping Country, Payment & Shipping Method, Category, Manufacturer / Brand, SKU, Product Name, Model, Product Option, Product Attribute, Product Status, Location, Affiliate Name & Email, Coupon Name & Code, Voucher Code.

Report 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.


Demo:
http://demo.opencartreports.com/admin/
Username: demo
Password: demo
Reports -> Products -> ADV Purchased

License:
Personal / Commercial (1 Site)

License, warranty, free upgrade and support apply to version:
OpenCart v1.5.x

License Developer (Unlimited Sites):
Price for License Developer (Unlimited Sites) is +$150.

Contact for support and customization:
opencart.reports@gmail.com

Link to Opencart store:
version 1.5.x
http://www.opencart.com/index.php?route ... on_id=3688

version 1.4.8, 1.4.9.x
http://www.opencart.com/index.php?route ... on_id=3943


################ RELATED EXTENSIONS ################
ADV Products Purchased Report + Profit Reporting v3.1 for OC v1.5.x
http://forum.opencart.com/viewtopic.php?f=124&t=46862

ADV Sales Report v3.1 for OC v1.5.x
http://forum.opencart.com/viewtopic.php?f=124&t=45034
ADV Sales Report + Profit Reporting v3.1 for OCv1.5.x
http://forum.opencart.com/viewtopic.php?f=124&t=46862

ADV Customer Orders Report v3.1 for OCv1.5.x
http://forum.opencart.com/viewtopic.php?f=124&t=44770
ADV Customer Orders Report + Profit Reporting v3.1 for OCv1.5.x
http://forum.opencart.com/viewtopic.php?f=124&t=46862


Main View for report by Products


Details for report by Products - Order List


Details for report by Products - Customer List


Main View for report by Manufacturers


Details for report by Manufacturers - Product List


Main View for report by Categories


Details for report by Categories - Product List


Export



Statistics Range selection box


b]Ajax autocomplete function and multiple select boxes[/b]


Report By, Product Options, Group By, Sort By, Details and Pagination selection box


Charts


Pagination


Settings option

Wow. Now that's advanced indeed
Great work

Extension Updated!
================
- fixed issues with databaze prefix and "no result" if products don't have manufacturer assigned,
- added manufacturer and categories to the results export function,
- added images to products,
- released version 1.4.8 and 1.4.9.x.

Extension Updated!
================
- added filtering by Product Options,
- changes in code which eliminate possible inaccuracies in the final report,
- in details view added colums for Customer Group, Shipping Method and Payment Method,
- fixed some design flaws

Extension Updated!
================

- added possibility to enable/disable grouping results by option to see the total value and purchased quantity for a product, regardless of options,
- thoroughly rewritten product options database queries for fully support multilingual stores and multilingual options names, now product with the same options don't get split based on the language! options names by product names and in option select box are now in your admin language.
- if products have option type text, textarea, file, date, time or datetime this option will not show by product names and in option select box because this are not actually options, just complement informations to products by ordering.
- changes in code to eliminate possible inaccuracies in the final report,
- fixed issue with select boxes in low resolution screens, now select boxes fit to screen width,
- fixed date formating in details view,
- fixed som other design flaws.

Extension Updated!
================

- added vQmod!
- added multiple select boxes for Order Status, Store, Currency, Tax, Customer Group, Category, Manufacturer / Brand and Product Status
- added filtering by multiple Product Options for "searching" the Product Options specifically (like "SMALL" and "BLACK" t-shirts... or "MEDIUM" and "RED" t-shirts)
- added filtering by Company, Customer Name, Customer Email and Product Name, it uses now Ajax autocomplete function (no big lists in select boxes!)
- added column for Product Tax in simple and details view and in export
- added select box Sort By, now it is possible sort results by Quantity or Total (default is sort by Total)
- added select box Show Details (default is No Details for quicker generating of report)
- added last line in report Total For Selected Criterias to show sum of Quantity, Tax or Total for selected filtering criterias
- fixed error if one or more orders contains more than one tax

======================================
!!! EXTENSION UPDATED TO VERSION 2.0 !!!
======================================

- added filtering by SKU, Model, Product Attributes and Location
- added column for Sold [%] in report and export function
- in details view - Order List added columns Product Price

Extension Updated - v2.1!
======================

- added new details view - Customer List, you can view detailed list of all customers who bought particular product (with product options) for selected date range or statistics range
- added sorting by Date, SKU, Product Name, Model, Category, Manufacturer / Brand and Product Status
- fixed wrong calculation of tax on products in details view
- changes in code for better performance and quicker generation of report

Extension Updated - v2.2!
======================

- added Settings option, now it is possible to choose select boxes for filtering and which columns to be shown in Main View, Order List, Product List and Customer List (settings remain saved till next editing !)
- significantly enhanced Statistics Range selection box, was added nine options for generate report
- changes in code for performance improvements
- some fixes and design changes and improvements

Extension Updated - v2.3!
======================

- added pagination into results of report and select box for showing 10, 25, 50 or 100 results on the one page
- in details view - Customer List added columns for complete billing address and shipping address
- improvements in code for better performance
- some fixes and design changes

Extension Updated - v2.4!
======================

- main functionality of report was enhanced by adding possibility to generate report by Manufacturers or by Categories, now it is possible to show sales data for every manufacturer or category!
- added new details view - Product List for report by Manufacturers or by Categories
- reports can be grouped by Year, Quarter, Months, Weeks, Days or No Grouping (default)
- added Charts for No. Orders, No. Customers, No. Products and for Sales
- added export option to .pdf file
- added option to export Report By Products, Manufacturers or Categories with or without details to .xls file, .html file or .pdf file
- added filtering by Affiliate Name
- changed file structure for smaller files size for quicker loading
- design changes of settings option

will this work with 1.4.9.6?
we are only getting a partial list of products sold and need a full list.

Version 1.4.8, 1.4.9.x is here
http://www.opencart.com/index.php?route ... on_id=3943

Extension Updated - v3.0!
======================

- installation of extension is now via modules page (Extensions -> Modules -> ADV Reports)
- in main view of report added columns for Attribute and Stock Quantity
- in details view - Product List for manufacturers and categories report added columns for Product Attributes, Manufacturer / Brand and Category
- added filtering option by Order Status Changed (with Date Picker)
- added filtering by Telephone, Billing & Shipping Company, Billing & Shipping Address, Billing & Shipping City, Billing & Shipping Region / State, Billing & Shipping Postcode, Billing & Shipping Country, Payment & Shipping Method, Affiliate Name & Email, Coupon Name & Code, Voucher Code
- enhanced Sort By select box
- better export function and show/hide settings of columns also apply to export function
- added automatic check version of extension with notification (Extensions -> Modules -> ADV Reports)
- minor bugs fixes and other graphical changes

Extension Updated - v3.1!
======================

- added filtering by Order ID Range, Tax Class, Geo Zone, Customer IP
- filter by Coupon Code and Voucher Code changed from select box to ajax autocomplete
- improvements in code for better performance
- minor bugs fixes and other graphical changes