After importing all our products, we forgot to add a column for "show_condition" and set to "1". "condition" is set to "New" (for all products).
So I used phpMyAdmin to update all rows with the below code:
update ps9t_product SET show_condition="1"
It worked: 478 rows affected. (Query took 0.005 seconds.)
All products have "show_condition" set to "1". But when viewing products on the website, Condition is not shown, unless manually set via admin interface. I tried clearing the cache, forcing compilation, etc.. in Advanced Parameters > Performance.
What did I forget? Thanks in advance for any help!
FYI: PrestaShop version: 1.7.8.5