Hi ECT Team, about the new [url="https://www.ecommercetemplates.com/help/admin-stats.asp"]Admin Stats page[/url] introduced in v6.8.4, here are some minor issues to look at:

(1) Select Payment Method "All" and then Generate Results "Stats".
Error message is:
"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 1 ..."

(2) Otherwise, there is an issue unique to latest Firefox v57.0.4 browser.
When generating results as an SVG Graph by Week / Month / Year, the inline styling for table text Headings and Labels excessively magnifies the font-size.

That font-size scaling issue does not occur when using Google Chrome, Microsoft Edge or old Internet Explorer.


Gary
[img]https://itzap.com.au/pics/logo/itzap-website-design-works-mini-logo.png[/img]

I also notice that when I select a "Section" / Category it doesn't populate that category or product.

It shows everything.

Maybe I'm doing something wrong?

Patrick

Yes, that does appear to be the case Patrick.

Tick "Section" box.
Click on a Menu Category, maybe a Section you know does not contain any Products and generated $zero sales.
Click "Stats" button.

The chosen Menu Category does not remain selected and $Total sales are displayed.

Gary
[img]https://itzap.com.au/pics/logo/itzap-website-design-works-mini-logo.png[/img]

Hi

Thanks for posting, we'll look into this and get back to you. One thing about the category / section though, the first table shows "ORDER RESULTS (NOT LIMITED BY PRODUCT / SECTION)" so if you choose a category with no sales that will still show as it's not limited by product / section. I'm unable to recreate the font problem in Firefox that you mention.

Andy

Please feel free to review / rate our software

Hi Andy,

It doesn't matter which way you choose or NOT choose a product/category... neither one works

Patrick

Hi Andy,[quote]I'm unable to recreate the font problem in Firefox that you mention.[/quote]Using your standard "adminstyle.css", here is a screenshot of the Order Stats Graph taken using Firefox v57.0.4. Notice the very large Graph Title and Label font sizes.

[img]https://itzap.com.au/pics/ect/ectadmin-firefox-order-graph.jpg[/img]

There is inline Transform and Translate code applied to the [purple]<text>[/purple]Heading and Label[purple]</text>[/purple] entries, which is odd. Perhaps that is the culprit ?

[img]https://itzap.com.au/pics/ect/ectadmin-firefox-graph-style-rules.jpg[/img]

Using latest Google Chrome v63.0.3239.132, the graph appears just fine.

[img]https://itzap.com.au/pics/ect/ectadmin-chrome-order-graph.jpg[/img]

Very minor issue, but likely easily fixed.

Gary
[img]https://itzap.com.au/pics/logo/itzap-website-design-works-mini-logo.png[/img]

Thanks Gary, that's what I see in the HTML too but without it making the text larger - - it's very odd.

Andy

Please feel free to review / rate our software