Sales report 2.0

[athena]

I'm having a small problem with version 2.2. The report is generating incorrect order totals. It is adding the product cost (ex tax) to the shipping cost (inc tax) and giving a total figure that doest match the order.
All I'm looking for with this add-on is to be able to obtain a total $ value of all orders between two dates. I need the order totals (including shipping and tax ie what the customer pays) for all orders so I have a 'total income'. Showing tax would also be a bonus but not essential as I can just divide the total by 11 (Aus GST 10%).

We are seeing this problem also. I have my old 1.3.0.2 zencart and new 1.3.8a opened to two windows comparing reports and the latter sales_report_rev104 is randomly a few cents off...but this adds up over time to make a difference of thousands. These reports are being run off the same data.

[athena]

Well...further research showed that the old 1.3.0.2 cart was off a cent here and there. It was adding shipping to the sales with an error of .01 ...odd...but not happening so far with this recent install. Will try and give the issue more time later.

[athena]

Although this 2.0 version is a beautiful thing, One thing I do miss is the quick ability to compare previous years to present and to filter results.

[greatwhitebuffalo]

Like I've said before, the first version of the Sales Report attempted this, and I took it out when I took over the project because it simply didn't work well. But I'm looking forward to seeing what solution you might come up with.

A few things you'll want to keep in mind:

• Attributes currently have no associated quantity, so you'll need to do your own counting.
• How will you handle text attributes? Remember that they are often completely different values (hence no counting).
• You'll probably want to ignore file upload and read-only attributes, but only if they do not have a currency value associated with them.

Hello,

This is exactly what I need. The accountants are asking for reports on each size sold for items (they often come from different manufacturers) and I'd really like to be able to do this within Zen Cart. Does anyone have a solution?

Thanks,
Darren

[Opal]

I have put all the files in all the right places and can't get it to work, when I click on sales report in the admin panel it comes up with the error 404 page or forbidden

What am I doing wrong?

[vhjdb]

Is this portbale to version 1.3.8? caz I am having trouble making it work there. do i need to change something?

Thanks in advance.
vhjdb

[nightwolff]

I am working with Sales Report on Zen Cart 1.38a and it works fine. The only thing I would like to do is to have an option to omit canceled orders from the totals. Can anyone advise me where I would need to make that change? Thank you!

-Shawn

[vhjdb]

I found the solution for my problem at http://www.zen-cart.com/forum/showth...=44669&page=18

Opal, If your log is showing " PHP Parse error: syntax error, unexpected $end.... " Please follow this and it will solve your problem as well.

Nightwolff, thanks for confirmation! This made me believe that it works with latest version and I tried diggin in instead of throwing this nice module thinking it is not competible.

Regards,
Vhjdb

[econcepts]

I've looked all over the place and although I find people with this same issue (see below) I have yet to find answer on HOW to correct it.

When I use the "Batch Status Update" option to update orders, everything updates EXCEPT the "last modified date" (in the "orders" table) is NOT updated.

The only way that updates is if I use the standard "Orders" option to edit and update.

How can this be corrected and what is causing it? At one point it time I believe it must have worked.

[econcepts]

I figured it out.

The problem was that there was a missing parameter in the super_orders_funtctions.php file.

Around lines 409 - 412 you'll find:

  $db->Execute("UPDATE " . TABLE_ORDERS . " SET
                orders_status = '" . $new_status . "'
                WHERE orders_id = '" . (int)$oID . "'");
} 

Change that to:

  $db->Execute("UPDATE " . TABLE_ORDERS . " SET
                orders_status = '" . $new_status . "', last_modified = now()
                WHERE orders_id = '" . (int)$oID . "'");
} 

And you are all set. This must have been altered in an update release somewhere because it was working in previous versions I had.