Inventory Update

Step1. Get itemSKU and facilityCode from the inventory event received from WMS.

Inventory Event:

{
    "account_slug": "teknodome",
    "account_id": 470,
    "externalWmsAccount": "eshopbox",
    "publishedAt": "2021-07-22 14:47:47",
    "externalChannelID": "CH1114",
    "locationId": "05593b4c-eb61-471a-8642-e11f40fb02",
    "connectionId": 294,
    "inventoryList": [
        {
            "changeInStock": 39,
            "productId": "Toshiba USB 128 GB U202W",
            "locationInventory": "39",
            "variantId": "Toshiba USB 128 GB U202W",
            "sku": "testsku7",
            "inventory": "39"
        }
    ],
    "message_id": "30210792",
    "externalWmsChannelName": "AMAZON_PRIME_TEKNODOME_XBLR_1028",
    "externalWarehouseID": "ESBBLR_111"
}

Step2. Get Tenant name and access token from “ie_appinstall_connection” table and prepare the Adjust Inventory API.

Sample API:

https://{tenant_name}.unicommerce.com/services/rest/v1/inventory/adjust/bulk

Step3. Using the extracted keys, prepare the request body

Keys	Values

Keys	Values
`itemSKU`	`productId`
`quantity`	`locationInventory`
`shelfCode`	"`default"`
`adjustmentType`	“REPLACE”
`facilityCode`	locationId
`transferToShelfCode`	`"Yes"`
`inventoryType`	“`GOOD_INVENTORY`“

Request Body:

{
    "inventoryAdjustments": [
        {
            "itemSKU": "test_inventory_check",
            "quantity": 130,
            "facilityCode": "Test",
            "shelfCode": "default",
            "inventoryType": "GOOD_INVENTORY",
            "transferToShelfCode": "Yes",
            "adjustmentType": "REPLACE",
        }
    ]
}

Step4. Make a HTTP POST request on the above prepared URL along with the request body.

Step5. Response:

{
    "successful": true,
    "message": null,
    "errors": null,
    "warnings": null,
    "inventoryAdjustmentResponses": [
        {
            "facilityInventoryAdjustment": {
                "itemSKU": "test_inventory_check",
                "quantity": 130,
                "shelfCode": "default",
                "inventoryType": "GOOD_INVENTORY",
                "transferToShelfCode": "Yes",
                "sla": null,
                "batchCode": null,
                "adjustmentType": "REPLACE",
                "remarks": null,
                "forceAllocate": true,
                "facilityCode": "Test"
            },
            "successful": true,
            "errors": []
        }
    ]
}

Apps and Automations

Inventory Update

Related content