Etsy

Locating Etsy Shop Name

  1. 1.
    Open & login to your Etsy store (https://www.etsy.com/).
  2. 2.
    Navigate to your shop settings button, right new to the cart.
The text above "View your profile" is your shop name.

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

  1. 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
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
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
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
Last modified 1mo ago