To those who want to be free from "CSV hell" and "the stress of increasing product numbers"
Are you struggling with data migration between multiple platforms because Shopify's CSV functionality isn't enough? Good news for production departments facing such challenges! Matrixify (formerly Excelify) is a **Shopify-specific data management app** that allows you to bulk operate large amounts of products, orders, customers, metafields, and more using Excel/CSV/Google Sheets via **drag and drop**. It is supported as an "indispensable tool" for large-scale store operators and those migrating platforms.
Table of Contents
- What is Matrixify? Overview & Features?
- Shopify Matrixify Use Cases! In what situations is it useful?
- List of Shopify Data handled by Matrixify
- File formats supported by Matrixify
- Matrixify Pricing Plans
- Export Method: Data Extraction Procedure
- Import Method: Data Import Procedure
- Notes: What you should know before implementing
- Matrixify utilization support provided by Commerce Media
- Summary: Matrixify is an essential tool for Shopify operators who seek speed and accuracy
Matrixify: Overview & Features
**Matrixify** is a **high-functional data management app** that allows you to **bulk import, export, update, and migrate** almost all Shopify store data such as *products, orders, customers, metafields, blogs, and redirects* in **Excel/CSV/Google Sheets (XLSX) format**. It supports a maximum file size of **30GB for compressed files**, making it robust enough for large-scale stores and migrations.
Furthermore, with its scheduling function and integration with FTP/Google Drive, it is possible to **build workflows for regular inventory/price updates and automatic backups**. It is also valuable for managing multiple stores simultaneously and for migrations from Magento/WooCommerce. Here's a comment from Reddit:
“I have automatic pricing and inventory imports scheduled every half hour. Also daily backups to external servers via ftp. Well worth the price.”
On the app store, it boasts a **high rating of 4.8/5**, with numerous reviews such as " *significantly easier to use than CSV* " and " *essential for migration* ".
Shopify Matrixify Use Cases! In what situations is it useful?
Matrixify is useful in the following situations!
**Bulk updating large quantities of products, prices, and inventory**
You can collectively adjust tens of thousands of product data through import/export during sales, campaigns, or seasonal promotions.
**Large-scale data migration from other platforms**
Commerce Media also uses it for projects migrating from EC-CUBE to Shopify.
**Regular backups & reports**
By setting up scheduled processing, daily exports and storage backups are automated.
**Centralized management of SEO, metafields, and blog posts**
It is also effective for inputting metadata and optimizing SEO. Its convenience becomes more apparent with larger quantities.
List of Shopify Data handled by Matrixify
Matrixify is a powerful app that efficiently imports and exports Shopify store data. Below is a summary of the main data types it supports:
| Data Type | Details |
|---|---|
| Products | Product information, variations, prices, inventory, SKUs, barcodes, tags, metafields, etc. |
| Collections | Smart collections, manual collections, product associations. |
| Customers | Customer information, tags, metafields. |
| Orders | Order information, order status, payment status, shipping status. |
| Draft Orders | Draft order information. |
| Discounts | Discount codes, discount details. |
| Pages | Static page information within the store. |
| Blogs & Blog Articles | Blog post titles, content, tags. |
| Files | Information on files uploaded to the store. |
| Store Settings | Basic store configuration information. |
| Redirects | URL redirect settings. |
| Metaobjects | Custom data structures. |
| Metafields | Additional information for products, customers, orders, etc. |
| Navigation Menus | Store navigation menu settings. |
| File Format | Features and Use Cases |
|---|---|
| CSV (Comma Separated Values) | Simple, lightweight text format. Suitable for importing large amounts of data, but not ideal for complex data structures. |
| XLSX (Microsoft Excel Format) | Can handle multiple sheets, making it suitable for complex data structures. Easy to format and calculate data. |
| Google Sheets | Allows online collaborative editing. Real-time data updates can be made using Google Sheets links. |
Matrixify Pricing Plans
So, how much does Matrixify cost? Below is a summary of the features and prices of each plan.
| Plan Name | Monthly Fee | Key Features |
|---|---|---|
| Demo | Free | Import/export up to 10 items per file. Ideal for testing and learning with small data volumes. |
| Basic | $20/month | Up to 5,000 products, 300 collections, 2,000 customers, 1,000 orders per file. For small to medium-sized stores. |
| Big | $50/month | Up to 50,000 products, 3,000 collections, 20,000 customers, 10,000 orders per file. Supports large-scale data management. |
| Enterprise | $200/month | Unlimited import/export, 10x processing speed, batch import, multi-thread support. For large enterprises. |
Click here for more details on Matrixify plans: https://matrixify.app/pricing/
Export Method: Data Extraction Procedure
Click "New Export" in the Matrixify admin panel.
Next, select your desired file format (e.g., CSV, XLSX) from the "Format" section, then choose the data type you want to export (e.g., products, collections, customers) in the "Select Sheets" section.
For example, if you select Products, you can meticulously select the data fields to be output in "Select Columns".
There's also a "Filter" function, allowing you to narrow down data based on specific criteria.
※The "Option" menu allows you to set schedules and change export file names as needed.
Once the settings are complete, proceed with the export. Click the "Export" button at the bottom of the screen to start the export.
Once the process is complete, it will be available for download from the admin screen.
Import Method: Data Import Procedure
Prepare the data to be imported in CSV, XLSX, or Google Sheets format.
In the Matrixify admin screen, drag and drop the prepared file into the "Import" section, or click the "Add file" button to select the file.
On the "Ready to Import" screen, confirm the content and settings of the data to be imported.
If the settings are correct, click the "Import" button to begin the import process.
Once the import is complete, an email will be sent to your registered email address confirming the completion of the process.
Matrixify Import Tips: How to Use Commands
When importing data with Matrixify, you can specify how data should be processed by adding a "Command" column to each row. Below are the main commands and their use cases.
| Command | Description | Use Case |
|---|---|---|
NEW |
Adds data as new. Will result in an error if existing data is present. | Used when importing new products or customers for the first time. |
MERGE |
Merges (updates) existing data. Updates if IDs match, creates new if not found. | Used when updating a portion of product information. |
UPDATE |
Overwrites existing data. Will result in an error if IDs do not match. | Used when you want to ensure specific product information is overwritten. |
REPLACE |
Completely replaces existing data. Original data is deleted and overwritten with new data. | Used when you want to completely replace product or customer information. |
DELETE |
Deletes data. The specified data will be permanently removed. | Used when deleting unnecessary products or customers. |
IGNORE |
Ignores data. The specified data will not be imported. | Used when you want to exclude specific data from the import. |
By using these commands appropriately, you can ensure data consistency and efficient importing.
Common "Command" Specification Errors and Solutions
Below are common errors when using commands.
| Point to Note | Result | Solution |
|---|---|---|
UPDATE specified, but IDs don't match |
Added as new data | Use MERGE or specify ID accurately |
DELETE specified, but ID is inaccurate |
Not deleted | Confirm correct ID and re-import |
IGNORE specified, but unintended data is updated |
Unnecessary data updated | Verify target data when using IGNORE
|
Practical Use Cases
For example, when updating product information, using the MERGE command updates existing product data. On the other hand, using UPDATE overwrites existing data, so caution is required.
Also, when deleting unnecessary products, the DELETE command is used, but if the ID is inaccurate, the product will not be deleted. Therefore, it is necessary to specify the ID accurately.
⚠️ Matrixify Considerations: What You Should Know Before Implementation
Backup and Store Original Data
This is the most important point. When making large-scale updates, keeping the current data backed up somewhere allows you to restore to the original state by importing the original data into Matrixify in case of errors or numerous input mistakes.
Careful Plan Selection
Matrixify offers four plans based on store size and data volume. For example, the free "Demo" plan allows importing and exporting up to 10 items per file. On the other hand, the "Enterprise" plan offers unlimited import/export and faster processing with multiple threads. While upgrading plans is always possible, the cost changes with an upgrade, so be sure to check the plans in advance!
Relationship between Data Volume and Processing Speed
When handling large amounts of data, processing speed and the number of concurrent executions are limited by the plan. "Big" and "Enterprise" plans allow parallel processing with multiple threads, which can streamline data migration and update tasks.
File Format and Template Consistency
Matrixify supports CSV, XLSX, and Google Sheets files. However, since the template structures for each data type (products, collections, customers, etc.) differ, it is important to refer to official documentation and tutorials to prepare data in the correct format.
Migrating WordPress Blog Posts to Shopify
When rebuilding an e-commerce site, you may need to migrate blog posts and static pages from WordPress to Shopify.
While manual migration might be considered for a small number of blog posts, this approach is impractical for a large volume. The following article provides more detailed information!
Matrixify utilization support provided by Commerce Media
Commerce Media offers comprehensive support for e-commerce sites, and our production department, in particular, has extensive experience in Shopify store data migration and bulk updates using Matrixify.
Utilizing Matrixify for Site Construction and Renewal
When migrating or renewing a site to Shopify, we efficiently import and export large amounts of product and customer data using Matrixify.This enables smooth data migration and commencement of operations.
Data Migration Support from Other Platforms
Even when migrating data from other e-commerce platforms such as Magento or WooCommerce to Shopify, we utilize Matrixify to quickly and accurately perform migration tasks for product information, order history, customer data, and more.
Bulk Data Updates and Maintenance
For existing Shopify stores, when bulk updates are required for product prices, inventory levels, or metafields, we efficiently perform data update tasks using Matrixify.This results in reduced operating costs and shortened work time.
Template Creation and Customization Support
We create and customize CSV templates for Matrixify to optimize the import and export of various data.We offer flexible solutions, especially for managing product variations and metafields. If you are considering migrating from another platform to Shopify, we provide support for data migration and bulk updates using Matrixify. Please feel free to contact us for detailed consultations and quotes.
Summary: Matrixify is an essential tool for Shopify operators who seek speed and accuracy
- Ideal for bulk management and migration of large data sets
- Stability and processing power to handle large-scale operations
- High quality support for peace of mind
If you're struggling with "CSV hell" or "the complexity of managing multiple stores," please consult with us. Feel free to contact us for a free consultation or quote!
If you have any questions about site construction (new, replacement, renewal), please contact us!
Contact Us Hereも見てみる
