Updated Admin Sales Report

[damonp]

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?

[cherylkemp]

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.

[Pauls]

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.

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?

[slaxed]

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.

[damonp]

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';

[slaxed]

Thanks now its working fine

[amandac]

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...alesreport.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

[amandac]

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...lesreport2.gif

Corresponding Report:
http://www.instituteforvibrantliving...lesreport3.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.

[damonp]

What happens if you don't filter by state?

[amandac]

Neither of these are filtered by state.

Amanda