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 601 to 620 of 882
28 Sep 2012, 8:28 AM
#601
renz avatar

renz

Zen Follower

Join Date:
Jun 2006
Posts:
439
Plugin Contributions:
0

Sales report 2.0

Does the latest version of Sales Report, play nicely with Store Credit and will it display the figures correctly if a refund is made with zen vs 138a. Thanks Regards Renz

15 Oct 2012, 6:41 AM
#602
southshorepizza avatar

southshorepizza

Zen Follower

Join Date:
Sep 2012
Posts:
253
Plugin Contributions:
0

Re: Sales report 2.0

I really like this mod. Can someone help me filter by shipping method? Also can someone help me get the report to display the tax amount for each order?

Thank you!

16 Oct 2012, 4:22 AM
#603
southshorepizza avatar

southshorepizza

Zen Follower

Join Date:
Sep 2012
Posts:
253
Plugin Contributions:
0

Re: Sales report 2.0

I want to clarify my last post a little.
When I asked to filter by shipping method what I meant was at the top in Gather and Filter data you can filter by payment method or payment method to omit. I would like the exact same thing but instead of payment have shipping method.

Another thing is as I was completing my paperwork for the night I noticed that the sales do not add up. As an example order #98. He was charge for 2 items at $9.00 each. He picked them up at the store so no shipping cost. Fl sales tax is 7%. His emailed invoice was for $19.26. $9X2=$18 $18x1.07=$19.26 so emailed invoice was correct. However the sales report shows goods value $16.74, goods tax $1.26, order rec. tax $1.26, Shipping $0.00, discounts $0.00, Order total $18.00. This happened on several orders. Also I only have one tax which is Florida sales tax. So why do I see a goods tax and an order rec. tax? Shouldn't there just be one? Why are some of the amounts different on the same category?

I am running version 1.5. I have added the following modules tip_module, SalesTaxReportv2.1, edit_orders_v4.0, discount_1.11, and of course SalesReport310.

Thank you in advance for your help in understanding this.

16 Oct 2012, 4:29 AM
#604
southshorepizza avatar

southshorepizza

Zen Follower

Join Date:
Sep 2012
Posts:
253
Plugin Contributions:
0

Re: Sales report 2.0

Shoot. I am really sorry. I wanted to include the .csv file so you could see what I am looking at and then forgot to attach it.
Attachment #11318

26 Oct 2012, 10:09 PM
#605
southshorepizza avatar

southshorepizza

Zen Follower

Join Date:
Sep 2012
Posts:
253
Plugin Contributions:
0

Re: Sales report 2.0

Is there any support for this?

26 Oct 2012, 10:16 PM
#606
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,511
Plugin Contributions:
176

Re: Sales report 2.0

Sounds like the questions you're asking are really feature requests in terms of changing or enhancing the data being reported on.
Any adjustments you're looking for will probably require having a programmer look into the code and the data in order to deliver the adjusted output you seek.

As you say, the data in the store is correct, but the report may not be understanding the complexities of the way your mods work together or wasn't designed to report things the way you're looking for. And adding filtering by another set of factors requires someone rewriting the queries and adding the form controls to the page, etc.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

4 Nov 2012, 9:11 PM
#607
carlvt88 avatar

carlvt88

Zen Follower

Join Date:
Aug 2007
Location:
Williston, Vermont
Posts:
180
Plugin Contributions:
0

Re: Sales report 2.0

@bseller, @southshorepizza -

Rather than changing the math in the salesreport, try the configuration option:

Configuration -> My Store -> Display Prices with Tax in Admin

I don't use taxes, but I modeled your situation and it seemed that in the function zen_add_tax in general.php, the tax wasn't getting added without this configuration option set.

5 Nov 2012, 12:05 PM
#608
buffoon avatar

buffoon

New Zenner

Join Date:
Sep 2012
Posts:
12
Plugin Contributions:
0

Re: Sales report 2.0

