Sales report 2.0

[CES]

I'm 99% certain this has been fixed by someone.

Have you seached this thread?

Craig

[kuroi]

I'm 99% certain this has been fixed by someone.

Have you seached this thread?

It has. Post 239. Which is why I'm surprised that the change to DATE_FORMAT_SPIFFYCAL didn't work for kitcorsa. I assume he must be using an older version.

[kitcorsa]

i have been rading through this post for 10 days now on and off and hadn't got to the stage you have listed above. the problem is the downloads section has the OLD 2.0 version not the 2.2 version this is why i was getting the problem i belive.

going to install the new version now and test.

[kitcorsa]

installed 2.2 and this sorted the problem. Thanks for posting the number of the post and savimng me anpther week of reading.

..ADMIN..
Please update the file on the downloads section

[jcun45]

Hi, I have installed the sales report add on and all seemed to work correctly. However, when I look at the report the total price (without tax) is correct but the actual total is wrong. I am adding 19% sales tax but it seems that the report is adding much more. The invoices are all correct it is only the sales report total that is incorrect and adding a bit more. Can someone please help me with this??

This is my customers invoice upon checkout:


1 ea. Westvleteren 12 33cl, 10.2%ABV €9.50
€9.50
Sub-Total:

€0.00
Store Pickup (Walk In):


Total: €9.50


This is the correct price including 19% tax.

In the admin the invoice looks like this:

Date Purchased: Friday 07 March, 2008
Payment Method: Cash on Delivery
Products Model Tax Price (ex) Price (inc) Total (ex) Total (inc)
1 x Westvleteren 12 33cl, 10.2%ABV 19.00% €7.98 €9.50 €7.98 €9.50
Sub-Total: €9.50
Store Pickup (Walk In): €0.00
Total: €9.50

This is also correct.

The sales report looks like this:

Timeframe Num Orders Num Products Goods Value Shipping Discounts Gift Cert. Sold Gift Cert. Used Total
3-7-2008 1 1 | Diff: 1 €7.98 €0.00 €0.00 | Qty: 0 €0.00 | Qty: 0 €0.00 | Qty: 0 €7.98
Prod ID Product Name Re-sort in DESCENDING order 2 Model No. Re-sort in DESCENDING order1 Base Price Qty. Product Total
180 Westvleteren 12 33cl, 10.2%ABV €7.98 1 €9.98

Why is the product total 9.98??? It should be 9.50!

Cheers,


Jeff

[jcun45]

OK, see page 24 for fix (took awhile to get there), great job, it fixed everything! I wonder why this version isn't what would be downloaded in the download page...

Awesome add on, thanks again.

Jeff

[kitcorsa]

OK, see page 24 for fix (took awhile to get there), great job, it fixed everything! I wonder why this version isn't what would be downloaded in the download page...

Awesome add on, thanks again.

Jeff

yeah this is what i menioned above. the download in the download section is an old version.

ADMIN PLEASE UPDATE!

[Alex Clarke]

First off, great contribution. This makes accounting so much easier for Zen Cart owners!

I'm currently running the latest version of Sales Report on Zen Cart 1.3.8a and I think I'm getting a similar error to jynxy.

When loading up the stats_sales_report.php file (via my Zen Cart admin) I receive the following error (displayed by Firefox):



When I click the 'Show me the money!' button the report is generated successfully, but I still receive the same error message (as quoted above).

This error message is also displayed when I click on the 'Report Defaults' button.

Anyone know how to fix this?

Just updated to the latest version of this contribution. I too was previously using the old version from the downloads section.

Everything is working fine with the new version, but I still get these errors (as mentioned in my last post). Does anyone else get similar errors?

[erika_311]

Hi. I LOVE this contribution! I do have a question that I can not find an answer too:

I have a store in which I have 8 designers and I need to give them a report on the products the sell so I can "pay" them, but how do I get the report onto a .pdf or spreadsheet... I have tried but it looks horrible!

Thanks for your help.

[kitcorsa]

you use the export option of a tab dielimited file and just open that in excell, then im sorry to say but you have to spend some time making it look like you want and adding charts etc.

other than that use the layout in the modular and dispay on screen then download a low res pdf converter like primopdf and then click print, primo pdf, and that will create a pdf of the on screen view.