Start Free Trial
Start Free Trial

Import data to Shopify with Matrixify

Learn deeply about Matrixify import feature, where to find various user interface details, and what they mean for your Shopify data imports.

Create a new Shopify data import

To create a new import, navigate to the Matrixify app in your Shopify store and in the Home page you will see the Import section.
In the import section, you can drag and drop the file you wish to import into the designated area or click the “Add file” button to select and upload the file from your computer.

1 . Create new Shopify data bulk import Matrixify app

Import from locations

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

Excel files and Google Sheet links can have several sheets/tabs, and ZIP files can have several CSV files in them – all those can be imported in a single import job.

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.

Column headers

In the import file column headers would need to match Matrixify 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 is not recognized then the app will ignore such a column.

File size

Manual uploads in the app from your computer are currently limited to 5 GB, if you need to import larger files, try uploading them to a file hosting service and import from a URL.
The maximum file size for an import job from URL is 10 GB, but if using multiple CSV files in a ZIP file then sum of all CSV files inside ZIP cannot be larger than 30 GB.

When importing large CSV files make sure to ZIP them. That will make your upload much faster because CSV files compress very well.

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.

Shopify limitations

To ensure platform stability, Shopify has many limitations on data you can have or import.
Before starting to import with a large dataset, it is important to find out in advance if any limitations apply to you in Shopify.

We still suggest contacting our support 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 make sure to read through it before importing.

Understanding the Matrixify app Import user interface

Once you have uploaded your file in the Matrixify app, it will first analyze it to understand the contents of the file and show various details about the import job.

Basic Matrixify Import job details

2. Shopify data import Matrixify app import details

At the very top of the import job page, you can see various details about the import:

  • ID – Matrixify internal job ID for the import.
  • State – current state of the import job such as “Ready to Import”, “Estimating”, “Queued”, “Finished” or others.
  • Format – the file format app detected that is being imported.
  • Dates such as when the import job was created, started, finished, scheduled and others.
  • Plan – Matrixify app subscription plan that the store had when the job was active. The plan can be changed mid-import.
  • API Call Limit – Shopify API “speed” limitation. Read more about it in our tutorial Shopify API Call Limit explained and how it impacts the Export and Import speed.
  • Threads – the number of parallel threads app uses to import data into the Shopify store. Big and Enterprise Matrixify subscription plans will, by default, have multiple parallel threads to import store data quicker – see more about Matrixify plans in the Pricing page.
  • Uploaded file – file name as a hyperlink to download the exact file that was uploaded into the app for this import job.

 

Sheets in the uploaded file

3. Shopify data import Matrixify multiple sheets selection import column ignored columns estimate

The next section in the Matrixify app import job is called “Sheets”. In the “Sheets” section you can see details about the actual data that will be imported.
Each card in this section represents a sheet in the imported file (tabs in Excel XLSX file or CSV files in a ZIP file). Read more about Excel and CSV file import formats.

Click on the checkbox to select the sheets that you wish to import.

Select and change what entity data is imported by each sheet

4. Select and change recognized Shopify data import entity Matrixify app

Matrixify app will use the sheet name and columns in the import file to detect what data entity you are importing.

If your sheet name is an exact match for the entity, for example, “Products”, “Customers”, “Orders”, etc. then the app will pre-select that data entity if the columns in the file match the minimum columns needed to import it.
You can also change the entity you wish to import. Matrixify will allow selecting any data entity that theoretically can be imported based on columns in the file.

If only one data entity can be selected based on the columns, then app will pre-select that entity.
For example, if the import file only has columns Variant SKU and Variant Price then the app will select the entity as Products and you would not be able to select a different entity as no other Matrixify import template sheet contains and recognizes those two columns.

  • If you see the message “Select at least one sheet” it means that you need to select the checkbox to import at least one of the sheets in the import file.
  • If you see the message “Sheets require entity selection” it means that for at least one sheet multiple entities qualify based on the column names, and it is ambiguous which entity that is. In the “Select Entity” dropdown, select the desired entity for that particular sheet, or unselect the checkbox to not import it. If this is causing trouble in your regular workflow then remember that you can ensure the app auto-detects the entity based on the exact sheet/tab name. Name the sheet according to the exact entity name you wish to automatically select, e.g. “Products”.

After changing the entity assigned to the import sheet, you will need to press the Analyze button for the app to apply the changes for each sheet and re-check the data based on selected entities.

Details about individual sheets

5. Exact import columns Shopify data imports Matrixify app

Within the import sheet card, you can see details about the specific sheet.

Upload sheet name

Under the selected entity you can see the sheet name in the uploaded file.

List of columns in the sheet

You can see if there are any ignored columns. It might be that some columns do not belong for the selected entity, and that’s ok – those will just be ignored.
Having ignored columns can also be a good indication that the wrong entity might have been selected for the sheet. For example, if your sheet has columns Title and Variant Price and you select the entity Custom Collections then the app will show that it will ignore 1 column – Variant Price as the Custom Collections template does not have such a column.

You can click on the sheet card to expand it and see the exact list of columns in the file.

Disabled/grayed-out columns are those that the app will ignore. Each ignored column will show the reason why it’s ignored when you hover your mouse over it.
Typically ignored columns are “Export Only” – those cannot be imported because they either don’t play any role for the import, or Shopify does not allow to set or change those values.

Columns with orange exclamation marks are completely unknown for this entity and will not be imported.

Total number of items

The “Total” number shows the count of items that the app has detected in the sheet.

Note that a single item can have multiple rows so the detected count might not be the same as the row count in the sheet.
For example, if you have 1 product with 10 variants, it will be 10 rows in the file, but in the app show as 1 product as all those variants belong to the same Product.

Duration Estimate

You can also see the “Estimate” for each sheet on how long the sheet import might take.

Before starting the job – this number is very approximate, to give an overall understanding of the timescale for different import jobs.
The actual import duration depends on many attributes including the data that already exists in the store, exact values in columns in the import files, API response times, app plan and many more.

The estimate will automatically improve when the import is running – after some first 100 items, it will become much more precise, because it will extrapolate the estimate based on item durations for this specific sheet.

Options

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.

Import progress

6. Shopify data import show progress Matrixify app follow import

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 Import Results file.
If you cancel your import, the Matrixify app will still generate the Import Results file up to the point how far it imported the data. The data that’s already imported will stay in your store and will not be rolled back.

 

Import Results file

After your import finishes the app will generate an Import Results file that you can download by pressing “Download Import Results” button.
In this results file you will see multiple columns added to the end of the file that will tell you more about the imported data and its status.

Columns with (Ref) such as ID (Ref) and Handle (Ref) are to help you reference the item that was created or updated in Shopify – those values are from the actual item within the Shopify store.
The Import Result column will tell you the status of how each item was imported such as OK or Failed.
In the Import Comment column you can see comments about how the import went for that specific item including any error or warning messages.

7. Matrixify app Import Results file Shopify data import errors message warnings comments

Matrixify file will contain only those rows, which were imported. That way you can review, what was imported, and 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?

The Import Comment value will be filled the same for all rows of the same item, so when you read them, consider the import comment about the item as a whole, not about each line.
If 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.

Tutorials

The most popular use cases and features of the Matrixify app are explained in our detailed tutorials.
Visit the Matrixify website Tutorials page to find exact step-by-step guides for your Shopify data import needs!