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
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