How do I change the date products are added?

Hello,

I just did a new install of zen cart dos any one know how I can fix this problem.

When I add my products to my store at the bottom of the product it show This product was added to our catalog on Wednesday 31 December, 1969. How do I change it to the correct date and year.

Thanks lexxie
https://www.ehaggle.ws
Free online auctions

I am having the same issue. please someone tell us how to correct this. it looks very unprofessional for something like that to be there if you have a professional business.

In other words HELP!!

Thank you

Backup the database first> https://www.zen-cart.com/tutorials/index.php?article=103

You will have to edit the date in the database for these items

Thank you did not know if i posted in correct area since there was no response to the other persons same question.

Ok i read how to do the backup etc but nothing on how to edit the date within the database, can you or someone link me to details step by step.

Again sorry for the double post,

Thanks
Jim

Your web host should have a cpanel for you to edit:
www.your-website.com/cpanel
Then click on the icon called phpMyadmin
click on the database you are using
click on the table called: Products
here you will see the product names and a heading called: products_date_added

Dec 31 1969 is a magic number: the lowest date that MySQL will display when it finds invalid data.

So, it begs the question: what is the actual data in your database set to?
You'll need to use phpMyAdmin to look at the date_added field in your products table. There are various tutorials on phpMyAdmin use available online. Maybe even in your hosting company's help system.

If you've been mussing with date display formats or changing locales or non-english languages that you've set your system to try using an invalid date format and it's confused so it's just displaying that magic value.

DrByte:

Dec 31 1969 is a magic number: the lowest date that MySQL will display when it finds invalid data.

So, it begs the question: what is the actual data in your database set to?
You'll need to use phpMyAdmin to look at the date_added field in your products table. There are various tutorials on phpMyAdmin use available online. Maybe even in your hosting company's help system.

If you've been mussing with date display formats or changing locales or non-english languages that you've set your system to try using an invalid date format and it's confused so it's just displaying that magic value.

I was lost before now i am totally lost by your response lol my brain went into seizures. Think i will let it stay where its at.

Thanks Everyone
Jim

Hi All!
I would like to reset the date that products were added to Zen Cart. I have backed up everything. In the cpanel, I have been able to access my mySQL database. I see the products_added_date file and the earliest date that I have is 7/17/2011.
I don't know if this means anything but my default is 0001-01-01 00:00:00.

I see the file but I do not know how I can change the date. I have tried searching the forum and looking for an answer through search engines with no success. It keeps bringing me back to this post.

Do I change the 0001-01-01 to a date that I would like?

Please help.

Down your product list with easy populate, Change the dates using find and replace in excel. save as csv and upload back to shop.

ZC Newbie:

Hi All!
I would like to reset the date that products were added to Zen Cart. I have backed up everything. In the cpanel, I have been able to access my mySQL database. I see the products_added_date file and the earliest date that I have is 7/17/2011.
I don't know if this means anything but my default is 0001-01-01 00:00:00.

I see the file but I do not know how I can change the date. I have tried searching the forum and looking for an answer through search engines with no success. It keeps bringing me back to this post.

Do I change the 0001-01-01 to a date that I would like?

Please help.