Sales report 2.0

Hi,


Sorry to bother you.

I have installed and can see 'sales report' in reports, however when i click on it, it gives me a HTTP 404 not found.


Any help would be greatly appreciated.



Thanks,


N.Hudda

Check where you uploaded the files. Like it says in the readme, everything will work without any configuration, as long as you upload to the proper directory.

Make sure you did not nest the admin folders. So, if your admin is still in a folder called "admin," make sure there's not another folder named "admin" under it:

e.g. "[zen catalog]/admin/admin."

Hi everyone!

After installing the module, I'm redirected to the admin login when I'm trying to access the sales report.
After this, all the admin is blocked: login page for every request made. the only way to get out of this is to delete the ZenAdminID cookie.
The weird thing is the mod works from my home computer (Apple Mac mini, OSX 10.4) but doesn't from the office ( Mac G5, same OSX version)

Any idea?

The SR does absolutely nothing with security permissions; it uses the same standard heading info as all other files in the Admin. Are you using any contribs that affect admin security?

I run zencart 1.3.7
I did the little changes suggested in the thread (the php missing after teh questionmark and remove the php from the ///// js)

installed MODS

1) SEO URLs 3.0 beta (set not to rewrite SSL urls, so it should not affect my admin URLs and redirect. I deactivated it, and the problem is still here. I even tried to change the link to SSL when sales reports is called from teh menu: nothing)
2) Google analytics
2) edit orders
3 ) Easy populate 2.75
4) impoved who's online
5) backup MySQL
6) recover carts
7) pdf order center
8) image handler
9) Checkout without account
10) TY package tracker

One more thing: my zencart is in a subdirectory of an oscomerce:

www.thefrenchybee.com runs on oscomerce
, and its bulk orders branch runs on zencart (www.thefrenchybee.com/bulk)

Thanks for your help!

Does the Sales Report appear properly in the "reports" dropdown? If you mouse over the link in the menu, the URL should appear in the lower left of your browser. Does it have a valid link? Nothing like "STATS_SALES_REPORT" in all caps, right?

Do you see the same behavior if you substitute another admin page for the Sales Report (e.g. orders page)?

Is there any crossover--shared admin, products, etc--between your OSC and Zen Cart stores?

Quote:

---

Originally Posted by BlindSide

Does the Sales Report appear properly in the "reports" dropdown? If you mouse over the link in the menu, the URL should appear in the lower left of your browser. Does it have a valid link? Nothing like "STATS_SALES_REPORT" in all caps, right?

---

See attached screenshot, everything looks fine

Quote:

---

Originally Posted by BlindSide

Do you see the same behavior if you substitute another admin page for the Sales Report (e.g. orders page)?

---

all other admin pages work fine UNTIL I select the Sales report option, which blocks the entire admin by asking for a login on every page request. If i delete the zenadmin cookie, I can access the backend again

Quote:

---

Originally Posted by BlindSide

Is there any crossover--shared admin, products, etc--between your OSC and Zen Cart stores?

---

The databases are completely separate. Nothing is shared: no file, no table.

I'm clueless.

Thanks for your input!

Ok, a few things to consider...

When I use my admin, the zenAdminID cookie is not attached to the link for any of the pages, even for the first click after logging in. Is zenAdminID attached to all the links in the nav menu, or just the SR?

That URL is a secure link, and the address root (secure19.prohosting.com) leads me to believe you use a shared SSL certificate. As above, none of the admin links use SSL by default, so there's something else to look at. Did you do anything fancy with the SSL settings in the admin, like set it to use SSL for every page request? Anything special settings for that shared cert?

I was playing with the SSL when I took my screenshot, wondering if it could have an effect but it doesn't. I removed the SSL option from the extra box file and the problem is still present. (my oscom has some SSL calls for pages displaying sensitive info, but Zencart doesn't run this way)

And yes, I have a session ID attached to every link when I navigate in admin and it has always been working like this with my ZC. In my Oscom, that's right, there is no session attached to the URL.

Regarding SSL, yes I do use a shared one.
my sessions setting are as follows:

Session Directory none, not filebased
Cookie Domain True
Force Cookie Use False
Check SSL Session ID True
Check User Agent False
Check IP Address False
Prevent Spider Sessions True
Recreate Session True
IP to Host Conversion Status true

I tried to change the check SSL session ID to false, nothing changed: I still have the session ID in my URL, and SR still doesn't work.

I'm also suspecting a session pb. How can we get rid of this session ID in the url?

I just checked from a PC from the office, and I don;t have any sessions ID attached to my URLs, and it works fine.

What can change sessions settings at the computer level????? Even my home Mac works fine...

Quote:

---

Originally Posted by 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

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.

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?

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

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

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

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

This would pull out tax-exempt numbers, too

HTH

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!

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.

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

Thanks
P

Hi,

Firstly thank you for this and the info that others have given to fix the little bugs - it is now installed! But .....

I have the latest Zen Cart - clean install, and the report page shows fine. I have installed in the root, so admin is a dir under root and not under catalog. At the mo it is on my WinXPPro with PHP Version 5.2.3

But when I select say the following, which I figure are the widest options:

1. Gather & Filter Data
Preset Date Range - This Month
Search date of... - Order Purchase
and leave the other 3 set to "doesn't matter

Then leave the rest and click "Show Me The Money" it does not load a page at all - I have even tried the setting to Open in New Window. There is nothing happening! - No error message - no "Processing, please wait" (got that from the view source)

I have made sure that I do have sales and have checked to make sure that all calls to js files are correct by checking them against the Add Product page in admin through a view source - they are the same in each file. Also made sure that the sales_report.js.php, is in it's place in the admin/includes/javascript folder

