/
Draft: EasyEcom Integration

Draft: EasyEcom Integration

Owned by Prateek Kaushik (Unlicensed)
Last updated: Mar 28, 2022 by Shubham Gupta (Unlicensed)
3 min read

Inventory Updates:

POST API:

https://app.easyecom.io/inventory?api_token=e754e595c43034f3d40d525fe614b5063f25166f44a9e8eb24245826ed31b7aa

Request Body:

{ "sku": "Nokia 3.2", "quantity": 12 }

Response:

{ "message": "13 stock updated successfully.", "code": 200, "company_product_id": 22508995, "sku": "Nokia 3.2" }

Open Points:

  1. On which location, this inventory update is going?

  2. Is api_token location specific? if yes then we will have to generate a new api_token location-wise and then Push Inventory Updates. If it is not location specific then how we can update or fetch inventory of a particular warehouse?

  3. Do we need to subtract or add reserved quantity or blocked quantity for the respective SKU?

Order Pull: https://bitbucket.org/easyecom/easyecom/wiki/EasyEcomApi#getAllOrdersV2

GET API:

https://app.easyecom.io/orders/V2/getAllOrders?api_token=e754e595c43034f3d40d525fe614b5063f25166f44a9e8eb24245826ed31b7aa&updated_after=2022-02-01 13:15:59&updated_before=2022-03-01 13:15:59&limit=1

Params:

api_token

e754e595c43034f3d40d525fe614b5063f25166f44a9e8eb24245826ed31b7aa

updated_after

2022-02-01 13:15:59

updated_before

2022-03-01 13:15:59

limit

1

Response:

{ "code": 200, "message": "Successful", "data": { "orders": [ { "invoice_id": 80722773, "order_id": 58015822, "queue_message": null, "queue_status": 8, "order_priority": 0, "blockSplit": 0, "reference_code": "1380", "company_name": "Easyecom_Test", "warehouseId": 15222, "seller_gst": "27AACCL9605M1Z3", "import_warehouse_id": 15222, "import_warehouse_name": "Easyecom_Test", "pickup_address": "180", "pickup_city": "gurgaon", "pickup_state": "Haryana", "pickup_pin_code": "122001", "pickup_country": "India", "order_type": "B2C", "order_type_key": "retailorder", "replacement_order": 0, "marketplace": "Shopify13", "marketplace_id": 179, "qcPassed": 0, "salesmanUserId": 0, "order_date": "2022-03-01 12:47:31", "tat": "2022-03-02 13:06:05", "invoice_date": "", "import_date": "2022-03-01 13:06:25", "last_update_date": "2022-03-01 13:06:05", "manifest_date": null, "manifest_no": null, "invoice_number": null, "marketplace_invoice_num": null, "shipping_last_update_date": null, "batch_id": null, "message": null, "courier": "SelfShip", "carrier_id": 23, "awb_number": null, "Package Weight": 250, "Package Height": null, "Package Length": null, "Package Width": null, "order_status": "Open", "order_status_id": 1, "shipping_status": null, "shipping_status_id": null, "shipping_history": null, "payment_mode": "PrePaid", "payment_mode_id": 5, "payment_gateway_transaction_number": null, "buyer_gst": "NA", "customer_name": "AA AA", "contact_num": "7894561237", "address_line_1": "AA", "address_line_2": "aa", "city": "Aurangabad", "pin_code": "110006", "state": "Delhi", "country": "India", "email": "all@mi.com", "billing_name": "AA AA", "billing_address_1": "AA", "billing_address_2": "aa", "billing_city": "Aurangabad", "billing_state": "Maharashtra", "billing_pin_code": "110006", "billing_country": "India", "billing_mobile": "7894561237", "order_quantity": 2, "documents": null, "total_amount": 799, "total_tax": 121.881, "total_shipping_charge": 0, "total_discount": 0, "collectable_amount": 0, "tcs_rate": 0, "tcs_amount": 0, "suborders": [ { "suborder_id": 93874307, "suborder_num": "10844554920002", "item_status": "Pending", "shipment_type": "SelfShip", "suborder_quantity": 1, "item_quantity": 1, "returned_quantity": 0, "cancelled_quantity": 0, "shipped_quantity": 1, "batch_codes": null, "tax_type": "GST", "suborder_history": { "qc_pass_datetime": null, "confirm_datetime": null, "print_datetime": null, "manifest_datetime": null }, "selling_price": "699", "total_shipping_charge": null, "total_miscellaneous": null, "tax_rate": 18, "tax": 106.6271, "product_id": 16647350, "company_product_id": 56590327, "sku": "FG00178", "sku_type": "Normal", "sub_product_count": 1, "marketplace_sku": "FG00178", "productName": "combo product - S", "description": null, "category": "", "brand": "epigamiatest", "model_no": "", "product_tax_code": null, "ean": null, "size": "S", "cost": null, "mrp": 100, "weight": 250, "length": null, "width": null, "height": null, "scheme_applied": 0 }, { "suborder_id": 93874310, "suborder_num": "10844554952770", "item_status": "Pending", "shipment_type": "SelfShip", "suborder_quantity": 1, "item_quantity": 1, "returned_quantity": 0, "cancelled_quantity": 0, "shipped_quantity": 1, "batch_codes": null, "tax_type": "GST", "suborder_history": { "qc_pass_datetime": null, "confirm_datetime": null, "print_datetime": null, "manifest_datetime": null }, "selling_price": "100", "total_shipping_charge": null, "total_miscellaneous": null, "tax_rate": 18, "tax": 15.2542, "product_id": 16660166, "company_product_id": 56862687, "sku": "FG12345", "sku_type": "Normal", "sub_product_count": 1, "marketplace_sku": "FG12345", "productName": "combo mapping", "description": null, "category": "", "brand": "epigamiatest", "model_no": "", "product_tax_code": null, "ean": null, "size": null, "cost": null, "mrp": 100, "weight": null, "length": null, "width": null, "height": null, "scheme_applied": 0 } ] } ], "nextUrl": "/orders/V2/getAllOrders?cursor=Op8oQKKcspjL0lsxcDlCOiz7plBCDwpWQDgJ1aCZXHUElwlF5Jw3mHWBe0HLj3HVcLHA10Lt5aKJOVuLtBqSCGfiCo28iX/Gr_iCMDH8qWBKJZSuCV5ntJXzj_1i1ZX6HocFqUCNQTS6wO6NrbxHu9MqHRCX_jL8NuGWJ7npexZhdOSoKKpZsBR7MZT5B8_iEY_eL41aIPXWRD2HZ_iKoUROIlk/KqDN4XBxfXWWLsIp_vgeZBJ5XHEdjdOkwBAAlB6QpgKXzjWGCE4PcK6V9g==" } }

