Forums / Addon Admin Tools / Sales report 2.0

Sales report 2.0

Started by blindside on 29 Aug 2006, 2:41 AM · Views: 248,184

Results 61 to 80 of 882
5 Oct 2006, 7:32 PM
#61
digidiva_kathy avatar

digidiva_kathy

Zen Follower

Join Date:
May 2006
Posts:
323
Plugin Contributions:
0

Sales report 2.0

Just to be clear, I don't have an issue with the community at large having access to the mod. However, in my own little specific industry, which happens to be digital scrapbooking, there are lots of people who would benefit from this mod. That's why I feel it fair that some of them help cover the cost because they will benefit just as much as I will from it. We all have the same issues and we all have discussed wishing we could do something about it, I just happen to be the one who made the effort to actually communicate with you, KWIM?

And I do have several mods installed, but the products do have a manufacturer assigned to them when they're added to the catalog and I can't imagine how any of the other mods could really affect that. I'd be happy to give you access via PM if you'd like to look around :) .

7 Oct 2006, 5:21 PM
#62
drc2100 avatar

drc2100

New Zenner

Join Date:
Oct 2006
Posts:
23
Plugin Contributions:
0

Re: Sales report 2.0

Blindside - thanks for creating and sharing the sales report with allof us. We sell products with manufacturers and music downloads with record labels and I can't get the manufacturers to show up on my report either?

I would like to discuss hiring you to do some custom work that could also benefit the community, what is the best way to set that up with you?

Thanks

11 Oct 2006, 3:50 AM
#63
digidiva_kathy avatar

digidiva_kathy

Zen Follower

Join Date:
May 2006
Posts:
323
Plugin Contributions:
0

Re: Sales report 2.0

So, um, hate to be a bother, but any word on why my manufacturers aren't showing on my report? I have been asked to install this mod for a customer for whom I installed a cart, but hate to think she'll have the same issue I do and I won't be able to tell her what's wrong.

Thanks!

12 Oct 2006, 5:39 AM
#64
fprimex avatar

fprimex

New Zenner

Join Date:
Jul 2006
Posts:
1
Plugin Contributions:
0

Re: Sales report 2.0

BlindSide,

Thanks so much for this contribution and your hard work!

Two things I've noticed (forgive me if this is a rehash, I haven't read all of the posts):

  • DEFAULT_DATE_SEARCH_TYPE works with 'preset', but not with 'open' as suggested. 'custom' gave me what I wanted.
  • It would be nice to have an option for the CSV export to contain the grand totals that are available in the display version.

If I go ahead and add the grand totals to mine, would you like for me to email you the changes?

Thanks again! Saved me a ton of work :D

12 Oct 2006, 12:55 PM
#65
donrichardsonnh avatar

donrichardsonnh

New Zenner

Join Date:
Oct 2006
Posts:
25
Plugin Contributions:
0

Re: Sales report 2.0

I have installed the Sales Report as the readme file states. Great tool, and thanks for contributing this.

After following the steps for installation, and still do not see the Sales Report in the pulldown for Reports in the Admin session for Zencart. I am using Zencart 1.3.0.2.

Have I missed somthing?

12 Oct 2006, 4:25 PM
#66
blindside avatar

blindside

Totally Zenned

Join Date:
Sep 2004
Posts:
1,237
Plugin Contributions:
1

Re: Sales report 2.0

digidiva-kathy:

So, um, hate to be a bother, but any word on why my manufacturers aren't showing on my report? I have been asked to install this mod for a customer for whom I installed a cart, but hate to think she'll have the same issue I do and I won't be able to tell her what's wrong.
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.
fprimex:

BlindSide,

Thanks so much for this contribution and your hard work!

Two things I've noticed (forgive me if this is a rehash, I haven't read all of the posts):

  • DEFAULT_DATE_SEARCH_TYPE works with 'preset', but not with 'open' as suggested. 'custom' gave me what I wanted.
  • It would be nice to have an option for the CSV export to contain the grand totals that are available in the display version.

If I go ahead and add the grand totals to mine, would you like for me to email you the changes?

Thanks again! Saved me a ton of work :D
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. :D

DonRichardsonNH:

I have installed the Sales Report as the readme file states. Great tool, and thanks for contributing this.

After following the steps for installation, and still do not see the Sales Report in the pulldown for Reports in the Admin session for Zencart. I am using Zencart 1.3.0.2.

Have I missed somthing?
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.

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

13 Oct 2006, 2:30 AM
#67
wickedklown avatar

wickedklown

Zen Follower

Join Date:
Aug 2005
Posts:
370
Plugin Contributions:
0

Re: Sales report 2.0

im having the same issue with manufactures not showing up after they are enabled in the lang file.

iv included both a copy of the source after i ran the report, showing there is no manufactures listed. *note: those that say --none-- are ones that i know dont have a manufacture listed for them, the rest that are blank should have the corrisponding manu.

im unable to put the code here, as it tells me that its too long. any way around that?

also the damn image is soo small i dont know if you can tell what it says.. if you need better image, let me know, ill upload one to my server and link ya to it

Super Orders2
Info at a glance
export email address
encrypted master pass
quick updates
recover carts
order Tracking
Tabbed products lite - admin edition
Hosted with sashbox.net <- best host around...

13 Oct 2006, 8:14 PM
#68
blindside avatar

blindside

Totally Zenned

Join Date:
Sep 2004
Posts:
1,237
Plugin Contributions:
1

Re: Sales report 2.0