I have made the changes as outlined in the "Read Me" as well as the changes on how to get the date to UK and adding in the php by the <? lines to get the report to show. (lines lines 693 and 1029)

Have tested in FF where nothing hapens and IE - in IE where nothing happens but it gives js errors in the report page -

line 26
Char 1
Syntax Error

line 665
Char 9
Object Expected

line 874
Char 1
Object Expected

line 967
Char 1
Object Expected

Would appreciate any advise and guidence to be able to get this working

hmm, this is now working - not too sure what I did except when I put it on a producation server, it worked - just wouldn't on my own pc.

Great mod!

Question... Think maybe a bug?

I find that when it grabs the lined items and shows the sales tax collected, that it doesn't depict the correct tax and total of the order.

But, it does show in the totals line, the correct tax. Any ideas why?

The Tax Collected was $4.48 and it rounded it down to $4.00 in the order line.

Thanks!

I am also getting this problem since a site reinstall but I can't work out where the error is.

On a report of the month everything still shows OK up until the date of the reinstall, but immediately afterwards I see the rounded down tax problem described by bhunted above.

On a report only of days since the reinstall, the tax is not shown at all, even though the orders themselves are still fine with tax added correctly.

I will try to get to the bottom of this this week and will of course post if I manage it, but mean time any ideas would be appreciated.

