Page 19 of 19 FirstFirst ... 9171819
Results 181 to 185 of 185
  1. #181
    Join Date
    Nov 2007
    Location
    Woodbine, Georgia, United States
    Posts
    3,717
    Plugin Contributions
    60

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

    I don't have a SQL 5.7 environment to solve this right now
    PRO-Webs, Inc. :: Recent Zen Cart Projects :: Zen Cart SEO 12 Steps to Success
    **I answer questions in the forum, private messages are NOT answered. You are welcome to contact us via our website for professional engagements.

  2. #182
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    7,180
    Plugin Contributions
    96

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

    Quote Originally Posted by dbltoe View Post
    Environment: A new 1.5.4 site with display logs, encrypted master password, inventory report, and monthly sales installed in the admin.

    When I select a state and then click on Filter, everything works well. If I then select a status other than all orders, I get the following debug.Possibly 1.5.4?
    OK I would guess that in stats_monthly_sales.php" line 292 you should remove the appending of $zone_only_sql to the query. This references fields in the orders table, and the query on line 192 is only against the orders status table.
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.

  3. #183
    Join Date
    Mar 2018
    Location
    Alabama
    Posts
    63
    Plugin Contributions
    0

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

    Version 1.5.4.

    Have been using this for a while and love it. Now I need to add something to it. I have a field in my products table called products_vendor_code. I need to add this to the report. I know the report comes from the orders table. How do I add this new info from the products table?

  4. #184
    Join Date
    Apr 2007
    Location
    Ontario, Canada
    Posts
    1,590
    Plugin Contributions
    19

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

    Quote Originally Posted by Speak394 View Post
    Version 1.5.4.

    Have been using this for a while and love it. Now I need to add something to it. I have a field in my products table called products_vendor_code. I need to add this to the report. I know the report comes from the orders table. How do I add this new info from the products table?

    If the products_vendor_code is stored in the orders table already you can simply add it to the lookup and publish the data the way the report publishes data. If you need to make a new column be certain to add the heading row and data row separately.
    Twitch.
    http://www.twitchtoo.com - Do you work for free? Please donate.
    Twitch Wholesale + Attributes, ZC 1.38 - 1.56c - Expert Site Migration & Upgrades!

  5. #185
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    7,180
    Plugin Contributions
    96

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

    This data is product based I assume, right? Since Monthly Sales and Tax Summary Report is order based, you might want to look at Sales Report or another mod that does product based breakdown. (Unless you can aggregate the vendor data in a way that makes sense per order.)
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.

 

 
Page 19 of 19 FirstFirst ... 9171819

Similar Threads

  1. v151 Sales Report with Graphs support thread
    By JacobBushnell in forum Addon Admin Tools
    Replies: 17
    Last Post: 25 Jul 2019, 02:27 PM
  2. Local Sales Tax Mod - Support Thread
    By LadyHLG in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 616
    Last Post: 3 Jul 2019, 09:30 PM
  3. v151 codeTrio Sales Summary Graph v1.0 [Support Thread]
    By imranulh in forum All Other Contributions/Addons
    Replies: 9
    Last Post: 20 May 2015, 01:10 AM
  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