I am using Power Automate to automatically update products, including variants via a SQL DB. However, when I perform the action of passing all the products that need to be updated with their location id, inventory item id and available quantity using a PUT request to the url ending with
/admin/api/2022-01/inventory_levels/set.json and according to these instructions: Manage product inventory with the Admin API (shopify.dev).
every variant that is associated with a product, gets deleted. For example, before updating quantities, Variant A will have a quantity of 8, Variant B will have a quantity of 18, and Variant C will have a quantity of 4. After running the workflow to set each quantity to 5, Variant A will have a quantity of 5 but Variant B and C will not exist. I have seen threads of this happening to people before but am looking for a more updated solution as those threads are quite old. Any help is appreciated!