Back to Blog

Export Shopify Data | Types, Methods, Formats, and Apps Available

Do you need to create a backup of your Shopify products? Or, you probably want to share your data with external sub-contractors? No? You’re opening a new store and moving your Shopify data from the current store, right?

We won’t be guessing why you may need to export Shopify data anymore since every user has their own purposes. What we can do is explain the options you can go with to get this job done. 

What data can I export from Shopify?

The most in-demand Shopify data for export is Products, Orders, and Customers. You can pull this data manually as a CSV file or automate data export to Google Sheets (or another destination). 

Beyond this, you can also pull reports, product reviews, gift cards, and much more. Some data is available for manual export as CSV, whereas most of the implicit data can be exported via REST API. But no worries, you don’t have to code to pull, for example, metafields. We’ll explain how you can do this with no code to Google Sheets or Excel. Here is the table with Shopify exportable data:

Type of dataCSVREST API
Products
Product collects
Product collections
Product variants
Product smart collections
Gift cards
Inventory items
Inventory levels
Orders
Abandoned checkouts
Order risks
Refunds
Transactions
Customers
Discount codes
Price rules
Reports
Inventory items
Inventory levels
Marketing events
Metafields
Articles
Assets for a theme
Blogs
Comments
Pages
URL redirects
Script tags
Themes
Payments
Fulfillments 
Balance
Disputes
Payouts
Transactions
Application charges
Store properties

How you can export data from Shopify

There are several options for exporting data from Shopify:

1. Export Shopify store data manually as a CSV file

With this option, you get your Shopify data downloaded as a CSV file to your device. This is well suited for rare or even one-time exports, for example, to migrate a store.

The flow is common: you need to go to the respective page (Products/Orders/Customers/etc.) and click the Export button. You can configure the export, and after that, the file will be either downloaded (for up to 50 records) or emailed to you (for more than 50 records).

We cover this flow in more detail a bit further.

2. Automate Shopify data export to data viz tools and spreadsheet apps 

With this option, you can schedule the export of data automatically on a schedule. For example, your data can be transferred to data viz and BI tools (Looker Studio and PowerBI), to a spreadsheet app (Shopify to Excel or Google Sheets), or to a data warehouse (Shopify to Google BigQuery integration). This is well suited for reporting and analytical purposes, as well as backup. 

For this option, you’ll need to use a third-party app to automate exports. In our example, we’ll be using Coupler.io, a popular data analytics and automation platform. Coupler.io supports out-of-the-box export of Shopify Products (including product variants), Inventory, Customers, and Orders. In addition to those, you can configure the export of other data types, such as transactions, payouts, etc. via the Shopify REST API. 

We explore this option in our article as well.

3. Export data using apps from Shopify app store

The good thing about this option is that you can choose an app that is specific to your needs. The bad thing is that there are way too many apps to choose from. 

Different apps provide different functionality such as “export your store’s data in customizable spreadsheet“, “automate your exports and ensure reliable order processing“, “grab the latest orders from your online store and format to CSV or XLSX file“, and so on.

However, you can search for a solution that suits your needs and maybe find a good fit.

Now, let’s see how to export data from Shopify. First, we explain how to do this automatically, and then we move on to the manual method.

How you can automate data export from Shopify

As we’ve already mentioned, we recommend automating data export with Coupler.io. This is a data analytics and automation platform that allows you to fully automate your data flows. It can collect data from 70+ business apps and send it to Looker Studio and Power BI, Google Sheets and Excel, and BigQuery.

For recurring reporting, analytics, and backups, this is probably the best option. For example, if you use Coupler.io to transfer your Shopify data to Looker Studio, you will receive an auto-updating dashboard. If you prefer to transfer your data to a spreadsheet app, you can create a self-updating report. Coupler.io will channel fresh Shopify data into your destination app, keeping imported information up to date automatically.

The Shopify integrations by Coupler.io allows you to export the following data entities:

  • Customers
  • Inventory
  • Products
  • Orders
  • Order fulfillments
  • Orders with line items
  • Orders with shipping lines
  • Orders refunds transactions

Let’s check out some examples of how you can use the Shopify to Google Sheets integration.

Note: Coupler.io is available as a web app and a Google Sheets add-on. We’ll check out the setup flow for the web app. The flow for the add-on is the same, but you’ll need to install the add-on from the Google Workspace Marketplace.

Example #1: Shopify export products with product id, tags, and other details

We need to export the product’s inventory from our Shopify store. The data should be transferred automatically every hour, so we can track the inventory and share the report with the stakeholders. Besides, we don’t need all the available columns, but only a few ones. 

1. Extract your Shopify data automatically

Sign up for Coupler.io, choose Shopify as your source and select the destination. In our example, it’s Google Sheets, but the process is the same for other destinations as well.