Transformation between EasyEcom Order keys with Eshopbox Order Keys:

Eshopbox Order API Keys

 

Eshopbox Order API Keys

 

vendorOrderNumber

 

customerOrderNumber

 

balanceDue

 

externalChannelID

 

orderTotal

 

paymentType

 

isCOD

 

subtotal

 

shipMethod

 

shippingAddress.customerName

 

shippingAddress.city

 

shippingAddress.countryCode

 

shippingAddress.postalCode

 

shippingAddress.addressLine1

 

shippingAddress.addressLine2

 

shippingAddress.countryName

 

shippingAddress.state

 

shippingAddress.contactPhone

 

shippingAddress.email

 

billingAddress.customerName

 

billingAddress.city

 

billingAddress.countryCode

 

billingAddress.postalCode

 

billingAddress.addressLine1

 

billingAddress.addressLine2

 

billingAddress.countryName

 

billingAddress.contactPhone

 

billingAddress.email

 

thirdPartyShipping

 

taxAmount

 

orderDate

 

shipChargeAmount

 

items[].lineItemSequenceNumber

 

items[].itemID

 

items[].quantity

 

items[].discount

 

items[].lineItemTotal

 

items[].customerPrice

 

items[].productName

 

items[].status

 

All the possible order status?
Order Status Ids

| Id | Status | |-------|-----------------------------| |1 | Pending | |2 | Assigned | |3 | Confirmed | |4 | Out of stock | |5 | Printed | |6 | Ready to dispatch | |7 | Shipped | |9 | Cancelled | |10 | Returned | |11 | Upcomin

Open Questions:

  1. How to fetch orders for a particular warehouse?

  2. What is forward order journey. What will be the status of the order that we have to create in our system?

  3. What are all the possible value for shipment_type and is it an important parameter for integration?

  4. Difference between suborder_quantity and order_quantity?

  5. What is “reference number” for an order?

  6. If an order has an item with multiple quantities so will there be separate suborders object for each quantity or only one? Difference between suborder_id and suborder_num, will both the keys will be different for each suborder.

  7. Type of authentication?

Related content