Visual FoxPro

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: Visual FoxPro

LOCAL lnSuccess
LOCAL loHttp
LOCAL loJsonRequestBody
LOCAL lcUrl
LOCAL loResp
LOCAL loJsonResponse
LOCAL lnInventory_levelInventory_item_id
LOCAL lnInventory_levelLocation_id
LOCAL lnInventory_levelAvailable
LOCAL lcInventory_levelUpdated_at
LOCAL lcInventory_levelAdmin_graphql_api_id

lnSuccess = 0

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

loHttp = CreateObject('Chilkat.Http')

loHttp.Login = "SHOPIFY_PRIVATE_API_KEY"
loHttp.Password = "SHOPIFY_PRIVATE_API_KEY"

* Also see: How to retrieve inventory levels

loHttp.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

loJsonRequestBody = CreateObject('Chilkat.JsonObject')
loJsonRequestBody.UpdateInt("location_id",6884556842)
loJsonRequestBody.UpdateInt("inventory_item_id",12250274365496)
loJsonRequestBody.UpdateInt("available_adjustment",1)

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

loResp = CreateObject('Chilkat.HttpResponse')
lnSuccess = loHttp.HttpJson("POST",lcUrl,loJsonRequestBody,"application/json",loResp)
IF (lnSuccess = 0) THEN
    ? loHttp.LastErrorText
    RELEASE loHttp
    RELEASE loJsonRequestBody
    RELEASE loResp
    CANCEL
ENDIF

? "Response Status Code: " + STR(loResp.StatusCode)

loJsonResponse = CreateObject('Chilkat.JsonObject')
loJsonResponse.Load(loResp.BodyStr)
loJsonResponse.EmitCompact = 0
? loJsonResponse.Emit()

IF (loResp.StatusCode >= 300) THEN
    ? "Failed."
    RELEASE loHttp
    RELEASE loJsonRequestBody
    RELEASE loResp
    RELEASE loJsonResponse
    CANCEL
ENDIF

* 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"
* ...
*   }
* }
* 

lnInventory_levelInventory_item_id = loJsonResponse.IntOf("inventory_level.inventory_item_id")
lnInventory_levelLocation_id = loJsonResponse.IntOf("inventory_level.location_id")
lnInventory_levelAvailable = loJsonResponse.IntOf("inventory_level.available")
lcInventory_levelUpdated_at = loJsonResponse.StringOf("inventory_level.updated_at")
lcInventory_levelAdmin_graphql_api_id = loJsonResponse.StringOf("inventory_level.admin_graphql_api_id")

RELEASE loHttp
RELEASE loJsonRequestBody
RELEASE loResp
RELEASE loJsonResponse