OpenCart Community

Extension Updated! - Advanced Sales Report + Profit Reporting v2.0
=========================================================

- (!) this significant update added new concept for entering Product Costs, which are now calculated like sum of Cost Price, Commission (percentage from sale price), Additional Costs (e.g. shipping cost) and Option Costs (if options are used)
- 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 Location
- added column for Profit Margin [%] in report and export function
- in details view - Order List added columns Order Costs and Profit Margin [%] for particular order ID
- added bubble help for explanation how Total Costs, Total Profit and Profit Margin [%] is calculated
- added option for exporting report with Product List into .xls or .html
- added new column in product list (Admin -> Catalog -> Products) to show Costs of products

Extension Updated! - Advanced Products Purchased Report + Profit Reporting v2.0
=====================================================================

- (!) this significant update added new concept for entering Product Costs, which are now calculated like sum of Cost Price, Commission (percentage from sale price), Additional Costs (e.g. shipping cost) and Option Costs (if options are used)
- added filtering by SKU, Model, Product Attributes and Location
- added columns for Sold [%] and Profit Margin [%] in report and export function
- in details view - Order List added columns Product Price, Product Costs and Profit Margin [%] for particular product and particular order ID
- added bubble help for explanation how Product Costs, Product Profit and Profit Margin [%] is calculated
- added new column in product list (Admin -> Catalog -> Products) to show Costs of products

Extension Updated! - Advanced Customer Orders Report + Profit Reporting v2.1
===================================================================

- in edit function of orders (Admin -> Sale -> Orders -> Edit) fixed issue when product costs is resetting to 0 after adding or deleting products into existing order
- fixed wrong calculation of tax on products in details view - Product List
- changes in code for better performance and quicker generation of report
- fixed auto calculating of Product Costs after combine Cost Price and/or Commission and Additional Costs in Mozilla Firefox browser
- small changes in xml files for better compatibility with modified sites

Extension Updated! - Advanced Sales Report + Profit Reporting v2.1
=========================================================

- in edit function of orders (Admin -> Sale -> Orders -> Edit) fixed issue when product costs is resetting to 0 after adding or deleting products into existing order
- fixed wrong calculation of tax on products in details view - Product List
- changes in code for better performance and quicker generation of report
- fixed auto calculating of Product Costs after combine Cost Price and/or Commission and Additional Costs in Mozilla Firefox browser
- small changes in xml files for better compatibility with modified sites

Extension Updated! - Advanced Products Purchased Report + Profit Reporting 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
- in edit function of orders (Admin -> Sale -> Orders -> Edit) fixed issue when product costs is resetting to 0 after adding or deleting products into existing order
- fixed wrong calculation of tax on products
- changes in code for better performance and quicker generation of report
- fixed auto calculating of Product Costs after combine Cost Price and/or Commission and Additional Costs in Mozilla Firefox browser
- small changes in xml files for better compatibility with modified sites

Extension Updated! - Advanced Sales Report + Profit Reporting 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 !)
- added Charts for No. Orders, No. Customers and for Sales, Total Costs, Total Profit
- significantly enhanced Statistics Range selection box, nine options was added for generate report
- added possibility grouping report by Quarter in Group By select box
- added new details view - Customer List, you can view detailed list of all customers for selected date range or statistics range
- added details view - Customer List into export function
- in main view of report added last row for view total value of columns - Total for Criterias
- in main view of report added columns for Handling Fee, Low Order Fee and Commissions
- 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)
- in edit function of orders (Admin -> Sale -> Orders -> Edit) added column for Cost in adding products into existing order
- enhanced explanation of calculations in bubble window, some changes in profit calculations
- some fixes and design changes and improvements

Extension Updated! - Advanced Products Purchased Report + Profit Reporting 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
- in edit function of orders (Admin -> Sale -> Orders -> Edit) added column for Cost in adding products into existing order
- changes in code for performance improvements
- enhanced explanation of calculations in bubble window, some changes in profit calculations
- some fixes and design changes and improvements

