Updating Inventory in Database

[kallym]

Is it okay to update the inventory directly in the database in ps_product_attribute?

I made a form that pulls in id_product, ps_product_lang.name, ps_attribute_lang.name (so I can see what I am updating), quantity and default_on. All I need to update is the quantity (and default_on if needed). I just want to make sure it won't mess up anything else.

I guess what I am asking is if there are any other tables updated when increasing or decreasing inventory within the Prestashop admin area that would be adverseley affected if I updated the quantity directly within the database? The stock_mvt tables would not be updated, but will that matter?

Thank you!

[bellini13]

I think if stock management is enabled, and you manually change the attribute table, it could cause a probably where the stock mgt thinks you are out of stock, although the product does in deed have stock.

Not really sure though, would need to explore that code in more detail to see how stock_mvt tables are used.

[kallym]

I am using stock management so need to be sure it wouldn't mess anything up, especially since this is a live shop. Does anyone know if manually updating the quantity in the database would create a problem in the stock_mvt tables?