Jump to content

Using phpMyAdmin to update all products?


Recommended Posts

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

image.png.55d2a89486e59c645c229c27f8aa12ff.png

Edited by theansible (see edit history)
Link to comment
Share on other sites

  • theansible changed the title to Using phpMyAdmin to update all products?

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...