Shopifyデータをインポート&エクスポートする「Matrixify」とは? |  Tsun Inc.

What is "Matrixify" that imports and exports Shopify data?

Tsunライターチーム

"RuffRuff 予約販売" supports reducing the opportunity loss that occurs at times such as out-of-stock, before a new product launch, or while waiting for restock.
You can implement pre-orders on your own Shopify store surprisingly easily, registering unlimited pre-order items and accepting unlimited pre-orders. It also lets you restrict customers from ordering pre-order and regular items together, and send restock notifications when the arrival date is undecided.
It also offers many unique features not found in other pre-order apps, such as a "deferred payment" function that lets you collect payment before the product ships.


While running a Shopify store, do you find yourself spending a lot of time managing products, customer information, order data, and more? Import and export work in particular can be tedious, and many people find it difficult to do efficiently.

This article introduces "Matrixify (formerly Excelify)," a handy app for streamlining data management on Shopify. Using this app can lighten the load of data work and free you up to focus on running your store.

What Is Matrixify (Formerly Excelify)?

Matrixify|Shopify App Store
Source: Matrixify|Shopify App Store

A Shopify app that lets you export all kinds of data on Shopify — products, blog posts, and more — and use its import feature to bulk-edit data.

We recommend it for Shopify sites carrying a lot of products or a lot of content.

The free plan lets you import/export 10 items at a time, so give it a try first.

Pricing: Free~

* Up to 10 imports/exports at a time are free. If you want to import/export more, it becomes paid — see the Shopify App Store for pricing details.

Matrixify's Main Features

Export Feature

You can output a wide range of data on Shopify — products, orders, blog posts, collections, and more — in file formats like CSV, Excel, and XML.

Data you can export

  • Product data
  • Collection data
  • Customer data
  • Coupon (discount) data
  • Order data
  • Draft order data
  • Page data
  • Blog data
  • Blog post data
  • File data
  • Store data
  • Redirect data
  • Activity data
  • Metafield data

And more

File formats you can export

  • CSV
  • Excel
  • XML

The blog article below explains how to export product data using Matrixify. Please use it as a reference.

Import Feature

A feature that lets you bulk-edit data on Shopify. Useful when you have too many SKUs to edit one at a time, when migrating data from another e-commerce system, or when you want to bulk-edit data other than products.

Data you can import

  • Product data
  • Collection data
  • Customer data
  • Coupon (discount) data
  • Order data
  • Draft order data
  • Page data
  • Blog data
  • Blog post data
  • File data
  • Store data
  • Redirect data
  • Metafield data

And more

Import methods

  • CSV
  • Excel
  • Google Sheets (automatic integration)

The blog article below explains how to bulk-update collection data and blog post data — which Shopify has no built-in bulk-update feature for — using Matrixify. Please use it as a reference.

Schedule Feature

Matrixify has a schedule feature that lets you periodically export specific data to a specific location, or periodically import data from Google Sheets.

Using the schedule feature, you can automate routine work like collecting data for reports. It's also useful for periodically backing up your Shopify data.

The blog article below explains how to back up Shopify and recommended apps. Please use it as a reference.

Filter Feature

Matrixify has a filter feature that lets you output only data matching specific conditions.

Matrixify's export feature limits, depending on your plan, how much data you can output and how long the export takes — so this filter feature is handy for making the most of Matrixify within your plan's limits.

Matrixify Pricing Plans

Matrixify's exportable data volume and export speed vary by plan.

Plan Demo Basic Big Enterprise
Price $0 $20 / mo $50 / mo $200 / mo
Product data 10 5,000 50,000 Unlimited
Smart collections 10 300 3,000 Unlimited
Custom collections 10 300 3,000 Unlimited
Customer data 10 2,000 20,000 Unlimited
Companies 10 50 500 Unlimited
Discount data 10 300 3,000 Unlimited
Draft order data 10 1,000 10,000 Unlimited
Order data 10 1,000 10,000 Unlimited
Page data 10 50 500 Unlimited
Blog post data 10 50 500 Unlimited
Redirect data 10 10,000 100,000 Unlimited
Payouts 10 366 3,660 Unlimited
Activity data 10 10,000 100,000 Unlimited
File data 10 1,000 10,000 Unlimited
Shop data 1 1 1 1
Speed - - 5x normal 5x normal

Steps to Export Data Using Matrixify

  1. Go to Shopify > Apps > Matrixify to access the Matrixify app
  2. Click "New Export"
  3. Choose a file format from the Format section
  4. Select the data you want to export from Select Sheets in the Sheets section
  5. Choose which output fields to include from "Select Columns"
  6. Tap the "Filter" button to set your filter conditions
  7. Click "Export"
  8. Once Matrixify's export process finishes, click "Download Exported File"

In Closing

How was that?

Matrixify is a powerful tool for streamlining data management on your Shopify store. You can try its basic features on the free plan, so we recommend giving it a try first. Beyond importing and exporting data, using the schedule and filter features can further streamline your day-to-day work.

Finally, beyond Matrixify, the blog article below introduces recommended Shopify apps for streamlining your store operations. Please use it as a reference for improving your workflow.

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

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

Back to blog
1 of 6
  • 【ストアインタビュー後編】やりながら育てる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...

  • 【ストアインタビュー後編】取り返しのつかない失敗さえしなければ、全部学びになる。EC戦略と経営哲学:Beverich株式会社 代表取締役 木下慶さん

    [Store Interview, Part 2] As Long as You Don't ...

    テキサス・アユミ

    Kei Kinoshita, President of Beverich, discusses his strategy for splitting roles between Shopify and Amazon, how he uses the RuffRuff apps, and a management philosophy that turns failure into learning....

    [Store Interview, Part 2] As Long as You Don't ...

    テキサス・アユミ

    Kei Kinoshita, President of Beverich, discusses his strategy for splitting roles between Shopify and Amazon, how he uses the RuffRuff apps, and a management philosophy that turns failure into learning....

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.