Extension Updated! - Advanced Customer Orders Report + Profit Reporting 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)
- in edit function of orders (Admin -> Sale -> Orders -> Edit) added column for Cost in adding products into existing order
- enhanced explanation of calculations in bubble window, some changes in profit calculations
- some fixes and design changes and improvements


Charts


Statistics Range selection box


Settings


Product Costs field on order edit page

Extension Updated! - Advanced Sales Report + Profit Reporting 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
- some changes in profit calculations, Vouchers are now included into Costs calculation
- in edit function of orders (Admin -> Sale -> Orders -> Edit) Cost field in Products tab is now editable (click Ajax function), very handy if you need edit costs for products in received orders
- improvements in code for better performance
- some fixes and design changes

Extension Updated! - Advanced Products Purchased Report + Profit Reporting 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
- some changes in profit calculations, Vouchers are now included into Costs calculation
- in edit function of orders (Admin -> Sale -> Orders -> Edit) Cost field in Products tab is now editable (click Ajax function), very handy if you need edit costs for products in received orders
- improvements in code for better performance
- some fixes and design changes

Extension Updated! - Advanced Customer Orders Report + Profit Reporting v2.3
===================================================================
- added pagination into results of report and select box for showing 10, 25, 50 or 100 results on the one page
- some changes in profit calculations, Vouchers are now included into Costs calculation
- in edit function of orders (Admin -> Sale -> Orders -> Edit) Cost field in Products tab is now editable (click Ajax function), very handy if you need edit costs for products in received orders
- improvements in code for better performance
- some fixes and design changes


Ajax product costs editing on order edit page


Pagination

Extension Updated! - Advanced Sales Report + Profit Reporting v2.4
=========================================================
- added filtering by Product Options and Affiliate Name
- 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
- in insert order function (Admin -> Sale -> Orders -> Insert) added Cost field in Products tab in adding products
- changed file structure for smaller files size for quicker loading
- design changes of settings option

Extension Updated! - Advanced Products Purchased Report + Profit Reporting v2.4
=====================================================================
- main functionality of report was enhanced adding possibility to generate report by Manufacturers or by Categories, now it is possible to show sales data, cost and profit 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, Product Costs, Product Profit
- 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
- in insert order function (Admin -> Sale -> Orders -> Insert) added Cost field in Products tab in adding products
- changed file structure for smaller files size for quicker loading
- design changes of settings option

Extension Updated! - Advanced Customer Orders Report + Profit Reporting 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 Sales, Total Costs, Total Profit
- 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
- in insert order function (Admin -> Sale -> Orders -> Insert) added Cost field in Products tab in adding products
- changed file structure for smaller files size for quicker loading
- design changes of settings option

================================================
!!! ALL PROFIT EXTENSIONS ARE UPDATED TO VERSION 3.0 !!!
================================================

Extension Updated! - ADV Sales Report + Profit Reporting v3.0
=====================================================
- installation of extension is now via modules page (Extensions -> Modules -> ADV Profit Reports)
- added ability to set product cost for all purchased products before installing the extension (Extensions -> Modules -> ADV Profit Reports)
- changes in formulas for calculations of sales, cost and profit, total sum is not change just the way of calculation for accounting purpose (read section Explanation of Profit Reporting)
- added Payment Costs and Shipping Costs into formulas for calculations of sales, cost and profit (read section Explanation of Profit Reporting)
- Payment Costs and Shipping Costs can be set on page of modules (Extensions -> Modules -> ADV Profit Reports) or in Setting option on report page
- added Shipping Balance to show if shipping paid by customers cover real shipping costs
- on order edit page (Sale -> Orders -> Edit) added editable fields for Payment Costs and Shipping Costs
- in main view of report added columns for Total Sales, Payment Costs, Shipping Costs and Shipping Balance
- in details view - Order List removed columns for Handling Fee and Low Order Fee and added column for Sales (read section Explanation of Profit Reporting)
- in details view - Product List added columns for Product Attributes, Category
- 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
- show/hide settings of columns also apply to export function
- better export function, significantly enhanced export of all details
- added permission check to product cost input fields on product page (Catalog -> Products -> Edit) and product cost, payment costs and shipping costs fields on order edit page (Sale -> Orders -> Edit); to show this fields Access Permission must be set for module/adv_profit_reports
- added automatic check version of extension with notification (Extensions -> Modules -> ADV Profit Reports)
- minor bugs fixes and other graphical changes

