I'm trying to figure out how can I change the
created_at date of a product.
can somebody point me in the right direction on how to do it?
I can't even find where it's stored in the database.
Magento Stack Exchange is a question and answer site for users of the Magento e-Commerce platform. It only takes a minute to sign up.Sign up to join this community
Usually this would be handled automatically by Magento it self.
The structure of the data is a MySQL DateTime format
YYYY-MM-DD HH:MM:SS and is stored within the
catalog_product_entity (although other tables will store this information for individual elements of data as well)
You should be able to update it by using the Magento model.
$model = Mage::getModel('catalog/product')->load(1); $model->setCreatedAt('2015-01-01 09:00:00'); $model->save();
Note however that you may require to be within the admin context as front end product model may not allow saving of the product for security reasons.