Hello, my question is on Odoo 8.

My customers have created a lot of locations (A001, A002, B001...), but it have the wrong parent location.

I have done an SQL request to change the location_id (the parent id) and the complete name. 

Then, when they go on product on these locations, the product_available fields ignore quants on these locations... (but when i click to see quants i see the correct quantities).

I've find in the code that an SQL request is done for the group_by clause, it search ids between of parent_left and parent_right.
But i didn't updated parent_left and parent_right of the parent in my own request.

How does the parent location is working ? and how can i solve my problem to compute available quantity correctly ?
Thank you, have a good day