This Advanced Sales Report is must-have for all sellers who is looking for accurate sales report. In main view there are columns for No. Orders, No. Customers, No. Products, Sub-total, Handling Fee, Low Order Fee, Shipping, total value of Rewards Points, total value of Coupons, Taxes, total value of store Credits, total value of Gift Vouchers, total value of Affiliate Commissions and Total Value of all orders for 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, Customer 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, 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, Product Name, Product Options, Product Attributes, Model, Manufacturer / Brand, Category, Currency, Product Price, Quantity, Tax and Product Total for particular ordered product.
By choosing Customer List you can view detailed list of all customers for selected date range or statistics range. There are columns for Order ID, Order Date, Invoice Number, Customer ID, complete Billing Address, Telephone and complete Shipping Address.
By choosing All Details you will get all details about orders, products and customers.
Report can be grouped by Years, Quarter, Months, Weeks, Days or individual Orders 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, 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 Customer 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.