This Advanced Sales Report with Profit Reporting is must-have for all sellers who is looking complete solution for accurate sales report and profit reporting. In main view there are columns for No. Orders, No. Customers, No. Products, Sub-total, Handling Fee, Low Order Fee, Shipping, Rewards Points, Coupons, Taxes, Store Credits, Gift Vouchers, Total Value of all orders, Total Sales, Product Costs, Affiliate Commissions, Payment Costs, Shipping Costs, Shipping Balance, Total Costs, Total Profit and Profit Margin 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, Order Taxes, Order Total, Sales, Order Costs, Order Profit and Profit Margin 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, Product Total, Product Costs, Product Profit and Profit Margin 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 ID Range, Order Status or Status Changed (with Date Picker), Store, Currency, Tax Name, Tax Class, Geo Zone, Customer Group, Company, 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.
Explanation of Profit Reporting:
After installing this extension Product Costs input fields has been added into Data Tab and Option Tab in the Admin -> Catalog -> Products -> Product Form. This costs of the product are used for profit reporting and is added to the order at the time the product is purchased, so any change in the costs of a product in future will have no impact on previously purchased products. This will give all time accurate data for profit reporting. Profit is starting calculate after you set product costs and after you receive order for product. It is possible import/export cost, price and stock quantity of products and product options to XLS file and set product costs for all orders received before installing the extension (Extensions -> Modules -> ADV Profit Reports). Product Costs fields are editable on order view page (Sale -> Orders -> View) and on order edit page (Sale -> Orders -> Edit).
Payment Costs field is useful for adding transaction fee that many payment companies (like PayPal) charge. You can configure payment costs on module page (Extensions -> Modules -> ADV Profit Reports) and set Percentage, Fixed Fee and Geo Zone for every payment type you select. You can set amount from which payment costs will be calculated. This calculated amount is hidden in checkout process and will show on order view page (editable) Sale -> Orders -> View and on order edit page (editable) Sale -> Orders -> Edit and in profit report.
Shipping Costs field is useful for adding your own and real shipping costs for every shipped order. You can configure shipping costs on module page (Extensions -> Modules -> ADV Profit Reports) and set Shipping Costs Rates for every Geo Zone. You can set amount from which shipping costs will be calculated. This calculated amount is hidden in checkout process and will show on order view page (editable) Sale -> Orders -> View and on order edit page (editable) Sale -> Orders -> Edit and in profit report. On report page in Shipping Balance column you can verify if you charge for shipping enough (too much/not much).
Explanation how Costs, Sales, Profit, Profit Margin [%] and Shipping Balance is calculated:
Product Costs = Cost Price (amount) and/or Commission (percentage from sale price) + Additional Costs (e.g. shipping) + Option Costs (if options are used)
Order Costs = Product Costs + Affiliate Commission + Payment Costs* + Shipping Costs*
Total Costs = sum of Product Costs + sum of Affiliate Commissions + sum of Payment Costs* + sum of Shipping Costs*
Sales = Sub-Total + Handling Fee + Low Order Fee + Shipping* - Reward Points - Coupons - Store Credits - Gift Vouchers
Total Sales = sum of Sub-Total + sum of Handling Fee + sum of Low Order Fee + sum of Shipping* - sum of Reward Points - sum of Coupons - sum of Store Credits - sum of Gift Vouchers
Product Profit = Product Total - Product Costs
Order Profit = Sales - Order Costs
Total Profit = Total Sales - Total Costs
Profit Margin [%] = (Profit / Sales) x 100
Shipping Balance = Shipping - Shipping Costs
*depends on configuration in Settings
Demo:
http://demo.opencartreports.com/admin/
Username: demo
Password: demo
Reports -> Sales -> ADV Orders & Profit
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 +$250.
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=4087
version 1.4.8, 1.4.9.x
http://www.opencart.com/index.php?route ... on_id=4134
Main View

Details - Order List

Details - Product List

Details - Customer List

Details - All Details