Proceed to the setup, connect your Shopify account, and select a data entity to export. 

2. Preview and transform your Shopify data

Now, you can check and edit the data that you are going to export. 

In particular, you can manage columns – hide those you don’t need, change their order, rename and rearrange columns. The dataset will be exported according to the edits you make. You can also sort and filter your data, as well as blend data from several Shopify accounts, if you connect them as additional data sources. 

Tiny Shopify to Google Sheets transform copy

In this example, we are going to export Products and specify the list of the columns to export:

  • product_id 
  • product_title 
  • product_body_html 
  • product_product_type
  • price 
  • sku 
  • inventory_quantity

This will be enough for a meaningful report, and we won’t have to delete unnecessary columns after the import.

Once this is done, follow instructions to connect your Looker Studio account.

3. Manage your Shopify data

The last touch – let’s make sure that our Shopify report in Google Sheets is self-updating. If you transfer your Shopify data to another destination, that’s applicable as well. Toggle on Automatic data refresh and specify your preferences for the updates. After this, Coupler.io will refresh your Shopify data in the destination app according to your schedule. 

4. Coupler.io schedule

Then, save and run the importer to transfer data.

Here’s what our dataset looks like in Google Sheets.

12 columns results

Will Shopify show stock level in the exported data set?

Sure it will! The column with the stock level data is called inventory_quantity. In the example above, we exported it along with other fields:

13 inventory quantity

Shopify export products with collections

To export data about products of a collection, you need to specify the ID of the collection in the collection ID field when setting up the Shopify source. 

Tiny Shopify export collections

You can find the collection ID in the URL bar of your browser when you select the collection.

9 collection id

Now you can proceed to the configuration of the destination and schedule – the steps are the same. Here is the result in Google Sheets:

15 collection products result

Note: Here we included the same columns as in the example above.

Shopify export collections as Excel

We mentioned that Coupler.io allows you to export data from Shopify to several destinations including Excel. So, to export a collection of products to Excel, you’ll need to complete the same three steps.

  • Extract your data in the same way, but specify Excel as a destination
  • Preview and transform your dataset, if needed
  • Schedule automated updates and manage the exported data

Here is what the exported data looks like in Excel.

17 excel product collection results

Note: Here we included the same columns as in the example above.

Example #2: Shopify export customer data

Let’s check out another case with exporting customer data. As you understand, the flow is mostly the same. The only difference is that you need to select Customers as a data entity when setting up the source.

18 customers data entity

Complete the rest of the flow and run the importer. Here is what the Shopify customer data exported to Google Sheets looks like:

19 customers data results

Example #3: Instantly visualize Shopify data with a free template

If you want to visualize your Shopify data in Looker Studio, you can use the same flow that we already described for Google Sheets. In this case, you will be able to create your data visualization from scratch.

However, you can grab our ready-to-use Shopify dashboard template – and get a copy of the dashboard below in just a few minutes. The template is free, and it’s powered by Coupler.io. This means Coupler.io will transfer fresh Shopify data to this dashboard automatically.

To create your dashboard, go to the Shopify dashboard template and click Readme in the menu on the left. Then, follow the instructions to connect your Shopify and Looker Studio accounts. That’s basically all you need to do – all the settings are pre-configured, so your data will be visualized automatically.

Frequently asked questions about the Shopify integration

Can I export product images from Shopify in this way?

Yes, you can! The product data you get will also contain different information about their images including width, height, id, and URL. You’ll find their URLs in the images.src column.

20 image data

Can I only export visible Shopify products?

Sure you can! By default, you get a list of all products of your store including active and archived ones, as well as drafts. If you need to only export the active products on your Shopify store, choose the respective value in the Product status of the Advanced Settings.

21 product status

Can I export sold-out Shopify products in this way?

Another yes 🙂 The data you can export from Shopify to Google Sheets using Coupler.io will contain the inventory information of your products.

Can I export Shopify pages URL for products?

When you export Shopify to Google Sheets, you don’t get product page URLs for your Shopify products, just product handles. But you can use the power of Google Sheets to automate the creation of URLs using the exported data.

For example, we added a column to the left of the data exported from Shopify. In this case, we edited the Cell address of the Destination setup of our Shopify integration. Now it is B1 instead of A1.

22 cell address

Then we applied the formula, which will concatenate the URL of our Shopify store with the product handle. For this, we nested CONCAT and ARRAYFORMULA functions like this:

={"URL";arrayformula(if(len(H2:H)=0,,concat("https://sf-sandwiches.myshopify.com/products/",H2:H)))}
  • sf-sandwiches.myshopify.com – replace with the name of your Shopify store
  • H2:H – the column with the product handle
23 product url

As a result, we’ve got a column that will generate the product URLs once the product data is exported from Shopify.

