[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, 2024 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 😉