Search the Community

Advanced Statistics Rev1 for osCommerce 2.3 - Compatible Without mysqlnd - - Support thread - Having made another module for handling products/categories which utilize DataTables, I realized that my store needed a new reporting "engine" to produce statistics/sales data for me so that I don't have to make a new spreadsheet every time I want some statistics. As of Revision 1 there's still a lot to work on but the the module has come to a point of being useful so I thought I share it with the rest of the osC community as an Add-On. If you think you have a good idea on new features/stats that could be useful, please share them here on the support forum. DataTables DataTables requests the sales data from your server with Ajax and then builds you a table with a action bar and selectable rows. You can Drag & Drop Column Headers to reorder the table the way you like it. It’s also possible to toggle column visibility. Clicking on the columns will sort the column ascending/descending. Clicking on the leftmost plus (+) sign will expand the column to detailed day-by-day per month sales & tax data. Performance The former Reporting Add-On I used was very slow, it queried each row in table orders_products and the amount of queries done to calculate sales & tax for a period was massive! Data will be loaded from JSON source which also helps improve Performance, especially on slow connections. Make very sure if you are going to use this Add-On that it calculates your data correctly! You have to both double and triple check the reports with another reporting system so you know for sure that everything works. This is how the Advanced Statistics Add-On calculates your sales data, it’s quite simple: If you have a tax rate set to 20% and the summary for this tax for 1 day is $200 then it will calculate generated sales with 20% tax this way: [Total Tax] / [Tax Rate] * 100 = Sold Goods with 20% Tax 200 / 20 * 100 = 1000. So Sales 20% will be $1000. As of Rev1, order_totals classes that will be counted are ot_total, ot_tax & ot_shipping. TableTools The TableTools Extension comes with a swf (flash) file which helps e.g. to copy table data to clipboard. Unfortunately, flash is the only way to do this right now.. Copying Data and then Pasting it in your spreadsheet editor is a neat way to quickly create custom reports. TableTools also comes with buttons to automatically create CSV files. You might need to configure the CSV field separator in advanced_statistics.js. Search for the sFieldSeperator option and set correct separator if you can’t get the CSV to import correctly. Print View Using a CSS with media="print”, a print view is automatically created when you select to print the page. If you have selected to filter orders by status, then there will be an added heading with Status Information, as of Rev1 however, you need to reload the page to get it to display. I’ll fix this later.. You can also use the TableTools ”Print” Button which essentially makes the same thing. You can also have TableTools create a PDF for you, but it looks like sh*t if you ask me. Check DataTables homepage on how to configure the layout for this PDF, I will not work on this as I don’t need it (will use CMD/CTRL + P instead..). Note also that some of the themes probably needs some CSS styling fixes if you want to print e.g. background colors of header. Make sure to add these to advanced_statistics_print_view.css. Menus & Navigation I always wanted one of those Slide-In menus so I finally got one; jQuery mmenu. It’s still rather empty, but should fill up with more filtering options and other knobs, buttons & of course whistles soon enough. To open it; click on the top left icon on the top navigation, it will randomly pick one out of 37 icons on each load but shouldn’t be hard to find as long as you’re not completely ”challenged” by the world around you… :P There’s a couple of more buttons in the Bootstrap top navigation which will toggle the admin menu and header and also a button to clear all currently applied filters. To the right on the top navigation you’ll have two dropdowns which will switch theme and filter by orders status. Theming jQuery DataTables comes with some options to implement themes, so I fixed support for five different layouts: jTable - Looks a bit like the Advanced Order Handler and uses Bootstrap buttons for the seven leftmost buttons. Original - DataTables as it comes out of the box (more or less) Bootstrap - Like Original but with the DataTables Bootstrap css & js jQuery UI - Will adapt to your jQuery-UI Admin Theme (default is Redmond) jQuery UI Smoothness - Uses Smoothness theme instead of Redmond Screenshots of all Themes can be found at the bottom of the ReadMe file in the package. Theme-creator https://www.datatables.net/manual/styling/theme-creator Internationalization Both amCharts and DataTables comes with many language definitions which is included and should automatically load the same language as the one you have set in your admin (assuming the definition exist). amCharts I plan to make a lot of use of amCharts to get easy to interpret charts from store sales etc.. As of Revision 1, you can get a line, area, column, bar, step line, smoothed line, candlestick and OHLC graph for each of the visible columns and for either the specific rows that you have selected (OS style selection, shift/control/CMD click to select multiple rows) or for the entire table(s). The chart modal is movable (only one move per page load) and also resizable. Click on the Graph Names at the bottom of the modal to hide/show different line graphs. Security & Compatability All querying with parameters/input variables to your database will be made with MySQLi Prepared Statements. Preferably you should use the MySQL Native Driver (mysqlnd), but I have added support and tested the Add-On without mysqlnd and everything should work. Prepared Statements removes the threat of MySQL Injections. Not that it matters that much on the admin side of the shop since only authorized users have access, but you can never be too secure, right? ;) For simple installation I have not messed with more native osC files than necessary and instead included necessary functions in general_functions.php. If you have any of my previous Add-Ons installed then you might run into a problem under certain conditions when the mysqli_prepared_query and tep_db_fetch_all functions will fail. If so, then try with replacing the current database functions that you have in ./admin/includes/functions/database.php with the ones that you find in general_functions.php from this Add-on. 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 Themes jTable Original Bootstrap 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 - Plenty of screenshots in package! -