Aha! T'was a bug in the system. Fortunately it's just a stupid variable misspelling. Open admin/includes/classes/sales_report.php and find this line...

            $this->timeframe[$id]['products'][$pID]['manufacturer'] = $gen_manu_id->fields['manufacturers_name'];

That $gen_manu_id is misspelled. Change it to $get_manu_id, so the line now reads as...

            $this->timeframe[$id]['products'][$pID]['manufacturer'] = $get_manu_id->fields['manufacturers_name'];

I'll be putting out a version update very shortly to address this. I know, I don't know how I typed an "n" instead of a "t" either. :blink:

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

13 Oct 2006, 10:01 PM
#69
blindside avatar

blindside

Totally Zenned

Join Date:
Sep 2004
Posts:
1,237
Plugin Contributions:
1

Re: Sales report 2.0

Ok, new version is posted in the downloads section. Here's a direct link:

http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_41&products_id=83

I also want to point out that this version includes a much-requested feature: filtering by manufacturer. Select a manufacturer from the dropdown and the report will only calculate product values from that manufacturer. In other words, now you can do those "manufacturer sales reports" you've all been clamoring for.

This was originally going to be a freelance job, but the buyer backed out, so I decided just to do it anyway. So if you're one of the many who wanted this feature, I'd like to remind you that donations are always welcome and info can be found at the bottom of the README.

As always, let me know if you find any bugs.

Enjoy. :D

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

13 Oct 2006, 10:40 PM
#70
wickedklown avatar

wickedklown

Zen Follower

Join Date:
Aug 2005
Posts:
370
Plugin Contributions:
0

Re: Sales report 2.0

w00t, thanks man, works great..

Super Orders2
Info at a glance
export email address
encrypted master pass
quick updates
recover carts
order Tracking
Tabbed products lite - admin edition
Hosted with sashbox.net <- best host around...

13 Oct 2006, 10:54 PM
#71
wickedklown avatar

wickedklown

Zen Follower

Join Date:
Aug 2005
Posts:
370
Plugin Contributions:
0

Re: Sales report 2.0

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

Super Orders2
Info at a glance
export email address
encrypted master pass
quick updates
recover carts
order Tracking
Tabbed products lite - admin edition
Hosted with sashbox.net <- best host around...

14 Oct 2006, 12:49 AM
#72
wickedklown avatar

wickedklown

Zen Follower

Join Date:
Aug 2005
Posts:
370
Plugin Contributions:
0

Re: Sales report 2.0

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.

Super Orders2
Info at a glance
export email address
encrypted master pass
quick updates
recover carts
order Tracking
Tabbed products lite - admin edition
Hosted with sashbox.net <- best host around...

14 Oct 2006, 6:58 PM
#73
wickedklown avatar

wickedklown

Zen Follower

Join Date:
Aug 2005
Posts:
370
Plugin Contributions:
0

Re: Sales report 2.0

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...

Super Orders2
Info at a glance
export email address
encrypted master pass
quick updates
recover carts
order Tracking
Tabbed products lite - admin edition
Hosted with sashbox.net <- best host around...

15 Oct 2006, 5:20 PM
#74
donrichardsonnh avatar

donrichardsonnh

New Zenner

Join Date:
Oct 2006
Posts:
25
Plugin Contributions:
0

Re: Sales report 2.0

BlindSide:

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. :D

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 :lamo: . 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 ?

16 Oct 2006, 11:02 AM
#75
wtl avatar

wtl

New Zenner

Join Date:
Nov 2005
Posts:
8
Plugin Contributions:
0

Re: Sales report 2.0

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

19 Oct 2006, 1:57 PM
#76
digidiva_kathy avatar

digidiva_kathy

Zen Follower

Join Date:
May 2006
Posts:
323
Plugin Contributions:
0

Re: Sales report 2.0

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.

23 Oct 2006, 6:10 PM
#77
blindside avatar

blindside

Totally Zenned

Join Date:
Sep 2004
Posts:
1,237
Plugin Contributions:
1

Re: Sales report 2.0

DonRichardsonNH:

I copied the files as your readme suggests, knowing that they will overlay the existing directory structures :lamo: . 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. :smile:
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?
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.
*** 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.

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

23 Oct 2006, 6:58 PM
#78
danielle avatar

danielle

Totally Zenned

Join Date:
Oct 2004
Posts:
973
Plugin Contributions:
0

Re: Sales report 2.0

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!

Danielle

24 Oct 2006, 3:36 AM
#79
blindside avatar

blindside

Totally Zenned

Join Date:
Sep 2004
Posts:
1,237
Plugin Contributions:
1

Re: Sales report 2.0

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.

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

24 Oct 2006, 10:40 PM
#80
missjane avatar

missjane

New Zenner

Join Date:
Oct 2006
Posts:
8
Plugin Contributions:
0

Re: Sales report 2.0

I'm just had sales report 2.0 installed and it is great! One problem I am having. Some of my orders appear on the report twice. How can that happen. My report is set up as follows:

This month
Status: Shipped
Timeframe: Daily
+order line items

I have an order that was on 10-23 and it is also showing up as an order for 10-24. Same order number, customer, total, etc.

I also had an order that I split using Super Orders and it didn't do what I wanted. I deleted the earlier order and modified the newly split order to be the remaining order. This order is also showing up twice. Once with today's date with the newly created order number, but it's also showing up on the original date of the order (10-22) with the newly created order number, too.

Any ideas?

Jane