/
Import Order

Import Order

Owned by Shubham Gupta (Unlicensed)
Last updated: May 12, 2022
2 min read

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

 

items[].productName

orderSheet.title

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

shipChargeAmount

sum of all orderSheet.ShippingCharges

subTotal

sum of all lineItemTotal

orderTotal

subTotal + shipChargeAmount + otherCharges

suggestedCourierCode

Forward shipping provider

suggestedTrackingNumber

Forward tracking number

 

Open Questions:
1. How to add other charges.

2. What will be customerPrice?

3. Use of forward shipping provider and forward tracking number?

4. Selling price represents orderItem price or complete order price and does it contain 1 quantity price or all?

5. How to differentitate if other charges represent gift charge or COD charge?

 

  1. If Gift Wrap==YES OR Gift Message is not empty then

giftWrapCharges = other charges

else balance due = other charges.

2. selling price contains prices of all quantities of that sku

3. customer price, tax amount, itemID: call product api to get the MRP of the product.

4. Group the orders on the basis of channel order id

 

Get itemID and mrp from Product API:
1. Product API: call the below API using sku

https://products-dot-esb-product-engine-staging.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&ids=TestingProduct1365

2. Based upon channelId extract integration_model_id from channels table

3. Using integration_model_id extract channelProductCode from integration models table.

4. Using channelProductCode extract value corresponding to label(channleProductCode)

Related content