Support thread for "Products Low Stock Report" for osCommerce 2.3.x (bootstrap and non-bootstrap) ---------------------------------------------------------------------------------------------------------------------------------------------- Use this add-on to easily view and update stock levels. It is especially useful when your store settings allow for automatically reducing stock levels when products are purchased. You will receive low stock alerts in admin and be able to view/update stock levels in one screen. Tested on, and compatible with, osCommerce versions 2.3.3, 2.3.4 non-BS and 2.3.4 BS GOLD/EDGE (but may work in earlier versions). This low stock reporting tool is based on "Low Stock Report v1.4" http://addons.oscommerce.com/info/7763 (credit to original author and all who contributed to it and earlier versions). This is a much improved version and has been completely re-written to work with the above osCommerce versions. Similar to the previous version, this new version also provides admin with low stock alerts when logged into admin. In addition, it allows admin to quickly view and update stock levels for "all products" or only the "low stock products", either in all categories or a selected category. From within this stock reporting page, you can update product quantities either individually or in bulk i.e. for all categories or only within the selected category, with options to update all the products or only the low stock products. Bulk quantity update options also include the ability to update qty's either by "adding to or replacing" existing qty's and an option to include "upcoming products" in the qty update. The low stock alert is governed by the setting in "Admin->Configuration->Stock->Stock Re-order level", where you can set the desired level. Virtual/downloadable products (if any) are not reported as low stock, unless they are upcoming, but are easily identifiable and can be updated individually if needed. Features include: Colour coded rows for easy identification of low stock products, upcoming products and OK qty products. Option to enable/disable the low stock alert message. Option to include upcoming products in low stock alert message. Tick boxes to send e-mails to customers who have subscribed to Product Notifications (including Global Product Notifications) when updating qty's to above zero either individually or in bulk. Drop down selection to choose a category. Drop down selection to choose number of products to show per page. An updated single product becomes bolded for easier identification and jumps to correct page number if qty is increased/decreased dramatically. Ability to search for products, by name or model (search is performed on all products regardless of selected category). Each product's status is also shown and you can click to change (updating quantities will also adjust status accordingly). Each product's category path is also shown (cropped if too long). Ability to browse to, i.e. edit, the actually product info to view/modify and then returns to previous screen. ---------------------------------------------------------------------------------------------------------------------------------------------- Report problems here. Feedback and comments appreciated. Download link: http://addons.oscommerce.com/info/9541 cheers

Hi, I Try to install Low Stock Report v1.4 in oscommerce v2.3 on in my store. It is perfectly working. Nice one and it is required for a shop owner. But I get some heading problems in this add ons. Actually I don't have any knowledge in PHP. So I require your help.... :-) After installation, In report section in admin area, I get 4 reports. Products Viewed Products Purchased BOX_REPORTS_STOCK_LEVEL Customer Orders-Total The developer make a fix in language file to fix the heading of low stock report in to "product stock level". But it see the same in reports. But If i click on this report BOX_REPORTS_STOCK_LEVEL, the heading for it changes in to "Product stock level". Products Viewed Products Purchased Products Stock Level Customer Orders-Total Please look in the attachment and suggest some solutions.

hello forum, has any body used a report add on that will-- list product-- price --qty-- wt i searched for a while and did not see what i need, thought i would ask the community. thanks, craig