Sales report 2.0

[CES]

Thanks Conor for updating Frank's "super" sales report!!

Just reporting back everything is great now!!

Thanks again you two.

Craig

[poosk]

why I get always an error with dates if I try to select custom timeline?

[CES]

why I get always an error with dates if I try to select custom timeline?

Have you tried the adjustments Conor suggests on the previous page.

I'm in the UK and use the day/month/year format and Conor's solution works fine for me.

Craig

[jamie2k]

Hi Blindside,

I have installed this mod on my test site and i get the following error after pressing "show me the money":-

1406 Data too long for column 'page_parameters' at row 1
in:
[insert into admin_activity_log (access_date, admin_id, page_accessed, page_parameters, ip_address) values (now(), '3', 'stats_sales_report.php', 'date_preset=yesterday&start_date=&end_date=&date_target=status&date_status=1&pa yment_method=¤t_status=&timeframe=day&timeframe_sort=asc&detail_level=timeframe& li_sort_order_a=asc&li_sort_order_b=asc&output_format=display&new_window=1&', '62.105.176.92')]
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.

Can you help Please?

[Stevietheman]

Hi Blindside,

I have installed this mod on my test site and i get the following error after pressing "show me the money":-

1406 Data too long for column 'page_parameters' at row 1
in:
[insert into admin_activity_log (access_date, admin_id, page_accessed, page_parameters, ip_address) values (now(), '3', 'stats_sales_report.php', 'date_preset=yesterday&start_date=&end_date=&date_target=status&date_status=1&pa yment_method=¤t_status=&timeframe=day&timeframe_sort=asc&detail_level=timef rame&li_sort_order_a=asc&li_sort_order_b=asc&output_format=display&new_window=1& ', '62.105.176.92')]
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.

Can you help Please?

Run this SQL on your Zen Cart database:

ALTER TABLE admin_activity_log CHANGE page_parameters page_parameters TEXT NULL DEFAULT NULL;

[jamie2k]

Run this SQL on your Zen Cart database:

ALTER TABLE admin_activity_log CHANGE page_parameters page_parameters TEXT NULL DEFAULT NULL;

:) Big smiles... thanks for such a quick reply... worked like a dream.

[Stevietheman]

:) Big smiles... thanks for such a quick reply... worked like a dream.

My pleasure. This one was easy, as it's already been answered before.

[jamie2k]

Stevie,

I am sure if you have done as much of this as i have you'll agree; once you have looked at the zen forum for longer than an hour, after a full days work, at 11pm; your eyes decieve you and even though you know how to find the answers, they seem to evade you.

I really need another pair of hands and eyes for this time of day... I'm shattered, been hard at it for time... so should think about bed now.

Many thanks again,

kind regards

Jamie

PS. R U UK Based ?

[Stevietheman]

Jamie, I understand how that goes. I've been there many times myself. I've even already asked a question in these forums that I smacked my head about afterwards.

I'm based in Louisville, KY, home of the Queen's recent visit. It's only about five hours behind here (and I speak a version of English), so I theoretically could work on UK projects.

[ronlee67]

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.

I'm confused about the version of this contribution. If I follow the link it takes me to the download section where this contribution is listed as:
Zen Cart™ Version: v1.3.6
Version: rev 104
Last Updated: Nov 11 2006
Author: BlindSide
There is no mention of Sales Report 2.0 (just Sales Report). I installed it anyway and it looks good!

My two questions are:

Is the above rev 104 the latest version of Sales Report 2.0?
Is there a way to display the State where the order is shipped (for completing sales tax reports)?

I installed on ZenCart Ver. 1.3.7 and haven't had any problems.

Ron