/
Ajio Pull Order Flow

Ajio Pull Order Flow

Owned by Prateek Kaushik (Unlicensed)
Last updated: Mar 13, 2023
2 min read

Step 1. To fetch all the active connections of Ajio from eshopbox_wms_production.channels table using the following Query:

SQL Query:

SELECT DISTINCT connectionId AS connectionIds FROM channels WHERE integrationType ='16'AND channels.status='0'

Step 2. Now fetch the connectionConfigData using the following Query for all the active connections:

SQL Query: To fetch connectionConfigData

SELECT ie_appinstall_connection.accessToken AS accessToken, ie_appinstall_connection.id AS connectionId, ie_app_automation_steps.id AS appAutomationStepId, ie_app_automation_steps.appId AS appId, ie_app_automation_steps_config.isActive, ie_appinstall_connection.isActive AS appIsActive, ie_app_automation_steps_config.otherDetails AS otherDetails, ie_app_automation_steps_config.latestSyncTimeStamp AS latestSyncTimeStamp, ie_app.clientId AS appClientId, ie_app.userName AS appWmsUserName, ie_app.password AS appWmsPassword, ie_appinstall_connection.inputFields AS inputFields, ie_app_credential.clientSecret as clientSecret, GROUP_CONCAT(ie_app_type_scope.scope) AS scope FROM ie_appinstall_connection LEFT JOIN ie_app_installation ON ie_app_installation.appInstallationId = ie_appinstall_connection.appInstallationId LEFT JOIN ie_app ON ie_app.appId = ie_app_installation.appId LEFT JOIN ie_app_automation_steps ON ie_app_automation_steps.appId = ie_app.appId LEFT JOIN ie_app_automation_steps_config ON ie_app_automation_steps_config.connectionId = ie_appinstall_connection.id AND ie_app_automation_steps_config.appAutomationStepId = ie_app_automation_steps.id LEFT JOIN ie_app_credential ON ie_app_credential.appId = ie_app_installation.appId LEFT JOIN ie_app_type_scope ON ie_app_type_scope.appType = ie_app.appType WHERE ie_appinstall_connection.id IN (:connectionIds) AND ie_app_automation_steps.appAutomationStepId = (:appAutomationStepId) AND ie_app_automation_steps_config.isActive = '1'

Step 3. Push the Data Into TaskQueue so that it can fetch the Pendency Orders for each connection parallelly and push them onto a PubSub topic where Ajio Transformation Service will create those orders into WMS.

SQL Query: To fetch connectionChannelData:

SELECT accounts.account_slug AS accountSlug, channels.connectionId AS connectionId, channels.externalChannelId AS externalChannelId, external_wms_channels.locationId AS locationId, warehouses.externalWarehouseId AS externalWareHouseId FROM channels LEFT JOIN external_wms_channels ON channels.id= external_wms_channels.channel_id LEFT JOIN warehouses ON warehouses.id = external_wms_channels.warehouse_id LEFT JOIN accounts ON channels.account_id = accounts.id LEFT JOIN channel_account_mapping ON channel_account_mapping.external_wms_channel_id = external_wms_channels.id WHERE channels.connectionId =:connectionId AND channel_account_mapping.enrollmentStatus = 'ACTIVE'

Step 4. Now listen to each connectionConfigData from TaskQueue and Prepare the GET /orders/pendency API URL to fetch the Pendency Orders from AJIO.

GET API:

https://api-seller.services.ajio.com/orders/pendency?orderDateFrom="2022-08-01T00:00:00"&orderDateTo="2022-08-01T00:20:00"

Headers:

Key

Value

Key

Value

Authorization

Bearer {{token Value}}

Params:

Keys

Value

Keys

Value

orderDateFrom

2022-08-01T00:00:00

orderDateTo

2022-08-01T00:20:00

Response:

