Forums / Addon Admin Tools / Sales report 2.0

Sales report 2.0

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

Results 321 to 340 of 882
5 Jun 2008, 10:10 AM
#321
whitekisses avatar

whitekisses

New Zenner

Join Date:
May 2008
Posts:
13
Plugin Contributions:
0

Sales report 2.0

Hi all,

I realised that

  1. Sales Report are showing even those deleted orders, can i actually do something to not let them showing up?

  2. I realised that Sales Report did not show orders if I shop for them (eg. I use Master Password to log in to their account and shop for them)

Is there anyway to fix both problems?

Thanks alot!:smile:

5 Jun 2008, 3:50 PM
#322
blindside avatar

blindside

Totally Zenned

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

Re: Sales report 2.0

whitekisses:

  1. Sales Report are showing even those deleted orders, can i actually do something to not let them showing up?
    They only way to prevent orders from appearing in the Sales Report is to delete them. Not sure how you are "deleting" your orders, but if they are still stored in the DB, they will be processed.
  2. I realised that Sales Report did not show orders if I shop for them (eg. I use Master Password to log in to their account and shop for them)
    Not sure what you mean here. Any orders in the system are eligible to display in the report; whether or not they display is determined by your report criteria. The fact that you are logging into your users' accounts using the master password is not relevant.

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

5 Jun 2008, 5:10 PM
#323
whitekisses avatar

whitekisses

New Zenner

Join Date:
May 2008
Posts:
13
Plugin Contributions:
0

Re: Sales report 2.0

Ya i figured that out, i'm just dumb hahaa

But i had another problem, as I use my cart with the Edit Order module, i realised i can't edit those with discounts.

For instance on the Edit Order module,

Total Price: $27
Discount: -$3.00
Total: $24

But it will show up on Sales Report module as;

Goods Value: $27
Discount: -$3.00
Total: $30

I tried without the minus sign, and this is what i get,

Edit Order Module;

Total Price: $27
Discount: $3.00
Total: $30

Sales Report module;

Goods Value: $27
Discount: $3.00
Total: $24

Any idea how to fix it? Thank you so much for your help! :smile:

6 Jun 2008, 12:38 AM
#324
blindside avatar

blindside

Totally Zenned

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

Re: Sales report 2.0

The Edit Orders module is not storing the discount value properly. If you can look at your database using a tool like phpMyAdmin, browse the orders_total table. You'll note there's a field called "class." This field is internal to this table (i.e. it's not used anywhere else), and defines exactly the "type" of order total for a given record. Core Zen cart functionality allows discounts to be defined using a class string of either "ot_gv" or "ot_group_pricing". Anything else is considered an expense, and increases the cost.

Based on your examples, it would appear that Edit Orders does not follow this convention, and simply appends a minus sign to the number stored in "value". The Sales Report picks this up as an expense (correctly) and counts accordingly.

I warn people all the time about the Edit Order modules out there. They are based on some way old code, and can cause some serious issues. This is (fortunately) a more minor one.

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

22 Jun 2008, 8:18 AM
#325
redmonds avatar

redmonds

Zen Follower

Join Date:
Jan 2006
Posts:
108
Plugin Contributions:
1

Re: Sales report 2.0

Firstly let me say this is an excellent contrib and always one of the first that I install.

I wanted to add something to the wishlist of Sales Report if there is one. I would like to generate reports where the output is more about customers then sales. It seems like it would be easy to add into, or mod from, Sale Reports (he says knowing nothing og PHP or sql).

For example I would like to generate lists of customers that purchase product x, during period y. Or a list of customers that made x number of purchases during period y. Or a list of customers that purchased product A and B either together or seperately. Or a list of customers that have spend more/less then X dollars. Filters also for State, postcode

I have a need for this in trying to select choice customer to get feedback from. For example I could generate a report of everyone that purchased X and then purchased y later. This report would be centred around customer details, showing name, address, phone, order date, order value/products. etc. because this customer made 2 seperate purchases I presume they would have something positive to say about the product or service that they received.

I hope that makes sense. I think it is (logically not code) as simple as generating a customer list with filters for date range, state, post code, order value, product1, product2, number of transactions...

I am currently trying to find a cheap coder to write this for me so am certainly willing to contribute to it being done.

Thanks for listening.

1 Jul 2008, 6:15 PM
#326
infocom avatar

infocom

Zen Follower

Join Date:
Jul 2006
Location:
Cardiff, Wales
Posts:
308
Plugin Contributions:
0

Re: Sales report 2.0

Hi. This is a great reporting mod. But is it possible to change the date format? We need it in dd/mm/yy. I have looked in the files and seems there are loads of references to date("m"), date("d") which I tried swapping but didn't work. Couldn't find a solution on this thread. The Zencart date format does not affect the format of this mod.
Thanks

2 Jul 2008, 3:12 PM
#327
infocom avatar

infocom

Zen Follower

Join Date:
Jul 2006
Location:
Cardiff, Wales
Posts:
308
Plugin Contributions:
0

Re: Sales report 2.0

I also notice another probem... using the Custom date selection results in UK date format (perhaps its based on the Zencart date format we have?) so when we run the query we get an error message saying date format is wrong. i.e. if we choose 30th June 2008 (using Custom box its 30/06/08) we get an error probably because the system thinks 30 is the month.

So please can you let us know how to switch between US/European date formats (mm/dd/yyyy and dd/mm/yyyy). Thanks.

2 Jul 2008, 3:23 PM
#328
ces avatar

ces

Zen Follower

Join Date:
Nov 2004
Location:
West Mids, England
Posts:
199
Plugin Contributions:
0

Re: Sales report 2.0

Try searching this thread for "conor" and you should find some posts and solutions.

Craig

8 Jul 2008, 6:26 PM
#329
athena avatar

athena

Totally Zenned

Join Date:
Jan 2006
Location:
NM
Posts:
740
Plugin Contributions:
0

Re: Sales report 2.0

Thanks again for this, Frank. It's come a long way and is quite exciting with my new 1.3.8a install....

I am concerned about the edit orders mod based on your comment.

Have not made this new store live yet...any tips on an alternative? Our goal is to be able to "edit orders" ;)

