We're a bookshop migrating to Odoo Online from another eCommerce system, bulk importing our existing products.
It's critically important that the store can be sorted accurately by release date of each book.
However it seems that the 'Newest Arrivals' sort order only works off the create_date
of the product record, which for all our existing products will be the same from the bulk import.
Even for new books this will be a problem, as a highly anticipated book might get created many months in advance, and thus it will have the incorrect chronological position with the 'Newest Arrivals' sorting.
I understand in Odoo Online it's not possible to create custom sort orders or to change how the field that 'Newest Arrivals' references.
I have also tried overwriting create_date
with an automation as a hack, but unsurprisingly this doesn't seem to be possible.
Does anyone have a workaround suggestion for this?