ADV Customer Orders 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 Customer Orders Report is must-have for all sellers who is looking for accurate customer orders report. 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.
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.