gdfwilliams Posted December 20, 2002 Share Posted December 20, 2002 A new addition to the NEW contributions section: http://www.oscommerce.com/community/contributions,524 ~-~-~-~-~-~-~-~-~-~-~-~-~-~-~ SALES REPORT v1.2 12/21/2002 ~-~-~-~-~-~-~-~-~-~-~-~-~-~-~ ~-~-~-~-~-~-~-~-~-~-~-~-~-~-~ Summary: ~-~-~-~-~-~-~-~-~-~-~-~-~-~-~ A sales report utility that includes Daily, Weekly, Monthly and Yearly sales reports, including Total # of Orders, Avg. Order Amount, Total Sales, % Variance from previous hours/days/weeks/months. Daily/Weekly/Hourly reports also include graphs that track total sales. Daily report uses a stacked bar graph to include average order amount. ~-~-~-~-~-~-~-~-~-~-~-~-~-~-~ Recent Improvements: ~-~-~-~-~-~-~-~-~-~-~-~-~-~-~ v1.2 - Fix for some graph layout issues v1.1 - Fix to Install file v1.0 - Hourly reports, dynamic graphs, improved navigation, minor tweaks v.8 - Minor fix in Install file v.7 - Additions made to language files v.6 - Moved all the logic into class file sales_report.php in admin/includes/classes/ ~-~-~-~-~-~-~-~-~-~-~-~-~-~-~ To Do: ~-~-~-~-~-~-~-~-~-~-~-~-~-~-~ -> Improved navigation -> Improved export options (CSV and Print) -> User input for date range of reports -> Additional sales data to include categories/subcategories, specials ~-~-~-~-~-~-~-~-~-~-~-~-~-~-~ Other Info: ~-~-~-~-~-~-~-~-~-~-~-~-~-~-~ Screenshot of Daily report: ~-~-~-~-~-~-~-~-~-~-~-~-~-~-~ Development Team: ~-~-~-~-~-~-~-~-~-~-~-~-~-~-~ * Charly Wilhelm * Greg Williams Quote Link to comment Share on other sites More sharing options...
dreamscape Posted December 20, 2002 Share Posted December 20, 2002 thanks for the hard work fellas... graphs look good. I'll be sure to update my v1.1 when I get the chance. Quote The only thing necessary for evil to flourish is for good men to do nothing - Edmund Burke Link to comment Share on other sites More sharing options...
wizardsandwars Posted December 22, 2002 Share Posted December 22, 2002 Well, I have installed this contribution, however, it doesn't seem to work. There are no graphs, not all of the table headers are displayed correctly, links to the daily, weekly, monthly, and yearly reports seem to be messed up, and the numbers are all wrong. I installed this contribution twice, and made sure that all of the directions were followed properly. Anyone else having problems with this contribution? Quote ------------------------------------------------------------------------------------------------------------------------- NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit. If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help. Link to comment Share on other sites More sharing options...
wizardsandwars Posted December 22, 2002 Share Posted December 22, 2002 Ah, I found the issue. In the Application_Top in Admin, the foowing definition should be define('FILENAME_STATS_SALES_REPORT', 'stats_sales_report.php'); NOT define('FILENAME_STATS_SALES_REPORT', 'sales_stats_report.php'); The installation instructions are wrong. Quote ------------------------------------------------------------------------------------------------------------------------- NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit. If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help. Link to comment Share on other sites More sharing options...
Bapha Posted January 10, 2003 Share Posted January 10, 2003 Greetings I'm trying to use your contribution, but I'm getting the following error: Fatal error: Cannot redeclare tep_db_connect() in c:apachehtdocsnew-zealadminincludesfunctionsdatabase.php on line 13 any idea what i'm doing wrong? Quote Link to comment Share on other sites More sharing options...
wizardsandwars Posted January 10, 2003 Share Posted January 10, 2003 Well I have had this contribution installed for some time now, and although I think it has alot of potential, it is currently not practical. It the totals for all sales, whether they are "paypal pending", "cancelled" or "Shipped". It does not offer a way to diferienciate, and all orders of all statuses are thrown into the same bucket. Quote ------------------------------------------------------------------------------------------------------------------------- NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit. If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help. Link to comment Share on other sites More sharing options...
radders Posted January 10, 2003 Share Posted January 10, 2003 I have just installed this contibution - worked first time. The only way I could see of accessing last year's data was daily. The weekly and monthly sales data always start at the beginning of the year and don't have a 'previous' button. How can this be changed? Quote Link to comment Share on other sites More sharing options...
jeanjerome Posted January 18, 2003 Share Posted January 18, 2003 Just installed it on 2.2 that I set up couple of days ago... Look very promissing only I get the same error as Bapha :cry: : Fatal error: Cannot redeclare tep_db_connect() in /home/httpd/vhosts/xxxxxx.com/httpdocs/shop/admin/includes/functions/database.php on line 13 I am pretty new to all this, any advice where I should start looking is greatly appreciated?? Thanks! Quote Link to comment Share on other sites More sharing options...
Snowman Posted January 18, 2003 Share Posted January 18, 2003 Um is it possible to set this mod up so that graphs can be displayed for weekly, monthly and yearly reports as well???? It seems a shame to have it just available on the daily report. Quote Link to comment Share on other sites More sharing options...
radders Posted January 18, 2003 Share Posted January 18, 2003 It comes with graphs for all of them by default Quote Link to comment Share on other sites More sharing options...
Snowman Posted January 18, 2003 Share Posted January 18, 2003 hmmm i must have a weird issue as i only get a graph on the daily section. The other sections judt list a table which spreads right across the page. Anyone have any ideas as to what would be causing this?? Quote Link to comment Share on other sites More sharing options...
jeanjerome Posted January 18, 2003 Share Posted January 18, 2003 Anton, Fatal error: Cannot redeclare tep_db_connect() in /home/httpd/vhosts/xxxxxxxx.com/httpdocs/shop/admin/includes/functions/database.php on line 13 Did you found out why you also got this error?? Anyone else came accross this problem?? :?: :?: Thanks... Jean Quote Link to comment Share on other sites More sharing options...
garyidweb Posted February 9, 2003 Share Posted February 9, 2003 I get the following error on istall. Any ideas please 1146 - Table 'catalog.TABLE_ORDERS_TOTAL' doesn't exist select sum(ot.value) as value, avg(ot.value) as avg, count(ot.value) as count FROM TABLE_ORDERS_TOTAL ot, orders o WHERE ot.orders_id = o.orders_id and ot.class = 'ot_subtotal' AND o.date_purchased >= '2003-02-09T00:00:00' AND o.date_purchased < '2003-02-10T00:00:00' [TEP STOP] Thanks in advance Gary Quote Link to comment Share on other sites More sharing options...
radders Posted February 9, 2003 Share Posted February 9, 2003 And did you remember to add the definition to application_top.php in admin? define('TABLE_ORDERS_TOTAL', 'orders_total'); Quote Link to comment Share on other sites More sharing options...
garyidweb Posted February 10, 2003 Share Posted February 10, 2003 I have worked out that this contribution isnt conpatible with my version of osc. I am using a release from about 02/02. Table orders doesnt exist in the database Quote Link to comment Share on other sites More sharing options...
garyidweb Posted February 10, 2003 Share Posted February 10, 2003 I have worked out that this contribution isnt conpatible with my version of osc. I am using a release from about 02/02. Table orders doesnt exist in the database Sorry I meant "orders total" Quote Link to comment Share on other sites More sharing options...
gdfwilliams Posted February 10, 2003 Author Share Posted February 10, 2003 Coming soon from Charly: Sales Report v2.0! http://www.oscommerce.com/community/contributions,953 - Greg Quote Link to comment Share on other sites More sharing options...
garyidweb Posted February 10, 2003 Share Posted February 10, 2003 is this new contribution going to be compatible with older versions, with the problem mentioned above Quote Link to comment Share on other sites More sharing options...
gdfwilliams Posted February 10, 2003 Author Share Posted February 10, 2003 Charly may be able to answer that question. Quote Link to comment Share on other sites More sharing options...
quicklyshop Posted February 20, 2003 Share Posted February 20, 2003 after installing this contribution i started to have below error everytime i try to add a new product to the catalog. I am using V2.2. I checked the the general.php and english.php but i haven seen any sysntax error where am i doing wrong? Warning: Cannot add header information - headers already sent by (output started at /home/quickly/public_html/shop/admin/includes/languages/english.php:277) in /home/quickly/public_html/shop/admin/includes/functions/general.php on line 18 Quote I can't type a trick like i can type. Link to comment Share on other sites More sharing options...
Snowman Posted February 20, 2003 Share Posted February 20, 2003 You have some whitespace in english.php after the ?> remove it and it should be fine Quote Link to comment Share on other sites More sharing options...
wizardsandwars Posted February 20, 2003 Share Posted February 20, 2003 As I've said, the main problem with this mod is that is doesn't break out the sales by order status. Therefore, a 'Cancelled' order is summed in with a 'Shipped' order. Obviously, until this is fixed, this makes this contribution useless. Quote ------------------------------------------------------------------------------------------------------------------------- NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit. If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help. Link to comment Share on other sites More sharing options...
dreamscape Posted February 20, 2003 Share Posted February 20, 2003 As I've said, the main problem with this mod is that is doesn't break out the sales by order status. Therefore, a 'Cancelled' order is summed in with a 'Shipped' order. Obviously, until this is fixed, this makes this contribution useless. hmm I didn't even think to create a "cancelled" status for orders... there isn't one in by default, which may be why this contribution doesn't use it. I'm using v1.5 and I modded it the other day to exclude orders that were placed on my test accounts. It was very simple to change and having it exclude "cancelled" orders should be equally as simple. Also in the upper right corner of the Sales/Tax page is a drop down box wehre you can select which order status you would like shown... so you can have ALL shown, or just shipped... but u can't select more than one, but again that would be easy to change to maybe checkboxes so that you can do a combination of statuses (for example companies running on cash basis, would not want to see the order added into total until it was shipped and companies running on acrual basis would want it recognized in the report if it was pending, processing, or shipped) Quote The only thing necessary for evil to flourish is for good men to do nothing - Edmund Burke Link to comment Share on other sites More sharing options...
wizardsandwars Posted February 20, 2003 Share Posted February 20, 2003 Also in the upper right corner of the Sales/Tax page is a drop down box wehre you can select which order status you would like shown.. I'm not sure we're talking about the same comtribution here. Either that or this has been added since I've installed it. There are two sales report contributions. 1 is a Monthly Sales/Tax contribution, and then there is this one, the Sales Report. The Monthly Sales/Tax contribution does allow for filtering on the order status. The version of the Sales Repot that I have does not. Quote ------------------------------------------------------------------------------------------------------------------------- NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit. If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help. Link to comment Share on other sites More sharing options...
dreamscape Posted February 20, 2003 Share Posted February 20, 2003 Also in the upper right corner of the Sales/Tax page is a drop down box wehre you can select which order status you would like shown.. I'm not sure we're talking about the same comtribution here. Either that or this has been added since I've installed it. There are two sales report contributions. 1 is a Monthly Sales/Tax contribution, and then there is this one, the Sales Report. The Monthly Sales/Tax contribution does allow for filtering on the order status. The version of the Sales Repot that I have does not. yeah it does... the newest monthly/sales tax is version 1.5 and allows for filtering the order status: Quote The only thing necessary for evil to flourish is for good men to do nothing - Edmund Burke Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.