Import flow - without product availability

Call the GET product API for all the SKUs of an order.

URL: https://products-dot-esb-product-engine-prod.appspot.com/_ah/api/esb/v1/products?fields=groupCode,components,status,accountSlug,additionalNames,esin,description,mrp,hsnCode,combo,imageUrl,channelCode,verticalName,brand,type,sku,weight,dimensionHeight,dimensionLength,dimensionWidth,weightUnit,dimensionUnit,properties,availableOn&ids=tshirt1,tshirt2

Headers:

Key	Value

Key	Value
Authorization	Bearer <token>
proxyHost	<accountSlug>

Response:

{
    "tshirt1": {
        "availableOn": [
            "CH1444",
            "CH1459"
        ],
        "hsnCode": "90000",
        "dimensionHeight": 1.0,
        "dimensionLength": 10.0,
        "dimensionUnit": "cm",
        "description": "tshirt1",
        "weight": 350.0,
        "mrp": 999.0,
        "dimensionWidth": 19.0,
        "type": "BASE",
        "verticalName": "Apparels",
        "imageUrl": "https://cdn.filestackcontent.com/I6TcufwdSIGQ0K1UnVwt",
        "accountSlug": "testing_brand_party",
        "sku": "tshirt1",
        "esin": "T1VUP3H8EN1",
        "brand": "DummyBrand",
        "additionalNames": {
            "others": [
                "TSHIRT1"
            ]
        },
        "properties": [
            {
                "label": "shopify_handle_742",
                "internalName": "shopify_handle_742",
                "value": [
                    "tshirt1"
                ]
            },
            {
                "label": "inventory_item_id_742",
                "internalName": "inventory_item_id_742",
                "value": [
                    "44697252692162"
                ]
            },
            {
                "label": "inventory_item_id_715",
                "internalName": "inventory_item_id_715",
                "value": [
                    "44697252692162"
                ]
            },
            {
                "label": "shopify_handle_715",
                "internalName": "shopify_handle_715",
                "value": [
                    "tshirt1"
                ]
            }
        ],
        "status": "ACTIVE",
        "weightUnit": "g"
    },
    "tshirt2": {
        "availableOn": [
            "CH1444",
            "CH1459"
        ],
        "hsnCode": "199",
        "dimensionHeight": 33.0,
        "dimensionLength": 23.0,
        "dimensionUnit": "cm",
        "description": "tshirt2",
        "weight": 239.0,
        "mrp": 900.0,
        "dimensionWidth": 11.0,
        "type": "BASE",
        "verticalName": "Apparels",
        "imageUrl": "https://cdn.filestackcontent.com/0z0BYb7hQmKX4m8CA5yF",
        "accountSlug": "testing_brand_party",
        "sku": "tshirt2",
        "esin": "T2EHC3H8EN2",
        "brand": "DummyBrand",
        "additionalNames": {
            "others": [
                "TSHIRT2"
            ]
        },
        "properties": [
            {
                "label": "shopify_handle_742",
                "internalName": "shopify_handle_742",
                "value": [
                    "tshirt2"
                ]
            },
            {
                "label": "inventory_item_id_742",
                "internalName": "inventory_item_id_742",
                "value": [
                    "44697256231106"
                ]
            },
            {
                "label": "inventory_item_id_715",
                "internalName": "inventory_item_id_715",
                "value": [
                    "44697256231106"
                ]
            },
            {
                "label": "shopify_handle_715",
                "internalName": "shopify_handle_715",
                "value": [
                    "tshirt2"
                ]
            }
        ],
        "status": "ACTIVE",
        "weightUnit": "g"
    }
}

2. After getting a successful response from the GET product details API, Fetch MRP, SKU and ESIN value from the response and call the create order API.

Call the WMS create order V2 API to create the order in Eshopbox.

Map SKU value received from GET product API to itemId and ESIN value to SKU in request of create order API.

Key mapping:

