Etsy
Locating Etsy Shop Name
Open & login to your Etsy store (https://www.etsy.com/).
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
Source documentation: https://developer.etsy.com/documentation/
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 |
Last updated