My goal is to sort products on the frontend from newest to oldest.
The products CSV file contains the created_at
column (e.g. 2020-10-31 14:05:44
). Format seems to be correct.
After the standard import, I'm looking in the catalog_product_entity
table, and created_at
is actually the import's timestamp (e.g. 2020-11-28 17:38:48
).
Am I looking at the wrong DB field? Is there some locale-specific formatting under the hood? (I'm importing for the ro
store)
References
- The Complete Guide to Magento 2 Product Import / Export
- Importing system attribute "created_at" with a timestamp
- date issues in magento 2.3.3
Versions: Magento 2.3.5-p1, PHP 7.3.24