WMS Create Order Keys	Order Sheet Keys
`externalChannelID`	`externalChannelID`
`customerOrderNumber`	`orderSheet.ChannelOrderId`
`expectedShipDate`	`orderSheet.Expected ready to ship`
`vendorOrderNumber`	`orderSheet.CustomerOrderId`
`shipMethod`	“STD”
`orderDate`	`orderSheet.OrderDate`
`isCOD`	If orderSheet.PaymentMethod == “COD“?1:0
`paymentType`	orderSheet.PaymentMethod
`balanceDue`
`thirdPartyShipping`	true
`shippingAddress.customerName`	`orderSheet.shippingCustomerName`
`taxAmount`	0
`shippingAddress.addressLine1`	`orderSheet.ShippingAddress`
`shippingAddress.addressLine2`
`shippingAddress.city`	`orderSheet.shippingCity`
`shippingAddress.postalCode`	`orderSheet.shippingPinCode`
`shippingAddress.countryCode`	`orderSheet.shippingCountry`
`shippingAddress.countryName`	`India`
`shippingAddress.contactPhone`	`orderSheet.shippingContactNumber`
`shippingAddress.email`	`orderSheet.shippingEmail`
`shippingAddress.state`	`orderSheet.shippingState`
`billingAddress.customerName`	`same as of shippingAddress`
`billingAddress.addressLine1`	`same as of shippingAddress`
`billingAddress.addressLine2`	`same as of shippingAddress`
`billingAddress.city`	`same as of shippingAddress`
`billingAddress.postalCode`	`same as of shippingAddress`
`billingAddress.countryCode`	`same as of shippingAddress`
`billingAddress.countryName`	`same as of shippingAddress`
`billingAddress.contactPhone`	`same as of shippingAddress`
`billingAddress.email`	`same as of shippingAddress`
`billingAddress.state`	`same as of shippingAddress`
`items[].lineItemSequenceNumber`	`orderSheet.OrderItemID`
`items[].quantity`	orderSheet.Quantity
`items[].itemID`	SKU from response of Product API
`items[].productName`	orderSheet.title /from response of product API
`items[].customerPrice`	MRP+ `taxAmount` ( from product API )
`items[].giftWrapCharges`	orderSheet.otherCharges
`items[].discount`	customerPrice(MRP)*quantites - (sellingPrice) (inculsive of quantities)
`items[].lineItemTotal`	(orderSheet.sellingPrice - discount)
`items[].taxAmount`	0
`items[].giftMessage`	orderSheet.GiftMessage
`items[].giftLabelContent`
`items[].isGift`	orderSheet.GiftWrap == “YES” ? 1:0
`items[].invoiceNumber`	orderSheet.InvoiceNumber
items[].isVirtualKit	“0” or “1“ from response product API (1 states that product is a virtual kit)
items[].sku	ESIN from response of product API
`shipChargeAmount`	sum of all orderSheet.ShippingCharges
`subTotal`	sum of all lineItemTotal
`orderTotal`	subTotal + shipChargeAmount + otherCharges
suggestedCourierCode	Forward shipping provider
suggestedTrackingNumber	Forward tracking number

URL : https://{{workspace}}.eshopbox.com/api/v2/order

Headers:

Header name	Value

Header name	Value
Authorization	Bearer <Token>
Content-Type	application/json

Sample request body:

{
    "vendorOrderNumber": "Test-04",
    "balanceDue": 0,
    "externalChannelID": "CH2065",
    "orderSiteID": "MAGENTO2",
    "expectedShipDate": "2022-09-15 11:13:00",
    "customerOrderNumber": "Test-04",
    "orderTotal": 1119.60,
    "paymentType": "Prepaid",
    "isCOD": "0",
    "subtotal": 1119.60,
    "shipMethod": "STD",
    "shippingAddress": {
        "city": "KOLKATA",
        "countryCode": "IN",
        "postalCode": "700063",
        "addressLine1": "TEST",
        "addressLine2": "",
        "state": "WB",
        "countryName": "IN",
        "contactPhone": "8802064263",
        "customerName": "TEST",
        "email": ""
    },
    "thirdPartyShipping": true,
    "billingAddress": {
        "city": "KOLKATA",
        "countryCode": "IN",
        "postalCode": "700063",
        "addressLine1": "TEST",
        "addressLine2": "",
        "state": "WB",
        "countryName": "IN",
        "contactPhone": "8802064263",
        "customerName": "TEST",
        "email": ""
    },
    "taxAmount": 0,
    "orderDate": "2022-09-13 17:08:00",
    "items": [
        {
            "productImageUrl": "",
            "itemID": "1059692",
            "sku": "T1VUP3H8EN1",
            "quantity": 1,
            "customerOrderItemID": "1",
            "lineItemSequenceNumber": "1",
            "lineItemTotal": 1184.47,
            "productUrl": "",
            "customerPrice": 1184.47,
            "externalWarehouseID": "Eshopbox_Mumbai",
            "productName": "Spaces Orthopedic Mattress"
        },
        {
            "productImageUrl": null,
            "itemID": "1052739",
            "sku": "T2EHC3H8EN2",
            "quantity": 1,
            "customerOrderItemID": "1",
            "lineItemSequenceNumber": "1",
            "lineItemTotal": 1184.47,
            "productUrl": null,
            "customerPrice": 1184.47,
            "externalWarehouseID": "Eshopbox_Mumbai",
            "productName": "SPACES BONICA 100% COTTON Single Bedsheet Air Purifying Anti-bacterial Soft Feel Skin Safe (FLORAL,"
        }
    ],
    "shipChargeAmount": 0.0
}'

Apps and Automations

Import flow - without product availability

Related content