PowerBuilder

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

See more Shopify Examples

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

integer li_rc
integer li_Success
oleobject loo_Http
oleobject loo_JsonRequestBody
string ls_Url
oleobject loo_Resp
oleobject loo_JsonResponse
integer li_Inventory_levelInventory_item_id
integer li_Inventory_levelLocation_id
integer li_Inventory_levelAvailable
string ls_Inventory_levelUpdated_at
string ls_Inventory_levelAdmin_graphql_api_id

li_Success = 0

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

loo_Http = create oleobject
li_rc = loo_Http.ConnectToNewObject("Chilkat.Http")
if li_rc < 0 then
    destroy loo_Http
    MessageBox("Error","Connecting to COM object failed")
    return
end if

loo_Http.Login = "SHOPIFY_PRIVATE_API_KEY"
loo_Http.Password = "SHOPIFY_PRIVATE_API_KEY"

// Also see: How to retrieve inventory levels

loo_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

loo_JsonRequestBody = create oleobject
li_rc = loo_JsonRequestBody.ConnectToNewObject("Chilkat.JsonObject")

loo_JsonRequestBody.UpdateInt("location_id",6884556842)
loo_JsonRequestBody.UpdateInt("inventory_item_id",12250274365496)
loo_JsonRequestBody.UpdateInt("available_adjustment",1)

ls_Url = "https://{shop}.myshopify.com/admin/api/2020-04/inventory_levels/adjust.json"

loo_Resp = create oleobject
li_rc = loo_Resp.ConnectToNewObject("Chilkat.HttpResponse")

li_Success = loo_Http.HttpJson("POST",ls_Url,loo_JsonRequestBody,"application/json",loo_Resp)
if li_Success = 0 then
    Write-Debug loo_Http.LastErrorText
    destroy loo_Http
    destroy loo_JsonRequestBody
    destroy loo_Resp
    return
end if

Write-Debug "Response Status Code: " + string(loo_Resp.StatusCode)

loo_JsonResponse = create oleobject
li_rc = loo_JsonResponse.ConnectToNewObject("Chilkat.JsonObject")

loo_JsonResponse.Load(loo_Resp.BodyStr)
loo_JsonResponse.EmitCompact = 0
Write-Debug loo_JsonResponse.Emit()

if loo_Resp.StatusCode >= 300 then
    Write-Debug "Failed."
    destroy loo_Http
    destroy loo_JsonRequestBody
    destroy loo_Resp
    destroy loo_JsonResponse
    return
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"
// ...
//   }
// }
// 

li_Inventory_levelInventory_item_id = loo_JsonResponse.IntOf("inventory_level.inventory_item_id")
li_Inventory_levelLocation_id = loo_JsonResponse.IntOf("inventory_level.location_id")
li_Inventory_levelAvailable = loo_JsonResponse.IntOf("inventory_level.available")
ls_Inventory_levelUpdated_at = loo_JsonResponse.StringOf("inventory_level.updated_at")
ls_Inventory_levelAdmin_graphql_api_id = loo_JsonResponse.StringOf("inventory_level.admin_graphql_api_id")


destroy loo_Http
destroy loo_JsonRequestBody
destroy loo_Resp
destroy loo_JsonResponse