Can I export Shopify products with metafields?

This integration will work well for exporting products, as well as orders and customers if you choose them as a data entity. To export other data entities, you can connect to the Shopify API using Coupler.io.

How to export Shopify metafields and other data via API

Let’s say you need to export various implicit data from Shopify, for example, transactions, metafields, etc. You can get these via the Shopify API. 

Coupler.io provides a JSON API connector that you can use to pull data using REST APIs from different apps. You’ll need to select the JSON as a source and configure it to connect to the Shopify API. The latter requires you to get a Shopify API token first.

How to get Shopify API token

To access the Shopify API and export data from your store, you’ll need to create a Shopify custom app.

  1. Go to the Apps menu of your Shopify store.
1 shopify apps
  • Click Develop apps for your store (former Private apps).
2 develop apps for your store
  • Click Create an app.
3 create an app

Note: If you haven’t created any private or custom apps before, you may be asked to enable app development.

  1. Name your app then click Create app.
4 app name
  1. Once the app is created, click Configure Admin API scopes.
5.1configure admin api scopes
  1. Check the read scopes for:
    • Customers – read_customers
    • Inventory – read_inventory
    • Orders – read_orders
    • Products – read_products

Then click Save

5 configure scopes
  1. Click Install app.
6 install app

You’ll find your Shopify API token in the Admin API section.

7 api key

Now you are ready to set up your Shopify integration to export metafields data. Let’s explore one use case to have some practice.

Use case: Shopify export metafields data 

Here are the types that implement metafields in Shopify:

  • Collection
  • Customer
  • DraftOrder
  • Image
  • Order
  • Product
  • ProductVariant
  • Shop

In Shopify, you can’t export all the metafields for a chosen type. For example, you can’t get all the metafields of all the products. All you can do is export metafields of a single product. This is very frustrating, and Shopify users raised this issue some time ago. Nevertheless, let’s review an option we have.

Sign up to Coupler.io, click Add new importer, then select JSON as a source and a preferred destination app, for example, Google Sheets.

Proceed with the setup as follows:

  • JSON URL – use the following URL:
https://{store_name}.myshopify.com/admin/api/2022-01/products/{product-id}/metafields.json
  • {store_name} – enter your shop name.
  • {product-id} – enter the ID of a product for which you want to export metafields.

You can find product ID in the URL bar of your browser when you select the product.

Shopify product ID

So, your JSON URL should look like this:

https://sf-sandwiches.myshopify.com/admin/api/2022-01/products/5607136559258/metafields.json

Note: If you’re exporting metafields for other types, make sure you modify your string accordingly – for example, orders/{order-id}/metafields.json

  • Request headers –  specify your API access token using the following HTTP header:
X-Shopify-Access-Token:{your-api-access-token}
api token header
  • Path – Enter the metafields string to select nested objects from the JSON response.

Now you can proceed to the next steps: destination and schedule.

The final action is to click the Save and Run button, which results in pulling your Shopify metafields data to Google Sheets. Here is what it looks like for our example:

Streamline data analytics & reporting

Streamline your data analytics & reporting with Coupler.io!

Coupler.io is an all-in-one data analytics and automation platform designed to close the gap between getting data and using its full potential. Gather, transform, understand, and act on data to make better decisions and drive your business forward!

  • Save hours of your time on data analytics by integrating business applications with data warehouses, data visualization tools, or spreadsheets. Enjoy 200+ available integrations!
  • Preview, transform, and filter your data before sending it to the destination. Get excited about how easy data analytics can be.
  • Access data that is always up to date by enabling refreshing data on a schedule as often as every 15 minutes.
  • Visualize your data by loading it to BI tools or exporting it directly to Looker Studio. Making data-driven decisions has never been easier.
  • Easily track and improve your business metrics by creating live dashboards on your own or with the help of our experts.

Try Coupler.io today at no cost with a 14-day free trial (no credit card required), and join 700,000+ happy users to accelerate growth with data-driven decisions.

Start 14-day free trial

What other data you can export from Shopify via the Shopify API

For more information on other data entities available for export from Shopify, read the Shopify API documentation. Below, we introduced just a few examples. 

https://{store_name}.myshopify.com/admin/api/2022-01/{resource}
Data entity{resource} for JSON URLPath
List of products…/products.jsonproducts
List of customers…/customers.jsoncustomers
List of orders…/orders.json?status=anyorders
Orders by customer…/orders.jsonorders
Reports
(available to Shopify Advanced and Shopify Plus merchants only)
…/reports.jsonreports
Application charges…/application_charges.json
Application credits…/application_credits.json
List of locations…/locations.jsonlocations
List of blogs…/blogs.jsonblogs
Current balance*…/shopify_payments/balance.json
List of disputes* (initiated at the specified date)…/shopify_payments/disputes.json?initiated_at={yyyy-mm-dd}
List of all payouts*…/shopify_payments/payouts.json
List of all balance transactions paid out in the specified payout*…/shopify_payments/balance/transactions.json?payout_id={payout-id}

