Sales report 2.0

[agamic]

I was wondering whether there was a fix for this as I have just loaded the latest report mod running on 1.3.7 and the tax shows as $1 which is incorrect under the product line items filter but correctly at $2.97 under the orders filter.
Thanks Blindside for a great mod nevertheless.

Hi
I take it that is a no then, no fix that is, as I have been through the whole thread and there is no mention of the tax problem fix. Does anyone have this problem or know of a cure?
Thanks in advance
a

[X.O.]

Hi, thanks for the awesome mod.
It worked fine until I started to get this error in Firefox console on line 402:document.search.btn_submit has no properties.
Nothing happening when I click on the button "Show me the money".
Re-installation did not help. I am using Zen 1.3.6 and Sales Report 2.0 plus a lot of other mods. What could it be? Thank you in advance.

[Guenhwyvar]

I installed it on my 1.3.7, everything went smooth. The report have problems with the german localisation (I altered the settings for the date format, but maybe I did something wrong). Anyway, I can switch to english and the date selection works good.

My problem: PayPal sells are ignored in the reports. How I can fix that?

[lyricwings]

This is a great mod!
Is there any way to sort on Manufacturer NAME, not ID, and also have the Manufacturer name show in the report?

I tried the following and it didn't work - now I'm not getting any report at all. Am I missing a step?

1. In admin/stats_sales_report.php, I edited the line:
define('DEFAULT_MANUFACTURER', ''); // manufacturers_id from Admin > Catalog > Manufacturers ("mID=##" in the URL)

to
define('DEFAULT_MANUFACTURER', ''); // manufacturers_name from Admin > Catalog > Manufacturers ("mID=##" in the URL)


2. I also set this line to "true":

define('DISPLAY_MANUFACTURER', true);

Am I missing a step?

Thanks - this is a great mod!

~LW

[lyricwings]

Oops - I spoke too soon!

Honestly, I am not sure exactly what I had done wrong to begin with, but when I saw that this update DID allow the Manufacturer name to display automatically, I re-installed the mod, and now everything works perfectly.

Again, I'm not sure what I did wrong the first time, but now all is well. Sorry for the alarm.

And thanks for this great mod!

~LW

[lyricwings]

This mod is working great! I love it...thank you!

I only have one issue. Whenever I do a report that includes one particular order in the date range, it calculates the total incorrectly, based on quantity. ALL of the other orders are calculated correctly, but it's just this one order that isn't correct.

Base price=$2.50
Quantity=1
Product Total = $8.50

Where did the $8.50 come from? I have looked at the order history, and I can't find anything odd or unusual about it.

The customer did only order 1, and was only charged the correct $2.50.

any ideas why this could be happening, for just this one order?

Thanks!
~LW

[DogTags]

Would be great if you could extract sales data per state.

This would pull out tax-exempt numbers, too

HTH

[redheads]

I was able to write up an SQL query which gives me the sales by state data - I just need to figure out how to translate it into a zen-cart feature... I would love to see this become reality so my clients can do the searches themselves!

[BlindSide]

Take a look at the sales_report class. All the SQL'ing goes on in there. If you can work out the proper SQL for such info, you might be able to work it into the class code.

[suffrinmick]

Hi - What a really useful tool! Is it possible to include the product category and the shipping costs in the csv output?

Thanks
P