Update Regions and stock level for each inventory by SQL

masqueunaweb

Hi!

I'm trying to update the regions and the stock level for each inventory by SQL.

1) For updating the regions, i have change them in the wp_atum_inventories table on the column region, folowing the same than other one that are correct, and then save, but when i go to the product, and check that variation, is still the same, why?

2) Also, how can i update the stock by SQL? i don't find it in any table.

The most important is the 1), thank you!

Salva

Hi masqueunaweb

I'm sorry, but custom development is out of the scope of our support service.
But why don't you use the ATUM API to retrieve that data instead of SQL?

https://stockmanagementlabs.github.io/atum-rest-api-docs/#introduction

But if you really need to get information directly from the database, you not only have to get it from "wp_atum_inventories", you will have to check other tables too:

wp_atum_inventory_locations
wp_atum_inventory_regions
wp_atum_inventory_meta
And for the main inventories, it is still using some WC meta keys, so wp_postmeta

I hope this helps.

Best Regards,
Salva.