For anyone wondering how to export product data from Shopify, this article explains in detail how to do a bulk export in CSV format. We'll cover everything from the free export method using Shopify's standard features to the more flexible export method using an app, comparing the pros and cons of each. In particular, if you need to export under complex conditions or customize the output fields, we recommend using the Shopify app "Matrixify." Use this article as a reference to achieve efficient data management.
2 ways to export product data
Exporting from product management
First, there's the method of exporting from product management. Since this is a native Shopify feature, you can export for free.
The disadvantages are that the following types of export are not possible:
- You can't export under complex conditions (e.g., exporting only products with a specific metafield value)
- You can't export all data fields (e.g., the collections a product belongs to)
- You can't export by specifying output fields (e.g., you can't export just the handle ID and product name)
Exporting with a Shopify app
Next, there's the method of exporting with a Shopify app. By using a Shopify app, you can achieve things that were listed as disadvantages of product management, such as "exporting under complex conditions" or "exporting with specified output fields."
On the other hand, the disadvantages of apps are that app usage fees may apply, and some apps may not support Japanese.
"Matrixify," an app recommended for exporting
Matrixify is a Shopify app that lets you export all kinds of data on Shopify, such as products and blog posts, and use its import feature to bulk-edit data.
We recommend introducing it for Shopify sites that carry many products or own a lot of content. On the free plan, you can import or export up to 10 items per run.
Price: Free~
The blog article below explains Matrixify's main features and pricing plans in detail. Please use it as a reference.
How to export from product management
In this section, we'll show you how to export product data in CSV format from product management.
(1) Click "Products" from the Shopify admin
(2) On the products page, narrow down the products you want to export
The conditions available for narrowing down are as follows:
- Vendor
- Product tags
- Status
- Category
- Sales channel
- Market
- Type
- Collection
- Publishing errors
- Gift card
- Bundle
- App
(3) Click "Export" at the top right of the screen
(4) From the pop-up that appears, select the group of products to export
(5) From the pop-up that appears, select the type of export
(6) Click "Export products"
(7) You'll receive an email with a download link, so click the link
That's it, you're done.
How to export with the Shopify app "Matrixify"
In this section, we'll show you how to export product data in CSV format using the Shopify app "Matrixify."
(1) Open the Matrixify app
(2) Click "New Export"
(3) From Format, select "Matrixify: CSV"
(4) Click Select Sheets
(5) From the displayed list, check "Products"
(6) Check the fields you want to output as CSV data
(7) From Filter, set the narrowing conditions for the products you want to output
(8) Click "Export"
(9) A job to create the CSV runs, so wait until the status becomes "Finished"
(10) Click the download link directly below the Finished status
That's it, you're done.
In closing
This article explained two ways to export product data from Shopify. Using Shopify's standard features, you can easily export for free, but if you need complex conditions or customization, using an app like "Matrixify" allows for more flexible data management. Understand each method and choose the best one for your purpose. Let's make Shopify operations even smoother through efficient data management.
