Nykaa Update Inventory Flow

STEPS:

Step1. The event received from WMS will be pushed directly to taskQueue in inventory-batch of 20.

Update Inventory Event:

{
    "inventoryList": [
        {
            "productId": "12334",
            "parentId": null,
            "sku": "32CVB3GJA87",
            "variantId": "17AW16804-429-102-M",
            "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":"2429",
    "channelSlug": null,
    "locationId": "JPCUP",
    "publishedAt": "2020-07-21 19:49:47"
}

Step2. Push the above event into TaskQueue.

Step3. The Nykaa Inventory Listener listens to the update inventory request from TaskQueue. It then interacts with the service layer.
Step4. Fetch connectionID from the above WMS Update event body.

Step4.1. The Nykaa Inventory Service fetches the access token from cache.
Step4.2 If it is not found in the cache, then extract the access token from get API which will extract the Input fields(username and password) from the database with the help of connectionId (parameter).

Sample Get API:

GET "https://{{baseUrl}}/_ah/api/esb/v1/getNykaaAccessToken/{{connectionId}}"

The above get API will then implement the Nykaa get token API which fetches Access token and stores it in the cache whereas return the response received from Nykaa.

Sample Nykaa Get Token API:

https://xxxxx/RestWS/api/sellerPanel/v3/authToken

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

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

Step5. Get accountName and accessToken from “ie_appinstall_connection” table and prepare the Adjust Inventory API.

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

Sample API:

POST 'http://accountName.vineretail.com/RestWS/api/sellerPanel/v3/inventoryPriceUpdate' \

Sample Curl:

curl --location --
request POST 'http://preprod.vineretail.com/RestWS/api/sellerPanel/v3/inventoryPriceUpdate' \
--header 'Content-Type: application/x-www-form-urlencoded' \
--header 'apiKey: NTFURVNUMX5hMjdkOGMyYzVmNGU0ZDVhYjA5MTcyOGMxOGIxNGEzZWMyNGMxYTBlMmI4YTQyODhhOWVhYWFj' \
--data-urlencode 'RequestBody:{"invPriceList":[{ "sku":"CSKU1", "invQty":11,"sellerId":"MWHP"},{ "sku":"CSKU2", "invQty":14,"sellerId":"MWHP"}]}'

Step5.1. Prepare the request body using the extracted keys.
Also, in the Nykaa Adjust Inventory API body, transform and map the WMS keys to Nykaa keys.

Nykaa Keys	WMS Keys

Nykaa Keys	WMS Keys
sku	inventoryList[].sku
invQty	inventoryList[].locationInventory
sellerId	locationId

Request Body:

{
    "invPriceList": [
        {
            "sku": "CSKU1",
            "invQty": 11,
            "sellerId": "MWHP"
        },
        {
            "sku": "CSKU2",
            "invQty": 14,
            "sellerId": "MWHP"
        }
    ]
}

Step5.2. Make a HTTP POST request on the above prepared URL along with the generated request body and get the Response Map with necessary details.

Response:

{
    "responseCode": 0,
    "responseMessage": "Success",
    "skus": [
        {
            "referenceKey": null,
            "moderationId": 16169,
            "sku": "TEST-55829-00007",
            "requestedInvQty": 2.000,
            "approvedInvQty": 2.000,
            "status": "SUCCESS",
            "requestedSalePrice": 0.00,
            "sellerId": "TEST4"
        },
        {
            "referenceKey": null,
            "moderationId": 16170,
            "sku": "TEST-55829-00011",
            "requestedInvQty": 3.000,
            "approvedInvQty": 3.000,
            "status": "SUCCESS",
            "requestedSalePrice": 0.00,
            "sellerId": "TEST4"
        }
    ]
}

Step6. Steps For Structured logging:

After Getting The Response, the status of the response is checked:

String status = String.valueOf(skus.status.get("status"));

now according to the Value of Status, make 2 different methods of Structured logging for Different status Responses (Success, Fail).
API Request and Response Field Mapping:

Keys	Description

Keys	Description
message	“NYKAA_INVENTORY_UPDATE”
account_slug	`account_slug`
externalwmschannelname	`externalWmsChannelName`
externalchannelid	`externalChannelID`
ESIN	ESIN code
responseCode	Specify whether there was any error
locationinventory	inventoryList[].locationInventory
publishedat	Date type
account_id	`account_id`
publishedat_1	DateType
locationid	Location ID
requestdata	request sent from API of Nykaa
responsedata	response received from API of Nykaa
severity	ERROR/INFO

Error Handling :
Case 1 : If SKU is not present in Nykaa,
Response Body From Nykaa :

{
    "responseCode": 304,
    "responseMessage": "[SKU -CSKU1 & Seller -MWHP] Code Combination not found in the System. ",
    "skus": null
}

Resolution : In this case will mark that particular product as unavailable in Eshopbox.

Apps and Automations

Nykaa Update Inventory Flow

STEPS:

Related content