Post by cmerry » Sat Nov 26, 2011 12:06 am

ADV Sales Report + Profit Reporting v3.1 for OC v1.5.x

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
Image

Details - Order List
Image

Details - Product List
Image

Details - Customer List
Image

Details - All Details
Image
Last edited by cmerry on Mon Dec 16, 2013 11:11 pm, edited 48 times in total.


User avatar
Active Member

Posts

Joined
Sat Jul 17, 2010 8:42 pm

Post by cmerry » Sat Nov 26, 2011 12:07 am

ADV Products Purchased Report + Profit Reporting v3.1 for OC v1.5.x

This Advanced Products Purchased Report with Profit Reporting is must-have for all sellers who is looking complete solution for accurate products purchased report and profit reporting. The supplied Products Purchased Report was completely rewritten, so if products have product options, report is divided by product options for particular product. There is possibility to enable/disable grouping results by product options to see the total value and purchased quantity for a product regardless of options. In main view there are columns for Product Image, SKU, Product Name (with bought product options), Model, Category, Manufacturer / Brand, Attribute, Status, Stock Quantity, Sold [Qty], Sold [%], Product Tax, Product Sales, Product Costs, Product Profit and Profit Margin for particular product and selected date or statistics range.

Main functionality of report is enhanced by possibility to generate report by Products, Manufacturers or Categories so it is possible to show sales data, cost and profit for every product, manufacturer or category.

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 and Customer List.

By choosing Order List in report by Products you can view detailed list of all orders for selected date range or statistics range, there are columns for Order ID, Order Date, Invoice No., Customer Name / Company, Email, Customer Group, Shipping Method, Payment Method, Order Status, Store Name, Currency, Product Price, Product Quantity, Product Tax, Product Total, Product Costs, Product Profit and Profit Margin for particular product in particular order ID and product.

By choosing Customer List in report by Products you can view detailed list of all customers for selected date range or statistics range. There are columns for Order ID, Order Date, Invoice No., Customer ID, complete Billing Address, Telephone and complete Shipping Address.

By choosing Product List in report by Manufacturers or by Categories 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 No., Product ID, SKU, Model, Product Name, Options, Attributes, Category, Manufacturer / Brand, Currency, Product Price, Product Quantity, Product Tax, Product Total, Product Costs, Product Profit and Profit Margin for particular ordered product.

Report can be generated by Product Options, grouped by Years, Quarter, Months, Weeks, Days, Orders 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 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, Product Status, Location, Affiliate Name & Email, Coupon Name & Code, Voucher Code.

Report supports table export to excel .xls file, .html file or .pdf file. There are 7 options for export function: export products report with No Details, with Order List and with Customer List, export manufacturers report with No Details and Product List, export categories report with No Details and Product List. 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).

NOTE: This report don't work with "Payment Costs" and "Shipping Costs" fields on order view page (Sale -> Orders -> View) and on order edit page (Sale -> Orders -> Edit). Those fields are related to our other extensions ADV Sales Report + Profit Reporting and ADV Customer Orders Report + Profit Reporting.

Explanation how Product Costs, Product Sales, Product Profit and Profit Margin [%] 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)
Product Sales = Sub-Total
Product Profit = Product Sales - Product Costs
Profit Margin [%] = (Product Profit / Product Sales) x 100


Demo:
http://demo.opencartreports.com/admin/
Username: demo
Password: demo
Reports -> Sales -> ADV Purchased & 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=4170

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


Main View in report by Products
Image

Details in report by Products - Order List
Image

Details in report by Products - Customer List
Image

Main View in report by Manufacturers
Image

Details in report by Manufacturers - Product List
Image

Main View in report by Categories
Image

Details in report by Categories - Product List
Image
Last edited by cmerry on Tue Dec 24, 2013 5:45 am, edited 34 times in total.


User avatar
Active Member

Posts

Joined
Sat Jul 17, 2010 8:42 pm

