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

1. Signin to Daton

2. Select Impact from Integrations page

3. Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later

4. Provide your EasyEcom email address and EasyEcom password.

5. After providing the details to authorize Daton to periodically extract data from Impact.

6. Post successful authentication you will be prompted to choose from the list of available tables

7. Then select all required fields for each table

8. Submit the integration.

Workflow

1. 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

2. Users would be able to edit/pause/re-activate/delete integration anytime

3. 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