Results 1 to 10 of 10
  1. #1
    Join Date
    Mar 2010
    Posts
    75
    Plugin Contributions
    0

    Default Problem with Products Purchased report, numbers way off

    So we have someone helping us out migrating from 1.5.1 (PROD) to 1.5.6c. (TEST). Both sites are PHP 5.3 for now, but we will switch over to PHP 7.3 once TEST bugs have been resolved. On the test site we are finding that the Products Purchased report number are way off:

    1) We have 4,591 products on PROD, and 105,086 on TEST in the report
    2) The numbers sold are also way askew on TEST vs PROD in the report

    In looking thru the forum it seems this may be a known issue on this thread.

    Is there a published fix available for this? If not, rough ETA on when it will be fixed?

  2. #2
    Join Date
    Jul 2012
    Posts
    14,362
    Plugin Contributions
    17

    Default Re: Problem with Products Purchased report, numbers way off

    That patch was incorporated into Zen Cart 1.5.6 in March of this year and is a part of Zen Cart 1.5.6c. Perhaps you could explain more about what the differences are and perhaps what makes it seem like there is an issue?
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...
    Upgraded to Zen Cart V1.5.3 from V1.5.1 from V1.5.0 from V1.3.9h

  3. #3
    Join Date
    Mar 2010
    Posts
    75
    Plugin Contributions
    0

    Default Re: Problem with Products Purchased report, numbers way off

    Quote Originally Posted by mc12345678 View Post
    That patch was incorporated into Zen Cart 1.5.6 in March of this year and is a part of Zen Cart 1.5.6c. Perhaps you could explain more about what the differences are and perhaps what makes it seem like there is an issue?
    On the production site (v 1.5.1) when I go to Reports - Products Purchased, it shows the top selling products in order of the most sold to the least sold. It also displays the number of products that were sold. For example...

    Apples - 689
    Oranges - 600
    Bananas - 589
    Grapes - 549

    Also, on the production site (v 1.5.1), it shows at the bottom of the page: Displaying 1-20 (of 4947 products). I have a total of 4951 products on my site. This would reflect that there are 4 products in my catalog that have never been sold. This seems to be the correct information. It also displays that I have 248 pages of reports in my Products Purchased report.


    On the test site (v 1.5.6c), the top selling products are not in the right order at all, and neither is the number of products purchased. Both are incorrect. For example, it displays this...

    Peaches - 725
    Grapefruit - 675
    Nectarines - 620
    Pineapples - 592

    And on the test site (v 1.5.6c), it shows the following at the bottom of the page: Displaying 1-20 (of 105086 products). This is most likely incorrect since I only have a total of 4951 products on my site. It also has 5255 pages or reports! I have never had that many pages in my Products Purchased report.

  4. #4
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    6,583
    Plugin Contributions
    260

    Default Re: Problem with Products Purchased report, numbers way off

    You can't run 1.5.6c on PHP 5.3. You need to move to at least PHP 5.6.
    That Software Guy, Plugin Moderator. Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Contributions: Quantity Discounts, Better Together, SMS on Sale, Gift Wrap at Checkout, and more.

  5. #5
    Join Date
    Mar 2010
    Posts
    75
    Plugin Contributions
    0

    Default Re: Problem with Products Purchased report, numbers way off

    Sorry my bad, it is running PHP 5.6, I just confirmed. I was traveling and didn't have access to my login.

    Name:  2019-10-05_15-20-04.jpg
Views: 27
Size:  5.5 KB

  6. #6
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    6,583
    Plugin Contributions
    260

    Default Re: Problem with Products Purchased report, numbers way off

    Double check your copy of admin/stats_products_purchased.php vs. a fresh download of 1.5.6c.
    That Software Guy, Plugin Moderator. Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Contributions: Quantity Discounts, Better Together, SMS on Sale, Gift Wrap at Checkout, and more.

  7. #7
    Join Date
    Mar 2010
    Posts
    75
    Plugin Contributions
    0

    Default Re: Problem with Products Purchased report, numbers way off

    Thanks, we just let our developer know.

  8. #8
    Join Date
    Jul 2012
    Posts
    14,362
    Plugin Contributions
    17

    Default Re: Problem with Products Purchased report, numbers way off

    Have products been renamed much/frequently over time? Even with the smallest of variation such as an extra space, a different punctuation mark, etc?

    The method of reporting was modified and there seemed to be the possibility of a change in how many product may get reported based on the "new" criteria. Of course as pointed out, there may be the possibility that the file has not been updated...
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...
    Upgraded to Zen Cart V1.5.3 from V1.5.1 from V1.5.0 from V1.3.9h

  9. #9
    Join Date
    Mar 2010
    Posts
    75
    Plugin Contributions
    0

    Default Re: Problem with Products Purchased report, numbers way off

    I verified that the stats_products_purchased.php file is identical in TEST to the one found in the 1.5.6c download.

    In terms of renaming products... there might have been a few over the years, but nothing sweeping like we are seeing now with the reports.

    Any thoughts on what to do next?

  10. #10
    Join Date
    Mar 2010
    Posts
    75
    Plugin Contributions
    0

    Default Re: Problem with Products Purchased report, numbers way off

    So by reverting back to the old SQL query format in this thread I was able to get the expected results.

    I am stoked it's producing the results we expect, but can someone explain the difference in the old and new queries?

 

 

Similar Threads

  1. Products Purchased report in admin qestion
    By marcopolo in forum General Questions
    Replies: 1
    Last Post: 6 Dec 2015, 01:27 AM
  2. v150 Products Purchased Report
    By swguy in forum Bug Reports
    Replies: 0
    Last Post: 4 Apr 2012, 12:42 PM
  3. Products Purchased Report, breakdown by Attributes
    By sapsaj in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 14 Oct 2009, 09:31 PM
  4. Customizing Products Purchased Report
    By balthajd in forum Managing Customers and Orders
    Replies: 0
    Last Post: 18 Sep 2009, 04:56 PM
  5. Is there a way to shut off the little numbers
    By rush_woman in forum Setting Up Categories, Products, Attributes
    Replies: 3
    Last Post: 30 Jan 2007, 08:30 AM

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