Page 2 of 23 FirstFirst 123412 ... LastLast
Results 11 to 20 of 229
  1. #11
    Join Date
    Jun 2008
    Location
    Washington, DC
    Posts
    781
    Plugin Contributions
    7

    Default Re: Monthly Sales and Tax Summary Report [support thread]

    Quote Originally Posted by nosnappyname View Post
    Skip, that second version acted the same as the first, but..... I found a number of notes that said: "$HTTP_GET_VARS[] Is IDENTICAL to $_GET, however, it is depreciated, and no longer in use in php 5 + (correct me if I am wrong). PHP advises you use $_GET, $_POST, $REQUEST.. etc for all your super global needs."

    So I changed $HTTP_GET_VARS to $_GET and $HTTP_POST_VARS to $_POST everywhere in stats_monthly_sales.php and everything seemed to work fine. I guess something in my ISP's settings are tighter than yours.

    Anyway, thanks and it really looks like a useful contribution.
    Thanks nosnappyname for PHP 5.0 fix. I was asleep on that one.
    I up loaded a new version 1.2 it should show up in a day or two.

    Thanks again for the help

    Skip
    446F63746F722057686F

  2. #12
    Join Date
    Apr 2006
    Location
    West Salem, IL
    Posts
    2,679
    Plugin Contributions
    0

    Default Re: Monthly Sales and Tax Summary Report [support thread]

    has anyone had an issue with the status dropdown only having All Orders in it and none of the other statuses.
    Mike
    GeekHost - Zen Cart Certified & PCI Compliant Hosting
    The Zen Cart Forum...Better than a monitor covered with post-it notes!

  3. #13
    Join Date
    Jun 2008
    Location
    Washington, DC
    Posts
    781
    Plugin Contributions
    7

    Default Re: Monthly Sales and Tax Summary Report [support thread]

    Quote Originally Posted by barco57 View Post
    has anyone had an issue with the status dropdown only having All Orders in it and none of the other statuses.
    'other statuses' what ones in particular are you asking about?

    Skip
    446F63746F722057686F

  4. #14
    Join Date
    Apr 2006
    Location
    West Salem, IL
    Posts
    2,679
    Plugin Contributions
    0

    Default Re: Monthly Sales and Tax Summary Report [support thread]

    Well should the dropdown for status have more than all orders in it? I would think that it would list all of the statuses I use in the shop. We have orders pending, processing, shipped, downloaded and cancelled. Pending orders may sit for a while over the close of a quarter and I wouldn't want them to be picked up for a tax report. cancelled orders are kept in the cart because the accountant and the irs like to see consecutive order numbers with out breaks.....so the 2 statuses I want to pull reports on would be shipped and downloaded as those are the only ones completed and money (including tax) collected
    Mike
    GeekHost - Zen Cart Certified & PCI Compliant Hosting
    The Zen Cart Forum...Better than a monitor covered with post-it notes!

  5. #15
    Join Date
    Jun 2008
    Location
    Washington, DC
    Posts
    781
    Plugin Contributions
    7

    Default Re: Monthly Sales and Tax Summary Report [support thread]

    This report is not setup for all that information. It gives the user the large picture of total sales and taxes.

    I have not tried this Sales Report but it sounds like it might have what you are looking for.


    Skip
    446F63746F722057686F

  6. #16
    Join Date
    Apr 2006
    Location
    West Salem, IL
    Posts
    2,679
    Plugin Contributions
    0

    Default Re: Monthly Sales and Tax Summary Report [support thread]

    Then I suppose the dropdown on the report page and shown in the attached image is legacy code......too bad. Though at least I don't have too many pending and cancelled I would need to make sure are excluded from the report when doing the paperwork....


    We already use the other sales report heavily but it doesn't do taxes like this one does, well actually it does taxes but not as well as this one does
    Last edited by barco57; 30 Aug 2008 at 11:50 PM.
    Mike
    GeekHost - Zen Cart Certified & PCI Compliant Hosting
    The Zen Cart Forum...Better than a monitor covered with post-it notes!

  7. #17
    Join Date
    Apr 2006
    Location
    West Salem, IL
    Posts
    2,679
    Plugin Contributions
    0

    Default Re: Monthly Sales and Tax Summary Report [support thread]

    ok it definitely must be legacy code because the help popup in the report page has the following:
    Selecting report summary by status

    To show the monthly or daily summary information for just one Order Status, select the status in the drop-down box at the upper right of the report screen. Depending on the store's setup for these values, there may be a status for "Pending" or "Shipped" for instance. Change this status and the report will be recalculated and displayed.
    Mike
    GeekHost - Zen Cart Certified & PCI Compliant Hosting
    The Zen Cart Forum...Better than a monitor covered with post-it notes!

  8. #18
    Join Date
    Jun 2008
    Location
    Washington, DC
    Posts
    781
    Plugin Contributions
    7

    Default Re: Monthly Sales and Tax Summary Report [support thread]

    Now that I am on the same page as you are. Sorry it took me awhile to catchup.
    The drop down order status works.
    What ever order status display in the admin home page will be in the drop down plus All Orders.
    Orders
    Pending:
    Processing:
    Delivered:
    Pending PayPal Notification:
    etc.

    I am running zc 1.3.8 php 5.0 mysql 5.0 and have no issues.

    This link example of selecting pending give us status=1 that is the value that is searched in the orders_status table a very simple query.
    /stats_monthly_sales.php?status=1&selected_box=reports

    There was a version update to 1.2 that fixed some issues with php 5.0 that some where having.

    Skip
    446F63746F722057686F

  9. #19
    Join Date
    Apr 2006
    Location
    West Salem, IL
    Posts
    2,679
    Plugin Contributions
    0

    Default Re: Monthly Sales and Tax Summary Report [support thread]

    Hmmmm......I have this loaded on several carts (1.3.8a, 1.3.6, 1.3.7) and the report displays fine except for the dropdown is not populated with any other status except "All Orders" on all of the installs....very weird
    Mike
    GeekHost - Zen Cart Certified & PCI Compliant Hosting
    The Zen Cart Forum...Better than a monitor covered with post-it notes!

  10. #20
    Join Date
    Jun 2008
    Location
    Washington, DC
    Posts
    781
    Plugin Contributions
    7

    Default Re: Monthly Sales and Tax Summary Report [support thread]

    Try this work around in the url location address bar add the status string.

    This is what you should have for All
    stats_monthly_sales.php?status=&selected_box=reports

    For pending try
    stats_monthly_sales.php?status=1&selected_box=reports

    For Processing try
    stats_monthly_sales.php?status=2&selected_box=reports

    For Shipped try
    stats_monthly_sales.php?status=3&selected_box=reports

    This will just bypass the drop down

    I wonder if the other report mod is using the same 'orders_status_array'?

    Skip
    446F63746F722057686F

 

 
Page 2 of 23 FirstFirst 123412 ... LastLast

Similar Threads

  1. Local Sales Tax Mod - Support Thread
    By LadyHLG in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 633
    Last Post: 13 Jun 2022, 09:25 PM
  2. v151 codeTrio Sales Summary Graph v1.0 [Support Thread]
    By imranulh in forum All Other Contributions/Addons
    Replies: 15
    Last Post: 25 Jul 2020, 04:00 AM
  3. v151 Sales Report with Graphs support thread
    By JacobBushnell in forum Addon Admin Tools
    Replies: 17
    Last Post: 25 Jul 2019, 02:27 PM
  4. Monthly Sales Report
    By Bruce1952 in forum General Questions
    Replies: 3
    Last Post: 10 Aug 2010, 01:06 PM
  5. Sales Tax Summary Report
    By fred_artemis in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 25 Mar 2008, 02:54 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR