The requested qty is not available (truncate inventory_reservation Table)

[steveberrill]

Even though i installed this module to block writing to the inventory_reservation table. There were entries added before so they were still causing problems and was not able to order the sku products that still existed in this table

Would be good for the module to truncate this table when the module is installed/enabled.

[convenient]

@kingberrill Great point!

I wonder whether it would be better to do this as a CLI command so that it could be run asynchronously from the setup:upgrade deployment. On databases with massive numbers of products/reservations it could increase the downtime on deployment. Something like php bin/magento ampersand:disable-stock-reservation:truncate-reservations or something like that.

I don't have capacity for this right now, but I've added some labels and will also add a note to the README.md to truncate that table after installing

[maxacarvalho]

Hello @convenient

I wonder if you simply mean that the inventory_reservation should be truncated by running truncate table inventory_reservation; directly in the database or if it's something that should be done from the application?

Thanks.

[convenient]

@maxacarvalho Directly in the database, sorry for lack of clarity.

[maxacarvalho]

No problem @convenient, thank you very much.

[convenient]

@maxacarvalho Also make sure to test everything locally, never do this kind of thing directly on prod without backups and testing first.

[maxacarvalho]

Hi @convenient

Sure, it's being tested in our development environment at the moment. Thank you very much once again.

[jamacio]

@kingberrill Great point!

I wonder whether it would be better to do this as a CLI command so that it could be run asynchronously from the setup:upgrade deployment. On databases with massive numbers of products/reservations it could increase the downtime on deployment. Something like php bin/magento ampersand:disable-stock-reservation:truncate-reservations or something like that.

I don't have capacity for this right now, but I've added some labels and will also add a note to the README.md to truncate that table after installing

I implemented the solution on command, I hope I can help you #49

the command looks like this
bin/magento ampersand:disable-stock-reservation inventory-reservation
has the possibility to add more tables

[gentookid]

Hey all, well.. Just stomped across here and tried the module.
Upon installing it (magento 2.4.3-p2), I tried to run:
bin/magento ampersand:disable-stock-reservation inventory-reservation

And found that the plugin is not being recognized properly, it does not belong to a namespace..
Should I directly go and truncate the table?

Regards

[convenient]

@gentookid that was never merged i'm afraid, sorry.

Manually truncate the table please

[gentookid]

Correct, although I seem to be missing the inventory-reservation table, what I do have is:
inventory_stock_1
inventory_stock_1.website_id
inventory_stock_1.is_salable
inventory_stock_1.product_id
inventory_stock_1.quantity
inventory_stock_1.sku
inventory_stock_1.stock_id

Could it be something differs in the schema from versions?

[convenient]

The table is inventory_reservation

It should be there is you have the inventory tables installed