Easyecom
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 |
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.
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 |
description | STRING |
add_date | TIMESTAMP |
update_date | TIMESTAMP |
product_unique_code | 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 |
category | STRING |
brand | STRING |
c_id | NUMERIC |
inventory_threshold | STRING |
EANNumber | NUMERIC |
customFields | RECORD |
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 |
Last modified 1yr ago