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 data	CSV	REST 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. 

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. 

Then, save and run the importer to transfer data.

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

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:

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. 

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

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

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.

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.

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

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.

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.

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.

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

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.

• Click Develop apps for your store (former Private apps).

• Click Create an app.

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

3. Name your app then click Create app.

4. Once the app is created, click Configure Admin API scopes.

5. Check the read scopes for:
   • Customers – read_customers
   • Inventory – read_inventory
   • Orders – read_orders
   • Products – read_products

Then click Save. 

6. Click Install app.

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

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.

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}

• 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 URL	Path
List of products	…/products.json	products
List of customers	…/customers.json	customers
List of orders	…/orders.json?status=any	orders
Orders by customer	…/orders.json	orders
Reports (available to Shopify Advanced and Shopify Plus merchants only)	…/reports.json	reports
Application charges	…/application_charges.json
Application credits	…/application_credits.json
List of locations	…/locations.json	locations
List of blogs	…/blogs.json	blogs
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.

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