Post by cmerry » Sat Nov 26, 2011 12:08 am

ADV Customer Orders Report + Profit Reporting 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, Total Value of all orders, Total Sales, Total Costs, Total Profit and Profit Margin 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, 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 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.

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 and Profit Margin [%] 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

*depends on configuration in Settings


Demo:
http://demo.opencartreports.com/admin/
Username: demo
Password: demo
Reports -> Customers -> 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=4409

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


Main View
Image

Details - Order List
Image

Details - Product List
Image

Details - Address List
Image

Details - All Details
Image
Last edited by cmerry on Thu Dec 19, 2013 10:17 pm, edited 26 times in total.


User avatar
Active Member

Posts

Joined
Sat Jul 17, 2010 8:42 pm

Post by Maansy » Sun Nov 27, 2011 1:46 am

I checked the demo. Great extension mate. Totally worth it.

ALL Templates :: 1.5.1+ Templates :: 50%-75% PRICE DROP ONLY at OpencartStuff.com


User avatar
Active Member

Posts

Joined
Thu Jun 24, 2010 6:04 am


Post by cmerry » Fri Dec 02, 2011 4:19 am

Released

Advanced Products Purchased Report (with product options) + Profit Reporting for OC v1.4.8, v1.4.9.x, v1.5.x
Advanced Customer Orders Report + Profit Reporting for OC v1.4.8, v1.4.9.x, v1.5.x

see above.
Last edited by cmerry on Thu May 03, 2012 9:19 pm, edited 6 times in total.


User avatar
Active Member

Posts

Joined
Sat Jul 17, 2010 8:42 pm

Post by cmerry » Fri Dec 16, 2011 7:54 pm

Extension Updated! - Advanced Sales Report + Profit Reporting
=====================================================

- added filtering by Shipping Method and Payment Method,
- in details view added column for Order Profit, now you can view profit for particular order ID (!),
- in details view added colums for Customer Group, Shipping Method and Payment Method,
- in Group By select menu added group report by orders,
- fixed some design flaws
Last edited by cmerry on Fri May 18, 2012 10:27 pm, edited 3 times in total.


User avatar
Active Member

Posts

Joined
Sat Jul 17, 2010 8:42 pm

Post by cmerry » Thu Dec 22, 2011 11:44 pm

Extension Updated! - Advanced Products Purchased Report (with product options) + Profit Reporting
====================================================================================

- added filtering by Product Options,
- changes in code which eliminate possible inaccuracies in the final report,
- in details view added column for Product Profit, now you can view profit for particular order ID (!),
- in details view added colums for Customer Group, Shipping Method and Payment Method,
- fixed some design flaws
Last edited by cmerry on Fri May 18, 2012 10:28 pm, edited 3 times in total.


User avatar
Active Member

Posts

Joined
Sat Jul 17, 2010 8:42 pm

Post by cmerry » Mon Dec 26, 2011 7:49 am

Released
Advanced Customer Orders Report + Profit Reporting for OC v1.5.x
Advanced Customer Orders Report + Profit Reporting for OC v1.4.8, v1.4.9.x
see above.


User avatar
Active Member

Posts

Joined
Sat Jul 17, 2010 8:42 pm

Post by cmerry » Wed Feb 08, 2012 11:17 pm

Extension Updated! - Advanced Products Purchased Report (with product options) + Profit Reporting
====================================================================================

- added possibility to enable/disable grouping results by option to see the total value and purchased quantity for a product, regardless of options,
- thoroughly rewritten product options database queries for fully support multilingual stores and multilingual options names, now product with the same options don't get split based on the language! options names by product names and in option select box are now in your admin language.
- if products have option type text, textarea, file, date, time or datetime this option will not show by product names and in option select box because this are not actually options, just complement informations to products by ordering.
- changes in code to eliminate possible inaccuracies in the final report,
- fixed issue with select boxes in low resolution screens, now select boxes fit to screen width,
- fixed date formating in details view,
Last edited by cmerry on Sun Feb 12, 2012 6:31 pm, edited 1 time in total.


