/
Update Inventory Flow

Update Inventory Flow

Owned by Shreyasi Prasad (Unlicensed)
Jun 15, 2022
2 min read

  1. WMS Publishes a UpdateInventory event to Pub/Sub. Sample UpdateInventory event from WMS:

    { "inventoryList": [ { "productId": "12334", "parentId": null, "sku": "32CVB3GJA87", "variantId": 12334, "inventory": "24", "locationInventory": "12", "changeInStock": 0, } ], "account_id": 124, "account_slug": "Account Slug", "externalWmsChannelName": "External WMS ChannelName", "externalWmsAccount": "External WMS Account", "externalWarehouseID": "FSL4", "externalChannelID": "CH0566", "connectionId":"12", "channelSlug": null, "locationId": "3425567898876543456786", "publishedAt": "2020-07-21 19:49:47" }

  2. EshopboxInventoryService listens to the UpdateInventory event from Pub/Sub and pushes it to TaskQueue.

  3. TataCliqInventoryListener listens to the event from TaskQueue and sends it for processing to TataCliqInventoryService.

  4. In TataCliqInventoryService, we extract access token from the cache. If not present in the cache, then:

    1. connect to the database and get the access token using connectionId by running the following query on the table “ie_appinstall_connection“:

      SELECT ie_appinstall_connection.accessToken FROM ie_appinstall_connection WHERE ie_appinstall_connection.id =:connectionId;

    2. Then save the access token in the cache in the following format:

      { "connectionAccessToken_{{connectionId}}":"{{ACCESS TOKEN}}" }

  5. Then, we create a Request Body by mapping warehouse keys to TataCliq’s API keys:

    1. InventoryUpdate.Item[].SKU-> inventoryList[].sku

    2. InventoryUpdate.Item[].SlaveID->locationId

    3. InventoryUpdate.Item[].Inventory->inventoryList[].locationInventory

    4. InventoryUpdate.Item[].SafetyStock->

  6. We send the request body as a POST request to the following URL to get the response body:

    https://intbatchqa5.tataunistore.com/PartnerConnect/PC_125050/AP_INVENTORY/AV_1.0/OG_1

    Sample request body:

    { "InventoryUpdate": { "Item": [ { "SKU": "CSW6598", "SlaveID": "SHSR", "Inventory": "2000", "SafetyStock": "1000" }, { "SKU": "CSW659", "SlaveID": "SHSR", "Inventory": "2000", "SafetyStock": "1000" }, { "SKU": "CSW6598", "SlaveID": "SHSR", "Inventory": "2000", "SafetyStock": "0" } ] } }

    Sample response body:

    { "InventoryUpdate": { "Item": [ { "SELLERCODE": "Seller_ID", "PRODUCTSKU": "CSW6598", "STORECODE": "SHS", "PRODUCTSTOCK": "2000", "SAFTYSTOCKY": "1000", "STATUS": "FAIL TO UPLOAD", "REASON": "SLAVE INACTIVE OR DOESN'T EXIST." }, { "SELLERCODE": "Seller_ID", "PRODUCTSKU": "CSW6598", "STORECODE": "SHSR", "PRODUCTSTOCK": "2000", "SAFTYSTOCKY": "1000", "STATUS": "UPLOAD FAILED", "REASON": "PRODUCT DELISTED OR DOES NOT EXIST" }, { "SELLERCODE": "Seller_ID", "PRODUCTSKU": "CSW6598", "STORECODE": "SHSR", "PRODUCTSTOCK": "2000", "SAFTYSTOCKY": "0", "STATUS": "RECORD UPDATED", "REASON": "RECORD CORRECT" } ] } }

 

Related content