pablofr Posted September 18, 2019 Share Posted September 18, 2019 (edited) Hello, After upgrading PS from 1.6 to 14.7, none of my products are visible online. If I want them to be visible I have to go to the admin and open it and save it. After this action it is displayed. I have 6000 products so I can't do this action as many times as I have a product. Do you have an idea to do this in the database? Know the value to be updated ? Thank you Pablo Edited September 19, 2019 by pablofr (see edit history) Link to comment Share on other sites More sharing options...
tuk66 Posted September 19, 2019 Share Posted September 19, 2019 Visible products have set active = 1 in two tables: ps_product ps_product_shop Link to comment Share on other sites More sharing options...
pablofr Posted September 19, 2019 Author Share Posted September 19, 2019 Thank you, I have check all product are set active = 1 in ps_product & ps_product_shop. This must be another option. Link to comment Share on other sites More sharing options...
tuk66 Posted September 19, 2019 Share Posted September 19, 2019 What about the "available_for_order" field? Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now