Critical Bug: Automatic Product Duplication with the Same ID in Prestashop 9

[giuse]

Hello everyone,

I'm facing a very serious and unusual issue on Prestashop 9 that I can't solve, and I need your help to understand the origin of this bug.

The problem starts when I access the back-office and open a product page to view, edit, or save it. Prestashop automatically creates a duplicate record in the catalog. The most anomalous thing is that the new record has the exact same ID as the original product.

For context, this duplication occurs specifically in the ps_stock_available table, which manages quantities. My Prestashop 9 installation is clean, contains only core modules, and the products were imported from a Prestashop 1.7 site.

Details of the problem:

In the catalog, two identical products appear with the same ID.

One of the two records is set to published (active = 1) but with a quantity of zero.

The other record is unpublished (active = 0) but has the correct quantity.

This behavior occurs for most of my products, but NOT ALL, and affects both products with and without combinations.

Attempting to delete one of the two records results in both being deleted.

Even after clearing the cache or cleaning up orphaned data, the problem persists and reappears every time I open a product.

What I've already done (without success):

I've tried to fix the data inconsistency with several SQL queries, but the issue keeps recurring. I have ruled out common causes like orphaned records and incorrect settings for the depends_on_stock and out_of_stock fields.

This behavior points to a deep anomaly in Prestashop's logic, likely caused by a bug in a module or a corrupted override file.

Has anyone ever encountered a problem with automatic product duplication with the same ID upon opening it in the back-office? Any suggestions on how to diagnose the origin of this issue (for example, which specific tables or core files I should inspect) would be extremely helpful.

Thank you in advance for your time and assistance.

[cocos.codes]

You have already posted this topic on the Italian/Espaniol forum. There is no need to duplicate posts.