Flipkart Listing Sync

Open

Steps:

For Flipkart listing sync we need to take care of two keys:

1. flipkart_product_id( also known as FSN)

2. flipkart_listing_id

Listing Cron:

1. Fetch connection details for listing step id.

2. Channel-account data:

   1. Check if channel data is present in cache.

   2. If not, fetch channel and account data and store in cache.

3. Workspace token:

   1. Check if token is present in cache.

   2. If not, get token by auth0 api and store in cache.

Channel data stored in cache

Key:

Value:

Workspace token stored in cache

Key:

Value:

Data pushed to queue:

Taskqueue Listener

1. Call GET products API to get all the products not available on the channel.

   1. Request parameter name: filter

   2. Value: (NOT availableOn:{externalChannelId})

   3. Sample Response.

      { "products" : [ { "objectID": "BBAPLCD132370_42", "accountSlug": "montecarlo", "status": "ACTIVE", "esin": "BBAPLCD132370_42", "parentEsin": "BBAPLCD132370", "type": "BASE", "sku": "BBAPLCD132370_42", "groupCode": "6190UCM0025-7", "additionalNames": { "ean": "8907903908339" }, "vertical": "APL", "verticalName": "Apparels", "availableOn": [ "MYN_MONTECARLO_2731", "AMZ_MONTECARLO_497", "MYN_MONTECARLO_2756", "AMAZON_XNBS_PATLI", "PYM_MONTECARLO_621" ], "unavailableOn": [ "Amazon_XNBS_Patli", "AMZ_MONTECARLO_497", "MYN_MONTECARLO_2756", "PYM_MONTECARLO_621" ], "brand": "cloak & decker", "description": "12", "imageUrl": "https://s3-eu-west-1.amazonaws.com/imagebucketeshopbox/Cloak_&_Decker_Flipkart/BBAPLCD132370/1.JPG", "mrp": 429.0, "unitPrice": 228.0, "hsnCode": "61099090", "tax": [ "5.0", "12.0" ], "taxCode": "ESBGST1", "weight": 12.0, "weightUnit": "g", "dimensionLength": 12.0, "dimensionWidth": 12.0, "dimensionHeight": 12.0, "dimensionUnit": "cm", "searchableProperties": { "occasion": [ "casual" ] }, "properties": [ { "label": "occasion", "internalName": "occasion", "value": [ "casual" ] } ], "createdAt": "1567555200000", "updatedAt": "1607693081780" } ] }

2. Push data to pubsub in loop.

   { "channelData": { "sellerSkuOnChannel": "sellerSku", "integrationType": "6", "Flipkart_workspaceToken_eshop": "Bearer eyJhbGciOiJSUzI1NiIsInR5cCI6", "externalChannelId": "eshop_flipkart_test", "latestSyncTimeStamp": "2020-10-30 10:46:09.0", "accountSlug": "eshop", "connectionId": 51, "integrationModelId": "3", "location": { "LOC62a30c1d159845e09dfeef303f52cfb9": "BDGUR103" }, "channelProductCode": "FSN", "accessToken": "6e3a2b62-9f40-42d0-b262-93048cf92344" }, "productData" : [ { "sku" : "ABC", "esin" : "ESIN1", . . }, { "sku" : "XYZ", "esin" : "ESIN2", . . } ] }

Pubsub

Call Mark product availability:

Mark product availability request:

Product Engine Service

Call search listing API with all the identifiers

Request

Integration Listing Service

1. Check if externalChannelId is valid

2. Fetch custom fields from channel_account_custom_fields table

3. Call Flipkart Get listings API with all the identifiers

   https://api.flipkart.net/sellers/listings/v3/{skuids}

   Response

   { "available": { "BBSHOCL164161_5": { "listing_id": "LSTSNDFZRKFMABWTETYX5UTGX", "product_id": "SNDFZRKFMABWTETY", "price": { "mrp": 4999, "selling_price": 2999, "currency": "INR" }, "tax": { "hsn": "64041990", "tax_code": "GST_18" }, "listing_status": "ACTIVE", "shipping_fees": { "local": 0, "zonal": 0, "national": 0, "currency": "INR" }, "fulfillment_profile": "NON_FBF", "packages": [ { "id": "PKGSNDFZRKFMABWTETYX5UTGX", "name": "BBSHOCL164161_5", "dimensions": { "length": 30.48, "breadth": 19.558, "height": 10.922 }, "weight": 0.82, "handling": { "fragile": false } } ], "locations": [ { "id": "LOCd3b2ee7836024b329ec7510e1c19702c", "status": "ENABLED", "inventory": 0, "pending_inventory": 0 }, { "id": "LOC01189f32db684bde949e36a36361d181", "status": "ENABLED", "inventory": 0, "pending_inventory": 0 }, { "id": "LOC62a30c1d159845e09dfeef303f52cfb9", "status": "ENABLED", "inventory": 0, "pending_inventory": 0 } ] }, "08PXG3FMDYY": { "listing_id": "LSTFABFQY27HNZZKG2FQ9EWPJ", "product_id": "FABFQY27HNZZKG2F", "price": { "mrp": 1920, "selling_price": 1344, "currency": "INR" }, "tax": { "hsn": "53091900", "tax_code": "GST_12" }, "listing_status": "ACTIVE", "shipping_fees": { "local": 0, "zonal": 0, "national": 0, "currency": "INR" }, "fulfillment_profile": "NON_FBF", "packages": [ { "id": "PKGFABFQY27HNZZKG2FQ9EWPJ", "name": "08PXG3FMDYY", "dimensions": { "length": 22.0, "breadth": 2.0, "height": 25.0 }, "weight": 0.482, "handling": { "fragile": false } } ], "locations": [ { "id": "LOCd3b2ee7836024b329ec7510e1c19702c", "status": "ENABLED", "inventory": 0, "pending_inventory": 0 }, { "id": "LOC01189f32db684bde949e36a36361d181", "status": "ENABLED", "inventory": 0, "pending_inventory": 0 }, { "id": "LOC62a30c1d159845e09dfeef303f52cfb9", "status": "ENABLED", "inventory": 11, "pending_inventory": 0 } ], "order_policy": { "maximum_allowed_quantity": 5, "independent_sellable": true } } }, "unavailable": [ "<sku1>", "<sku2>" ], "invalid": [ "test" ] }

Custom Fileds for flipkart

product_id = FSN( itemId in listings)

4. Loop over available SKUs and fetch internalName values from Flipkart response, add sellerSku in response.

Response

Product Engine Service

Log duplicate and invalid products.

If list size = 1:

1. Check if the value of property and additional names already exist

2. Else update properties and additionalNames

Mark the product available and update the listings table.