I want to update the inventory quantity based product SKU automatically every day. I have product SKU and its quantity stored in the SQL Server database. I was thinking to make GraphQL API call from the server where the database is present and update the inventory. Is it possible?
Suggestions of a better way would be really appreciated.
You can definitely update inventory via GraphQL using the Admin API. If you are not storing the ID of the inventory matched with SKU locally you will need to look up the inventory items with the SKU beforehand. Here is a tutorial that shows both REST and GraphQL ways to update inventory in Shopify.
|2 hours ago|