Just found a clue. At the point of change (unfortunately I don't know if it was at this point that I switched to 1.3.7 or whether I had done that before), I have found a change in the orders_total table.

Any entry in the orders_total table used to be 4 rows per order_id:
"Sub-Total".
Shipping Method description
"(Incl VAT)"
"Total"

The "(Incl VAT)" entry for each order no longer appears against any of my orders.

I notice in the sales_report class code the following:

####################___

// future code - currently being pulled from orders_total table for better accuracy
// calculate tax values
//$this->timeframe[$id]['total']['tax'] += zen_calculate_tax($onetime_charges, $tax);
//$this->timeframe[$id]['total']['tax'] += zen_calculate_tax(($final_price * $quantity), $tax);

####################____

Uncommenting these lines does give me a tax figure in the total rows of the report, but it is still being rounded down.

I am fiddling beyond my capability here, and hope this means something to someone fore familiar with sales_report and ZC tax.

I wonder if the loss of my orders_total row is a change in 1.3.7 (I can't remembered when I upgraded unfortunately) or a setting somewhere else in my new shop install.

Help appreciated.

Thanks a lot!
It works perfect on zencart v.1.3.7!!

Hi.... just an FYI.... I only ever had ZC 1.3.7 and SR 2.0
So I don't think it's anything you did... maybe just a bug or maybe it only works properly in 1.3.6...
Dunno... hopefully the author will give us some insight soon...

Quote:

---

Originally Posted by hqarrse

Just found a clue. At the point of change (unfortunately I don't know if it was at this point that I switched to 1.3.7 or whether I had done that before), I have found a change in the orders_total table.

Any entry in the orders_total table used to be 4 rows per order_id:
"Sub-Total".
Shipping Method description
"(Incl VAT)"
"Total"

The "(Incl VAT)" entry for each order no longer appears against any of my orders.

I notice in the sales_report class code the following:

####################___

// future code - currently being pulled from orders_total table for better accuracy
// calculate tax values
//$this->timeframe[$id]['total']['tax'] += zen_calculate_tax($onetime_charges, $tax);
//$this->timeframe[$id]['total']['tax'] += zen_calculate_tax(($final_price * $quantity), $tax);

####################____

Uncommenting these lines does give me a tax figure in the total rows of the report, but it is still being rounded down.

I am fiddling beyond my capability here, and hope this means something to someone fore familiar with sales_report and ZC tax.

I wonder if the loss of my orders_total row is a change in 1.3.7 (I can't remembered when I upgraded unfortunately) or a setting somewhere else in my new shop install.

Help appreciated.

---

Hi,

I run Zencart 1.3.7.1.

I just installed Sales Report 2.0 and all the files seem to be in the correct places.

When I select "Sales report" from the Reports menu in Admin I get the following error:

Parse error: syntax error, unexpected $end in C:\PHPSites\ZenCart\admin\stats_sales_report.php on line 1187

By the look of the path in the error message it seems that the right file is being found. So, what could be wrong ?

Thanks,
Murray

Quote:

---

Originally Posted by murrah

Hi,

When I select "Sales report" from the Reports menu in Admin I get the following error:

Parse error: syntax error, unexpected $end in C:\PHPSites\ZenCart\admin\stats_sales_report.php on line 1187

---

OK. Here is the solution:

The script \admin\stats_sales_report.php has 2 places where it uses short_tags ie <? instead of <?php. If your php config has short_tags off (as mine did) the script will fall over (as mine did). So, change any <? to <?php. In the version of Sales Report 2.0 I am using, these occur on lines 693 and 1029. It is better NOT to use short_tags for just this reason - you never know what the config on the target server will be.

There is another problem you need to fix:
File \admin\includes\javascript\sales_report.js.php has javascript errors caused by numerous <?php// and //?> instances. Do a search and replace to change both these to just // ie these are just javascript comments, you dont need the <?php or ?> at all.

Hope that helps others.

Now, let me test the module itself !

Cheers,
Murray

Quote:

---

Originally Posted by murrah

Hi,

When I select "Sales report" from the Reports menu in Admin I get the following error:

Parse error: syntax error, unexpected $end in C:\PHPSites\ZenCart\admin\stats_sales_report.php on line 1187

---

OK. Here is the solution:

The script \admin\stats_sales_report.php has 2 places where it uses short_tags ie <? instead of <?php. If your php config has short_tags off (as mine did) the script will fall over (as mine did). So, change any <? to <?php. In the version of Sales Report 2.0 I am using, these occur on lines 693 and 1029. It is better NOT to use short_tags for just this reason - you never know what the config on the target server will be.

There is another problem you need to fix:
File \admin\includes\javascript\sales_report.js.php has javascript errors caused by numerous <?php// and //?> instances. Do a search and replace to change both these to just // ie these are just javascript comments, you dont need the <?php or ?> at all.

Hope that helps others.

Now, let me test the module itself !

Cheers,
Murray

I may have found a bug in S/R 2.0 b104 (that's what I downloaded, but in the file, it says b103)... Also, something to watch out for if you have the "Better Together" contrib installed.

If you run a report using date ranges (ie; 1/1/07 to 10/23/07), AND you select a Manufacturer filter, the values for Num Orders, Num Products, Shipping $, Discounts $, Discounts Qty are all totaled up for the entire year, for all orders, NOT just for the manufacturer.

Anyone know where/how to fix this?


Regarding the B/T issue, the discounts don't include this Order Total module, so to fix it, you need to change this line:

PHP Code:

---

          elseif ($class == "ot_coupon" || $class == "ot_group_pricing") { 


---

to this:

PHP Code:

---

          elseif ($class == "ot_coupon" || $class == "ot_group_pricing" || $class == "ot_better_together") { 


---

If you have OTHER discounts, you need to add them the same way.

Thanks.

Hi,

I seem to have fixed the problem where the tax on the order lines was rounding to 00 instead of showing the cents rounded to 2 places. This is the case where the user selects the +Product Line Items option.

See my post at

http://www.zen-cart.com/forum/showpo...73&postcount=3

for details.

I am still working on the other rounding issues (something to do with the way the tax calculations are done on the report). Will let you know what I work out.

Cheers,
Murray

Quote:

---

Originally Posted by murrah

I seem to have fixed the problem where the tax on the order lines was rounding to 00 ...

---

Thanks Murray, your a legend. That fixed the Tax on mine that was also rounding to 0.

What are the other rounding problems you are talking about when using Product Line Items option? I've noticed that when there is an item with quantity greater than 1, the calculation for "Total" is incorrect due to the fact that the "Base Price" is not rounded before multiplying by the quantity. I just added PHP round function to the calculation for 'total' array value.

I also changed 'base_price' array value to use $final_price instead of $products->fields['products_price']. This fixes my problem with products that are priced by attribute.

See code below for changes.

admin/includes/classes/sales_report.php - lines 330 - 337

Code:

---

          $this_product = array('id' => $pID,
                                'name' => $products->fields['products_name'],
                                'model' => $model,
                                'base_price' => $final_price,
                                'quantity' => $quantity,
                                'tax' => $product_tax,
                                'onetime_charges' => $onetime_charges,
                                'total' => ( (round($final_price,2) * $quantity) + $onetime_charges) );

---

I'm still testing Sales Reports. I've got to make some changes to the calculations for Order Line Items as well. My shipping value on my site includes Tax, so for Sales Reports I will need to remove tax for it's calculations. This will only affect you if you have setup your store like mine.

Also watch the admin console timing out. Sales Reports makes no indication that it has happened, it just stops returning new data, just keeps returning the same old stale data.

Hi Craig,

Thanks for that.

>What are the other rounding problems you are talking about when using Product Line Items option?

Well, I noticed that the tax didnt add up but havent had a chance to look at it yet. I will be back onto it tomorrow so your tips will be very helpful.

Once we sort these out it would be good to make an update for the Sales Reports contribution, I reckon.

Thanks again,
Murray

I'm happy with it now.

I just put in a calculation on the shipping to remove tax from the amount. I added a check to see if there is tax, if not, then it does not remove tax. If that makes sense.

Some of my modifications are specific to me, but not those rounding problems and your fix for 00 tax.

It's not perfect, but certainly a very handy module. I can appreciate the work that's gone into it so far.

Hi,

Quote:

---

Originally Posted by murrah

I am still working on the other rounding issues (something to do with the way the tax calculations are done on the report). Will let you know what I work out.

---

I noticed rounding problems with this module about 8 months ago so rewrote the module slightly to introduce a "check" column which could be used to highlight any errors.

I think I also added automatic support for UK dates etc.

I'll see if I can get a bit of time this week to package up my changes and release them as a new version of the module. I've been meaning to do so for a very long time now but no-one else had mentioned the rounding errors so I thought maybe only my client was having any real problems with this module. A quick search today found your recent comments and it seems silly for me not to save you a bit of work by releasing the updated code. :)

As I said, hopefully I get some time this week to do so... I'll post again here soon if I do!

All the best...

Conor
Ceon

Hi,

Quote:

---

Originally Posted by conor

A quick search today found your recent comments and it seems silly for me not to save you a bit of work by releasing the updated code. :)

As I said, hopefully I get some time this week to do so... I'll post again here soon if I do!
Ceon

---

That would be great if you can. Apart from the tax rounding to 00 issue, I have some mods I needed to make to get it to work at all in the first place. Can we colloborate on making a new version or should we do it sequentially?

See: http://www.zen-cart.com/forum/showpo...&postcount=230

Thanks again,
Murray

Hi Murray,

How are you?

Quote:

---

Originally Posted by murrah

Can we colloborate on making a new version or should we do it sequentially?

See: http://www.zen-cart.com/forum/showpo...&postcount=230

---

The updates I've made include those parsing problems you've listed in the above thread.. I too have short tags disabled and had to fix those errors also. :)

I'll see if I can get a new version up tomorrow. :smile:

All the best...

Conor
Ceon

Hi,

Argh, you got me thinking so I went ahead and did this now...! :)

Rather than upload this directly to the downloads area I thought I'd upload a version here so that people can test it as it has been quite a long time since I made the modifications to the module and I am not totally confident that all the necessary work is complete. Also, I think it's probably best to try and get on contact with the original author to ask his permission to upload to the main downloads area, so once some of you have tested this and we've fixed any bugs one of us can do that! :)

I feel that this version works much better than 2.0 1.0.4.

I've given the version as "2.2.0RC1" as I feel this versioning convention is much more useful and easier to read...

I.e. this is release candidate 1 of version 2.2.0, the "point 2" indicating that new features have been added to the module and that this version is "stable". After bringing this to a final release of 2.2.0, subsequent bug fix releases would be 2.2.1, 2.2.2 etc.

Changes in 2.2.0RC1

[ADDED] Support for UK date formats added. Module now supports DD/MM/YYYY format as well as MM/DD/YYYY.
[UPDATED] Tax column renamed to "Goods Tax". The tax for this column is now calculated directly from the product information for the order, in the same manner as the order class calculates the tax.
[ADDED] A second tax column, "Order Recorded Tax" has been added so that a comparison can be made with the calculated tax so that any rounding errors can be identified.
[ADDED] Validation Column added for Order Total in " + Order Line Items" view. If enabled, an extra column is displayed which highlights any orders for which the tax recorded doesn't match that calculated based on the products' prices and tax rates. This should aid those who are finding that their official order totals don't quite match up with the order totals reported by the Sales Report module (and therefore avoid annoying their accountants!). This is a rare problem but seems to appear from time to time with very slight (0.01) rounding errors.
[UPDATED] If no order information exists for a particular day in a report, no row is generated for that day. (Previously an empty row was displayed which is of little use to anyone!).
[BUGFIX] Parsing problems with short tags disabled fixed.
[BUGFIX] Currencies class wasn't being loaded at an appropriate point in the main script.
[ADDED] Order ID in " + Order Line Items" view now links directly to the order edit functionality of the admin for the order. Allows quick and easy look ups of the detailed order information.
[ADDED] Support for That Software Guy's "Better Together" order total module added.
[ADDED] Support for Ceon's "Cashback" order total module added.


Please test this and let me know what you think! :)

To upgrade, just copy the files in the archive over your existing files... that's it! :)



All the best...

Conor
Ceon


.

Hi,

I just downloaded and installed this RC1 version. The order total works fine for the B/T contrib, however, an unrelated problem, but one that's been there all along still exists.

If you select a Manufacturer to report on, the totals are not correct for the data (manufacturer) selected. They are for ALL sales for the time span selected.

From what I can check in my data, Num Products & Shipping are wrong.

I can't figure out how to fix this yet. Anyone have a suggestion where it is?

Hi,

Quote:

---

Originally Posted by rcrosier

If you select a Manufacturer to report on, the totals are not correct for the data (manufacturer) selected. They are for ALL sales for the time span selected.

---

Sorry but filtering by manufacturer works perfectly here. Are you sure you are reading/doing things right?

If so, please list exactly what settings you are using and what is happening (or not as it would seem! ;) ).

All the best...

Conor

Quote:

---

Originally Posted by conor

Hi,



Sorry but filtering by manufacturer works perfectly here. Are you sure you are reading/doing things right?

If so, please list exactly what settings you are using and what is happening (or not as it would seem! ;) ).

