[SOLVED] What db table stores the total product stock quantity?

[BlackEngine]

Hi!

I have a misalignment in the last item (qty: 36), it happents after deleting all of its variations and recreating them. The real stock is correct, but the total quantities in stock shown in the backoffice does not correspond, so I assume that something happent in-between when deleting, creating and saving changes.

I would like to locate the right table so I can try fixing it with the actual stock quantity.

Does someone know where it's stored in the database?

Thank you.

Edited December 27, 2024 by BlackEngine (see edit history)

[Daresh]

It is the ps_stock_available table in the database. The entry with id_product_attribute = 0 corresponds with the sum stock of all the combinations.

[BlackEngine]

15 minutes ago, Daresh said:

It is the ps_stock_available table in the database. The entry with id_product_attribute = 0 corresponds with the sum stock of all the combinations.

Thank you for your answer, but it does not store the total stock quantity. Also, its name tells you what it stores: ID of the product attribute.

[Daresh]

Please read carefully

Table: ps_stock_available

Entry with is_product_attribute = 0 - total quantity row

Column: quantity

[BlackEngine]

Ok, I got what it's happening, I think. There are other entries for the same product ID, and the total of them is: 36.

Do you think that deleting these, minus the last 2 ones should fix it? And also ,why could that happend?

 

Edited December 27, 2024 by BlackEngine (see edit history)

[BlackEngine]

23 minutes ago, Daresh said:

Please read carefully

Table: ps_stock_available

Entry with is_product_attribute = 0 - total quantity row

Column: quantity

Ok, I got what it's happening, I think. There are other entries for the same product ID, and the total of them is: 36.

Do you think that deleting these, minus the last 2 ones should fix it? And also ,why could that happend?

[Daresh]

Maybe there are leftovers after deleting / regenerating combinations?

You should delete all entries that have id_product_attribute > 0 and do not exist in the ps_product_attribute table.

[BlackEngine]

Ok, solved. After deleting all entries with unmatched id_product_attribute it got synced.

Thank you!