Excellent module! I have a few questions which I hope aren't repeats. I'm running the latest version on ZC 1.5.1, and also have Super Orders installed if it makes a difference.

  1. We have two statuses which we regularly report on, shipped orders and confirmed orders (where payment has been received but the item hasn't yet shipped). With Sales Report I can see how to report on both individually, but being able to run a report with both status types included would be ideal. Is there an easy trick to get this set up?
  2. Relatedly, is it possible to add an extra column in the Product/Order reports to show the order status, to allow us to run comparisons without downloading and merging separate reports or being confused if 1. is possible?
  3. Is is possible to have a report which gives both products ordered and order references together? There would be some logistical issues with the display of totals where orders contain multiple line items, but it would still be helpful for my sales team.

I suppose my real question is how best to go about adding some custom reports of my own in order to avoid breaking anything. Any guidance or documentation pointers would be great, then I can start experimenting...

7 Nov 2012, 3:02 PM
#609
buffoon avatar

buffoon

New Zenner

Join Date:
Sep 2012
Posts:
12
Plugin Contributions:
0

Re: Sales report 2.0

Can't edit my last post now, but I've solved most of my requirements by installing the separate Export Shipping Information mod which covers #3 in my list and gives me the best of both modules to play with. The only remaining query I have is whether it would be possible to run Sales Report on two order statuses at a time (at the moment it's a dropdown, so I can't). It's certainly not a critical feature, but I figured it might be handy to know there's demand if it was ever considered.

Thank you for making such a solid module!

3 Dec 2012, 10:01 PM
#610
postig avatar

postig

New Zenner

Join Date:
Oct 2011
Posts:
22
Plugin Contributions:
0

Re: Sales report 2.0

I'm sure Sales Report must be a great mod and I would like to use it, but, unfortunately, nothing happens when I click the button "Show me the money"... The page remains blank.

Any clue of what I might have done wrong?

ZC 1.5.1 through Firefox

I'll mention that I have only a few recent orders, since I'm still testing the site, in case it has any influence...

Thanks

4 Dec 2012, 8:23 PM
#611
postig avatar

postig

New Zenner

Join Date:
Oct 2011
Posts:
22
Plugin Contributions:
0

Re: Sales report 2.0

postig:

I'm sure Sales Report must be a great mod and I would like to use it, but, unfortunately, nothing happens when I click the button "Show me the money"... The page remains blank.

Any clue of what I might have done wrong?

ZC 1.5.1 through Firefox

I'll mention that I have only a few recent orders, since I'm still testing the site, in case it has any influence...

Thanks


Problem solved. I knew I had done something wrong. Just a missing file. Thanks for this great mod!

18 Jan 2013, 9:38 PM
#612
wk4hm avatar

wk4hm

New Zenner

Join Date:
Jan 2007
Posts:
24
Plugin Contributions:
0

Re: Sales report 2.0

Can anyone tell me the difference between the order received tax and the Goods Tax? Below is an example where i dont see how order received tax is 2.75?

Timeframe |
Num Orders |
Num Products |
Goods Value |
Goods Tax |
Order Rec. Tax |
Shipping |
Discounts |
Gift Cert. Sold |
Gift Cert. Used |
Total |

     2-10-2012 | 
     13 | 
     13 | 
     | Diff: 3 | 
     $317.60 | 
             $2.40 | 
     $2.75 | 
             $25.75 | 
     $20.00 | 
     | Qty: 1 | 
     $0.00 | 
     | Qty: 0 | 
     $0.00 | 
     | Qty: 0 | 
     $325.75 | 

[TABLE="width: 100%"]

     Prod ID | 
     Product Name [\[IMG\]https://www.robbell.com/work/admin616/images/icons/up\_arrow.gif\[/IMG\] 2](https://www.robbell.com/work/admin616/stats_sales_report.php?securityToken=58546f5a56257b6e46b050adadc795df&start_date=01/01/2012&end_date=01/01/2013&date_target=purchased&date_status=1&prod_includes=&cust_includes=&payment_method=&current_status=&timeframe=day&timeframe_sort=asc&detail_level=product&li_sort_a=model&li_sort_order_a=asc&li_sort_b=name&output_format=display&new_window=1&li_sort_order_b=desc) | 
             Model No. [\[IMG\]https://www.robbell.com/work/admin616/images/icons/up\_arrow.gif\[/IMG\]1](https://www.robbell.com/work/admin616/stats_sales_report.php?securityToken=58546f5a56257b6e46b050adadc795df&start_date=01/01/2012&end_date=01/01/2013&date_target=purchased&date_status=1&prod_includes=&cust_includes=&payment_method=&current_status=&timeframe=day&timeframe_sort=asc&detail_level=product&li_sort_a=model&li_sort_b=name&li_sort_order_b=asc&output_format=display&new_window=1&li_sort_order_a=desc) | 
     Base Price | 
     Qty. | 
             Tax | 
             Total | 
             Product Total | 
   

   

     **16** | 
     prod 1

|
|
$10.00 |
2 |
$0.00 |
$20.00 |
$20.00 |

     **9** | 
     prod 2

|
|
$20.00 |
7 |
$0.00 |
$140.00 |
$140.00 |

     **35** | 
     prod 3

|
|
$40.00 |
4 |
$2.40 |
$160.00 |
$162.40

[/TD]
[/TR]
[/TABLE]

18 Jan 2013, 9:46 PM
#613
southshorepizza avatar

southshorepizza

Zen Follower

Join Date:
Sep 2012
Posts:
253
Plugin Contributions:
0

Re: Sales report 2.0

Goods tax is the tax on full face value or before any discount. Order Receipts Tax is the tax collected after discounts are applied. If you have an item for $20 and discount it 50%, with a sales tax rate of 1% the Goods tax is $0.20 the order rec tax is $0.10.

21 Feb 2013, 3:47 PM
#614
uswebworx avatar

uswebworx

Zen Follower

Join Date:
Sep 2006
Location:
USA
Posts:
297
Plugin Contributions:
0

Re: Sales report 2.0

Got it working, is there any way to make it show Address Shipped to? Or billed to?
Thanks

Signature not needed

1 Apr 2013, 12:56 AM
#615
kavlito avatar

kavlito

New Zenner

Join Date:
Sep 2009
Posts:
40
Plugin Contributions:
0

Re: Sales report 2.0

Every month I use the Sales Report to generate sales on specific products using the feature ' Only include specific Product IDs (comma separated list) '. I paste in different lists of the products to generate the report. It has been working great until my Hosting Service recently upgraded our servers and PHP version to 5.3.2, and MYSQL version 5.1.65. Now when I run the report, I am limited to what looks like 150 csv values???

If I paste in less than 150, the report generates.

I get the following error in /admin/stats_sales_report.php when I paste in more than 150 csv values:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
in:
[select distinct pd.products_name from zen_products_description pd where products_id = ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Here is the code in question:

<?php if ($_GET['doCustInc']== 'on' || $_GET['doProdInc']== 'on') {
          // if reporting for a specific product, build up a string of product descriptions
        $i = 0;
        $header_string = "";
        $include_products = explode(",",$_GET['prod_includes']);
        if ($_GET['doProdInc']== 'on' && DISPLAY_TABLE_HEADING_PRODUCTS) {
            foreach($include_products as $cID) {
                $tempAry = $db->Execute("select distinct pd.products_name from " .
                            TABLE_PRODUCTS_DESCRIPTION . " pd where products_id = " . trim($cID));
                if ($i == 0) {
                    $header_string = $tempAry->fields['products_name'] ;
                }
                else
                {
                    $header_string .= ", " . $tempAry->fields['products_name'];
                }
                $i++;
            }
        }

Anybody else have this problem and/or have a clue how to fix it?

PS. I also upgraded to the latest version and get the same error.

1 Apr 2013, 1:30 AM
#616
carlvt88 avatar

carlvt88

Zen Follower

Join Date:
Aug 2007
Location:
Williston, Vermont
Posts:
180
Plugin Contributions:
0

Re: Sales report 2.0

deleted

10 Apr 2013, 9:52 PM
#617
ibuttons avatar

ibuttons

New Zenner

Join Date:
Nov 2008
Posts:
51
Plugin Contributions:
0

Re: Sales report 2.0

I would also like to be able to exclude orders from the Sales Report based on the current order status, however...

the change shown below doesn't accomplish that. Instead, the drop-down field used to select the *Current Order Status * no longer contains the orders_status_id of 5, but the report still includes orders with a current orders_status_id of 5. This is not what I want at all! :wacko:

wolfderby:

If you'd like to remove "cancelled" orders from the sales report data (marked "cancelled" through a manually created order status, under admin > localization > order status > "insert")...

Go into your stats_sales_report.php file (in your admin folder) and around line 49 you'll find this line of code

$orders_status = $db->Execute("select orders_status_id, orders_status_name from " . TABLE_ORDERS_STATUS . "
                               where language_id = '" . (int)$_SESSION['languages_id'] . "'
                               order by orders_status_id asc");
> 
> you'll want to change it to:
> ```
$orders_status = $db->Execute("SELECT orders_status_id, orders_status_name FROM " . TABLE_ORDERS_STATUS . "
                                   WHERE language_id = '" . (int)$_SESSION['languages_id'] . "' AND NOT (orders_status_id = 5)
                                   ORDER BY orders_status_id asc");

Here is what I need ...

  1. I'd like to be able to exclude any order that has a current orders_status_name that contains a string like %test%, %unused%, %voided%, or %RMA%.
  2. Ideally, I'd like to have a new text field I can type into, kind of like the field called: Only include specific Customer IDs (comma separated list), only this new one would be called: Exclude current orders_status_names that contain.
  3. In this new field, I would enter the following: test, unused, void, rma.
  4. Also, I would like to be able to setup a default for it so I don't have to type those in all the time.
  5. And I would like to be able to specify if my strings are case-sensitive or not.

Anybody have any idea about how to do this? Any/all help/suggestions would be graciously appreciated.

BTW: here are the specs of my cart:

  • https://www.KeylessEntryLocks.com
  • Zen Cart 1.5.1
  • Sales Report - Version: 3.1.0
  • Linux 2.6.32-279.19.1.el6.x86_64
  • PHP Version 5.3.21
  • Database Patch Level: 1.5.1
  • anthing else you need, ju
11 Apr 2013, 10:15 PM
#618
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

Re: Sales report 2.0

ibuttons:

I would also like to be able to exclude orders from the Sales Report based on the current order status, however...

the change shown below doesn't accomplish that. Instead, the drop-down field used to select the *Current Order Status *no longer contains the orders_status_id of 5, but the report still includes orders with a current orders_status_id of 5. This is not what I want at all! :wacko:

Here is what I need ...

  1. I'd like to be able to exclude any order that has a current orders_status_name that contains a string like %test%, %unused%, %voided%, or %RMA%.
  1. Ideally, I'd like to have a new text field I can type into, kind of like the field called: Only include specific Customer IDs (comma separated list), only this new one would be called: Exclude current orders_status_names that contain.
  1. In this new field, I would enter the following: test, unused, void, rma.
  1. Also, I would like to be able to setup a default for it so I don't have to type those in all the time.
  1. And I would like to be able to specify if my strings are case-sensitive or not.

Anybody have any idea about how to do this? Any/all help/suggestions would be graciously appreciated.

BTW: here are the specs of my cart:

  • Zen Cart 1.5.1
  • Sales Report - Version: 3.1.0
  • Linux 2.6.32-279.19.1.el6.x86_64
  • PHP Version 5.3.21
  • Database Patch Level: 1.5.1
  • anthing else you need, ju

This is a pretty extensive customization, and I'm not sure you're gonna find anyone that is gonna post this kind of solutution here on the forum. You may have to consider hiring someone to code these modifications for you..

My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

14 May 2013, 3:39 PM
#619
herrons avatar

herrons

New Zenner

Join Date:
Apr 2013
Location:
UK
Posts:
1
Plugin Contributions:
0

Re: Sales report 2.0

Trying to get the delivery country to display, I have managed to change the header in the languages version of the stats_sales_report but, can't seem to get the sql to return the actual country the sql seems to be pulling the infor from several different tables and not really sure where to interveen.

really need help with this issue.

23 Jul 2013, 12:45 AM
#620
dandieconner avatar

dandieconner

New Zenner

Join Date:
Jul 2013
Location:
Texas
Posts:
1
Plugin Contributions:
0

Re: Sales report 2.0

I am having problems with this add-on. I made sure to download the v1.3.9h, as that is the version of ZenCart we are using, but I cannot get it to work! I unzipped the file and copied everything over as instructed... The problem is that when I pull the Sales Report in the Admin it is still the same old report from before the add-on, without the new filters and options. Is there something I'm missing? I'm VERY new to ZC so I have no idea where to look but HAVE tried to search the web and forums fir a possible solution...