All the best...

Conor

---

Hi Conor.

Specifically, on my copy it does not work if I select either:
"This Month", ONE vendor
"Date Range" (ie; 10/29/07-10/29/07), ONE vendor.

Also, try a Vendor where there are NO sales, and you'll get totals at the top that are for ALL vendors for that period.

Compare the results to ALL vendors for same period, and some of the total fields are not right. They still contain the totals of ALL vendors for that period.

On the report of Vendor with NO sales, for example, The specific fields that are off are:
Num Orders
Shipping $
Discounts $
Discounts Qty
Total $

I've attached a few screenshots for you to view. Sorry they're small, but the limitations on the forum are such that I had to shrink them.

Hi folks. I installed this mod a while ago and it seems to work pretty well for us but we only just started trying to use it in earnest. I see from this thread things are in the works which I take as very promising and I'm hoping you can perhaps enlighten me. Do you have any feeling for how 'close' the new release candidate is to being final and stable?

See the guy that does our accounts would be very happy if when he outputs sales information to csv files the days that do not have any sales did not generate errors. An example is provided at the end of this post. Works like a charm for days with sales but unfortunately for us we do get those no sales days.

I think 2.2.rc1 with it's no output for empty lines correction should fix that - am I right?

Thank you,

Alan

<br />,,,,,,,

<b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/talis4/public_html/brainradio/talismanshop/admin/includes/classes/sales_report.php</b> on line <b>908</b><br />,,,,,,,

<br />,,,,,,,

<b>Warning</b>: array_multisort() [<a href='function.array-multisort'>function.array-multisort</a>]: Argument #1 is expected to be an array or a sort flag in <b>/home/talis4/public_html/brainradio/talismanshop/admin/includes/classes/sales_report.php</b> on line <b>915</b><br />,,,,,,,

<br />,,,,,,,

<b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/talis4/public_html/brainradio/talismanshop/admin/includes/classes/sales_report.php</b> on line <b>930</b><br />,,,,,,,

Hi Conor,
sorry for the delay in replying - I have been on other jobs. Thanks very much for creating this release candidate - it worked perfectly for me and seems to fix all the issues I was having.

Quote:

---

Originally Posted by conor

Also, I think it's probably best to try and get on contact with the original author to ask his permission to upload to the main downloads area, so once some of you have tested this and we've fixed any bugs one of us can do that! :)