User avatar
Active Member

Posts

Joined
Sat Jul 17, 2010 8:42 pm

Post by cmerry » Sun Feb 12, 2012 6:31 pm

Extension Updated! - Advanced Sales Report + Profit Reporting
=====================================================

- added filtering by Tax, Shipping Country and Payment Country,
- in details view added columns for Sub-Total, Shipping and Tax,
- in Group By function added possibility to no grouping the results,
- 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.


User avatar
Active Member

Posts

Joined
Sat Jul 17, 2010 8:42 pm

Post by cmerry » Tue Feb 14, 2012 10:55 pm

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

- 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.
Last edited by cmerry on Mon May 14, 2012 7:50 pm, edited 1 time in total.


User avatar
Active Member

Posts

Joined
Sat Jul 17, 2010 8:42 pm

Post by MrTech » Mon Feb 20, 2012 1:19 pm

As far as I can tell you have 3 very well designed reports. Having a problem grasping what the differences are between each. Do you happen to have a feature comparison chart between the reports so I can try to figure out which one will work for my needs? Thanks!

~
Install Extensions OR OpenCart Fast Service! PayPal Accepted
I will professionally install and configure any free or purchased theme, module or extension.

Visit http://www.mrtech.ca if you need an OpenCart webmaster
~


User avatar
Active Member

Posts

Joined
Mon Jan 09, 2012 2:39 pm
Location - Canada, Eh!

Post by cmerry » Tue Feb 21, 2012 6:50 pm

MrTech wrote:As far as I can tell you have 3 very well designed reports. Having a problem grasping what the differences are between each. Do you happen to have a feature comparison chart between the reports so I can try to figure out which one will work for my needs? Thanks!
Thanks for your comment. Basically the differences are these:

ADV Sales Report + Profit Reporting - gives sales information and detailed overview about received orders for selected date range or statistic range. There are lot of filtering options for narrowing the results, you can view costs and profit for received orders and selected filtering criteria. By clicking on 'Details' you can view detailed list of all received orders, detailed list of all products and detailed list of all customers for selected date range or statistic range and for filtering criteria.

ADV Products Purchased Report + Profit Reporting - gives you detailed overview about particular products. You can view sales information for particular products, what products are selling best, what costs and profit you have for particular product and again you have lot of filtering options for narrowing the results. By clicking on 'Details' you can view detailed list of all received orders which containing particular product (with options) or detailed list of all customers who bought particular product for selected date range or statistic range and filtering criteria.

ADV Customer Orders Report + Profit Reporting - gives you detailed overview about particular customers. You can view sales information for particular customers, what is your costs and what profit you have for particular customers and again you have lot of filtering options for narrowing the results. By clicking on 'Details' you can view detailed list of all received orders or detailed list of all products for particular customer and for selected date range or statistic range and filtering criteria.

Please look at demo for every extension.

Demo:
http://demo.opencartreports.com/admin/
Username: demo
Password: demo
Reports -> Sales -> ADV Orders & Profit
Reports -> Products -> ADV Purchased & Profit
Reports -> Customers -> ADV Orders & Profit
Last edited by cmerry on Wed Dec 04, 2013 4:47 pm, edited 6 times in total.


User avatar
Active Member

Posts

Joined
Sat Jul 17, 2010 8:42 pm

Post by MrTech » Tue Feb 21, 2012 10:43 pm

Thank you that helps spell it out clearly! English is also not my 'primary' language either lol.

~
Install Extensions OR OpenCart Fast Service! PayPal Accepted
I will professionally install and configure any free or purchased theme, module or extension.

Visit http://www.mrtech.ca if you need an OpenCart webmaster
~


User avatar
Active Member

Posts

Joined
Mon Jan 09, 2012 2:39 pm
Location - Canada, Eh!