Extension Updated! - ADV Products Purchased Report + Profit Reporting v3.0
================================================================
- installation of extension is now via modules page (Extensions -> Modules -> ADV Profit Reports)
- added ability to set product cost for all purchased products before installing the extension (Extensions -> Modules -> ADV Profit Reports)
- changes in formulas for calculations of sales, cost and profit, total sum is not change just the way of calculation for accounting purpose (read section Explanation of Profit Reporting)
- 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 permission check to product cost input fields on product page (Catalog -> Products -> Edit); to show those fields Access Permission must be set for module/adv_profit_reports
- added automatic check version of extension with notification (Extensions -> Modules -> ADV Profit Reports)
- minor bugs fixes and other graphical changes

Extension Updated! - ADV Customer Orders Report + Profit Reporting v3.0
==============================================================
- installation of extension is now via modules page (Extensions -> Modules -> ADV Profit Reports)
- added ability to set product cost for all purchased products before installing the extension (Extensions -> Modules -> ADV Profit Reports)
- changes in formulas for calculations of sales, cost and profit, total sum is not change just the way of calculation for accounting purpose (read section Explanation of Profit Reporting)
- added Payment Costs and Shipping Costs into formulas for calculations of sales, cost and profit (read section Explanation of Profit Reporting)
- Payment Costs and Shipping Costs can be set on page of modules (Extensions -> Modules -> ADV Profit Reports) or in Setting option on report page
- on order edit page (Sale -> Orders -> Edit) added editable fields for Payment Costs and Shipping Costs
- in main view of report added columns for Telephone and Country
- in details view - Order List removed columns for Handling Fee and Low Order Fee and added column for Sales (read section Explanation of Profit Reporting)
- 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
- show/hide settings of columns also apply to export function
- better export function, significantly enhanced export of all details
- added permission check to product cost input fields on product page (Catalog -> Products -> Edit) and product cost, payment costs and shipping costs fields on order edit page (Sale -> Orders -> Edit); to show this fields Access Permission must be set for module/adv_profit_reports
- added automatic check version of extension with notification (Extensions -> Modules -> ADV Profit Reports)
- minor bugs fixes and other graphical changes


Import\Export of Product Costs and set Product Costs to all orders


Payment Costs configuration


Shipping Costs configuration


Payment Costs field on order edit page


Shipping Costs field on order edit page

Hello,
we love your reports extension. it works really well.
but we are also using a formula based fees / discounts extension to add handling fees for some products.
Is there a way to include this in reporting to figure out how much money has been charged for these fees?

the extention we are using is here: http://goo.gl/fjl4ba

Hello, yes it is possible, please contact us by support email.

Extension Updated! - Advanced Sales Report + Profit Reporting v3.1
=========================================================
- added Product Costs table on module settings page (Extensions -> Modules -> ADV Profit Reports) and ability to import/export costs, price and stock quantity of products and product options with XLS file
- enhanced Payment Costs and Shipping Costs on module settings page (Extensions -> Modules -> ADV Profit Reports)
- 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

Extension Updated! - Advanced Products Purchased Report + Profit Reporting v3.1
=========================================================
- added Product Costs table on module settings page (Extensions -> Modules -> ADV Profit Reports) and ability to import/export costs, price and stock quantity of products and product options with XLS file
- 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

Extension Updated! - Advanced Customer Orders Report + Profit Reporting v3.1
===================================================================
- added Product Costs table on module settings page (Extensions -> Modules -> ADV Profit Reports) and ability to import/export costs, price and stock quantity of products and product options with XLS file
- enhanced Payment Costs and Shipping Costs on module settings page (Extensions -> Modules -> ADV Profit Reports)
- 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