# 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       | <p>Email ID<br>Password </p>    |
| Replication Type                | <p>Incremental<br>Full Load</p> |
| 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.

&#x20;

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

\ <br>

2\.     Returns\
Purpose: To get information about all the returns.\
Replication: Incremental\
Replication key: order\_date\
**Fields**

| <p> </p><p><strong>Field name</strong></p><p> </p> | <p> </p><p><strong>Datatype</strong></p><p> </p> |
| -------------------------------------------------- | ------------------------------------------------ |
| order\_id                                          | NUMERIC                                          |
| order\_item\_id                                    | STRING                                           |
| sku                                                | STRING                                           |
| order\_date                                        | TIMESTAMP                                        |
| returned\_date                                     | DATE                                             |
| quantity                                           | NUMERIC                                          |
| marketplace\_name                                  | STRING                                           |

\ <br>

3\.     PurchaseOrders\
Purpose: To get information about all purchase orders.\
Replication: Incremental\
Replication key: po\_created\_date\
**Fields**

| <p> </p><p><strong>Field name</strong></p><p> </p> | <p> </p><p><strong>Datatype</strong></p><p> </p> |
| -------------------------------------------------- | ------------------------------------------------ |
| 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                                          |

\ <br>

4\.     Customers\
Purpose: To get information about all customers.\
Replication: Full load\
**Fields**

| <p> </p><p><strong>Field name</strong></p><p> </p> | <p> </p><p><strong>Datatype</strong></p><p> </p> |
| -------------------------------------------------- | ------------------------------------------------ |
| 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                                           |

\
\ <br>

5\.     Inventory\
Purpose: To get information about all inventory.\
Replication: Full load\
**Fields**

| <p> </p><p><strong>Field name</strong></p><p> </p> | <p> </p><p><strong>Datatype</strong></p><p> </p> |
| -------------------------------------------------- | ------------------------------------------------ |
| 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                                          |

\ <br>

6\.     ProductList\
Purpose: To get information about all the product listings.\
Replication: Full load\
**Fields**<br>

| <p> </p><p><strong>Field name</strong></p><p> </p> | <p> </p><p><strong>Datatype</strong></p><p> </p> |
| -------------------------------------------------- | ------------------------------------------------ |
| 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                                           |

\ <br>

7\.     Masterproduct\
Purpose: To get information about all the master products based on location.\
Replication: Full load\
**Fields**

| <p> </p><p><strong>Field name</strong></p><p> </p> | <p> </p><p><strong>Datatype</strong></p><p> </p> |
| -------------------------------------------------- | ------------------------------------------------ |
| 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                                           |

&#x20;

8\.       Vendors\
Purpose: To get information about all the vendors.\
Replication: Full load\
**Fields**

| <p> </p><p><strong>Field name</strong></p><p> </p> | <p> </p><p><strong>Datatype</strong></p><p> </p> |
| -------------------------------------------------- | ------------------------------------------------ |
| cid                                                | NUMERIC                                          |
| firstname                                          | STRING                                           |
| primary\_contact                                   | STRING                                           |
| companyname                                        | STRING                                           |
| email                                              | STRING                                           |
| code                                               | STRING                                           |
| token                                              | STRING                                           |

&#x20;

&#x20;

&#x20;