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

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

Jump right to the instruction on how to export Shopify data as a CSV file.

Automate Shopify data export to Google Sheets/Excel/BigQuery 

With this option, you can schedule the export of data automatically on a schedule to a spreadsheet – Shopify to Excel or Google Sheets – or a data warehouse – Shopify to Google BigQuery integration. This is well suited for reporting and analytical purposes, as well as backup. 

You’ll need to use a third-party app, Coupler.io, to automate exports. It supports the out-of-the-box export of: Products (including product variants and inventory information), Customers, and Orders. In addition to those, you can configure the export of implicit data such as transactions, payouts, etc. via the Shopify REST API.

Jump right to the instruction on how to automate data export from Shopify.

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.

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.

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.

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.

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.

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.

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.

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 you can automate data export from Shopify

We’ve mentioned Coupler.io above. It’s a solution for importing data to Google Sheets/Excel or BigQuery from multiple sources, including Shopify, on a schedule. So, for example, you can automate exports of your orders from Shopify every Friday at 5-6 p.m. For recurring reporting, analytics, and backups, this is probably the best option. 

Figure 2.4.3. Coupler.io to import data from Facebook into Excel Google Sheets and BigQuery

The Shopify integration 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. 

To export data from Shopify with Coupler.io, you’ll need to get a Shopify API token first.

How to get Shopify API credentials

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

Configuration for the Shopify export product id and other data on a schedule

Sign in to Coupler.io, click Add new importer and name it as you want. After that, complete three steps:

Set up Source (Shopify)

  • Source application: choose Shopify. Click Continue
8.1 source shopify
  • Shop name: Enter the hostname of your Shopify store in the following format:
{store_name}.myshopify.com

{store_name} – replace with the name of your Shopify store

  • API key/API token: Enter your API access token for your custom app. If you have previously created a private app, use this field to enter your Shopify API key
  • API password (optional): Enter an API password (for those who have a private Shopify app).
  • Data entity: Select Products as the data entity to export from Shopify. 

Click Continue if you want to configure the additional filter parameters:

  • Filter after ID
  • Collection ID
  • Created before date
  • Created after date
  • Changed before date
  • Changed after date
  • Status
  • Columns

Read the Coupler.io documentation to discover how you can use these filter parameters.

Set up Destination

  • Select the destination app: Google Sheets, Excel, or Google BigQuery. Click Continue
  • Connect to your destination app. Click Continue.
  • If your destination is Google Sheets or Excel, you can choose the spreadsheet and the sheet to load data to. For BigQuery, you’ll need to enter the names of a data set and a table manually.
  • Optionally, you can change the first cell to import your data range to, and the import mode.

Here is how the destination setup looks for Google Sheets:

8.2 destination setup

Set up Schedule

To automate data export from Shopify on a schedule, toggle on Automatic data refresh and specify the frequency.

5 airtable import schedule

Click Save and Run to load your Shopify data to the spreadsheet. After the successful import, you can check out the results by clicking on the View Results button.

9 views results shopify products

In our case, we’ve got 80 columns of data, which is huge! 

10 80 columns

To track the inventory efficiently, the following columns would be enough:

  • product_id (column A)
  • product_title (column B)
  • product_body_html (column C)
  • product_product_type (column E)
  • price (column R)
  • sku (column S)
  • inventory_quantity (column AK)

To only return these columns, list them in the Columns parameter of the Advanced Settings as follows:

11 columns parameter

Now we can rerun our Shopify integration to export the columns we need.

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. 

14 collection id field

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 three destinations including Excel. So, to export a collection of products to Excel, you’ll need to configure the destination as follows:

  • Choose Microsoft Excel as a destination application.
  • Connect to your Microsoft account
  • Select a workbook on your OneDrive and a worksheet where the data will be loaded.
16 destination excel

You can also use Microsoft Excel as the destination to connect Shopify to Power BI.

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

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 do this with Coupler.io as well, but the setup flow will be slightly different. You’ll need to select the JSON as a source and configure it to connect to the Shopify API. 

With the JSON integration, you can get data using REST APIs from different apps. For example, Etsy allows its users to download two types of data in CSV, but with the JSON importer, you can import much more. Check out how it works in our Etsy to CSV blog post.

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.

json source and destination

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.

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:

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

Back to Blog

Comments are closed.

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

Try Coupler.io