Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2007
    Posts
    151
    Plugin Contributions
    0

    help question What is the last product I added to my catalog?

    Is there a way to see what the last product I added to the catalog?

  2. #2
    Join Date
    Aug 2005
    Location
    Vic, Oz
    Posts
    1,905
    Plugin Contributions
    5

    Default Re: What is the last product I added to my catalog?

    Quote Originally Posted by gws76 View Post
    Is there a way to see what the last product I added to the catalog?
    Use phpmyadmin to find the last row in "products"
    or
    in zencart
    admin->Calalog->Categories / Products
    Use the search box to do a binary search for the highest existing products id
    eg: if you have approx 4000 products
    search for 4100 (result not found)
    search for 3900 (result found)
    search for in between numbers until you find the highest existing number

    nb: exclude matches that are not product id's

  3. #3
    Join Date
    Apr 2007
    Posts
    151
    Plugin Contributions
    0

    Default Re: What is the last product I added to my catalog?

    Please explain the steps in
    Use phpmyadmin to find the last row in "products"
    .

    I was able to do an advance search on the public side of the website, "Search by Date Added" and put in by trial and error begining of the year to today's date until I found the oldest products that pulled up in the search results. I then used your Admin -Catalog/Products search box and was able to locate out those products which was the latest added products. Thank you!

  4. #4
    Join Date
    Aug 2005
    Location
    Vic, Oz
    Posts
    1,905
    Plugin Contributions
    5

    Default Re: What is the last product I added to my catalog?

    Quote Originally Posted by gws76 View Post
    Please explain the steps in .
    Open phpmyadmin
    Select the database
    Browse the table "products"
    Click >> to go to the last record
    Scroll down this list and its the last row on the page
    (which also happens to have the highest "products_id")

  5. #5
    Join Date
    Jul 2012
    Posts
    16,798
    Plugin Contributions
    17

    Default Re: What is the last product I added to my catalog?

    What is the need for knowing what the last product entered was? How is this data being used? Sure can identify the number to the last product that is present, but if after that a product is added then deleted, the number of the next product will normally also be different than any previously.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

 

 

Similar Threads

  1. v153 Display product added/modified count in last 7 days in admin
    By DigitalShadow in forum General Questions
    Replies: 3
    Last Post: 22 Jan 2015, 09:44 PM
  2. Replies: 1
    Last Post: 5 Dec 2013, 12:57 PM
  3. This product was last updated to our catalog on
    By Alexiss in forum General Questions
    Replies: 4
    Last Post: 16 Aug 2011, 02:16 PM
  4. Howto: Change the date a product was added to catalog?
    By wmarcy in forum General Questions
    Replies: 1
    Last Post: 16 May 2006, 01:01 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