[SOLVED] How BO product list is cached?

[frkosk]

Hello everyone,

I’m currently dealing with an issue in version 8.1.7. After making changes in the database – updating product categories and changing their default category – the product list in the BO still shows the original default category. The data updates correctly only after I open the product and save it without making any further changes.

In the database, I’m modifying the table ps_category_product to update individual product categories, and in ps_product, I’m changing the default category.

I’ve tried clearing the cache and reindexing the products, but nothing has worked.

Any ideas or suggestions?

Thank you

Edited December 5 by frkosk (see edit history)

[Prestashop Addict]

Hi, you mean you changed directly in database?

[frkosk]

17 minutes ago, Prestashop Addict said:

Hi, you mean you changed directly in database?

Yes, directly in database.

[Prestashop Addict]

😞 You must change id also in ps_product_shop and ps_category_product

[frkosk]

41 minutes ago, Prestashop Addict said:

😞 You must change id also in ps_product_shop and ps_category_product

Prestashop Addict, thank you for your response. While working on the SQL query, I had no idea it was also stored in the ps_product_shop table. It’s working perfectly now.

[Prestashop Addict]

Don't forget to change your title post by adding [SOLVED] and add a Thanks or Like to the good answer, this will help community.

[frkosk]

12 minutes ago, Prestashop Addict said:

Don't forget to change your title post by adding [SOLVED] and add a Thanks or Like to the good answer, this will help community.

Yes sir! And thank you 😉