How Do I Upload a Csv File to Etsy

How oftentimes practise you export data from your Etsy store? Not enough, likely. However, recently we've faced an interesting apply example. One Etsy shop owner wanted to sum upwardly her stats for the twelvemonth to reward the most loyal customers. For this, she needed to export the Etsy gild report in CSV to Google Sheets. In this blog mail service, we'll explain how she handled the task and what exporting options are available in Etsy.

What data can I download from my Etsy shop?

Etsy allows its sellers to download the following store data:

• Currently for Sale Listings in CSV including championship, clarification, tags, and other data.
• Orders in CSV that include ii types of reports:
  • Social club CSV written report – sales data at the order level.
  • Order Detail CSV report – sales data at an individual item level.
• Store Settings in JSON including the name, announcement, and other descriptive information.
• Customer reviews in JSON.

CSV and JSON data are downloaded as CSV and JSON files to your device, respectively.

Download CSV from Etsy

Etsy allows yous to download information well-nigh orders and agile listings of your Etsy shop, as a CSV file.

Etsy orders report in CSV

Etsy users can download sales data in the grade of two types of reports: Order CSV and Society Particular CSV. Check out the difference between ii of them in terms of fields that volition exist exported:

Order CSV report

Order Particular CSV report

– Sale Date – Lodge ID – Buyer User ID – Full Name – First Proper noun – Concluding Name – Number of Items – Payment Method – Date Shipped – Street 1 – Street 2 – Transport Urban center – Ship Country – Ship Zipcode – Ship Country – Currency – Order Value – Coupon Code – Coupon Details – Discount Amount – Shipping Discount – Shipping – Sales Tax – Gild Total – Status – Card Processing Fees – Club Cyberspace – Adjusted Order Total – Adjusted Carte du jour Processing Fees – Adapted Net Order Amount – Buyer – Social club Type – Payment Type – InPerson Discount – InPerson Location – SKU

– Sale Date – Item Proper name – Buyer – Quantity – Price – Coupon Code – Coupon Details – Discount Amount – Shipping Disbelieve – Order Shipping – Order Sales Revenue enhancement – Item Full – Currency – Transaction ID – Listing ID – Date Paid – Date Shipped – Transport Proper noun – Send Address1 – Send Address2 – Ship City – Transport Country – Transport Zipcode – Transport State – Order ID – Variations – Order Blazon – Listings Type – Payment Type – InPerson Discount – InPerson Location – VAT Paid by Buyer – SKU

How to export orders from Etsy to CSV

To download either of the reports, go to Shop director => Settings => Options and select the Download Data tab.

• 

Observe the Orders section, choose the blazon of CSV written report and period (month and year) and click Download CSV.

• 

You at present have a CSV file with your sales data on your device. You tin can import this file into Google Sheets or some other spreadsheet app to process the data. This is how information technology looks in Google Sheets:

• 

Alternatively, you lot can upload the CSV file to your cloud storage, such as Google Drive or Dropbox, and export CSV data to Google Sheets from there.

How to consign Etsy listings to CSV

In a similar style, you can export to CSV the information of the listings that are currently for auction in your shop. Again, get to Store manager => Settings => Options => Download Data tab. Click "Download CSV" in the Currently for Sale Listings department, and the file will be exported to your device.

• 

After the import to Google Sheets, the data will appear as follows:

• 

How to automate export of Etsy CSV orders to Google Sheets

You tin can export your Etsy orders every month by paw, or automate exports on a schedule. The latter sounds pretty good, doesn't it? The best thing is that you don't accept to code to make this happen. Follow the instructions below to implement automated exports of Etsy orders or gild items to Google Sheets.

Stride 1: Cull the CSV to download and open Chrome Dev tools

Become to Southhop director => Settings => Options and select the Download Data tab (just like nosotros described in the above department). Choose the type of CSV written report (Club Items or Orders) and period (month and year).

Right-click and choose "Inspect" => this will open Chrome Dev Tools. Click on the "Network" tab.

• 

Stride 2: Download CSV and find cookie:

Click "Download CSV". A new request will appear in the Network tab of the Chrome Dev Tools.

• 

Click on the new request, gyre down to the Request Headers department and find the cookie: header.

• 

Click on it and copy it to a text editor.

Step iii: Remove the unnecessary cookies

Browse your cookie: header, and remove the values that brainstorm with the following symbols:

