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