Sales Report with Graphs support thread

I have updated the Sales Report with Graphs add on to work with ZenCart version 1.5.1 and have fixed a few errors I found.
http://www.zen-cart.com/downloads.php?do=file&id=848
(pending review)

The old support thread is here: http://www.zen-cart.com/forum/showthread.php?t=68417
It is locked now so I will start this one to help out any one who wants help!

Many thanks to www.healthyjavashop.com for sponsoring the edits. They have been successfully using ZenCart since 2007.

Jacob Bushnell

Please could somebody tell me how I can generate the reports so they include tax and shipping?

Many Thanks

Stevis2002, there is no feature built in for that. It would require a fairly major re-write. If it's very important I would guess you could hire a programmer on oDesk.com to do that for around $100-$300 USD.

Thank you,
Jacob Bushnell

If you can, please make a demo page. Thanks.

I've been using this for a while and just noticed something I wish I had noticed earlier. It's not deducting coupons used from the total amount of sales. Is there a way to change this? I was doing a promo this month for free product so I have a whole bunch of orders with $0 payments, but this module is recording them as if they did in fact pay the full price for the items.

I've installed the files, but the admin/reports portion doesn't show up. Is there anything I might have missed...an SLQ or something? I haven't noted one yet.

Thanks,
DML

DMLyons:

I've installed the files, but the admin/reports portion doesn't show up. Is there anything I might have missed...an SLQ or something? I haven't noted one yet.

Thanks,
DML

Check to make sure you uploaded the admin files into the right place, and the sales_report_graphs.php in the root of the admin folder.

There are no SQL patches to install.

Have a great day,
Jacob

JacobBushnell:

Check to make sure you uploaded the admin files into the right place, and the sales_report_graphs.php in the root of the admin folder.

There are no SQL patches to install.

Have a great day,
Jacob

Thanks, Jacob! I did have a file in the wrong place. I blame it on lack of caffeine this morning.

Brenna

I notice there isn't activity on this thread for a while. I use the version for 1.3.9h all the time. I'm upgrading to 1.5.4 Will your latest support 1.5.4? Unless there are big database changes, I would guess it would.

Thanks!
Al

acmaurer:

I notice there isn't activity on this thread for a while. I use the version for 1.3.9h all the time. I'm upgrading to 1.5.4 Will your latest support 1.5.4? Unless there are big database changes, I would guess it would.

Thanks!
Al

I have not tried on on 1.5.4, but it works fine with 1.5.1 so I'm guessing it should be fine.
-Jacob

I've got the plugin running properly (without modification!) on a Zen Cart v1.5.4 site.

I've been working on some changes to dump the old Netscape graphing code and use the Google Charts feature. I may package it up as an update sometime next month if someone reminds me mid-February.

JacobBushnell:

I have not tried on on 1.5.4, but it works fine with 1.5.1 so I'm guessing it should be fine.
-Jacob

Works fine. There was a file in /admin/boxes/extra_boxes that I didn't copy over because the 1.5.4 admin folder didn't have a /boxes folder.

Does the summary reports I need--thanks!

DrByte:

I've been working on some changes to dump the old Netscape graphing code and use the Google Charts feature.
Update posted :)
Also resolved the issue of the order-status filter showing multiple times for every language in the store.
https://www.zen-cart.com/downloads.php?do=file&id=848

DrByte:

Update posted :)
Also resolved the issue of the order-status filter showing multiple times for every language in the store.
https://www.zen-cart.com/downloads.php?do=file&id=848

hi, is there any (easy) way how to make this work with 1.3.9f? (i know it's old ;)

thanks!

luidzi_1:

hi, is there any (easy) way how to make this work with 1.3.9f? (i know it's old ;)

thanks!
you would need to download the older version of the plugin (go to the plugin page, and scroll down to the one compatible with 139). Note that you'll be missing some bugfixes, and won't have some of the newer features such as Google Charts to do the graphing, etc.

It would be wise for you to put a plan in place to upgrade to the latest ZC version soon :)

I can't believe I wasn't aware of this mod before! Nicely done, Dr. Byte and other contributors. Works like a charm.

On some installations where PHP was compiled without cal support, this mod will fail because the cal_days_in_month function doesn't exist. You can just define it locally if this happens to you.

Under the inclusion of application_top, add

if (!function_exists('cal_days_in_month')) {
  function cal_days_in_month($cal, $month, $year) {
    return date('t', mktime(0, 0, 0, $month, 1, $year));
  }
}