Etsy

Locating Etsy Shop Name

1. Open & login to your Etsy store (https://www.etsy.com/).

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

Source documentation: https://developer.etsy.com/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