Sales report 2.0

[BlindSide]

Well it's been a long time in the making, but hopefully the wait was worth it! Sales Report 2.0 is here, so go get it!

http://www.zen-cart.com/index.php?ma...products_id=83

You can drop the files right into the admin and right over top of the existing files. Still no overwrites.

Take it for a spin, and let me know what you think, and if you find any problems. I've been using it for the past few months as I built and tweaked it, so there should be no major issues.

Enjoy, and thanks for your patience.

[Woodymon]

Hi Frank-

Easy install as you stated.

Regarding setting defaults for timeframe reports, is there a method available to disable displaying a period when no orders are processed? That is, rather than displaying "-- NO ORDERS IN TIMEFRAME --", instead just display the periods where an order was processed? Hopefully not many shopkeepers will have days like that, but would be useful feature for some mom & pops (especially for weekends or vacations).

Of course if reports are to be used as any kind of an "audit" instrument then showing zero order days is indeed a good idea.

Thanks,
Woody

[BlindSide]

Regarding setting defaults for timeframe reports, is there a method available to disable displaying a period when no orders are processed? That is, rather than displaying "-- NO ORDERS IN TIMEFRAME --", instead just display the periods where an order was processed? Hopefully not many shopkeepers will have days like that, but would be useful feature for some mom & pops (especially for weekends or vacations).

I had actually thought about adding that option already. Look for it in a future release.

Of course if reports are to be used as any kind of an "audit" instrument then showing zero order days is indeed a good idea.

Precisely.

[jettrue]

I installed it too, thanks for the update!

I find it a little busy though, with all of the dark grey headings with the white text. I'd prefer one heading at the top, and then maybe odd-even colored rows to help differentiate lines.

I'd also love the option to remove some fields. Gift certs for example.

[BlindSide]

I find it a little busy though, with all of the dark grey headings with the white text. I'd prefer one heading at the top, and then maybe odd-even colored rows to help differentiate lines.

The color scheme is design to match the rest of the admin. If you don't like it, you're welcome to change it on your install, just as you would the Admin nav bar. The style defines begin on Line 241.

The number of headings all depends on how your arrange your timeframes. If you choose a 30-day range, but daily timeframes, you'll get that timeframe heading above each day. Instead, choose monthly timeframes and you'll get all those orders neatly organized under one heading. The reason for this flexibility goes back to report's intent: it's for an accountant. These types of breakdowns are necessary for proper double bookeeping. If you're not seeing what you want, it's not the report's fault.

I'd also love the option to remove some fields. Gift certs for example.

Take a look at the language define file. You'll find two defines which will enable/disable One-time Fees and the Manufacturer. Beyond that, I again point you to the report's intended audience. If you're big enough to have a bookeeper, you are likely using coupons at least as a loss-leader invitation.

[langer]

Frank, nice work. I did turn up a "division by zero" error though. I'll let you know the exact details soon - it may have something to do with my occasional $0.00 product "sales".

Cheers!

[BlindSide]

it may have something to do with my occasional $0.00 product "sales".

I have no doubt that is the cause. Post the details when you have them.

[eztrumpet]

Thanks for the great work but anyway to merge more information to this report, I need customer's address, maybe in other way I can customize my sales report. Thank you very much.

[Pauls]

I can't make it work as it used to, ie it won't show a months sales for a month between two dates .... obviously I am missing something here, but it was very simple with the previous version but I am unable to do this ... I will go rtfm I think

[kelvyn]

It's working great here - but, having spent yesterday (Sunday) morning installing it, and updating all my other mods, does anyone know if this works with the 1.3.5d release announced this morning?