Flipkart Update Inventory Sequence Diagram

Steps

Step 1. FlipkartInventoryListener(Subscriber) POST API will receive data like below and will store this data into HashMap

{
    "inventoryList": [
        {
            "productId": "12334",
            "parentId": null,
            "skuId": "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"
}

Step 2. Now use connectionId from the data to fetch accessToken and store it into the cache memory in the following format

Using the below query, accessToken can be generated

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

Once the accessToken is generated store it into the Cache Memory in the format given below.

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

Step 3. Now transform the Data

Request Body

{
    "<sku>": {
        "product_id": "<product_id>",
        "locations": [
            {
                "id": "<location-id>",
                "inventory": 0
            }
        ]
    }
}

Warehouse Keys	Flipkart Keys

Warehouse Keys	Flipkart Keys
`inventoryList[].skuId`	`<sku>`
`inventoryList[].productId`	`<sku>.product_id`
`locationId`	`<sku>.locations[].id`
`inventoryList[].locationInventory`	`<sku>.locations[].inventory`

Step 4. Now use the accessToken and push the Transformed Data to Flipkart in the following format

POST API URL

https://api.flipkart.net/sellers/listings/v3/update/inventory

Request Body

{
    "inventoryList[].skuId": {
        "product_id": "{{inventoryList[].productId}}",
        "locations": [
            {
                "id": "{{locationId}}",
                "inventory": {{inventoryList[].locationInventory}}
            }
        ]
    }
}

Response Body

200 OK

{
    "sku": {
        "status": "success|failure|warning",
        "errors": [
            {
                "severity": "ERROR|WARNING",
                "code": "<code>",
                "description": "<description>"
            }
        ],
        "attribute_errors": [
            {
                "severity": "ERROR|WARNING",
                "code": "<code>",
                "description": "<description>",
                "attribute": "<attribute>",
                "path": "<path-to-attribute>"
            }
        ]
    }
}

2. 400 Bad Request

{
    "errors": [
        {
            "severity": "ERROR|WARNING",
            "code": "<code>",
            "description": "<description>",
            "path": "<path-to-failed-json-node>"
        }
    ]
}

3. 500 Internal ServerError

{
    "errors": [
        {
            "severity": "ERROR|WARNING",
            "code": "<code>",
            "description": "<description>"
        }
    ]
}