View Source

Apps and Automations > Ajio Create Order Transformation Service > image-20220822-125122.png

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