Ajio Create Order Transformation Service

Component	Infra Description
`Ajio Dropship Platform`	Event Received from Default Service of Ajio Dropship
`Aijo-Order Service`	App Engine Service Name: Ajio-Order Service GCloud Project ID: ajio_integration_staging (STAGING) ajio_integration_prod (PROD) Repository Name: esb-ajio-order-integration
`PubSub`	Topic Name: ajio_create_order
`WMS Create Order API`	API to Create Order in Eshopbox Workspace

Step 1. Listen to the Event received from PubSub that will be similar to as shown below:

{
    "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
        }
    }
}

Step 2. Following is the Transformation Table where we are converting Ajio Order Keys to Eshopbox WMS Create Order API

WMS Create Order Keys	Ajio Order Event Keys
`externalChannelID`	`channelData.externalChannelID`
`customerOrderNumber`	`orderDetail.order_id`
`expectedShipDate`
`vendorOrderNumber`	`orderDetail.order_id`
`shipMethod`	`"STD"`
`orderDate`	`orderDetail.order_date`
`isCOD`	`orderDetail.payment_method`
`paymentType`	if isCOD = '1' then “CASH ON DELIVERY“ else ”PREPAID”
`balanceDue`	if `COD.equals("1")` then `balanceDue = orderTotal` else `balanceDue = 0.00`
`thirdPartyShipping`	`"1"`
`externalWarehouseID`	`channelData.externalWarehouseID`
`taxAmount`	0.00
`shippingAddress.customerName`	`"Test customer"`
`shippingAddress.addressLine1`	`"Test Apartment, test road"`
`shippingAddress.addressLine2`	`"Phase 5"`
`shippingAddress.city`	`Gurgaon`
`shippingAddress.postalCode`	`122016`
`shippingAddress.countryCode`	`IN`
`shippingAddress.countryName`	`"INDIA"`
`shippingAddress.contactPhone`	`9999900000`
`shippingAddress.email`	`testemail@gmail.com`
`shippingAddress.state`	`Haryana`
`billingAddress.customerName`	`"Test customer"`
`billingAddress.addressLine1`	`"Test Apartment, test road"`
`billingAddress.addressLine2`	`"Phase 5"`
`billingAddress.city`	`Gurgaon`
`billingAddress.postalCode`	`122016`
`billingAddress.countryCode`	`IN`
`billingAddress.countryName`	`"INDIA"`
`billingAddress.contactPhone`	`9999900000`
`billingAddress.email`	`testemail@gmail.com`
`billingAddress.state`	`Haryana`
`items[].lineItemSequenceNumber`	`orderDetail.order_lines[].order_item_id` For ex: if the value is `S100182277.2` then we can save it as `2`
`items[].customerOrderItemID`	`orderDetail.order_lines[].order_item_id`
`items[].quantity`	`orderDetail.order_lines[].ordered_quantity`
`items[].itemID`	`orderDetail.order_lines[].item_details.item_code`
`items[].productName`	`orderDetail.order_lines[].item_details.name`
`items[].customerPrice`	`same as lineItemTotal`
`items[].discount`	`0.0`
`items[].lineItemTotal`	`b2b_base_price + b2b_tax`
`items[].taxRate`	0.00
`items[].taxAmount`	`orderDetail.order_lines[].b2b_tax or 0.00`
`items[].externalWarehouseID`	`channelData.externalWarehouseID`
`items[].productAdditionalInfo`	`orderDetail`.`order_lines`.`unit_price` + `orderDetail`.`order_lines`.`seller_discount` + `orderDetail`.`order_lines`.`listing_price`
`shipCharge`
`shipChargePromotion`
`shipChargeAmount`
`subTotal`	`sum of all the lineItems`
`orderTotal`	`subTotal + shipChargeAmount`

Step 3. Once the transformation is done, call the WMS Create Order API

POST API:

https://wms.eshopbox.com/api/order

Headers:

Keys	Value

Keys	Value
Authorization	Bearer {{token Value}}

Request Body:

{
    "vendorOrderNumber": "{{orderDetail.order_id}}",
    "balanceDue": 0,
    "externalChannelID": "{{channelData.externalChannelID}}",
    "customerOrderNumber": "{{orderDetail.order_id}}",
    "orderTotal": {{orderTotal}},
    "paymentType": "{{paymentType}}",
    "isCOD": "{{isCOD}}",
    "subtotal": {{subTotal}},
    "shipMethod": "{{shipMethod}}",
    "externalWarehouseID":"{{externalWarehouseID}}",
    "shippingAddress": {
        "city": "Hyderabad",
        "countryCode": "IN",
        "postalCode": "500072",
        "addressLine1": "Flat.no:210,vijaya durga B block, nagarjuna homes",
        "addressLine2": "Nizampet road, kukatpally",
        "countryName": "INDIA",
        "state": "Telangana",
        "contactPhone": "9493405050",
        "customerName": "Praneetha Kannikanti",
        "email": "praneetha.k3@gmail.com"
    },
    "thirdPartyShipping": 1,
    "billingAddress": {
        "city": "Hyderabad",
        "countryCode": "IN",
        "postalCode": "500072",
        "addressLine1": "Flat.no:210,vijaya durga B block, nagarjuna homes",
        "addressLine2": "Nizampet road, kukatpally",
        "countryName": "INDIA",
        "state": "Telangana",
        "contactPhone": "9493405050",
        "customerName": "Praneetha Kannikanti",
        "email": "praneetha.k3@gmail.com"
    },
    "taxAmount": 0,
    "orderDate": "2022-08-17T12:15:42+05:30",
    "items": [
        {
            "itemID": "{{itemID}}",
            "quantity": {{quantity}},
            "lineItemSequenceNumber": "{{lineItemSequenceNumber}}",
            "discount": {{discount}},
            "lineItemTotal": {{(customerPrice*quantity)-discount}},
            "customerPrice": {{customerPrice}},
            "productName": "Real Rose Face Wash For Hydrated, Younger Looking Skin",
            "status": "CREATED",
            "externalWarehouseID":"{{externalWarehouseID}}"
        }
    ],
    "shipChargeAmount": {{shipChargeAmount}}
}

Apps and Automations

Ajio Create Order Transformation Service

Step 1. Listen to the Event received from PubSub that will be similar to as shown below:

Step 2. Following is the Transformation Table where we are converting Ajio Order Keys to Eshopbox WMS Create Order API

Step 3. Once the transformation is done, call the WMS Create Order API

Related content