Easyecom

Snapshot

Feature
Details
Release Status
Released
Source API Version
V2
Table selection
Yes
Column selection
Yes
Edit integration
Yes
Replication Type Selection
No
Authentication Parameters
Email ID Password
Replication Type
Incremental Full Load
Replication Key
created/updated
Suggested Replication Frequency
1hr

Integrate Easyecom with Daton

1. Signin to Daton.
2. Select Easyecom from the list of Integrations.
3. Provide Integration Name, Replication Frequency, and History. The integration name would be used in creating tables for the integration and cannot be changed later.
4. Enter your Easyecom login email and password.
5. Post successful authentication, you will be prompted to choose from the list of available tables.
6. Then select all required fields for each table.
7. Submit the integration.

Easyecom Tables

1. All orders Purpose: To get information about all the orders. Replication: Incremental Replication key: updated_at Fields
Field name
Datatype
marketplace
STRING
marketplace_id
NUMERIC
reference_code
NUMERIC
order_id
NUMERIC
order_date
TIMESTAMP
ptotal_amount
NUMERIC
tax_rate
NUMERIC
awb_number
NUMERIC
invoice_id
NUMERIC
marketplace_invoice_num
STRING
invoice_number
STRING
order_status
STRING
customer_name
STRING
state
STRING
address_line_1
STRING
address_line_2
STRING
pin_code
NUMERIC
city
STRING
suborders
RECORD
2. Returns Purpose: To get information about all the returns. Replication: Incremental Replication key: order_date Fields
Field name
Datatype
order_id
NUMERIC
order_item_id
STRING
sku
STRING
order_date
TIMESTAMP
returned_date
DATE
quantity
NUMERIC
marketplace_name
STRING
3. PurchaseOrders Purpose: To get information about all purchase orders. Replication: Incremental Replication key: po_created_date Fields
Field name
Datatype
po_items
RECORD
po_id
INTEGER
total_po_value
STRING
po_number
INTEGER
po_ref_num
STRING
po_status_id
INTEGER
po_created_date
DATETIME
po_updated_date
DATETIME
po_created_warehouse
STRING
po_created_warehouse_c_id
INTEGER
vendor_name
STRING
vendor_c_id
INTEGER
4. Customers Purpose: To get information about all customers. Replication: Full load Fields
Field name
Datatype
company_invoice_group_id
NUMERIC
c_id
NUMERIC
companyname
STRING
pricingGroup
STRING
customer_support_email
STRING
customer_support_contact
NUMERIC
branddescription
STRING
currency_code
STRING
gstNum
STRING
billingStreet
STRING
billingCity
STRING
billingZipcode
NUMERIC
billingState
STRING
billingCountry
STRING
dispatchStreet
STRING
dispatchCity
STRING
dispatchZipcode
NUMERIC
dispatchState
STRING
dispatchCountry
STRING
5. Inventory Purpose: To get information about all inventory. Replication: Full load Fields
Field name
Datatype
warehouseName
STRING
company_product_id
NUMERIC
product_id
NUMERIC
inventory
INTEGER
reserve_inventory
INTEGER
brand
STRING
category
STRING
ImageUrl
STRING
brand_id
NUMERIC
title
STRING
model
STRING
mrp
NUMERIC
sku
STRING
Total_Inventory
INTEGER
is_combo
INTEGER
virtual_inventory_count
INTEGER
6. ProductList Purpose: To get information about all the product listings. Replication: Full load Fields
Field name
Datatype
productId
NUMERIC
accounting_sku
STRING
accounting_unit
STRING
weight
NUMERIC
length
NUMERIC
width
NUMERIC
height
NUMERIC
hsn_code
NUMERIC
sku
STRING
inventoryThreshold
STRING
size
STRING
colour
STRING
model_no
STRING
name
STRING
brands
STRING
category
STRING
mrp
NUMERIC
cost
NUMERIC
product_image_url
STRING
7. Masterproduct Purpose: To get information about all the master products based on location. Replication: Full load Fields
Field name
Datatype
productId
NUMERIC
sku
STRING
accountingSku
STRING
accountingUnit
STRING
mrp
NUMERIC
add_date
TIMESTAMP
lastUpdateDate
TIMESTAMP
cost
NUMERIC
HSNCode
NUMERIC
colour
STRING
weight
NUMERIC
height
NUMERIC
length
NUMERIC
width
NUMERIC
size
STRING
material_type
NUMERIC
modelNumber
STRING
description
STRING
modelName
STRING
8. Vendors Purpose: To get information about all the vendors. Replication: Full load Fields
Field name
Datatype
cid
NUMERIC
firstname
STRING
primary_contact
STRING
companyname
STRING
email
STRING
code
STRING
token
STRING