DataFlex

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: DataFlex

Use ChilkatAx-win32.pkg

Procedure Test
    Boolean iSuccess
    Handle hoHttp
    Variant vJsonRequestBody
    Handle hoJsonRequestBody
    String sUrl
    Variant vResp
    Handle hoResp
    Handle hoJsonResponse
    Integer iInventory_levelInventory_item_id
    Integer iInventory_levelLocation_id
    Integer iInventory_levelAvailable
    String sInventory_levelUpdated_at
    String sInventory_levelAdmin_graphql_api_id
    String sTemp1
    Integer iTemp1

    Move False To iSuccess

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

    Get Create (RefClass(cComChilkatHttp)) To hoHttp
    If (Not(IsComObjectCreated(hoHttp))) Begin
        Send CreateComObject of hoHttp
    End

    Set ComLogin Of hoHttp To "SHOPIFY_PRIVATE_API_KEY"
    Set ComPassword Of hoHttp To "SHOPIFY_PRIVATE_API_KEY"

    // Also see: How to retrieve inventory levels

    Set ComAccept Of hoHttp To "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

    Get Create (RefClass(cComChilkatJsonObject)) To hoJsonRequestBody
    If (Not(IsComObjectCreated(hoJsonRequestBody))) Begin
        Send CreateComObject of hoJsonRequestBody
    End
    Get ComUpdateInt Of hoJsonRequestBody "location_id" 6884556842 To iSuccess
    Get ComUpdateInt Of hoJsonRequestBody "inventory_item_id" 12250274365496 To iSuccess
    Get ComUpdateInt Of hoJsonRequestBody "available_adjustment" 1 To iSuccess

    Move "https://{shop}.myshopify.com/admin/api/2020-04/inventory_levels/adjust.json" To sUrl

    Get Create (RefClass(cComChilkatHttpResponse)) To hoResp
    If (Not(IsComObjectCreated(hoResp))) Begin
        Send CreateComObject of hoResp
    End
    Get pvComObject of hoJsonRequestBody to vJsonRequestBody
    Get pvComObject of hoResp to vResp
    Get ComHttpJson Of hoHttp "POST" sUrl vJsonRequestBody "application/json" vResp To iSuccess
    If (iSuccess = False) Begin
        Get ComLastErrorText Of hoHttp To sTemp1
        Showln sTemp1
        Procedure_Return
    End

    Get ComStatusCode Of hoResp To iTemp1
    Showln "Response Status Code: " iTemp1

    Get Create (RefClass(cComChilkatJsonObject)) To hoJsonResponse
    If (Not(IsComObjectCreated(hoJsonResponse))) Begin
        Send CreateComObject of hoJsonResponse
    End
    Get ComBodyStr Of hoResp To sTemp1
    Get ComLoad Of hoJsonResponse sTemp1 To iSuccess
    Set ComEmitCompact Of hoJsonResponse To False
    Get ComEmit Of hoJsonResponse To sTemp1
    Showln sTemp1

    Get ComStatusCode Of hoResp To iTemp1
    If (iTemp1 >= 300) Begin
        Showln "Failed."
        Procedure_Return
    End

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

    Get ComIntOf Of hoJsonResponse "inventory_level.inventory_item_id" To iInventory_levelInventory_item_id
    Get ComIntOf Of hoJsonResponse "inventory_level.location_id" To iInventory_levelLocation_id
    Get ComIntOf Of hoJsonResponse "inventory_level.available" To iInventory_levelAvailable
    Get ComStringOf Of hoJsonResponse "inventory_level.updated_at" To sInventory_levelUpdated_at
    Get ComStringOf Of hoJsonResponse "inventory_level.admin_graphql_api_id" To sInventory_levelAdmin_graphql_api_id


End_Procedure