{ "orders": [ { "carrier": "string", "order_date": 1635828975, "order_id": "firstOrder", "order_lines": [ { "item_details": { "brand_name": "string", "color": "string", "ean": "string", "item_code": "string", "name": "string", "size": "string" }, "order_item_id": "string", "ordered_quantity": 0, "mrp": 0, "unit_price": 0, "listing_price ": 0, "seller_discount": 0, "b2b_base_price": 0, "b2b_tax": 0 } ], "payment_method": "string", "tracking_number": "string", "total_amount": 0, }, { "carrier": "string", "order_date": 1635828975, "order_id": "secondOrder", "order_lines": [ { "item_details": { "brand_name": "string", "color": "string", "ean": "string", "item_code": "string", "name": "string", "size": "string" }, "order_item_id": "string", "ordered_quantity": 0, "mrp": 0, "unit_price": 0, "listing_price ": 0, "seller_discount": 0, "b2b_base_price": 0, "b2b_tax": 0 } ], "payment_method": "string", "tracking_number": "string", "total_amount": 0, } ], "page": { "number": 0, "size": 0, "totalElements": 0, "totalPages": 0 } }

Step 5. Now iterate over each Order and Push it onto a PubSub topic wherein the Ajio-Transformation Service will extract the required data from this Order Object and will create the Order into Eshopbox System.

PubSub Topic: ajio-create-order

{ "queueData": { "channelData": { "externalChannelId": "MONTECARLO_PREPROD", "accountSlug": "montecarlo", "connectionId": 52, "location": { "58291847336": "MJPAT_109" }, "ajioAPIToken": "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", "wmsToken": "eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCIsImtpZCI6Ik1UaERRamxDUlRJelJVUTRRVU0wUVRJNU1FSkVOVGszUVVFeU5qVXdSa1JDTmpBeU16WTROQSJ9.eyJodHRwczovL2FwcERhdGEiOnsiYXBwQ2xpZW50SWQiOiJjN2U1MDU4NGRhMDM4MmFlY2RmMWEzMzQ1OTFmZmQzOCJ9LCJodHRwczovL2FjY291bnRTbHVnIjoibW9udGVjYXJsbyIsImh0dHBzOi8vdXNlckRldGFpbHMiOnsiaWQiOjgwOCwidXNlclR5cGUiOiJkZWZhdWx0IiwiZW1haWwiOiJhcHB1c2VyMjFAZXNob3Bib3guY29tIn0sImh0dHBzOi8vYWNjb3VudHMiOlsibW9udGVjYXJsbyJdLCJodHRwczovL3dhcmVob3VzZXMiOltdLCJodHRwczovL3BhcnRuZXJzIjpbXSwiaXNzIjoiaHR0cHM6Ly9lc2hvcGJveC5hdXRoMC5jb20vIiwic3ViIjoiYXV0aDB8NWZlNDdkZjFhNGZhNmMwMDZmMTBjN2I2IiwiYXVkIjoiaHR0cHM6Ly93bXMubXllc2hvcGJveC5jb20iLCJpYXQiOjE2MDkxNTkxNjYsImV4cCI6MTYxMTc1MTE2NiwiYXpwIjoiUXpWTzdmSGsySFl4Mlk1YjNXRG9pRHVHZTR2Q3dqSFAiLCJzY29wZSI6InJlYWQ6b3JkZXJzIG9mZmxpbmVfYWNjZXNzIiwiZ3R5IjoicGFzc3dvcmQifQ.WIdaENzdkYY90VRv-9AEGwreD66tvGaOBug-9G5erhDvboihXpRevDFe1gZTfJdA-HYWOFadw8bqjoM8ZtUv0pJdOI2QA-rKRhfAAaZOdfZc9Tn3DhybZHT4Pmltthz4Cgz-T516F0CTj0VhcR-T-FGg6-qb1xtPB83lflLAa-Lrj7T3FRqA9yp2r9MLCEkBCzqlrKUpCvdeA5DFaCAb-J8gvPsf9rs9pu6lf2Y_1P1fNETZUk2wZ6tGAt0gQnga6zCkoYZ_Su9FseuRx6rq-1IHeSvvbWUcNkvkZN2X91eAqjSNzK7WtCs0ZATpR9m08bFuFO4XascGfptJnfxb5Q" }, "orderDetail": { "carrier": "string", "order_date": 1635828975, "order_id": "string", "order_lines": [ { "item_details": { "brand_name": "string", "color": "string", "ean": "string", "item_code": "string", "name": "string", "size": "string" }, "order_item_id": "string", "ordered_quantity": 0, "mrp": 0, "unit_price": 0, "listing_price ": 0, "seller_discount": 0, "b2b_base_price": 0, "b2b_tax": 0 } ], "payment_method": "string", "tracking_number": "string", "total_amount": 0 } } }

 

Related content