• _gid
• _uetsid
• _uetvid
• session-key-www
• session-cardinal-apex
• exp_hangover
• _gcl_au

Doing this should continue the header working for i year. In our example, we but had to remove the following:

exp_hangover=uzz1QZvdiPneM_5cfxxX7mL18Q5jZACCeEX1DhCdEOzOUq1UnpoUn1hUkpmWmZyZmBOfk1iSmpdcGV9oEm9kYGipZKWUmZeak5memZSTqlTLAAA.;

Step 4: Configure the CSV importer

Coupler.io is an all-in-one solution for importing data to Google Sheets from different sources including apps (Airtable, Pipedrive, Xero, etc.) and information sources (CSV, XLSC, JSON). CSV importer is an integration by Coupler.io to export data from online published CSV, TSV, and Excel files to Google Sheets. This tool volition help you automate exports of Etsy orders. Y'all need to:

• Sign in to Coupler.io and click "Add together importer".

• 

• Name your new importer whatever you lot want and cull CSV as the source application. Click "Continue".

• 

• Insert the following URL into the CSV URL field and click "Proceed".

https://www.etsy.com/your/orders/sold.csv

• 

• Configure the following parameters:

HTTP method: GET

Asking headers:

cookie: {insert-your-cookie-header-value-except-for-the-removed values}

URL query string:

For orders

csv-type: guild-level  calendar month: {ane-to-12 or skip} twelvemonth: {year}

For order items

csv-type: transaction-level  month: {1-to-12 or skip} twelvemonth: {year}

You should get something similar this:

• 

• Click "Proceed to Destination Settings" where you need to configure the Destination:
  • Destination account: add your Google account.
  • Spreadsheet: select your Google Sheets dr. and the sheet that volition be receiving your Etsy orders data.
  • Click "Proceed to Schedule Settings".

• 

• Configure the schedule for automated data exports of your Etsy orders to Google Sheets.

• 

Click "Save and Run" to become your information into the spreadsheet.

Now y'all can get your Etsy orders to Google Sheets automatically. At the same time, you can export other Etsy data using Coupler.io. Check out the next section to acquire more.

Export data from Etsy to Google Sheets

Would you concord that the Etsy native exporting functionality is rather scarce? Some users may need to procedure other valuable data such every bit receipts, transactions, and many others. Actually, this is possible using the Etsy API, only it'due south not that obvious. We'll explain the basics and show how y'all tin can import some data using Coupler.io. Y'all'll take to consummate two major steps:

• Get an Etsy API cardinal
• Set up the JSON Client importer to import data

Let'due south go step past step.

How to get an Etsy API key

An API key is a required parameter to import data from Etsy. To get it, you'll need to register a "dummy" Etsy app. Follow this link to create a new Etsy app.

• 

Fill out the following fields:

• Awarding proper name
• Awarding description
• Awarding website (you can leave it bare)

• 

Then mark the following checkboxes:

• 

Once ready, click Read Terms and Create App and agree to the Etsy API Terms of Use. Another click on Create App and at that place you become!

• 

This procedure was needed more often than not to get the KEYSTRING (here, "f36sdf6v4h21ldoekrmns5pk"), which we will use to import data with Coupler.io.

Coupler.io to import data via APIs to Google Sheets

Nosotros've already introduced the ability of Coupler.io in the example of the CSV importer. Now, permit'south check out another tool: JSON Client. Since well-nigh REST APIs interchange data in JSON format, y'all can utilise JSON Customer to import JSON data to spreadsheets without coding.

This fourth dimension, we'll describe the workflow for the Coupler.io add-on that allows you to connect to Etsy right from your Google Sheets medico. To showtime using the tool, install Coupler.io from Google Workspace Marketplace.

• 

Alternatively, you can use the Coupler.io web interface to set up the connection. Check out how information technology works in the example of the Stripe to Google Sheets integration.

Subsequently that, open your spreadsheet and go to Add-Ons => Coupler.io => Open up Dashboard. Click +Add importer and cull JSON Client.

Now, let the magic begin 🙂

How to import data via Etsy API

To import data using the Etsy API, you need to use a JSON URL that matches a specific category of data you need. Let's get a list of all information entities you can import. For this, enter the post-obit URL in the JSON URL field of your JSON Client importer:

                https://openapi.etsy.com/v2?api_key={KEYSTRING}              

• {KEYSTRING} – insert the KEYSTRING yous obtained in one case created an Etsy app