24 Jul 2008, 2:23 PM
#330
athena avatar

athena

Totally Zenned

Join Date:
Jan 2006
Location:
NM
Posts:
740
Plugin Contributions:
0

Re: Sales report 2.0

psr racing:

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.

28 Jul 2008, 6:52 PM
#331
athena avatar

athena

Totally Zenned

Join Date:
Jan 2006
Location:
NM
Posts:
740
Plugin Contributions:
0

Re: Sales report 2.0

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.

31 Jul 2008, 8:42 PM
#332
athena avatar

athena

Totally Zenned

Join Date:
Jan 2006
Location:
NM
Posts:
740
Plugin Contributions:
0

Re: Sales report 2.0

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.

15 Aug 2008, 9:13 PM
#333
greatwhitebuffalo avatar

greatwhitebuffalo

New Zenner

Join Date:
Jan 2008
Posts:
16
Plugin Contributions:
0

Re: Sales report 2.0

BlindSide:

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

17 Sep 2008, 7:21 PM
#334
opal avatar

opal

New Zenner

Join Date:
Apr 2008
Posts:
70
Plugin Contributions:
0

Re: Sales report 2.0

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?

17 Sep 2008, 8:59 PM
#335
vhjdb avatar

vhjdb

New Zenner

Join Date:
Dec 2007
Posts:
19
Plugin Contributions:
0

Re: Sales report 2.0

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

18 Sep 2008, 11:03 PM
#336
nightwolff avatar

nightwolff

New Zenner

Join Date:
Dec 2006
Location:
Ohio
Posts:
16
Plugin Contributions:
0

Re: Sales report 2.0

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

www.flagladyohio.com
Zen Cart v1.38a, Installed mods: - Css Flyout Menus - Gallery Categories - Google Analytics by Andrew - Ultimate SEO URLs - Custom Imagebox by cshart

19 Sep 2008, 5:53 PM
#337
vhjdb avatar

vhjdb

New Zenner

Join Date:
Dec 2007
Posts:
19
Plugin Contributions:
0

Re: Sales report 2.0

I found the solution for my problem at http://www.zen-cart.com/forum/showthread.php?t=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

3 Oct 2008, 2:55 AM
#338
econcepts avatar

econcepts

Totally Zenned

Join Date:
Dec 2005
Posts:
1,505
Plugin Contributions:
2

Re: Sales report 2.0

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.

Eric
20 Ways to Increase Sales Using Zen Cart
Zen Cart contribs: Simple Google Analytics, Export Shipping Information

3 Oct 2008, 3:50 AM
#339
econcepts avatar

econcepts

Totally Zenned

Join Date:
Dec 2005
Posts:
1,505
Plugin Contributions:
2

Re: Sales report 2.0

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.

Eric
20 Ways to Increase Sales Using Zen Cart
Zen Cart contribs: Simple Google Analytics, Export Shipping Information

3 Oct 2008, 8:05 AM
#340
ces avatar

ces

Zen Follower

Join Date:
Nov 2004
Location:
West Mids, England
Posts:
199
Plugin Contributions:
0

Re: Sales report 2.0

Hi Eric

Shouldn't this be in the super orders thread, not the sales report?

Craig