*If you get an error with the Shopify Payments endpoints, it’s most likely that the Shopify Payments module is not available in your region. 

Important: Make sure that your Shopify has the required app permissions set to Read access.

How to export Shopify sales data to CSV manually

CSV export is a go for those users who want either to migrate their data to another store or to make a backup manually. There is no “Export all” button in Shopify, so you’ll have to export each data entity separately. 

If you’re exporting more than 50 records, the CSV file will be emailed to you and the store owner. For requests of up to 50 records, the CSV file will be downloaded right away. The time it takes to generate a CSV file depends on the number of orders for export. The estimate is around one hour per 100,000 orders. The exported CSV files are limited to 1 MB.

Export Shopify purchased data (orders) as CSV

In your Shopify admin, go to the Orders page and click Export. If you want to export data about specific orders, select those.

Shopify export orders

Then you need to select which orders you want to export, the CSV file format and whether you want to include transaction histories.

Configure Shopify export orders

Read our guide for more about Shopify export orders.

Export customer data from Shopify as CSV

The flow for exporting Shopify customer data is the same as for exporting orders:

  • Go to the Customers page and click Export. If you want to export data about specific customers, select those.
  • Select which customer you want to export, as well as the CSV file format. Click Export customers.
Export customer data from Shopify as CSV

Shopify export products as CSV 

Repeat the same steps if you want to export product data from Shopify:

  • Go to the Products page and click Export. If you want to export data about specific products, select those.
  • Select which products you want to export, as well as the CSV file format. Click Export products.
Shopify export products as CSV 

In the Products section, you can also find other data for export, including Collections, Gift Cards, and Inventory. The exporting flow for them is the same.

Export Shopify reports as CSV

You will find Shopify reports in Analytics => Reports.

Shopify reports in Analytics

Click on the report you want to export and configure it for export:

  • Choose the data range
  • Apply filters if needed
  • Add or remove columns to include

Click Export once you’re ready.

Export Shopify reports as CSV

To download your report as a CSV file and click the Export button. 

Export Shopify discount codes as CSV

To export discount codes data as CSV, do the following: 

  • Go to the Discounts page and click Export. If you want to export data about specific discounts, select those.
  • Select which discount codes you want to export, as well as the CSV file format. Click Export discount codes.
Export Shopify discount codes as CSV

That’s it for your CSV exporting experience. Now let’s check out the more advanced options that will let you automate data exports.

How to export Shopify data for taxes

First of all, do not forget that: 

Shopify doesn’t report or remit your sales taxes for you.

This is on you, but you can configure the most common sales calculations in Settings => Taxes

As for the reporting, you’ll have to export Shopify reports yourself for your local tax authorities. Usually, the data about Users, Products, and Orders is a common practice for tax legislation in many countries. You can export them as CSV from Shopify as was described above.

If you’ve integrated Shopify with Google Sheets for reporting or backup purposes, you can download this data as CSV as well – go to File => Download => Comma-separated values (.csv, current sheet).

Free tax compliance apps on Shopify store

Shopify provides a few free apps designed for your tax compliance convenience. The main one is Data Exporter – Tax Compliance, but it’s designed to export CSV files tailored to meet only the tax formatting requirements for Australia, Germany, and France. Additionally, there are Germany-specific apps, GoBD‑Export and TSE (KassenSichV), as well as Data exporter – France.

Beyond this, you can search for paid options that meet your specific requirements.

Which is the best way to export financial data from Shopify?

We will be slightly biased in answering this question. 😇 But let’s be honest: the native exporting as CSV functionality in Shopify is rather shallow and inconvenient for recurring data manipulations. Besides, it won’t let you export much raw financial data, such as transactions, payouts, etc. 

Coupler.io will let you do this from Shopify to Google Sheets (or other destination) and get almost any record you need. Moreover, you can set up your importer once and automate it on the schedule you want. 

As for the apps on the Shopify store, they can do the job as well. However, their drawback is that most of the apps provide separate functionalities, so you’ll have to install a few apps instead of one. And this can be rather costly.

The final decision should rely on your goal. We’re sure that you’ll make the best choice for your needs. Good luck with your data!

  • Zakhar Yung

    A content manager at Coupler.io whose key responsibility is to ensure that the readers love our content on the blog. With 5 years of experience as a wordsmith in SaaS, I know how to make texts resonate with readers' queries✍🏼

Back to Blog

Comments are closed.

Focus on your business
goals while we take care of your data!

Try Coupler.io