Easyecom
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
- Signin to Daton.
- Select Easyecom from the list of Integrations.
- Provide Integration Name, Replication Frequency, and History. The integration name would be used in creating tables for the integration and cannot be changed later.
- Enter your Easyecom login email and password.
- 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.
Easyecom Tables
- 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 |
- 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 |
- 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 |
- 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 |
- 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 |
- 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 |
description |
STRING |
add_date |
TIMESTAMP |
update_date |
TIMESTAMP |
product_unique_code |
STRING |
- 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 |
category |
STRING |
brand |
STRING |
c_id |
NUMERIC |
inventory_threshold |
STRING |
EANNumber |
NUMERIC |
customFields |
RECORD |
- 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 |