Post by cmerry » Mon Mar 19, 2012 10:11 pm

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

- 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 Customer Status
- added filtering by Company, Customer Name, Customer Email and Product Name, it uses now Ajax autocomplete function (no big lists in select boxes!)
- 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
Last edited by cmerry on Thu May 17, 2012 8:11 pm, edited 2 times in total.


User avatar
Active Member

Posts

Joined
Sat Jul 17, 2010 8:42 pm

Post by cmerry » Thu Mar 29, 2012 12:46 am

Extension Updated! - Advanced Sales Report + Profit Reporting
=====================================================

- added vQmod!
- added select box for Group Report By, you can generate report grouped by Years, Months, Weeks, Days or by Orders (default is No Grouping)
- added select box Sort By, now it is possible sort results by Date, No. Customers, No. Orders, No. Products, Sub-Total, Rewards, Shipping, Coupons, Tax, Credits, Vouchers, Total, Costs or Profit (default is sort by Date)
- added select box Show Details (default is No Details for quicker generating of report)
- added filtering by Region / State
- added multiple select boxes for Order Status, Store, Currency, Tax, Customer Group, Customer Status, Shipping Method, Payment Method, Region / State, Shipping Country and Payment Country
- added filtering by Company, Customer Name, Customer Email and Product Name, it uses now Ajax autocomplete function (no big lists in select boxes!)
- fixed error if one or more orders contains more than one tax
- fixed some other issues and design flaws
Last edited by cmerry on Fri May 18, 2012 10:28 pm, edited 1 time in total.


User avatar
Active Member

Posts

Joined
Sat Jul 17, 2010 8:42 pm

Post by cmerry » Wed Apr 04, 2012 10:30 pm

Extension Updated! - Advanced Products Purchased Report (with product options) + Profit Reporting
====================================================================================

- added vQmod!
- added multiple select boxes for Order Status, Store, Currency, Tax, Customer Group, Category, Manufacturer / Brand and Product Status
- added filtering by multiple Product Options for "searching" the Product Options specifically (like "SMALL" and "BLACK" t-shirts... or "MEDIUM" and "RED" t-shirts)
- added filtering by Company, Customer Name, Customer Email and Product Name, it uses now Ajax autocomplete function (no big lists in select boxes!)
- added column for Product Tax in simple and details view and in export
- added select box Sort By, now it is possible sort results by Quantity, Total, Costs or Profit (default is sort by Profit)
- added select box Show Details (default is No Details for quicker generating of report)
- added last line in report Total For Selected Criterias to show sum of Quantity, Tax, Total, Costs or Profit for selected filtering criterias
- fixed error if one or more orders contains more than one tax
Last edited by cmerry on Thu May 24, 2012 10:58 pm, edited 1 time in total.


User avatar
Active Member

Posts

Joined
Sat Jul 17, 2010 8:42 pm

Post by dbassa » Sun Apr 22, 2012 12:48 am

This reply was removed by i2Paq because it has hijacking this topic.

User avatar
Active Member

Posts

Joined
Tue May 19, 2009 12:11 am
Location - Spain

Post by cmerry » Tue Apr 24, 2012 9:45 pm

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


This significant update brings 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) (!)

Input for Product Costs
Image

Entering Product Options Cost
Image

Product Costs in product list
Image
Last edited by cmerry on Tue Mar 05, 2013 8:52 am, edited 11 times in total.


User avatar
Active Member

Posts

Joined
Sat Jul 17, 2010 8:42 pm

Post by cmerry » Tue Apr 24, 2012 9:48 pm

Extension Updated! - Advanced Customer Orders 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 Customer IP
- added columns for Customer IP, Sub-Total, Total Costs and 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
Last edited by cmerry on Mon May 14, 2012 7:51 pm, edited 2 times in total.


User avatar
Active Member

Posts

Joined
Sat Jul 17, 2010 8:42 pm
Who is online

Users browsing this forum: No registered users and 4 guests