Huetty Posted November 17, 2009 Share Posted November 17, 2009 Hi,i was searching the forum but didn't find any answer. I upgraded the shop from 1.1 to 1.2.5 and now it doesn't show the actual turnover. I get the number of registrations and viewed Products, but the turnover and the orders placed is emtpy - how can i get these informations? Do i need to update something in the database or in the modules? Thanks for your help. Link to comment Share on other sites More sharing options...
zeiser50 Posted November 17, 2009 Share Posted November 17, 2009 Do you have de activated the invoice ? Link to comment Share on other sites More sharing options...
Huetty Posted November 18, 2009 Author Share Posted November 18, 2009 Hi Michael,no we didn't activate invoices, because we need to write the data in to our erp system and it would cause more work. But i would like to know how much turnover i have made - how can i solve this? ThanksHuetty Link to comment Share on other sites More sharing options...
zeiser50 Posted November 18, 2009 Share Posted November 18, 2009 The turnover calculation is made using invoice date (in order to filter a time range). If you haven't activated invoice, then the invoice are not created and the invoice date is 00 00 00 : the calculation can not be done.I've solved it using the delivery date (instead of invoice date). If you are interested in, i will give you the modification i've done (i'm not at home). Link to comment Share on other sites More sharing options...
Huetty Posted November 18, 2009 Author Share Posted November 18, 2009 Hi Michel,sorry that i made a mistake in your name in the last reply. Please give me the info when you're back home. Thanks very much.Huetty Link to comment Share on other sites More sharing options...
zeiser50 Posted November 18, 2009 Share Posted November 18, 2009 No problem Huetty !The file which should be modified is adminstats.php (in /admin/tabs folder).Find "public static function getSales($dateBetween)" (should be on line 46).a)replace 'invoice_date' in the $result formula with 'delivery_date'b)replace 'invoice_date' in the $xtrems formula with 'delivery_date'c)replace 'invoice_date' in the $products formula with 'delivery_date'That's all. Link to comment Share on other sites More sharing options...
paradate Posted December 1, 2009 Share Posted December 1, 2009 Where can I find instructions about upgrading to 1.2.5 version? Link to comment Share on other sites More sharing options...
Huetty Posted December 1, 2009 Author Share Posted December 1, 2009 Hi, just look at the wiki - the update how to is described there very good - when you follow the instructions, you will have no problem. (so i didn't had any). Look here:wiki update how toDon't forget to follow the links in the how to. E.g. database backup and so on so you don't miss anything... ;-) Link to comment Share on other sites More sharing options...
Huetty Posted December 1, 2009 Author Share Posted December 1, 2009 @ Michel,thanks for your help - in the statistics i now can see the right sums - but i don't see them in the BackOffice starting page (it doesn't matter, but if you know a workaround also here please let me know)Thanks for your helpHuetty Link to comment Share on other sites More sharing options...
L. Brett Sinclair Posted February 12, 2010 Share Posted February 12, 2010 No problem Huetty !The file which should be modified is adminstats.php (in /admin/tabs folder).Find "public static function getSales($dateBetween)" (should be on line 46).a)replace 'invoice_date' in the $result formula with 'delivery_date'b)replace 'invoice_date' in the $xtrems formula with 'delivery_date'c)replace 'invoice_date' in the $products formula with 'delivery_date'That's all. HelloIf I wanted to use the ordering date, what would that be ? Link to comment Share on other sites More sharing options...
Huetty Posted February 12, 2010 Author Share Posted February 12, 2010 try instead of `delivery_date´ `date_add´ this ist the date when the order was added to the database Link to comment Share on other sites More sharing options...
L. Brett Sinclair Posted February 12, 2010 Share Posted February 12, 2010 ok - Thank you Huetty , now in the index page on the BO side, there are statistics also, which php file must I update ? Link to comment Share on other sites More sharing options...
L. Brett Sinclair Posted February 12, 2010 Share Posted February 12, 2010 statshome.php would be the file - thank you again ! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now