Sales report 2.0

[wickedklown]

w00t, thanks man, works great..

[wickedklown]

well im looking into your report now.
and im not sure if i found errors, or what

but for some reason, i have a guy that orderd 1 item, at 55.67 total w/ shipping.

for some reason, when i pull up his order with the sales report, its showing 5428.89 with 108 products in his order. whats up with that? im filtering by manufacture, and +product line for display. on last month.
ALSO- along with that- when i display by +Order Line, it shows me all the orders from that timeframe, but its only calculating items from the selected manufacture, correct? and only the goods value?

when i change it to show (dont matter) for the manufacture, it displays correct for his order. and i see no problems.

im also noticing that its calculating shipping costs for some that didnt order those manufacture items. why is that? dont calc the goods value (i assume becuase its not the selected manufacture) but it is calculating its shipping total. and for those orders that do have the selected manufacture its calcuating the goods value and not the shipping.. am i missing somthing?

why is it working like that?

any help would be great

[wickedklown]

sorry to slam this forum over and over. but the questions are just flying right now....

as i dig into the new sales report, i notice that order which have been set to canceled, or refuned, are still showing up in the report as a sale. but we cant account for that money since it was refunded. sometimes we give store credit, but that is set under another status.

but in any event, how would i setup super orders, to not calcuate that order as a sale, since it was refuned. i use the refuned button and return the money to reflect in the total *shows customer still owes whole balance again* then i look at the report and its still being calculated in the total.

so how do i set it up, maybe im running super orders wrong, and its not understanding that it was a cancled order. im sure some of you guys are pros with this, so just fill me in... please..

also, what exactly do that COMPLETED and CANCELD buttons do on the bottom of the order? im using those too, but they dont see to do anything, at least that i can tell.

[wickedklown]

outch, i guess im talking to myself here... i really wish that you could del/edit your posts, so taht i didnt have to make another one everytime i found somthing new.

anyways-

i ran a report for a manufacture that i KNOW didnt have any sales last month (we just started to carry them this month). yet, the report is calculating the SHIPPING costs for orders that dont have that manufacture in them.. its not calculating anything with the goods value, those all state 0.00 for every one. but all the shipping costs on every order for those days is being calculated. Is that they way this is suppose to work?

maybe im missing how this is setup, and suppose to work.. but it seems to me that it should show nothing TOTAL: 0.00 when the manufacture wasnt found for that time period. maybe the shipping total should show it, but then you would think that it would be showing the goods value too.


1440958 *******,**** 0 | -- $0.00 $0.00 $12.85 $0.00 | Qty: 0 $0.00 | Qty: 0 $20.00 | Qty: 1 $-7.15

this one really trips me out... becuase this customer DIDNT buy anything from that manufacture that i choose, however its calculating it into my total. and further more, its showing that there account is at -7.15 becuase its taking the total for shipping and subtracting the whole gift cert value without calcuating the cost for the actual item or Goods Value...

[DonRichardsonNH]

Sorry for the delay, Kathy. I've looked and I honestly don't know what could be causing this. Can you attach to a post [1] a screenshot of the page where the manufacturers dont display, and [2] the source of the page as a text document.

Good catch on the settings in the defines, fprimex. I don't know how that one squeaked by, but it's corrected for the next version. You are correct, custom is actually the second option for DEFAULT_DATE_SEARCH_TYPE, not open.

Totals are left out of the CSV because the file is intended for use where the information is going to be imported into another system. There you need the data to be sequantial and repeating in order to properly read the CSV.

However, having the totals could obviosuly be useful if you just want a spreadsheet. If you make the changes, send them my way and I'll see about adding them in as an optional setting.

Glad you like it, too.

I'm afraid you must have. The files are set up in folders so that all you need to do is drop them right into your site. Simply FTP to your server, then drop the entire /admin folder into the same directory where your store's /admin folder exists. If you browse back you'll find another post I made that explains what happens in more detail.

I copied the files as your readme suggests, knowing that they will overlay the existing directory structures . I will check again to be sure they got into the right directories, but is that all there is to getting them to show up in the reports pull down ?

[wtl]

I would like to re-iterate a big Thanks to BlindSide for this new sales report version!
I have always been after a manufacturer split having searched / sorted with my excel csv reports...however:

I am experiencing the same issue regards manufacturer selection report.
When I run report with no manufacturers selected data is correct, but when I choose a single manufacturer the data is very different,

e.g 15/10 One manufacturer I sold 6 items Correct, but in the single manufacturer report says 74 products!?

My only thought is that is calculating on stock holding and not stock sold?

Any help / thoughts.

Thanks
wtl
wantthelook.com

[digidiva-kathy]

So, um, the manufacturer sales report doesn't work with the "Order Line Items" setting? I got negative totals on every line with that option... With the "Product Line Items" I got 0 product totals and the error message for the days on which there were no orders.

On another note, thanks for fixing the other thing with the manufacturers not showing up.

[BlindSide]

I copied the files as your readme suggests, knowing that they will overlay the existing directory structures . I will check again to be sure they got into the right directories, but is that all there is to getting them to show up in the reports pull down ?

Yes.

I would like to re-iterate a big Thanks to BlindSide for this new sales report version!
I have always been after a manufacturer split having searched / sorted with my excel csv reports...however:

I am experiencing the same issue regards manufacturer selection report.
When I run report with no manufacturers selected data is correct, but when I choose a single manufacturer the data is very different,

e.g 15/10 One manufacturer I sold 6 items Correct, but in the single manufacturer report says 74 products!?

My only thought is that is calculating on stock holding and not stock sold?

So, um, the manufacturer sales report doesn't work with the "Order Line Items" setting? I got negative totals on every line with that option... With the "Product Line Items" I got 0 product totals and the error message for the days on which there were no orders.

On another note, thanks for fixing the other thing with the manufacturers not showing up.

* kathy: Logically, what you are doing doesn't make sense. You want a report of all the products sold by a particular manufacurer, but want to see them by order? Why would do that, when products are the reiterating line item?

* wtl & kathy: Remember, when you filter by manufacturer, all it does is cut out products that do not match the manufacturer. Order totals (coupons, discount, taxes, etc) are still calculated normally. I would therefore recommend that you do not use order line items when filtering by manufacturer, as the information is outputs is somewhat misleading (however it is still accurate according to the search crieria that you set). I can't say for sure that this is what you're doing, wtl, but it sounds like it at least.

The strength of the Sales Report lies in its ability to report across a wide range of information. However this also makes it somewhat unforgiving of odd report choices.

[Danielle]

Do you think it would be difficult to get the Sales Report to split the Tax column into two to show GST and PST seperately? Zen Cart calculates them seperately and then adds them together on the invoice. Since GST and PST returns have to be sent in seperately, it makes it a HUGE pain because I have to go through each invoice and calculate the GST and PST seperately It would totally solve my problem (and other forum member's too!) if the Sales Report could show each one. If I had an idea where to start I'd be happy to play around with it!

[BlindSide]

The sales report can only report on information already stored in the DB. Since the taxes are combined, the sales report cannot display them separately. You don't need to modify this report, but rather the Zen core in how it handles taxes.