This product was added to our catalog date

[muah]

Hello to all. Question, I erased a product that was on my site for years. I made a mistake. I now need to put that item back but the bottom says "This product was added to our catalog on [today's date]" Since this particular item is an older version of the design (We create new versions every couple years and upload that as a separate new SKU, separate UPC...totally new product for each variation), i want the erased item to read the date it was added years ago. How can i change that back?

[dbltoe]

Simplest method is to add the item and change the product_date_added in the database's products table using phpMyAdmin.

Or run the following from YOUR_ADMIN >> Tools >> Install SQL Patches after changing the ### to the new product's ID

UPDATE products SET products_date_added = NOW() WHERE products_id = '###';

NOTE: if you're your database has a prefix to the products table name, you will need to match that in the code. i.e., if you have a prefix of Zen_, the code would be

UPDATE zen_products SET products_date_added = NOW() WHERE products_id = '###';

[mc12345678]

Note though about the table prefix, for ZC 1.5.7 (and many of the more recent versions), the DB_PREFIX is not required to be added when using the Install SQL Patches tool as the tool is expected (generally speaking) to address the prefix.
Put another way, the second query above is applicable to phpMyAdmin not to ZCs Install SQL Patches Tool.

Pssstttt.. dbltoe, thought they wanted to change the date to some old date rather than NOW()...

Normally, the date is stored in a YYYY-MM-DD hh:mm:ss format
so if wanted it to be entered on December 18, 2018 then:

UPDATE products SET products_date_added = '2018-12-18 00:00:00' WHERE products_id = '###';

again replacing the ### with the products_id should update to indicate that the product was added at midnight on that day.

[dbltoe]

I was playing with now() meaning to change it to the date later.


Forgot about the prefix non-use in the admin.

Gotta get more sleep

[muah]

other than looking at the top of the URL to find products_id...where do i find the products_id?

[swguy]

Go to Admin > Catalog > Categories Products, search for the product and the ID is on the left hand side.

[muah]

Follow up... worked well. thank you to all.