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. 1.
    Signin to Daton
  2. 2.
    Select Impact from Integrations page
  3. 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. 4.
    Provide your EasyEcom email address and EasyEcom password.
  5. 5.
    After providing the details to authorize Daton to periodically extract data from Impact.
  6. 6.
    Post successful authentication you will be prompted to choose from the list of available tables
  7. 7.
    Then select all required fields for each table
  8. 8.
    Submit the integration.

Workflow

  1. 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. 2.
    Users would be able to edit/pause/re-activate/delete integration anytime
  3. 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
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