Is there a way to see what the last product I added to the catalog?
Printable View
Is there a way to see what the last product I added to the catalog?
Use phpmyadmin to find the last row in "products"Quote:
Originally Posted by gws76
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
Please explain the steps in.Quote:
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!:clap::clap::clap:
Open phpmyadminQuote:
Originally Posted by gws76
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")
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.