---

I sent message to the original author (Blindside) a few weeks ago asking if there was anything in the pipeline and did not receive a reply. So, I reckon you could safely upload your release candidate as the latest version. What do you think?

Murray

I am having problems with the sales report module, it always shows all the orders from the first order the store had, is there a way to not display this, i have tried to check last month, and this month, and i always get an error message if i try to use custom dates, it says that one of the dates are not valid.

Can anyone help,

I would realy like to use this module in my accounting

Morten

Quote:

---

Originally Posted by mgrefsrud

I am having problems with the sales report module, it always shows all the orders from the first order the store had, is there a way to not display this, i have tried to check last month, and this month, and i always get an error message if i try to use custom dates, it says that one of the dates are not valid.

Can anyone help,

I would realy like to use this module in my accounting

Morten

---

I have the same problem. I always get an error message when I try to use custom dates. No matter what dates I use, same error. I do not get any date error when using the standard presets date ranges.

When I use preset dates, it just shows one line, Oct 15 for some reason, with 3 orders. That's it. Nothing after that. (For you sarcastic readers, yes, I do have orders after that! :D )

I am using Zen 1.3.7 and also have Super Orders module installed.

Another quick comment on the install notes for this mod. They include the following lines:

INSTALL
===========
...

3. Copy the entire "admin" folder to the root of your shop.

Does anyone besides me think that line is an invitation to newbies to replace their entire admin folder with this new admin folder (with only a couple of files in it)?!?!?!

I think it should more properly read as "copy the contents of the admin folder into their respective locations within your current zencart admin folder"..or something like that.

When I run a report for "This month" (which should be Nov 1-27 as of today), on the timeframe column for the order line listing, it shows "CST0OctE_Mon0thP0AM2007_MonAM2007"...so I assume the date problem is in their somewhere. The 3 orders shown are from Oct 15 only.

Quote:

---

Originally Posted by murrah

So, I reckon you could safely upload your release candidate as the latest version. What do you think?

---

