Community Forums

by **cmerry** » Thu Nov 03, 2011 3:31 pm

Advanced Sales Report v3.0 for OC v1.5.x

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, Tax, 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, Sub-Total, Fees, Shipping, Order Tax 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, Price, Quantity, Total and Tax 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, Status Changed (with Date Picker), Order Status, Store, Currency, Tax, Customer Group, Company, Customer Name, Customer Email, Telephone, 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.

Demo:
http://demo.opencartreports.com/admin/
Username: demo
Password: demo
Reports -> Sales -> ADV Orders

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 +$150.

Contact for support and customization:
opencart.reports@gmail.com

Link to Opencart store:
version 1.5.x
http://www.opencart.com/index.php?route=extension/extension/info&extension_id=3803

version 1.4.8, 1.4.9.x
http://www.opencart.com/index.php?route=extension/extension/info&extension_id=3978

################ RELATED EXTENSIONS ################
ADV Sales Report + Profit Reporting v2.4 for OC v1.5.x
http://forum.opencart.com/viewtopic.php?f=124&t=46862

ADV Products Purchased Report v2.4 for OC v1.5.x
http://forum.opencart.com/viewtopic.php?f=124&t=44419
ADV Products Purchased Report + Profit Reporting v2.4 for OC v1.5.x
http://forum.opencart.com/viewtopic.php?f=124&t=46862

ADV Customer Orders Report v2.4 for OC v1.5.x
http://forum.opencart.com/viewtopic.php?f=124&t=44770
ADV Customer Orders Report + Profit Reporting v2.4 for OC v1.5.x
http://forum.opencart.com/viewtopic.php?f=124&t=46862

Main View

Details - Order List

Details - Product List

Details - Customer List

Details - All Details

Export

Statistics Range selection box

Ajax autocomplete function and multiple select boxes

Group By, Sort By and Details selection box

Charts

Pagination

Settings

by **JAY6390** » Thu Nov 03, 2011 3:35 pm

Wow, this report looks great, nice job cmerry!

by **fourgood** » Tue Nov 15, 2011 11:32 am

Any chance to get this for v1.4.9.x ?

by **cmerry** » Fri Nov 18, 2011 3:13 pm

Released version 1.4.8, 1.4.9.x
http://www.opencart.com/index.php?route=extension/extension/info&extension_id=3978

by **cmerry** » Fri Dec 16, 2011 11:49 am

Extension Updated!
================

- added filtering by Shipping Method and Payment Method,
- added colums for Rewards, Coupons, Credits, Vouchers in report and export function,
- 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

by **travoltron** » Thu Dec 29, 2011 8:52 pm

I have this mostly installed, and it's awesome, I just can't get the li item in the Reports menu in the Admin section. I've found where in admin/view/template/common/header.tpl to edit, I just don't know what variable to put in there.

Any help?

by **travoltron** » Thu Dec 29, 2011 9:25 pm

NVM, I got it, a little reading my controllers helped me. I was just being lazy.

by **cmerry** » Sun Feb 12, 2012 10:23 am

Extension Updated!
================

- 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.

by **ralpher46** » Mon Mar 19, 2012 8:58 am

travoltron wrote:I have this mostly installed, and it's awesome, I just can't get the li item in the Reports menu in the Admin section. I've found where in admin/view/template/common/header.tpl to edit, I just don't know what variable to put in there.

I've been having a similar issue, getting the error message bellow when trying to add certain variables to the header.tpl file.

Notice: Undefined variable: text_contact in /home/www/opencart/catalog/view/theme/shoppica/template/common/header.tpl on line 163

by **cmerry** » Mon Mar 19, 2012 9:22 am

Notice: Undefined variable: text_contact in /home/www/opencart/catalog/view/theme/shoppica/template/common/header.tpl on line 163[/quote]

This error is not from my extension, you are trying modify header.tpl on category side, my extension is purely on admin side. If you have any trouble with installing, please use support email address (read Readme.txt).

by **cmerry** » Wed Mar 28, 2012 4:41 pm

Extension Updated!
================

- 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 or Total (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

by **cmerry** » Fri Apr 27, 2012 3:04 pm

======================================
!!! EXTENSION UPDATED TO VERSION 2.0 !!!
======================================

- 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 option for exporting report with Product List into .xls or .html

by **cmerry** » Fri May 18, 2012 2:26 pm

Extension Updated - v2.1!
======================

- fixed wrong calculation of tax on products in details view - Product List
- changes in code for better performance and quicker generation of report

by **cmerry** » Tue Jun 05, 2012 2:30 pm

Extension Updated - 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 Total Value
- significantly enhanced Statistics Range selection box, was added nine options 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)
- some fixes and design changes and improvements

by **NathanStarkey** » Tue Jun 12, 2012 6:38 am

Hi,

I was just wondering if this sales report is able to keep track of how much profit I am making per sale (is there somewhere to input that information and if so, where will it be outputted on the report).

The reason being is that I'm hoping to have this module implemented to make my life a little easier come tax time.

Thanks in advance for all of your help!

Sincerely,

Nathan Starkey

by **cmerry** » Tue Jun 12, 2012 7:06 am

Hi,
for this I have Advanced Sales Report + Profit Reporting
http://forum.opencart.com/viewtopic.php?f=124&t=46862#p223404
Thanks for interest.

by **NathanStarkey** » Tue Jun 12, 2012 7:19 am

My God! You are a king amongst men!

You just made my life 9867187561327856325 times easier

THANKYOU!!!!

by **cmerry** » Tue Jul 03, 2012 11:50 am

Extension Updated - 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
- improvements in code for better performance
- some fixes and design changes

by **cmerry** » Mon Jul 30, 2012 11:48 am

Extension Updated - 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
- changed file structure for smaller files size for quicker loading
- design changes of settings option

by **cmerry** » Thu Apr 18, 2013 11:40 am

Extension Updated - v3.0!
======================

- installation of extension is now via modules page (Extensions -> Modules -> ADV Reports)
- in details view - Order List removed columns for Handling Fee and Low Order Fee
- 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
- settings of columns for show or hide columns also apply to export function!
- better export function, significantly enhanced export of all details
- added automatic check version of extension with notification (Extensions -> Modules -> ADV Reports)
- minor bugs fixes and other graphical changes