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 | |
- 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.
- 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
Customers
Purpose: Retrieve all customers
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
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
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
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
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
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
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 |