Shopifyの商品データをエクスポートする方法|CSV形式で一括出力する方法

How to Export Product Data from Shopify | Bulk Export in CSV Format

Tsunライターチーム

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

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 | Shopify App Store
Source: Matrixify | Shopify App Store

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.

Click 'Products' from the Shopify admin

(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

Click 'Export products'

(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."

Click 'New Export'

(1) Open the Matrixify app

(2) Click "New Export"

From Format, select 'Matrixify: CSV'

(3) From Format, select "Matrixify: CSV"

(4) Click Select Sheets

(5) From the displayed list, check "Products"

Check the fields you want to output as CSV data

(6) Check the fields you want to output as CSV data

From Filter, set the narrowing conditions for the products you want to output

(7) From Filter, set the narrowing conditions for the products you want to output

Click 'Export'

(8) Click "Export"

A job to create the CSV runs, so wait until the status becomes 'Finished'

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

👆️目次はShopifyアプリ「RuffRuff 目次作成」を利用

👆️Table of contents by the Shopify app RuffRuff Table of Contents

Back to blog
  • 【アプリなし】Shopifyテーマのカウントダウンタイマーを50件比較

    [No app required] Countdown timers across 50 Sh...

    Tsun ライターチーム

    We reviewed 50 Shopify themes. On all 39 with a timer, we could still add products to the cart and reach checkout after the deadline. See where to find the...

    [No app required] Countdown timers across 50 Sh...

    Tsun ライターチーム

    We reviewed 50 Shopify themes. On all 39 with a timer, we could still add products to the cart and reach checkout after the deadline. See where to find the...

  • Shopifyテーマの予約販売の対応可否を50件比較|41テーマで予約ボタンを確認

    Pre-order support across 50 Shopify themes | Pr...

    Tsunライターチーム

    We reviewed the official help and the theme editor for 50 Shopify themes. We tried the settings on a development store and confirmed pre-order buttons with no app on 41...

    Pre-order support across 50 Shopify themes | Pr...

    Tsunライターチーム

    We reviewed the official help and the theme editor for 50 Shopify themes. We tried the settings on a development store and confirmed pre-order buttons with no app on 41...

  • Shopify Protect: Rule Builderとは?機能・メリット・料金を解説

    What is Shopify Protect: Rule Builder? Features...

    Tsun ライターチーム

    Explore the features, pricing, and considerations for Shopify's fraud prevention app, Shopify Protect: Rule Builder. Learn about custom rules, testing against orders from the past 90 days, the waitlist, Japanese-language...

    What is Shopify Protect: Rule Builder? Features...

    Tsun ライターチーム

    Explore the features, pricing, and considerations for Shopify's fraud prevention app, Shopify Protect: Rule Builder. Learn about custom rules, testing against orders from the past 90 days, the waitlist, Japanese-language...

  • Shopifyアプリ「ChatGPT」とは?機能・料金・日本での利用条件を解説

    What Is the Shopify App “ChatGPT”? Features, Pr...

    Tsun ライターチーム

    An introduction to the features and pricing of OpenAI’s Shopify app “ChatGPT.” It explains product information sync, information management and analytics in Business Hub, ad delivery, Business Agent features, and...

    What Is the Shopify App “ChatGPT”? Features, Pr...

    Tsun ライターチーム

    An introduction to the features and pricing of OpenAI’s Shopify app “ChatGPT.” It explains product information sync, information management and analytics in Business Hub, ad delivery, Business Agent features, and...

  • Shopifyで使える決済方法一覧|手数料・導入サービス・選び方

    [Complete Guide] A Roundup of Payment Methods A...

    Tsunライターチーム

    This article gives a detailed explanation of the many payment methods available on Shopify and their respective payment processing fees and transaction fees. We also introduce handy Shopify apps that...

    [Complete Guide] A Roundup of Payment Methods A...

    Tsunライターチーム

    This article gives a detailed explanation of the many payment methods available on Shopify and their respective payment processing fees and transaction fees. We also introduce handy Shopify apps that...

  • GMOイプシロンの手数料・決済方法・入金サイクル|Shopifyの条件も解説

    GMO Epsilon Fees, Payment Methods, and Payout C...

    Tsun ライターチーム

    GMO Epsilon payment methods and fees, organized by contract type. Covers Shopify-specific terms, payouts, authorization and capture deadlines, refunds, and cancellation. Also introduces ways to use apps to control which...

    GMO Epsilon Fees, Payment Methods, and Payout C...

    Tsun ライターチーム

    GMO Epsilon payment methods and fees, organized by contract type. Covers Shopify-specific terms, payouts, authorization and capture deadlines, refunds, and cancellation. Also introduces ways to use apps to control which...

1 of 6
  • AI仮想顧客の改善ツール「SimGym」を使ったら売上はどうなった?実行から3か月後までの記録

    What Happened to Sales After Using SimGym, an A...

    テキサス・アユミ

    A record of trying SimGym on the miso specialty store ドットミソ, from checking the proposals through carrying out changes to the look-back three months later. It covers how the order...

    What Happened to Sales After Using SimGym, an A...

    テキサス・アユミ

    A record of trying SimGym on the miso specialty store ドットミソ, from checking the proposals through carrying out changes to the look-back three months later. It covers how the order...

  • 【ストアインタビュー後編】やりながら育てるShopify。「野菜をMOTTO」の試行錯誤:モンマルシェ株式会社 河野雄士さん

    [Store Interview, Part 2] Building and Growing ...

    テキサス・アユミ

    "Even when e-commerce is the main battlefield, e-commerce isn't the goal." An in-depth look at our interview with Yuji Kono of Mon Marché, whose brand "Yasai wo MOTTO" grew its...

    [Store Interview, Part 2] Building and Growing ...

    テキサス・アユミ

    "Even when e-commerce is the main battlefield, e-commerce isn't the goal." An in-depth look at our interview with Yuji Kono of Mon Marché, whose brand "Yasai wo MOTTO" grew its...

  • 【ストアインタビュー前編】 ECが主戦場でも、ECが目的ではない。「野菜をMOTTO」が貫くEC戦略:モンマルシェ株式会社 河野雄士さん

    [Store Interview, Part 1] Even When E-Commerce ...

    テキサス・アユミ

    "Even when e-commerce is the main battlefield, e-commerce isn't the goal." Part 1 of our interview with Yuji Kono of Mon Marché, whose brand "Yasai wo MOTTO" grew its e-commerce...

    [Store Interview, Part 1] Even When E-Commerce ...

    テキサス・アユミ

    "Even when e-commerce is the main battlefield, e-commerce isn't the goal." Part 1 of our interview with Yuji Kono of Mon Marché, whose brand "Yasai wo MOTTO" grew its e-commerce...

1 of 3
  • Our Editorial Process

    For readers new to e-commerce and Shopify, we write our articles with care to explain difficult commerce and marketing terms, along with how everything works from building a store through to selling, as “gently,” “clearly,” and “accurately” as we can.

    Learn more 
  • About the information on this site

    The information published here is based on Tsun Inc.’s own experience and research. While we make every effort to publish information that is as “current” and “accurate” as possible, we cannot fully guarantee its contents. Tsun Inc. accepts no liability whatsoever for any damages arising from this site. If you find an error in the information published here, we would be grateful if you would contact Tsun Inc.