[RELEASED] ADV Customer Orders Report v3.1

ADV Customer Orders Report v3.1 for OC v1.5.x

This Advanced Customer Orders Report with Profit Reporting is must-have for all sellers who is looking for complete solution for accurate customer orders report and profit reporting. In main view there are columns for Customer Type (registered with ID or quest), Customer Name, Email, Telephone, Country, Customer Group, Status, Customer IP, Last Order, No. Orders, No. Products and Total Value of all orders for particular customer and selected date or statistics range.

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, Address List and All Details.

By choosing Order List you can view detailed list of all orders for selected date range or statistics range. There are columns for Order ID, Order Date, Invoice Number, Customer Name / Company, Customer Email, Customer Group, Shipping Method, Payment Method, Order Status, Store Name, Currency, No. Products, Order Sub-Total, Shipping, Order Taxes and Order Total for particular order ID.

By choosing Product List 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 Number, Product ID, SKU, Model, Product Name, Product Options, Product Attributes, Manufacturer / Brand, Category, Currency, Product Price, Product Quantity, Product Tax and Product Total for particular ordered product.

By choosing Address List you can view complete Billing Address and Shipping Address of every customer.

By choosing All Details you will get all details about orders, products and customers.

Report can be generated by All Registered and Guest, Registered, Guest or by New Customers, grouped by Years, Quarter, Months, Weeks, Days 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 Status, 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, Location, Affiliate Name & Email, Coupon Name & Code, Voucher Code.

Report supports table export to excel .xls file, .html file or .pdf file. There are 4 options for export function: export with No Details, export with Order List, export with Product List, export with Address List and export of All Details. 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 -> Customers -> ADV Orders

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=3749

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


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

ADV Products Purchased Report v3.1 for OC v1.5.x
http://forum.opencart.com/viewtopic.php?f=124&t=44419
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 OC v1.5.x
http://forum.opencart.com/viewtopic.php?f=124&t=46862


Main View


Details - Order List


Details - Product List


Details - Address List


Details - All Details


Export


Statistics Range selection box


Ajax autocomplete function and multiple select boxes


Customer Type, Group By, Sort By, Details and Show on page selection box

Charts


Pagination


Settings

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

- fixed issue with unregistered customers (guests), report is showing correctly now,
- added filtering by Shipping Method and Payment Method,
- added colums for Customer ID or Guest in report and export function,
- in details view added colums for Customer Group, Shipping Method and Payment Method,
- fixed some design flaws

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

- added filtering by Tax, Shipping Country and Payment Country,
- in details view - Order List added columns for Sub-Total, Shipping and Tax,
- fixed issue with select boxes in low resolution screens, now select boxes fit to screen width,
- fixed date formating in details view,
- fixed some other design flaws.

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

- added vQmod!
- added select box for Report by Customer Type, you can generate report for registered customers, guests or for both
- added multiple select boxes for Order Status, Store, Currency, Tax, Customer Group, Customer Status, Shipping Method, Payment Method, Shipping Country and Payment Country
- added last line in report Total For Selected Criterias to show sum of Orders, Products, Sub-Total and Total Value for selected filtering criterias
- added filtering by Company, Customer Name, Customer Email and Product Name, it uses now Ajax autocomplete function (no big lists in select boxes!)
- added filtering by Customer Status
- filtering by Company, Customer or Email now uses Ajax autocomplete function (no big lists in select boxes any more)
- fixed some issues and design flaws

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

- added new details view - Product List, you can view detailed list of all ordered products for selected date range or statistics range
- added filtering by Customer IP
- added columns for Customer IP and Sub-Total in report and export function
- added option for exporting report with Product List into .xls or .html

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

- fixed wrong calculation of tax on products in details view - Product List
- 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 and Product List (settings remain saved till next editing !)
- significantly enhanced Statistics Range selection box, was added nine options for generate report
- added sort by Customer ID, Customer Name, Customer Email, Customer IP, Customer Group, Status, Last Order
- in details view - Product List added column for Product Options and Product ID (with active link for editing product)
- in details view - Order List added column for income from Fees (Handling Fee + Low Order Fee)
- some fixes and design changes and improvements

Can you filter customers who have made multiple purchases? i.e. same full name and same street address, or same full name and same ip?

Yes, it is possible filter customers by same full name and same ip.

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
- improvements in code for better performance
- some fixes and design changes

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

- 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 Total Value
- added Sort By Date
- added filtering by Product Options, Location, Affiliate Name and Region / State
- added export option to .pdf file
- added option to export orders with All Details to .xls file, .html file or .pdf file, very handy for product packaging and shipping preparation of orders
- changed file structure for smaller files size for quicker loading
- design changes of settings option

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

- installation of extension is now via modules page (Extensions -> Modules -> ADV Reports)
- in main view of report added columns for Telephone and Country
- in details view - Product List added columns for Product Attributes, Category
- added new details view - Address List for complete Billing Address and Shipping Address of every customer
- added new details view - All Details; list is split by single orders and provides very detailed data about orders, purchased products and customers
- 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, Category, Manufacturer / Brand, SKU, Model, Product Attribute, Affiliate Name & Email, Coupon Name & Code, Voucher Code
- enhanced Sort By select box
- settings of columns for show or hide columns also apply to export function!
- better export function, significantly enhanced export of all details
- added automatic check version of extension with notification (Extensions -> Modules -> ADV Reports)
- minor bugs fixes and other graphical changes

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

- added report type by New Customers, it allows view all new customers (with all available details) for selected date range or statistics range
- added filtering by Order ID Range, Tax Class, Geo Zone
- 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