Hi, I have a website that contains over 1,000 products and they were all imported via CSV. I just noticed that all of my products do not show up in categories nor searches as products, but can be accessed via permalink.
I have done a whole whopping 5+ hours of research and found one solution and that is to go into each product's edit page and update it manually.
Is there any way I can put in some kind of MySQL query to do this for all of the products to save time? Or is updating each of the products individually the only way to do it?