# Etsy
## **Locating Etsy Shop Name**
1. Open & login to your Etsy store ().
2. Navigate to your shop settings button, right new to the cart.
3\. The name above "view your profile" is your shop name, use that name while creating an integration.
## **Snapshot**
| **Features** | **Details** |
| ------------------------------- | --------------------------------- |
| Release Status | Released |
| Source API Version | V3 |
| Table Selection | Yes |
| Column Selection | Yes |
| Edit Integrations | Yes |
| Replication Type Selection | No |
| Authentication Parameters | Client ID
Client Secret
|
| Replication Type | Full Load
Incremental
|
| Replication Key | Date |
| Suggested Replication Frequency | 1 hr |
## **Integrate Etsy with Daton**
1\. Sign in to Daton.
2\. Select Etsy from the Integrations page.
3\. Provide Integration Name Replication Frequency and History.
4\. Provide your shop name here as explained [above](#locating-etsy-shop-name).
5\. A popup prompt will open to authorize Daton to access data, click the “Grant access” button.
6\. Post successful authentication you will be prompted to choose from the list of available tables.
7\. Submit the integration.
## **Etsy Payments Tables**
Source documentation:
1. **ListingsbyShop**\
Purpose: To get information about all the listings & corresponding listing images.\
Replication: Incremental (Limit & Offset)\
\
**Fields**
| **Field name** | **Datatype** |
| ----------------------------- | ------------ |
| price | RECORD |
| production\_partners | RECORD |
| ListingImages | RECORD |
| ListingInventory | RECORD |
| listing\_id | INTEGER |
| user\_id | INTEGER |
| shop\_id | INTEGER |
| title | STRING |
| description | STRING |
| state | STRING |
| creation\_timestamp | INTEGER |
| ending\_timestamp | INTEGER |
| original\_creation\_timestamp | INTEGER |
| last\_modified\_timestamp | INTEGER |
| state\_timestamp | INTEGER |
| quantity | INTEGER |
| featured\_rank | INTEGER |
| url | STRING |
| num\_favorers | INTEGER |
| non\_taxable | BOOLEAN |
| is\_taxable | BOOLEAN |
| is\_customizable | BOOLEAN |
| is\_personalizable | BOOLEAN |
| personalization\_is\_required | BOOLEAN |
| listing\_type | STRING |
| tags | STRING |
| shipping\_profile\_id | NUMERIC |
| processing\_min | INTEGER |
| processing\_max | INTEGER |
| who\_made | STRING |
| when\_made | STRING |
| is\_supply | BOOLEAN |
| item\_weight | NUMERIC |
| item\_weight\_unit | STRING |
| item\_length | NUMERIC |
| item\_width | NUMERIC |
| item\_height | INTEGER |
| item\_dimensions\_unit | STRING |
| is\_private | BOOLEAN |
| file\_data | STRING |
| has\_variations | BOOLEAN |
| should\_auto\_renew | BOOLEAN |
| language | STRING |
| taxonomy\_id | INTEGER |
| skus | STRING |
| item\_height\_nu | NUMERIC |
| ListingImagesVariants | RECORD |
2\. **Receipts**\
Purpose: To get all the receipts from your store.\
Replication: Incremental\
Replication Key: Last\_modified
| **Field name** | **Datatype** |
| --------------------- | ------------ |
| grandtotal | RECORD |
| subtotal | RECORD |
| total\_price | RECORD |
| total\_shipping\_cost | RECORD |
| total\_tax\_cost | RECORD |
| total\_vat\_cost | RECORD |
| discount\_amt | RECORD |
| gift\_wrap\_price | RECORD |
| transactions | RECORD |
| receipt\_id | NUMERIC |
| receipt\_type | INTEGER |
| seller\_user\_id | INTEGER |
| seller\_email | STRING |
| buyer\_user\_id | INTEGER |
| buyer\_email | STRING |
| name | STRING |
| first\_line | STRING |
| second\_line | STRING |
| city | STRING |
| state | STRING |
| zip | INTEGER |
| status | STRING |
| formatted\_address | STRING |
| country\_iso | STRING |
| payment\_method | STRING |
| payment\_email | STRING |
| message\_from\_buyer | STRING |
| is\_shipped | BOOLEAN |
| is\_paid | BOOLEAN |
| create\_timestamp | INTEGER |
| update\_timestamp | INTEGER |
| is\_gift | BOOLEAN |
| gift\_message | STRING |
| shipments | RECORD |
| zip\_st | STRING |
| receipt\_id\_in | INTEGER |
3\. **Reviews**\
Purpose: To get information about all the listing reviews.\
Replication: Incremental (Limit & Offset)
| **Field name** | **Datatype** |
| --------------------- | ------------ |
| shop\_id | INTEGER |
| listing\_id | INTEGER |
| transaction\_id | NUMERIC |
| buyer\_user\_id | INTEGER |
| rating | INTEGER |
| review | STRING |
| language | STRING |
| create\_timestamp | INTEGER |
| update\_timestamp | INTEGER |
| image\_url\_fullxfull | STRING |
| transaction\_id\_in | INTEGER |
4\. **Transactions**\
Purpose: To get information about all the transactions from your shop.\
Replication: Incremental (Limit & Offset)
| **Field name** | **Datatype** |
| --------------------- | ------------ |
| price | RECORD |
| shipping\_cost | RECORD |
| transaction\_id | NUMERIC |
| title | STRING |
| description | STRING |
| seller\_user\_id | INTEGER |
| buyer\_user\_id | INTEGER |
| create\_timestamp | INTEGER |
| paid\_timestamp | INTEGER |
| shipped\_timestamp | INTEGER |
| quantity | INTEGER |
| listing\_image\_id | NUMERIC |
| receipt\_id | NUMERIC |
| is\_digital | BOOLEAN |
| file\_data | STRING |
| listing\_id | INTEGER |
| sku | STRING |
| product\_id | NUMERIC |
| transaction\_type | STRING |
| shipping\_profile\_id | NUMERIC |
| min\_processing\_days | INTEGER |
| max\_processing\_days | INTEGER |
| expected\_ship\_date | INTEGER |
| receipt\_id\_in | INTEGER |
| transaction\_id\_in | INTEGER |
| variations | RECORD |
5\. **User Addresses**\
Purpose: To get information about all your user's addresses\
Replication: Incremental (Limit & Offset)
| **Field name** | **Datatype** |
| ------------------------------ | ------------ |
| user\_address\_id | NUMERIC |
| user\_id | INTEGER |
| name | STRING |
| first\_line | STRING |
| second\_line | STRING |
| city | STRING |
| state | STRING |
| zip | INTEGER |
| iso\_country\_code | STRING |
| country\_name | STRING |
| is\_default\_shipping\_address | BOOLEAN |
| zip\_st | STRING |