(Visual Basic 6.0) Shopify Update Inventory Level for a Product (Adjust available quantity)

Use the adjust endpoint with the location ID and inventory item ID to increase or decrease the available quantity for an inventory level:

For more information, see https://shopify.dev/tutorials/manage-product-inventory-with-admin-api#update-inventory-levels-for-a-product-variant

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

' This example requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

Dim http As New ChilkatHttp

http.Login = "SHOPIFY_PRIVATE_API_KEY"
http.Password = "SHOPIFY_PRIVATE_API_KEY"

' Also see: How to retrieve inventory levels

http.Accept = "application/json"

' The following JSON is sent in the request body:

' {
'   "location_id": 6884556842,
'   "inventory_item_id": 12250274365496,
'   "available_adjustment": 1
' }

' Use this online tool to generate the code from sample JSON: 
' Generate Code to Create JSON

Dim jsonRequestBody As New ChilkatJsonObject
success = jsonRequestBody.UpdateInt("location_id",6884556842)
success = jsonRequestBody.UpdateInt("inventory_item_id",12250274365496)
success = jsonRequestBody.UpdateInt("available_adjustment",1)

Dim url As String
url = "https://{shop}.myshopify.com/admin/api/2020-04/inventory_levels/adjust.json"

Dim resp As ChilkatHttpResponse
Set resp = http.PText("POST",url,jsonRequestBody.Emit(),"utf-8","application/json",0,0)
If (http.LastMethodSuccess <> 1) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Debug.Print "Response Status Code: " & resp.StatusCode

Dim jsonResponse As New ChilkatJsonObject
success = jsonResponse.Load(resp.BodyStr)
jsonResponse.EmitCompact = 0
Debug.Print jsonResponse.Emit()

If (resp.StatusCode >= 300) Then
    Debug.Print "Failed."

    Exit Sub
End If

' Sample output...
' (See the parsing code below..)
' 
' Use the this online tool to generate parsing code from sample JSON: 
' Generate Parsing Code from JSON

' {
'   "inventory_level": {
'     "inventory_item_id": 12250274365496,
'     "location_id": 6884556842,
'     "available": 9,
'     "updated_at": "2018-06-26T15:04:49-04:00",
' ...
'     "admin_graphql_api_id": "gid://shopify/InventoryLevel/6485147690?inventory_item_id=12250274365496"
' ...
'   }
' }
' 

Dim inventory_levelInventory_item_id As Long
inventory_levelInventory_item_id = jsonResponse.IntOf("inventory_level.inventory_item_id")
Dim inventory_levelLocation_id As Long
inventory_levelLocation_id = jsonResponse.IntOf("inventory_level.location_id")
Dim inventory_levelAvailable As Long
inventory_levelAvailable = jsonResponse.IntOf("inventory_level.available")
Dim inventory_levelUpdated_at As String
inventory_levelUpdated_at = jsonResponse.StringOf("inventory_level.updated_at")
Dim inventory_levelAdmin_graphql_api_id As String
inventory_levelAdmin_graphql_api_id = jsonResponse.StringOf("inventory_level.admin_graphql_api_id")