Click Save&Run and welcome the data imported from Etsy in Google Sheets.

• 

We've got 242 records of data entities or resources as they are chosen co-ordinate to Etsy API documentation. However, we are going to use just those that fall under ii categories:

• results.http_method – GET (column I)
• results.visibility – Public (column H)

Considering Become is the type of requests to fetch information from API and public resource are what we tin export with an API central without OAuth authorization.

Use the Google Sheets filter functionality to filter data by these two categories. Click on the Filter button on the toolbar:

• 

After that, the filter icon appears adjacent to the name of each column. Click the icon on the column you lot want to filter, and select the filter criteria. For case, hither is how we filtered out the GET values in the results.http_method cavalcade:

• 

One time nosotros take filtered the values by two criteria (Get and public), we have 97 entities.

• 

One of them is to import all active listings – what nosotros've already done when exporting electric current for sale listings in CSV. Allow's check out how information technology works.

Import Etsy active listings to Google Sheets

In the results.uri column, you'll find the URI to attach to the base Etsy API  URL.

Base of operations Etsy API URL is:

                https://openapi.etsy.com/v2/              

Note that there are a few URIs associated with agile listings:

• /shops/:shop_id/listings/active – imports active listings of a certain Etsy store. You can use the shop name as :shop_id
• /listings/active – imports active listings of the entire Etsy marketplace (you can import the results from all Etsy shops filtered by land, keyword, price, etc.)

And so, the JSON URL to import active listings should expect as follows:

                https://openapi.etsy.com/v2/listings/active?api_key={KEYSTRING}              

Let'due south import all agile listings with the following filters:

• Minimum toll – $30
• Maximum price – $40
• Tag – necklace

Here are the parameters y'all should use in the JSON Customer importer:

We've also specified the post-obit destination Canvas Proper name (where your data will be imported to): "Active listings price <40 and >xxx". Click Save&Run, and at that place y'all go!

• 

You lot tin meet that some of the results have price values outside of the specified range; for case 27GBP and 285TRY. The default currency is USD, and then Etsy tin return results in other currencies that correspond to the specified range based on the actual currency rate.

Etsy will render results with a limit of 25 records per page. Yous can increase this value up to 100 (maximum value) with the help of the "limit: 100" parameter. To get the next records, yous need to use the "folio:" parameter and specify the page number.

In our instance, to go the next 25 records, we should use the post-obit JSON Client parameters:

Source
JSON URL	https://openapi.etsy.com/v2/listings/active?api_key={KEYSTRING}
HTTP Method	GET
URL query string	min_price: 30 max_price: 40 tags: necklace folio: two
Settings
Import mode	append

Click Save&Run, and the next 25 records will be appended to the kickoff imported data prepare:

• 

How can I export receipts and other individual information from Etsy?

With the solution above, yous won't be able to consign certain data, such as expired listings or receipts. To go the private account data from Etsy (receipts, client's emails, etc.), you need to obtain OAuth credentials and make authorized requests to the Etsy API. It's possible, but requires some additional manipulations and a bit of tech skill.

However, if this is definitely what you need, fill out this course and specify that yous'd dear to take a ready-to-employ Etsy integration bachelor at Coupler.io. Our team volition do their best to make this happen.

Use case: How to identify elevation buyers of your Etsy shop

To wrap up, let's go dorsum to our user who needed to export information from Etsy to identify which customers made the most purchases during the twelvemonth. She downloaded the social club written report in CSV and uploaded it to Google Sheets, as we described above. The next steps were:

• Calculating how many items each client bought in 2020
• Calculating how much each customer spent in 2020
• Grouping these results by each unique customer

All these can exist done using the Google Sheets QUERY role. Here is what the formula looks like:

=query(EtsySoldOrders2020!D:10; "select D, sum(G), sum(10) grouping by D")

• 

Now, for this data set, we demand to extract the top v customers by the number of items bought and the top 5 customers past the total spending. QUERY function will do the task equally well:

Top v by the number of items:

=Query(A2:B; "select A,B where A<>'' society by B desc limit 5")

Peak five by total spending:

=Query(A2:C; "select A,C where A<>'' gild by C desc limit 5")

• 

We hope that this utilise case volition inspire you to reward your most loyal customers equally well. Adept luck with your data!

Back to Web log

Access your information

in a simple format for free!

Start Free

francismoren1991.blogspot.com

Source: https://blog.coupler.io/etsy-to-csv/

Share this post