It works fine for me, if that is any help.
It would be great to have it on the contributions page (http://www.zen-cart.com/index.php?ma...products_id=83)
in order to make it easier for folks to find (it took me a while of fishing around on the forums...).

in any case, thumbs up and thank you.

There is also this state/zone filter that i found elsewhere that might be nice to incorporate:
ZenCart Sales Report State Filter

http://damonparker.org/blog/2006/06/...-state-filter/

Hi,

I've just upgraded to 2.0 from the old version (1.4) and I like a lot of the upgrades. Howver, it seems as if I've lost the ability to show a breakdown of attributes. I used to be able to list products sold by day and underneath each product it would show each of the attributes and how many of each sold. Eg:

Some T-Shirt
- Small 3
- Medium 2
- Large 1
TOTAL 6

Are there any plans to re-add this functionality to Sales Report 2.0? Or is it there and I'm just missing it?

Thanks,
-afx

P.S. I'm using Conor's 2.2.0RC1

Quote:

---

Originally Posted by dni

It works fine for me, if that is any help.
It would be great to have it on the contributions page (http://www.zen-cart.com/index.php?ma...products_id=83)
in order to make it easier for folks to find (it took me a while of fishing around on the forums...).

in any case, thumbs up and thank you.

---

Hi dni, what version of zencart are you using it with (mine is 1.3.7)?

Do you have any of these mods installed: Superorders, Customer Loyalty Rewards? (I also have other mods but I think these are the two that could be having some adverse effect on this mod)

I will try to compare my setup with yours this way.

Thanks,

Thomas

Nevermind! I figured it out.

I am running a multilanguage website and admin. When I am using the Sales Report mod running under my Chinese language admin, it does not work right. But when I use it under English language admin, everything is ok.

Would be great if there could be multi-select boxes for lots of the filters such as the assigned status filter

Thanks for this very helpful tool :smile:

Has anyone figured out the problem with the totals when you run a report for ONE manufacturer?

On my system, if I run a report for one manufacturer, for a custom date range OR a preset, some of the totals at the top include ALL records for that range, NOT just the ones for that manufacturer. Very difficult to get totals for just one manufacturer.

Does anyone else have this problem?

I looked at the code briefly, but being very green at PHP, I could not find where the problem is.

Hi,

I've just installed Sales Report 2.2rc1 and i like it a lot. It does 80% of what i need. However i think it could be more complete adding a couple of functions such:

Report Sales by Compartments/Categories:
I sell clothing, so i have categories for Pants, Tees, Sweters, Shoes, Accessories and more. I would like to know wich of theese categories is the most sold. I don't care about sub-categories just the main categories.

Diagrams:
Diagrams are cool and with PHP/GD library are easy to create on the fly. This should be a great addition to Sale Report for a quick and more clear view of any report.

What do u guys think about it?

Where are people finding this new version? I've looked all over... :lamo:

Quote:

---

Originally Posted by bhunted

Where are people finding this new version? I've looked all over... :lamo:

---

Here it is
http://www.zen-cart.com/forum/showpo...&postcount=239

Thanks! :blink:

I just noticed that Cash On Delivery (cod) is not added in any calculations even in gran total.

Great Mod,

Have it running on my Site using ver. 1.3.8.

Again Great Mod

Hey guys!

Saw the fixes you made. Love it! I've got them in the main module repository now. I'm going to try and push out a new version asap.

Also, for anyone wondering where the hell I've been.

This is great. I had an older version and upgraded. seems to work fine on 1.3.7, however I would do a back flip if this could show an attribute breakdown as well as products. I have sizes for clothes. It would be AWESOME to be able to se in a given timeframe the amount of every size that I sold. I have read some references to attributes in the mod but I have not seen them am I missing somthing?

thanks!!!

That request comes up every few months, but the reason stays the same: you cannot display attributes in a line item basis on a report with multiple products. Here's a little background:

http://www.zen-cart.com/forum/showpo...9&postcount=89

When I install a new product, I don't have the Profit Margin Calculator.
I have just installed Zen Cart 1.3.7
Am I missing something.

Yes I understand. thanks, however there must be away to account for individual sizes, colors etc. attributes. I love ZenCart but its getting impossible to account for dailey sales due to the lack of reporting at the attribute level. Does anyone have any suggestions?

I would really appreciate any advice.

Quote:

---

Originally Posted by BlindSide

That request comes up every few months, but the reason stays the same: you cannot display attributes in a line item basis on a report with multiple products. Here's a little background:

http://www.zen-cart.com/forum/showpo...9&postcount=89

---

Quote:

---

Originally Posted by sky1

When I install a new product, I don't have the Profit Margin Calculator.
I have just installed Zen Cart 1.3.7
Am I missing something.

---

That's not part of the Sales Report, and I'm pretty sure that's not part of the core either. Is this a 3rd party module you installed? Regardless, this isn't the thread you need.

Quote:

---

Originally Posted by wapnoj

Yes I understand. thanks, however there must be away to account for individual sizes, colors etc. attributes. I love ZenCart but its getting impossible to account for dailey sales due to the lack of reporting at the attribute level. Does anyone have any suggestions?

I would really appreciate any advice.

---

It's been a known problem for some time. Most Dev team effort has focused on the catalog side, and the reporting etc has remained woefully short in the meantime.

However there is light at the end of the tunnel starting in 1.4, which includes inventory tracking at the attribute level. You can read about it in the project roadmap.

Until then you're just going to have to sit tight; I have no plans to write code that will be outdated in the next 12 months or less.

Thanks...knowing that there is a light at the end of the tunnel makes all the difference for me. The roadmap looks great. Can't wait......but I will. HAHA

Quote:

---

Originally Posted by BlindSide

It's been a known problem for some time. Most Dev team effort has focused on the catalog side, and the reporting etc has remained woefully short in the meantime.

However there is light at the end of the tunnel starting in 1.4, which includes inventory tracking at the attribute level. You can read about it in the project roadmap.

Until then you're just going to have to sit tight; I have no plans to write code that will be outdated in the next 12 months or less.

---

Alright so I've had a request to do something, I was hoping the sales report modules was going to cover all the monthly financial analysis needs and it actually might but I don't think so. Being hideously out of date with programming doing this myself could be 'interesting' even though it really doesn't strike me as the sort of thing that should be that tough - time consuming maybe. So I'm putting out the feelers now. I wants a report that can produce the following for a given calendar month:

OrderNo
Customer
Date
From Email Address
Address Line 1
Address Line 2/District
Town/City
State/Province/Region/County/Territory/Prefecture/Republic
Postcode
Country
ProductModel
ProductName
ProductPrice
SellPrice
Quantity
Total Earnings

Ideally outputting to csv file when done.

So folks, what do you think? Can this be done in sales report at present? If not would it be easier to add it to the functionality offered or to create something new. I just need to be able to gather this information and would like some pointers from those that might just know better where would be a good place to start. Should I even be trying to do this through the zen cart interface/reports?

I have just installed "Products Profit/Margin Calculator + Report" witch has given me extra features such as.

Profit Margin Calculatorhttp://telescopeshop.co.za/shop/admi...ixel_trans.gifProducts Cost:http://telescopeshop.co.za/shop/admi...ixel_trans.gif Markup Percent :http://telescopeshop.co.za/shop/admi...ixel_trans.gif %Gross Margin $:http://telescopeshop.co.za/shop/admi...ixel_trans.gif Gross Margin %:http://telescopeshop.co.za/shop/admi...ixel_trans.gif %

talisman-studios - Start with this mod, then add the extra fields you want.
http://www.zen-cart.com/index.php?ma...roducts_id=170

sky1 - Just what does any of that have to do with the Sales Report? Please limit your posts to Sales Report-related information

I just wanted to post a big THANK YOU to Frank for this incredible mod. With Kobra's help, I migrated this month from the stone age of osC and this was one of the tools that he recommended for install.

I have been playing with it today and can't believe the detail and flexibility that it provides me. I can finally output some decent data from the 2 years of history I had stored in my old db.

THANK YOU THANK YOU THANK YOU!! (where is the donate button?)

I love this mod and I have never had any problems with it.

My only request is that I really need to have both Manufacturers AND Order ID be available on the same report. It seems I can get Order ID included when I display by Order Line Item, and I can get Manufacturer when I display by Product Line Totals. But I can't get them both to display on the same report. Ideally, I'd like the Order ID to display when I go by Product Line Items.

Am I missing something? Maybe there's an option I haven't seen yet?

If not, I would be happy to pay for this modification, if possible.

Quote:

---

Originally Posted by gezuvor

I just wanted to post a big THANK YOU to Frank for this incredible mod. With Kobra's help, I migrated this month from the stone age of osC and this was one of the tools that he recommended for install.

I have been playing with it today and can't believe the detail and flexibility that it provides me. I can finally output some decent data from the 2 years of history I had stored in my old db.

THANK YOU THANK YOU THANK YOU!! (where is the donate button?)

---

Guess I should add one. If you want, you may send via PayPal to fkoehl {at} gmail {dot} com.

Quote:

---

Originally Posted by lyricwings

I love this mod and I have never had any problems with it.

My only request is that I really need to have both Manufacturers AND Order ID be available on the same report. It seems I can get Order ID included when I display by Order Line Item, and I can get Manufacturer when I display by Product Line Totals. But I can't get them both to display on the same report. Ideally, I'd like the Order ID to display when I go by Product Line Items.

Am I missing something? Maybe there's an option I haven't seen yet?

If not, I would be happy to pay for this modification, if possible.

---

Logically this doesn't make sense. How can you display just one manufacturer for an order when you may have multiple products, each with a potentially different manufacturer?

---Quote (Originally by lyricwings)---
I love this mod and I have never had any problems with it.

My only request is that I really need to have both Manufacturers AND Order ID be available on the same report. It seems I can get Order ID included when I display by Order Line Item, and I can get Manufacturer when I display by Product Line Totals. But I can't get them both to display on the same report. Ideally, I'd like the Order ID to display when I go by Product Line Items.

Am I missing something? Maybe there's an option I haven't seen yet?

If not, I would be happy to pay for this modification, if possible.

---End Quote---
Logically this doesn't make sense. How can you display just *one* manufacturer for an order when you may have *multiple products*, each with a potentially *different* manufacturer?
***************
Thanks for your response, Blindside.

What you are saying is why I was suggesting that it be added to the option for Product Line -- where just one Product appears per line.

So, the Product Line option would show the Order ID, in addition to giving Product ID, Product Name, Manufacturer, etc.

If there were multiple products in an order, the same Product ID would appear in each product listed in the "Product Line" view.

The situation is that I want to use Sales Report to check against the confirmations that I receive from my manufacturers, when they confirm that they have shipped an item. They simply submit the Order ID to us, so if there was a way for the Order ID to be in the Sales Report, then checking the two would be much easier. Right now we're trying to just try to figure it out by dates and such, which don't always line up if the Manufacturers don't know the date they received the order, or if multiple orders for them came on a specific date.

Does that clarify my question?

Thanks --

Yeah that makes more sense. You completely lost me by describing your need as "both Manufacturers AND Order ID be available on the same report", as the order ID only appears on the per-order view.

Phew, glad I am making sense.

So - is there any way to do that, that I might be missing?

Like I said, I'd be willing to pay for this customization.

Basically you'd be expanding the product output view to a unique report line for each order|product combination. So yes it's possible, but would require hacking up the report quite a bit, because the data outputted is ingrained in the class that drives the report.

Depending on your search and output needs, it might be better to make this a separate report, designed specifically to select orders and manufacturers the way you want, and output the data in the format you want.

Quote:

---

Originally Posted by BlindSide

Hey guys!

Saw the fixes you made. Love it! I've got them in the main module repository now. I'm going to try and push out a new version asap.

Also, for anyone wondering where the hell I've been.

---

Hey BlindSide ,
when the new version will be available ?
thanks

I just picked up a new freelance job, and those obviously trump the open source stuff. Sorry. :cry: I'll post when I have something, promise.

Quote:

---

Originally Posted by rcrosier

Has anyone figured out the problem with the totals when you run a report for ONE manufacturer?

On my system, if I run a report for one manufacturer, for a custom date range OR a preset, some of the totals at the top include ALL records for that range, NOT just the ones for that manufacturer. Very difficult to get totals for just one manufacturer.

Does anyone else have this problem?

I looked at the code briefly, but being very green at PHP, I could not find where the problem is.

---

I have tracked down the problem. It's in the sales report class in the build_li_totals function.

This function is very careful only to extract product line information for the products from those manufacturers that you are filtering on. Unfortunately it then goes on to extract order level information, such as discount coupons and gift certs used and shipping costs. Since these are not recorded as being associated with any particular product, neither is there a manufacturer to filter them against and they all make it into the totals.

It's very difficult to see a solution to this. Yes, there's the obvious one of trailing back to the database to examine the products in each order and apportion the order level transactions against those to which they could apply, with appropriate error handling when the information needed is no longer in the database, but this would be horrendously complicated to do.

I have a partial fix, which simply suppresses the order level transactions when the manufacturers filter is in use. Unfortunately I don't have good data to test this with, but have asked a store owner who does to take it for a test drive. If they agree, I'll post the outcome and if appropriate the code change.

Hi i get the following error. can someone please help.

thanks.

Line: 289
Char: 5
Error: 'options' is null or not an object
Code: 0

the code at this line is the following

////////////
// Function : build_select
// Arguments : string "view", element "sort_box"
// Description : performs the leg work of populating the line item sort boxes
// with options according to the search type selected
///////////////
function build_select(view, sort_box) {
sort_box.options.length = 0; <<-- this is line 289
var sort_title = document.getElementById('span_sort_title');

if (view == 'order') {
// define text above first sort box
sort_title.innerHTML = 'Sort orders by...';

First off, great contribution. This makes accounting so much easier for Zen Cart owners!

I'm currently running the latest version of Sales Report on Zen Cart 1.3.8a and I think I'm getting a similar error to jynxy.

When loading up the stats_sales_report.php file (via my Zen Cart admin) I receive the following error (displayed by Firefox):

Quote:

---

select has no properties
auto_select_input("", "manufacturer", "select")
populate_search(undefined)
onload(load )
for(var i = 0; i < select.options.length; i++) {

---

When I click the 'Show me the money!' button the report is generated successfully, but I still receive the same error message (as quoted above).

This error message is also displayed when I click on the 'Report Defaults' button.

Anyone know how to fix this?

I am not sure if I am missing something here, but is it possible to list each individual order throughout the month. I can get it to list the totals of each order, but not what each order consisted of.

I am wondering if anyone has modified the sales reports to include the Company Name.

If anyone knows what needs to be modified, it would be appreciated.

Also, is it possible to remove any reference to Gift Certificates in the report, as we don't utilize them.

Thanks,

Ken

ive installed this and im getting an error with custom dates etc.

i think this is an error due to the code being set so the date is mm-dd-yyyy where ive changed my site to uk which is dd-mm-yyyy

how can i change this mod so it works with UK style dates??

can someone please help me, i need to edit this modual so that it will work with UK date style instead of US as it is.

Ive edited my site so that dates are in UK style so dd/mm/yyyy not mm/dd/yyyy and this causes errors to appear and incorrect reports. ie 1st may 2007 in uk is 01/05/2007 where that is the 5th Jan in the US and if i want i choose a date range later that 12th of a month i get an error as there are only 12 months in a year not 31.

PLEASE HELP

@kitcorsa

Have you tried changing this line in your admin/includes/languages/english.php file?

Quote:

---

define('DATE_FORMAT_SPIFFYCAL', 'MM/dd/yyyy'); //Use only 'dd', 'MM' and 'yyyy' here in any order

---

an mentioned i have already edited this file as my whole site is in uk dates.

Code:

---

define('DATE_FORMAT_SPIFFYCAL', 'dd/MM/yyyy'); //Use only 'dd', 'MM' and 'yyyy' here in any order

---

as you can see.

the problem is with the modual as its coded to be in mm/dd/yyyy so as soon as it gets a custom date of 30/12/2007 (uk 30th december 2007) it gives and error as there are not 30 months in a year etc.

the modual needs changing not the zencart files.

id plow my way through this modual and try and change it but i thought someone might have already have had this problem or the creator might know how to fix this problem as im sure im not the first UK person to install this mod.

I'm 99% certain this has been fixed by someone.

Have you seached this thread?

Craig

Quote:

---

Originally Posted by CES

I'm 99% certain this has been fixed by someone.

Have you seached this thread?

---

It has. Post 239. Which is why I'm surprised that the change to DATE_FORMAT_SPIFFYCAL didn't work for kitcorsa. I assume he must be using an older version.

i have been rading through this post for 10 days now on and off and hadn't got to the stage you have listed above. the problem is the downloads section has the OLD 2.0 version not the 2.2 version this is why i was getting the problem i belive.

going to install the new version now and test.

installed 2.2 and this sorted the problem. Thanks for posting the number of the post and savimng me anpther week of reading.

..ADMIN..
Please update the file on the downloads section

Hi, I have installed the sales report add on and all seemed to work correctly. However, when I look at the report the total price (without tax) is correct but the actual total is wrong. I am adding 19% sales tax but it seems that the report is adding much more. The invoices are all correct it is only the sales report total that is incorrect and adding a bit more. Can someone please help me with this??

This is my customers invoice upon checkout:


1 ea. Westvleteren 12 33cl, 10.2%ABV €9.50
€9.50
Sub-Total:

€0.00
Store Pickup (Walk In):


Total: €9.50


This is the correct price including 19% tax.

In the admin the invoice looks like this:

Date Purchased: Friday 07 March, 2008
Payment Method: Cash on Delivery
Products Model Tax Price (ex) Price (inc) Total (ex) Total (inc)
1 x Westvleteren 12 33cl, 10.2%ABV 19.00% €7.98 €9.50 €7.98 €9.50
Sub-Total: €9.50
Store Pickup (Walk In): €0.00
Total: €9.50

This is also correct.

The sales report looks like this:

Timeframe Num Orders Num Products Goods Value Shipping Discounts Gift Cert. Sold Gift Cert. Used Total
3-7-2008 1 1 | Diff: 1 €7.98 €0.00 €0.00 | Qty: 0 €0.00 | Qty: 0 €0.00 | Qty: 0 €7.98
Prod ID Product Name Re-sort in DESCENDING order 2 Model No. Re-sort in DESCENDING order1 Base Price Qty. Product Total
180 Westvleteren 12 33cl, 10.2%ABV €7.98 1 €9.98

Why is the product total 9.98??? It should be 9.50!

Cheers,


Jeff

OK, see page 24 for fix (took awhile to get there), great job, it fixed everything! I wonder why this version isn't what would be downloaded in the download page...

Awesome add on, thanks again.

Jeff

Quote:

---

Originally Posted by jcun45

OK, see page 24 for fix (took awhile to get there), great job, it fixed everything! I wonder why this version isn't what would be downloaded in the download page...

Awesome add on, thanks again.

Jeff

---

yeah this is what i menioned above. the download in the download section is an old version.

ADMIN PLEASE UPDATE!

Quote:

---

Originally Posted by Alex Clarke

First off, great contribution. This makes accounting so much easier for Zen Cart owners!

I'm currently running the latest version of Sales Report on Zen Cart 1.3.8a and I think I'm getting a similar error to jynxy.

When loading up the stats_sales_report.php file (via my Zen Cart admin) I receive the following error (displayed by Firefox):



When I click the 'Show me the money!' button the report is generated successfully, but I still receive the same error message (as quoted above).

This error message is also displayed when I click on the 'Report Defaults' button.

Anyone know how to fix this?

---

Just updated to the latest version of this contribution. I too was previously using the old version from the downloads section.

Everything is working fine with the new version, but I still get these errors (as mentioned in my last post). Does anyone else get similar errors?

Hi. I LOVE this contribution! I do have a question that I can not find an answer too:

I have a store in which I have 8 designers and I need to give them a report on the products the sell so I can "pay" them, but how do I get the report onto a .pdf or spreadsheet... I have tried but it looks horrible!

Thanks for your help.

you use the export option of a tab dielimited file and just open that in excell, then im sorry to say but you have to spend some time making it look like you want and adding charts etc.

other than that use the layout in the modular and dispay on screen then download a low res pdf converter like primopdf and then click print, primo pdf, and that will create a pdf of the on screen view.