Having used a modified version of the Monthly Sales & Tax Report Add-On for a couple of years I figured that it was time to make a more modern sales reporting Add-On.
Unlike Monthly Sales & Tax Report which calculate sales out of every product in table orders_products this Add-On will query the database and calculate sales based on each orders_total class which greatly increases query time. Example: with a database of 30 000 example orders, this Add-On will finish in just 1.5 seconds.
This Add-On uses jQuery DataTables to create the Table.
Features for Revision 1
⚫ Sales/Tax Statistics/Report Generator for osC 2.3.x
⚫ Only tested on osC 2.3.4 but should work on any version
⚫ Simple five step Installation - Only three files needs to be modified!
⚫ Automatically creates HTML table and loads orders from server using AJAX.
⚫ Export Options: CSV, Copy/Paste, XLS, PDF
⚫ "Automatic" Print View
⚫ amCharts Graphs over sales & taxes
⚫ Very Fast Operation, a shop with 30 000 orders loads in under 2 seconds.
⚫ jQuery DataTables - https://datatables.net/
⚫ Drag & Drop Columns
⚫ Automatic Column Sorting
⚫ Toggle Column Visibility
⚫ Detailed day-to-day sales
⚫ Slide-In Menu with mmenu - http://mmenu.frebsite.nl/
⚫ Fixed Bootstrap Top Navigation
⚃ jQuery UI
⚄ jQuery UI Smoothness
⚫ DataTables Internationalization - 63 Language Definitions Included
⚫ amCharts Internationalization - 29 Language Definitions Included
⚫ 100% MySQLi Prepared Statements
⚫ Bootstrap Tooltips
⚫ Toggleable Visibility of both your store header and Admin menu using CSS3 classes
⚫ OS style selection, shift/control/CMD click to select multiple rows
☞ Screenshots included in package! ☜
Forum Support Thread: http://forums.oscommerce.com/topic/401423-jqueryajax-advanced-statistics-for-oscommerce-23/