Updated Admin Sales Report

Added a local state filter to the Sales Report contribution for reporting of local sales taxes.

Download http://damonparker.org/files/zen_sales_report_v1.4.1.zip

Thanks Damon-

Would you add it to the Downloads section? https://www.zen-cart.com/index.php?main_page=add_contrib

I have a problem, this mod is great however for some reason and it was working fine before. The layout has all gone absolutely crazy. As far as I know nothing has changed and I just recently re-upped all of the files in this mod, but the layout is all over the place, I will attach a screenshot for you to see.

Notice how the drop down menus are all over the place, and the selection bullets are on the left hand side, all of those menus were originally on the top, what has happened?

Please help.

Are you saying this mod was working and now it suddenly isn't or are you saying the original mod was working and when you installed my updated version you get the broken display?

What happened in between when it was working and now?

Hi damon, it makes no difference which version i use, that fomatting thing still happens. But as far as I can recall nothing has changed on our website since adding the mod. However, when I first installed it, it formatted the page correctly. We only went live recently however, so only had some real data in the last 3 days, it is since the arrival of this new data that this formatting error has happened, very odd.

I don't really have enough infomation to work with here. If it was working before, it can't break without something being changed somewhere.

If the formatting problem happens with either version of this mod, I would guess that the mod wasn't installed completely.

Turn on your table borders in stats_sales_report.php to debug where the table cells break.

Well, OK, I turned the table borders to 1, but the tables don't break, they are just malformed.

Anyway, I have taken the mod out for now, I intend to replace it with superorders so don't worry about it, thanks for your help. :thumbsup:

If your tables are misaligned the tables are 'broken'. Turning borders on sometimes help you to see where they ware working and where they start to break. Then you can look at the source to see what is causing the misalignment. Most probably a missing closing /td or /tr.

I just installed this a couple of days ago and it looks exactly like the screen shot...have to scroll horizontally to see all of it. It does work though, but it would be nice to have it look a little neater.

I have fixed this issue now, the problem was I had included a 'WorldPay' logo at the checkout stage as one of the options for the customer, instead of just having the default text. It would appear that the worlpay.php page was incuding the HTML used to allow the insertion of the image into the admin section. This caused problems with this module, and with super orders too.

Sadly this means that I cannot have an image at the checkout stage for WorldPay, ironically though it works perfectly with the PayPal logo in the same page. I guess the worldpay.php sends its data back to admin differently than the paypal.php file.

Regardless, problem solved, I thought I would post the solution that this might help others. Oh and the reason it worked fine originally was that we hadn't received any WorldPay orders, only PayPal ones.

One final note, being from the uk I find the inclusion of 'Local State' of no benefit to me, therefore I have stuck with the previous version.

Pauls:

I have fixed this issue now, the problem was I had included a 'WorldPay' logo at the checkout stage as one of the options for the customer, instead of just having the default text. It would appear that the worlpay.php page was incuding the HTML used to allow the insertion of the image into the admin section. This caused problems with this module, and with super orders too.

Did you look through the Worldpay module to see why it would be throwing that html in there? Some of the other payment mods can use an icon too, do thase have the same problem?

UK taxes are the same country wide? No addon local taxes?

Pauls:

I have fixed this issue now, the problem was I had included a 'WorldPay' logo at the checkout stage as one of the options for the customer, instead of just having the default text. It would appear that the worlpay.php page was incuding the HTML used to allow the insertion of the image into the admin section. This caused problems with this module, and with super orders too.

Sadly this means that I cannot have an image at the checkout stage for WorldPay, ironically though it works perfectly with the PayPal logo in the same page. I guess the worldpay.php sends its data back to admin differently than the paypal.php file.

Regardless, problem solved, I thought I would post the solution that this might help others. Oh and the reason it worked fine originally was that we hadn't received any WorldPay orders, only PayPal ones.

One final note, being from the uk I find the inclusion of 'Local State' of no benefit to me, therefore I have stuck with the previous version.

Well I think that explains my sales report and super orders problem too...I also have an image in the checkout process. Wonder if there is any way to fix this...seems like it shouldn't be too hard since other payment modules don't do that.

UK taxes are the same throughout the country, no local taxes.

I had started a thread relating to this problem before I posted here, I posted my solution and the code differences ... I couldn't see any, but have a look at the thread here

http://www.zen-cart.com/forum/showthread.php?t=40298

Cheryl, yes I agree this is probably the same problem for you too. DrByte might be able to shed some light on it, but my php skills are far too limited I am afraid.

damonp:

Did you look through the Worldpay module to see why it would be throwing that html in there? Some of the other payment mods can use an icon too, do thase have the same problem?

UK taxes are the same country wide? No addon local taxes?

Hi there,
I seem to be getting an error when i set the SR_TAX_BASIS in stats_sales_report.php to shipping and try to filter by local tax zone. However the filter works when i set the SR_TAX_BASIS to billing.

1054 Unknown column 'shipping_state' in 'where clause'
in:
[SELECT count(o.orders_id) as order_cnt FROM orders o WHERE o.date_purchased >= '2006-07-21T00:00:00' AND o.date_purchased < '2006-07-22T00:00:00' AND shipping_state = 'Singapore' ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Take a look at sales_report.php line ~#103

$state = SR_TAX_BASIS == 'shipping' ? 'shipping_state':'billing_state';

Should be:

$state = SR_TAX_BASIS == 'shipping' ? 'delivery_state':'billing_state';

Thanks now its working fine

We installed this module a couple days ago & it's a fantastic tool. However, last night we noticed a situation with some of the number totals. Please see the image at this link:

http://www.instituteforvibrantliving.com/salesreport.gif

This is a snip of a report using search from Jul 29 - Jul 29, Show Products, & DAILY, Order Status - ALL. Everything else was left as the default.

What would cause this? We're using the most recent version of Zen & this module.

Thanks ;-)
Amanda

Updating my post:

I've noticed (just now LOL) that if the customer's shipping & billing address do not match - the products ordered either 1) Do not appear on the Sales Report at all or 2) Have incorrect totals.

Here are some screen clips of the order itself - and how the totals appear in the report.

Order:
http://www.instituteforvibrantliving.com/salesreport2.gif

Corresponding Report:
http://www.instituteforvibrantliving.com/salesreport3.gif

On this report it is important to note that this gentleman's order was the ONLY order for the TRIAL OFFER today. He ordered 3x of the product but the report only shows 1x.

What happens if you don't filter by state?

Neither of these are filtered by state.

Amanda