Export from Shopify
From the app Home page section Export, you can create new export by pressing the “New Export” button.
This will open a new page in the app where you can configure your export.
Choose an export format
In the “Format” section you can click on the format to open a drop-down list of all available formats.
If your goal is to bulk update your Shopify store data or migrate to another Shopify store then you will need to select one of “Matrixify: …” formats.
We suggest using the “Matrixify: Excel” format which would export the Excel XLSX file. Excel files are a lot more stable than CSV files, allows using formulas, and are more user friendly.
If your store is very large, and your exported store data might exceed any excel limitations then select “Matrixify: CSV” format to export to the CSV file.
Select what entities to export
Click on the “Select Sheets” button to add sheets to your export file.
You can select multiple entities at the same export!
Select Columns – Select what columns to export
Click on the entity sheet to open it. There you will see groups of fields that you can select to export.
You can find what fields are under each group in Matrixify template sheets documentation.
Open the group to select individual columns/fields you wish to export.
Export only the Shopify store data you need, because that impacts the duration of how long the export will take. Export becomes significantly longer if you include Metafields.
Customize Columns – Customize how columns will be exported
By opening the “Customize Columns” section you can customize your export columns.
In this section, you can also drag column tags to change their exported position, and press on the “X” button to remove the field.
Check out this tutorial for more details on advanced exporting – Export Data from Shopify with custom columns.
Set Filters – specify what data to export
To focus on a specific list of items, use the Filters.
You can find the Shopify export filter icon in the Matrixify app when creating new export, select what you wish to export, and under that entity click on the “Filters” button.
Select the filter of your choice for your items and press “Set” to apply the filter to your next export.
When you apply the filter, the item count and estimates will not change at that point – the estimate will adjust when you actually start the export. For some filters Matrixify still has to run through all your store though, to find those items.
You can specify additional options for the export like schedule export to run at a specific date and time and/or repeat the export which is handly when importing from URL to create automated import from that URL.
Custom File Name:
You can specify a custom file name for the export so that the exported file URL is always the same.
Ideal to use for regular backups or outgoing Shopify store data feeds.
Exported item sorting
You can also set “Export items sorted in the order as they come from Shopify”, which will make sure that exported items are sorted exactly as they are returned by the Shopify API.
Do note that if you have Big or Enterprise plan, then the app will not leverage your plans speed increase as it will need to use 1 export thread to get data from Shopify instead of multiple.
Export format-specific options:
Some options only appear when you have selected to export to a specific format.
Format date columns as Excel date-time without timezone – (Disabled by default) By default the exported date will be the full ISO date with a timezone like this
2018-12-17 18:20:07 +0200, but you can select this Export Option to put the Excel proper date&time columns – just note that Excel doesn’t support time zones, so that time will be without the timezone.
Matrixify: CSV or other format that export to CSV
If you wish to import the file back with Matrixify - the file will need to have default CSV options.
Zip CSV files – (Enabled by default) When exporting to CSV file, by default it will be compressed into a ZIP file. If you do not need to compress the CSV files, you can un-check this option.
CSV column delimiter – (Comma by default) You can select other standard delimiters or any custom delimiter you wish.
CSV quote symbol – (Double-quote by default) CSV file cells are enclosed in quotes for programs such as Excel to be able to understand where the new cell starts and not to take the new line in e.g. description as a new row in the file.
CSV quotes forced – (Enabled by default) Makes the exported file more Excel-friendly by enclosing all cells with quote symbol. If not selected, only cells that need to be enclosed will be.
CSV with included BOM – (Enabled by default) When opening a CSV file in Excel – if that CSV file contains special non-English language characters encoded in UTF-8, then those characters are shown as corrupted. To tell Excel that the file is in UTF-8 encoding, and thus have those non-English characters show correctly, the CSV file needs to start with the BOM characters (Byte order mark).
However, if processing the CSV files with automation scripts, then the BOM characters might not be interpreted correctly, so it’s better to not include them if you process CSV files with scripts or other automation services. Unselecting this option will not include the BOM characters in your export.
CSV newline symbol – (LF [\n]) by default) Specify CSV files newline symbol. Shopify be
CSV file encoding – (UTF-8 by default) Select file encoding format. Should be
Exported Item Count
While the export is running you can see exactly how many items have been exported and how far the app is in the export process from all items.
This comes in handy when you are applying multiple filters to your export to see how many items exactly will be in your file.
Total Count – This number will display the total count of the item you have in the store. For example, the job is exporting Products and this store has 547 Products.
Processed Count – Displays how far the app is between all items. Some filters might provide the ability for the app to disregard a lot of items in bulk, so you might see the processed count jump at the start.
Exported Count – Displays how many items are actually exported and will be in your exported file.
Edit Shopify Data
Import only columns you need
When you import, you don’t have to import all columns. You can import only the columns you need to update.
In each sheet, you can use the “Command” column, by which you can tell, what to do with the row that is being imported.
The possible entity commands are NEW, MERGE, UPDATE, REPLACE or DELETE.
If no Command is specified, then the app will assume the MERGE command (for Orders and Draft Orders – NEW command).
- NEW Command would create a new item and fail if it already exists.
- MERGE Command would update an item if it exists and create a new one if it does not exist.
- UPDATE Command only updates an item if it exists and fails if not found.
- REPLACE Command would delete items from the store and create a new one only from data in the file.
- DELETE Command would delete items if found.
When updating items with related items – like Product Variants, then the app merges your variant rows with existing variants, by finding an existing variant of the Product by its Variant ID, then by SKU, then by Barcode, then by Option values.
To delete Variants, use the “Variant Command” column with value “DELETE”. Or put “REPLACE” if you want to replace all variants of that product to your new variant rows.
The same principle is used in other sheets and items as well, like Product images. By default, Matrixify merges existing images with your image links, but you can DELETE or REPLACE images too.
You can read detailed documentation about each command in the documentation pages of each sheet.
This stuff is powerful!
- You can update all images of all Products at once.
- You can link images to Product variants all at once.
- You can add new variants without having to list the existing variants – just import the additional variant rows, and the app will merge them automatically.
- Create and update Orders.
- And much much more.
Since Metafields are just additional rows in the same import file, all you need to do is – put the Metafield columns and set their values as you need.
Import to Shopify
With the sheet name, you can tell Matrixify what you are importing.
If you wish to import Products, the sheet name needs to contain word “products”.
To import Pages, the sheet name need to contain the word “pages”, and same for other entities that you can import with the Matrixify.
In Excel import files you can also have other sheets in your import file, the app will only import those that have recognized sheet names such as “products”. Unrecognized sheets will be ignored.
If the import file has a single sheet, then the app will assume its Products unless the sheet name specifies a different entity.
In the import file column headers would need to match our template column headers so that app can read data from them.
Column order in the file does not matter for the import and you can have additional columns in your file, if the column header will not be recognized then app will ignore such column.
In the sheet which is not ignored the maximum column header length is 361 characters for any column header – imported or ignored.
If you must have longer column headers in your import file, reach out to our support.
The maximum file size that you can upload is 10 GB.
This is the limit for the actual file uploaded in the app.
If using CSV in ZIP file then the sum of all CSV files inside ZIP cannot be larger than 30GB.
Excel format itself can hold up to 1 million rows. But it is advised that if your data might be larger than some 600’000 rows, then use the “Matrixify: CSV” format.
Supported import formats
At the moment the app can import the following format files:
- Matrixify: Excel
- Matrixify: CSV (zipped or not zipped)
- Shopify: CSV (zipped or not zipped)
- Matrixify: Google Sheets (from Google Sheets shared public link)
- Other custom file formats developed as additional service for merchants
The app will auto-detect CSV file encoding, like UTF-8, ISO-8859-1 (Latin 1), ISO-2022-JP, etc., and automatically convert to UTF-8 as needed for Shopify.
When you upload the file, at first the app is analyzing the file. After that, you can choose the options and press the “Import” button if everything is showing ok.
Import From Locations
- Upload the file directly into the app
- URL to a file that is hosted on the web
- FTP URL to a file that is stored on FTP server
- SFTP URL to a file that is stored on SFTP server
- URL to a Dropbox file
- URL to a Google Drive file
- URL to a Google Sheet on Google Docs cloud
- URL to a Microsoft SharePoint file
To ensure platform stability, Shopify also has many limitations of much of something you can have or import.
Before starting to import with a large dataset, it is important if there are any limitations that apply to you in Shopify.
We still do suggest contacting us to be sure that there are no other limits that could apply to you.
Know what you are doing
Test and analyze the impact of the data you are importing.
We have prepared a special checklist to make your Shopify store data imports safe – please, read that.
Matrixify import provides various settings and options you can apply before starting your import.
For most imports, you do not need to adjust any options and can import files with the default options.
If selecting an option, make sure that you understand what it means.
As your file imports, Matrixify will show how many items are New, Updated, Replaced, Deleted or Failed.
If your import has any failed items then for each entity the app will display 5 most common errors from your file.
You can let the import run or you can cancel the import any time. When you cancel the import or the job finishes, you will be able to download the Results file.
After you import the file, the app will generate an Import Results file with additional two columns that show status for each imported item, and detailed error message, if the import has Failed.
Matrixify file will contain only those rows, which were imported. That way you can review, what was imported, what were the errors. And that way you know, which items it actually imported, so that if you need to continue, you can exclude those already imported items from the next import.
If your import speed is a concern, read more about improving import speed in the tutorial: How to maximize Shopify bulk import speed?
Maybe strange, but really useful is that each Product (or any other item) will have the same “Import Comment” value for all its rows, so when you read them, consider them about the product as a whole, not about each line. The convenience here is that in case you need to filter rows by the import comment, you can easily filter them in Excel, and know that your filtered results will contain all the rows of that product, because the “Import Comment” column value is the same.
When pressing the “All Jobs” button in the side-menu Navigation, you can see all the past import and export jobs. You can download all the files for each job. And you can see what happened to each of the past jobs.
More than that, you can see the future scheduled jobs as well. And you can cancel any scheduled or running jobs from here, too.
You can change this setting if you wish for your files not to be public. Then you and others will only be able to download the files while being in the Matrixify app.
If the setting is enabled then anyone with a link to your uploaded, exported or results file can download the file giving you the maximum freedom working with your files.
The app will send you an email about import or export jobs.
You can adjust what jobs you wish to receive an email about.
If you have multiple Shopify stores or just wish to transfer Shopify store data from one Shopify store to another then you can take advantage of your additional free store.
Linking the free store will automatically upgrade Matrixify to the same plan as the store where you have a paid subscription.
With Matrixify you can securely save your FTP/SFTP servers and their users so you do not need to fill in all details for each import or export.
If you have set up the server in Matrixify settings, when creating import or export, you do not need to enter Username and Password again.
Only specify the path to file/folder.
When first opening the app you approved documents such as Terms & Conditions, Privacy Notice, and Cookies Policy.
In this Settings section, you can see the direct timestamp of when you approved these documents.
When you run the export or import, you don’t need to keep the browser open – you can close Matrixify and come back later to check the progress.
Head over to the apps “All Jobs” section to find all your future, current, and past jobs including the ones that are currently running.
Each job and page in the app has a unique browser URL.
This allows you to bookmark individual pages and jobs to use as templates.
For example, you can bookmark the “Export Again” page of any previous job – to use it as a template for your typical exports, or you can bookmark a page with specific All Jobs filters applied.
Initial import and export estimates are very approximate average because it really depends on your real data and any API limitations set by the Shopify to your store.
Once the export or import actually starts, the estimates become very precise, because then those are showing about your current export or import, with your real data.
The app does not allow running multiple imports or exports at the same time as it would make each job a lot slower due to Shopify API limitations.
However, you can queue your jobs so you do not need to wait for the previous one to finish.
When you have started your import or export you can go to the Matrixify Home page and start a new job.
Instead of running the job, the app will automatically queue it so the job will start itself when the already running job finishes.
In our website under Knowledge -> Tutorials you can find tutorials for a lot of use cases where you might use the Matrixify to bulk edit Shopify data and more.
In the “Tutorials” page, select item that you wish to import or export, for example, “Products” or “Customers“.
You can also apply Filters to your opened “Tutorials” page. That way you will be able to easier find tutorials about what you wish to achieve.
For each sheet in that Matrixify allows to import or export you can find documentation that explains each column from our template.
Head over to Knowledge -> Documentation on our website to find an explanation for the fields that are not clear for you.
Here you can also find a page that explains our template in general and allows you to download our Demo template file.
If you cannot find a tutorial that you are looking for, have any issues or questions about the app, or just an amazing feature to suggest – we are here for you!