EasyEcom V2
EasyEcom ETL connector for data replication
EasyEcom V2
EasyEcom ETL connector for data replication
Snapshot
Features |
Details |
Release Status |
Released |
Source API Version |
v2 |
Table Selection |
Yes |
Column Selection |
Yes |
Edit Integration |
Yes |
Replication Type Selection |
No |
Authentication Parameters |
EasyEcom Email Address EasyEcom Password |
Replication Type |
Key based Replication Full Replication |
Replication Key |
DATE NA |
Suggested Replication Frequency |
24 hrs |
| Tables/APIs Supported | |
Customers |
Products |
Purchase_orders |
Returns |
Inventory_details |
Inventory_snapshots |
Orders |
Integrate EasyEcom with Daton
- Signin to Daton
- Select Impact from Integrations page
- Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
- Provide your EasyEcom email address and EasyEcom password.
- After providing the details to authorize Daton to periodically extract data from Impact.
- Post successful authentication you will be prompted to choose from the list of available tables
- Then select all required fields for each table
- Submit the integration.
Workflow
- Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
- Users would be able to edit/pause/re-activate/delete integration anytime
- Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
EasyEcom Data
Customers
Purpose: Retrieve all customers
Source API Documentation: https://api-docs.easyecom.io/#849fab71-b30d-46c6-94f5-1abea951b595
Replication: Full-Based Replication
Replication Key: NA
Fields
| FULLNAME | DATATYPE |
c_id |
NUMERIC |
companyname |
STRING |
customer_support_email |
STRING |
customer_support_contact |
STRING |
currency_code |
STRING |
gstNum |
STRING |
billingStreet |
STRING |
billingCity |
STRING |
billingZipcode |
STRING |
billingState |
STRING |
billingCountry |
STRING |
dispatchStreet |
STRING |
dispatchCity |
STRING |
dispatchZipcode |
STRING |
dispatchState |
STRING |
dispatchCountry |
STRING |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
_daton_batch_id |
NUMERIC |
Products
Purpose: Returns the list of Products
Source API Documentation: https://api-docs.easyecom.io/#3129767c-adc5-4a98-9f26-7e27cca3d14c
Replication: Fulload
Replication Key: NA
Fields
| FULLNAME | DATATYPE |
cp_id |
NUMERIC |
product_id |
NUMERIC |
sku |
STRING |
product_name |
STRING |
description |
STRING |
active |
NUMERIC |
created_at |
DATETIME |
updated_at |
DATETIME |
inventory |
NUMERIC |
product_type |
STRING |
brand |
STRING |
colour |
STRING |
category_id |
NUMERIC |
brand_id |
NUMERIC |
category_name |
STRING |
expiry_type |
NUMERIC |
company_name |
STRING |
c_id |
NUMERIC |
height |
NUMERIC |
length |
NUMERIC |
width |
NUMERIC |
weight |
NUMERIC |
cost |
NUMERIC |
mrp |
NUMERIC |
size |
STRING |
cp_sub_products_count |
NUMERIC |
model_no |
STRING |
hsn_code |
STRING |
tax_rate |
NUMERIC |
product_image_url |
STRING |
cp_inventory |
NUMERIC |
tax_rate_bn |
BIGNUMERIC |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
_daton_batch_id |
NUMERIC |
Purchase Orders
Purpose: Returns the list of Purchase orders
Source API Documentation: https://api-docs.easyecom.io/#5a890ecf-5d3d-41a5-a6f2-11489f46b726
Replication: Fulload
Replication Key: NA
Fields
| FULLNAME | DATATYPE |
po_id |
NUMERIC |
total_po_value |
STRING |
po_number |
NUMERIC |
po_ref_num |
STRING |
po_status_id |
NUMERIC |
po_created_date |
DATETIME |
po_updated_date |
DATETIME |
po_created_warehouse |
STRING |
po_created_warehouse_c_id |
NUMERIC |
vendor_name |
STRING |
vendor_c_id |
NUMERIC |
po_items |
RECORD |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
_daton_batch_id |
NUMERIC |
po_items.purchase_order_detail_id |
NUMERIC |
po_items.cp_id |
NUMERIC |
po_items.product_id |
NUMERIC |
po_items.sku |
STRING |
po_items.model_no |
STRING |
po_items.product_description |
STRING |
po_items.original_quantity |
NUMERIC |
po_items.pending_quantity |
NUMERIC |
po_items.item_price |
STRING |
Returns
Purpose: Retrieve list of all returns
Source API Documentation: https://api-docs.easyecom.io/#b675a104-2ee3-440d-a5fb-d3ea0d0a4a5b
Replication: Fulload
Replication Key: NA
Fields
| FULLNAME | DATATYPE |
credit_note_id |
NUMERIC |
invoice_id |
NUMERIC |
order_id |
NUMERIC |
reference_code |
STRING |
company_name |
STRING |
warehouseId |
NUMERIC |
forward_shipment_pickup_address |
STRING |
forward_shipment_pickup_city |
STRING |
forward_shipment_pickup_state |
STRING |
forward_shipment_pickup_pin_code |
STRING |
forward_shipment_pickup_country |
STRING |
order_type |
STRING |
order_type_key |
STRING |
replacement_order |
NUMERIC |
marketplace |
STRING |
marketplace_id |
NUMERIC |
salesmanUserId |
NUMERIC |
order_date |
DATETIME |
invoice_date |
DATETIME |
import_date |
DATETIME |
last_update_date |
DATETIME |
manifest_date |
DATETIME |
credit_note_date |
DATETIME |
return_date |
DATE |
manifest_no |
STRING |
invoice_number |
STRING |
credit_note_number |
STRING |
batch_id |
NUMERIC |
payment_mode |
STRING |
payment_mode_id |
NUMERIC |
buyer_gst |
STRING |
forward_shipment_customer_name |
STRING |
forward_shipment_customer_contact_num |
STRING |
forward_shipment_customer_address_line_1 |
STRING |
forward_shipment_customer_address_line_2 |
STRING |
forward_shipment_customer_city |
STRING |
forward_shipment_customer_pin_code |
STRING |
forward_shipment_customer_state |
STRING |
forward_shipment_customer_country |
STRING |
forward_shipment_customer_email |
STRING |
forward_shipment_billing_name |
STRING |
forward_shipment_billing_address_1 |
STRING |
forward_shipment_billing_address_2 |
STRING |
forward_shipment_billing_city |
STRING |
forward_shipment_billing_state |
STRING |
forward_shipment_billing_pin_code |
STRING |
forward_shipment_billing_country |
STRING |
forward_shipment_billing_mobile |
STRING |
order_quantity |
NUMERIC |
total_invoice_amount |
NUMERIC |
total_invoice_tax |
NUMERIC |
invoice_collectable_amount |
NUMERIC |
items |
RECORD |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
_daton_batch_id |
NUMERIC |
total_invoice_tax_bn |
BIGNUMERIC |
total_invoice_amount_bn |
BIGNUMERIC |
invoice_collectable_amount_bn |
BIGNUMERIC |
marketplace_invoice_num |
STRING |
credit_note_amount |
BIGNUMERIC |
credit_note_tax_amount |
NUMERIC |
credit_note_tax_amount_bn |
BIGNUMERIC |
credit_note_amount_nu |
NUMERIC |
return_type |
STRING |
return_awb_number |
STRING |
seller_gst |
STRING |
items.company_product_id |
NUMERIC |
items.product_id |
NUMERIC |
items.suborder_id |
NUMERIC |
items.suborder_num |
STRING |
items.return_reason |
STRING |
items.inventory_status |
STRING |
items.shipment_type |
STRING |
items.suborder_quantity |
NUMERIC |
items.returned_item_quantity |
NUMERIC |
items.tax_type |
STRING |
items.total_item_selling_price |
STRING |
items.credit_note_total_item_shipping_charge |
BIGNUMERIC |
items.item_tax_rate |
NUMERIC |
items.credit_note_total_item_tax |
NUMERIC |
items.credit_note_total_item_excluding_tax |
NUMERIC |
items.sku |
STRING |
items.productName |
STRING |
items.description |
STRING |
items.category |
STRING |
items.brand |
STRING |
items.model_no |
STRING |
items.product_tax_code |
STRING |
items.ean |
STRING |
items.size |
STRING |
items.cost |
NUMERIC |
items.mrp |
NUMERIC |
items.weight |
NUMERIC |
items.length |
NUMERIC |
items.width |
NUMERIC |
items.height |
NUMERIC |
Inventory Details
Purpose: Fetches inventory details
Source API Documentation: https://api-docs.easyecom.io/#0274a076-0ffd-4491-b432-5f02383675e8
Replication: Fulload
Replication Key: NA
Fields
| FULLNAME | DATATYPE |
companyId |
NUMERIC |
companyName |
STRING |
companyProductId |
NUMERIC |
productId |
NUMERIC |
availableInventory |
NUMERIC |
reservedInventory |
STRING |
sku |
STRING |
mrp |
NUMERIC |
creationDate |
DATETIME |
lastUpdateDate |
DATETIME |
cost |
NUMERIC |
skuTaxRate |
NUMERIC |
color |
STRING |
size |
STRING |
weight |
NUMERIC |
height |
NUMERIC |
length |
NUMERIC |
width |
NUMERIC |
category |
STRING |
ImageUrl |
STRING |
brand |
STRING |
productName |
STRING |
modelNo |
STRING |
description |
STRING |
is_combo |
NUMERIC |
skuTaxRate_bn |
BIGNUMERIC |
productUniqueCode |
STRING |
weight_bn |
BIGNUMERIC |
height_bn |
BIGNUMERIC |
length_bn |
BIGNUMERIC |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
_daton_batch_id |
NUMERIC |
Inventory Snahpshot
Purpose: Fetches inventory snapshots
Source API Documentation: https://api-docs.easyecom.io/#0274a076-0ffd-4491-b432-5f02383675e8
Replication: Key-Based
Replication Key: LastDateRun
Fields
| fullname | type |
c_id |
NUMERIC |
companyname |
STRING |
job_type_id |
NUMERIC |
entry_date |
DATETIME |
file_url |
STRING |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
_daton_batch_id |
NUMERIC |
Orders
Purpose: Retrieves list of orders
Source API Documentation: https://api-docs.easyecom.io/#0274a076-0ffd-4491-b432-5f02383675e8
Replication: Key-Based
Replication Key: LastDateRun
| FULLNAME | DATATYPE |
invoice_id |
NUMERIC |
order_id |
NUMERIC |
queue_status |
NUMERIC |
order_priority |
NUMERIC |
blockSplit |
NUMERIC |
reference_code |
STRING |
company_name |
STRING |
warehouseId |
NUMERIC |
import_warehouse_id |
NUMERIC |
import_warehouse_name |
STRING |
pickup_address |
STRING |
pickup_city |
STRING |
pickup_state |
STRING |
pickup_pin_code |
STRING |
pickup_country |
STRING |
order_type |
STRING |
order_type_key |
STRING |
replacement_order |
NUMERIC |
marketplace |
STRING |
marketplace_id |
NUMERIC |
qcPassed |
NUMERIC |
salesmanUserId |
NUMERIC |
order_date |
DATETIME |
tat |
DATETIME |
invoice_date |
STRING |
import_date |
DATETIME |
last_update_date |
DATETIME |
courier |
STRING |
carrier_id |
NUMERIC |
Package Weight |
NUMERIC |
Package Height |
NUMERIC |
Package Length |
NUMERIC |
Package Width |
NUMERIC |
order_status |
STRING |
order_status_id |
NUMERIC |
payment_mode |
STRING |
payment_mode_id |
NUMERIC |
buyer_gst |
STRING |
customer_name |
STRING |
contact_num |
STRING |
address_line_1 |
STRING |
address_line_2 |
STRING |
city |
STRING |
pin_code |
STRING |
state |
STRING |
country |
STRING |
email |
STRING |
billing_name |
STRING |
billing_address_1 |
STRING |
billing_address_2 |
STRING |
billing_city |
STRING |
billing_state |
STRING |
billing_pin_code |
STRING |
billing_country |
STRING |
billing_mobile |
STRING |
order_quantity |
NUMERIC |
total_amount |
NUMERIC |
total_tax |
NUMERIC |
total_shipping_charge |
NUMERIC |
total_discount |
NUMERIC |
collectable_amount |
NUMERIC |
tcs_rate |
NUMERIC |
tcs_amount |
NUMERIC |
customer_code |
STRING |
suborders |
RECORD |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
_daton_batch_id |
NUMERIC |
documents |
RECORD |
seller_gst |
STRING |
manifest_date |
DATETIME |
manifest_no |
STRING |
invoice_number |
STRING |
shipping_last_update_date |
DATETIME |
awb_number |
STRING |
shipping_status |
STRING |
shipping_status_id |
NUMERIC |
payment_gateway_transaction_number |
STRING |
payment_gateway_name |
STRING |
total_tax_bn |
BIGNUMERIC |
batch_id |
NUMERIC |
batch_created_at |
DATETIME |
total_shipping_charge_bn |
BIGNUMERIC |
total_amount_bn |
BIGNUMERIC |
total_discount_bn |
BIGNUMERIC |
collectable_amount_bn |
BIGNUMERIC |
Package_Length_bn |
BIGNUMERIC |
Package_Width_bn |
BIGNUMERIC |
marketplace_invoice_num |
STRING |
queue_message |
STRING |
shipping_history |
RECORD |
Package_Weight_bn |
BIGNUMERIC |
available_after |
DATETIME |
Package_Weight_st |
STRING |
Package_Height_st |
STRING |
Package_Length_st |
STRING |
Package_Width_st |
STRING |
Package_Height_bn |
BIGNUMERIC |
suborders.suborder_id |
NUMERIC |
suborders.suborder_num |
STRING |
suborders.item_status |
STRING |
suborders.shipment_type |
STRING |
suborders.suborder_quantity |
NUMERIC |
suborders.item_quantity |
NUMERIC |
suborders.returned_quantity |
NUMERIC |
suborders.cancelled_quantity |
NUMERIC |
suborders.shipped_quantity |
NUMERIC |
suborders.serial_nums |
STRING |
suborders.batchcode_serial |
STRING |
suborders.tax_type |
STRING |
suborders.suborder_history |
RECORD |
suborders.suborder_history.qc_pass_datetime |
DATETIME |
suborders.selling_price |
STRING |
suborders.total_shipping_charge |
BIGNUMERIC |
suborders.tax_rate |
NUMERIC |
suborders.tax |
NUMERIC |
suborders.product_id |
NUMERIC |
suborders.company_product_id |
NUMERIC |
suborders.sku |
STRING |
suborders.sku_type |
STRING |
suborders.sub_product_count |
NUMERIC |
suborders.marketplace_sku |
STRING |
suborders.productName |
STRING |
suborders.description |
STRING |
suborders.category |
STRING |
suborders.brand |
STRING |
suborders.model_no |
STRING |
suborders.product_tax_code |
STRING |
suborders.ean |
STRING |
suborders.size |
STRING |
suborders.cost |
NUMERIC |
suborders.mrp |
NUMERIC |
suborders.weight |
NUMERIC |
suborders.length |
NUMERIC |
suborders.width |
NUMERIC |
suborders.height |
NUMERIC |
suborders.scheme_applied |
NUMERIC |
documents.easyecom_invoice |
STRING |
documents.label |
STRING |
documents.marketplace_tax_invoice |
STRING |
shipping_history.status |
STRING |
shipping_history.time |
DATETIME |
shipping_history.location |
STRING |
