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|
|Product smart collections||✔|
|Assets for a theme||✔|
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 of how to export Shopify data as a CSV file.
Automate Shopify data export to Google Sheets/Excel/BigQuery
With this option, you can schedule export of data automatically on a schedule to a spreadsheet (Google Sheets/Excel) or a data warehouse (BigQuery). 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, Orders, and Orders with line items. 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 of 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.
Then you need to select which orders you want to export, the CSV file format, and whether you want to include transaction histories.
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 export of your orders from Shopify every Friday at 5-6 p.m. For recurring reporting, analytics, and backups, this is probably the best option.
To use it, you need to sign in to Coupler.io and complete three steps:
- Set up Source (connect to Shopify and choose the data to export)
- Set up Destination (choose the spreadsheet to export data to)
- Set up Schedule (customize the frequency for your data exports)
The final action is to click “Save and Run“, which initiates the first data export. Here is what a successful export looks like:
Click “View Results” to check out your data in your spreadsheet. For more details, read our blog post Shopify to Google Sheets.
Besides automatic data refresh, another cool feature of Coupler.io is JSON Client as a source. This allows you to export implicit data, such as metafields, via the Shopify REST API without any coding. Let’s see how it works.
Use case: How to export metafield data in Shopify
Here are the types that implement metafields in Shopify:
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.
For example, we have two metafields implemented for the Product type. To export metafields from Shopify to Google Sheets, we’ll need first to obtain Shopify API credentials – Example URL is what we need. Here is what they will look like:
Now we need to set up the source in Coupler.io as follows:
- Select JSON Client as a source application. Click “Continue“.
- JSON URL – use the Example URL that you obtained and replace the resource “
orders.json” with the following string:
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:
Note: If you’re exporting metafields for other types, make sure you modify your string accordingly – for example,
- Path – Enter the “
metafields” string to select nested objects from the JSON response.
Now you can proceed to the destination setup, where you need to select the spreadsheet to export data to and the schedule setup for recurring exports. The final action is to click the “Save and Run” button, which results in pulling your Shopify metafields data to Google Sheets. Here is how it looks for our example:
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 calculations and reports yourself for your local tax authorities. Usually, the data about Users, Products, and Orders is a common practice for tax legislation of 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 separated 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