Start Free Trial
Start Free Trial

Products

See what each field/column from our “Products” template means including possible allowed values and examples.

Fields marked as “Export Only” cannot be imported/set in Shopify but can be exported with Matrixify export.

Excel Sheet Name

Products

When importing a file, to tell the app that you are importing Products, you need to ensure that the sheet/tab name is set to “Product” or “Products”.

For example:

  • If using a CSV file then the file name can be “my-shopify-products.csv”
  • If using an XLSX file then the sheet/tab name would be set to “Products”. The file name for the XLSX file does not matter.

Even if the sheet/tab name is not set correctly, you will be able to manually change and set the entity you are importing after uploading file in the app.

See more on the Matrixify app import process and import user interface.

Need a quick start?

Columns Available For Export And Import

Basic Columns

Column Description / Example Value
ID ID is automatically generated number by Shopify to identify the item.
It is filled in by an Export.
Can be used for Import to identify and update existing Products.
When creating new Products, leave this value empty.

Allowed Values

Number

Example
11920047631
Handle This is what your store visitors will see in the product URL address, like this: https://etaystore.com/products/mom-strength-red-t-shirt-slim-fit.
URL address has a great impact on SEO, so be sure to give it a meaningful name.
Regardless, what you write here, the app will convert it to lowercase, and remove all non-URL friendly symbols.
You can leave it empty when creating new Products – in that case, the app will generate it for you from Title.If the handle will have non-Latin characters like Chinese, Arabic or Russian, or any other language, it will get “transliterated” to the similar-sounding Latin letters by default. You can switch this option off in Options upon importing by unchecking “Transliterate Handles to English alphabet”.Each product Handle must be unique across your Shopify store, so when creating new products from external data source, even better approach would be to create Handle from Title and original product ID using Excel formula like this: =C2 & ” ” & B2 (assuming that you put some original product ID in the B column).Whatever you will put in the Handle column, the app will convert it to the required Handle format, which is acceptable by Shopify.When updating Handle the app by default will also create a Redirect from old Handle to the new one. You can turn this off in the Import options with importing a file.In Shopify, all Handles have a limitation of 255 characters, so any Handle longer than that will be truncated to 255 characters.

Allowed Values

Any characters allowed in a URL

Example
mom-strength-red-t-shirt-slim-fit-123456
Command When importing Product row – tell the app, what to do with it:

  • NEW: will try to create a new Product with the provided details. If such Product will already exist, then the result will be Failed.
  • MERGE: will try to find existing Product, and update it with data from the row. If such product will not be found, then it will create new.
  • UPDATE: the app will search for an existing Product and update it. If an item cannot be found then that item will fail to import.
  • REPLACE: WARNING! Use this Command value to fully replace the whole product, not individual fields. Using this Command value, the app will delete the product from the store completely and create a new one only from data in the file, resulting in losing all data that is not included in the import file.
    If a Product exists, then the app will delete it and create a new one from data in the file.
    If an existing Product will not be found, then still the app will create a new one. The difference from UPDATE is that it will not keep any of columns, which were not included in the import file since the Product will be deleted and re-created.
  • REPLACE: at first, if such Product exists, then the app will delete it. After that, it will create a new one. If an existing Product will not be found, then still the app will create a new one. The difference from UPDATE is that it will not keep any of columns, which were not included in the import file since the Product will be deleted and re-created.
  • DELETE: the app will delete the existing Product. If such Product will not be found, then the result will be Failed. This DELETE command is very handy for deleting Products in bulk.
  • IGNORE: the app will ignore this Product and will skip it.

If no Command is specified, then the app will assume the MERGE command.

See our tutorial on how Matrixify identifies Products when importing.

Allowed Values
NEW
MERGE
UPDATE
REPLACE
DELETE
IGNORE
Example
MERGE
Title Title of the Product.

When creating a new product, this is the only mandatory field for the Product.

When importing Product update Title can be used as identification for Product (there is no ID or Handle).

Allowed Values

Text

Example
Mom Strength Red T-shirt Slim Fit
Body HTML

This is a long description of the Product.

You can write here just a plain text, or format that text using HTML code.

You can put here additional images, videos, links to other Products or sites, tables, and so on.

You can learn about HTML capabilities online, for example W3Schools.com or use some online video courses, like from Treehouse.com or Udemy.com.

The best way to create HTML for Product, is to write a Description in the Shopify Admin for one Product, format it as you like, and then do the export. Then you will see, how that translates to HTML, and will be able to apply the same to other Products.

The app is also doing some helping with the descriptions automatically to make it easier to use and fix popular issues:

  • Converting text to UTF-8 encoding.
  • Automatically removing invalid characters like “_x000D_” , “” , and such (ask Matrixify Support if there are any other characters invalid that need to be removed).
  • Converting plain text to HTML if this is not an HTML already – so that you have proper newlines and basic formatting.
  • Optionally removing images from HTML (if checkbox enabled in Import Options).

When exporting, by default the Body HTML value will only be filled in the first row for each product if the product has multiple rows.
Ask our Support if you need Body HTML column values filled in all rows of a Product when exporting.

Allowed Values

Text, HTML

Example
<b>Features</b>
<ol>
  <li>Looks nice</li>
  <li>Feels good</li> 
</ol>
Vendor Basically the Brand name.

Be sure to keep all the same Brand names written the same. For example, “H&M” and “H & M” (with spaces) will be appearing as two different brands.

The Vendor field cannot be set empty in Shopify. Doing so with an import, Shopify will automatically set the Vendor to the store name.

Allowed Values

Text

Example
Nike
Type Shopify Product Custom Type – allows you to define a certain kind for each Product. Any text can be entered into this field.

To import/export Shopify Product Categories, use Category columns.

Allowed Values

Text

Example
T-shirt
Tags Tags allow you to add additional elements or “properties” to your product, which you can use for filtering, for showing some additional information about the Product in the store.

Tags also are great, when Type column is not enough, and you need to create a hierarchy of some sort. For example, you might want to tell that this Product is a Shirt and a Skirt. In this case, you could add tags: Type: Shirt, Type: Skirt.

Then you can create Smart Collections “Shirts”, where you include all Products which have Tag “Type: Shirt”, and another Smart Collection, where you include Products which have Tag “Type: Skirt”. That way this Product will be included in both Smart Collections.

Tags column values are read joined together from all the duplicated product rows so if you like, you can have duplicate rows with each tag in its own row, and those all will be imported.

See this tutorial on how to bulk manage your Tags.

Allowed Values

Comma Seperated List

Example
Color: Red, Eatable, Featured, Type: Skirt
Tags Command Tell the app, what to do with Tags:

  • MERGE: will add Tags to existing tags. It means that you don’t need to list all the tags in the import file, you can import those which you want to add. If some of the tags you are importing already exist, then the app will ignore it.
  • DELETE: will delete the Tags that are listed in the import file. If the listed tag will not exist, then the app will ignore it.
  • REPLACE: will replace all existing tags with the tags from the import file. Use this method to maximize the import speed, because if you will use MERGE, it means that the app will need first to load existing tags which takes additional time.

If Tags Command is not set, the app will assume the MERGE command by default.

You can also have Tags listed in multiple rows within the item and with different Tags Commands.
They will be executed in the same order within the item as you have them listed in the file.

See this tutorial on how to bulk manage your Tags.

Allowed Values
MERGE
DELETE
REPLACE
Example
REPLACE
Created At
Export only
It will be automatically set to the time when the Product was actually created in Shopify.
When migrating from another store, this time will always be the time of migration.

Allowed Values

Date & Time

Example
2018-12-17 18:20:07 +0200
Updated At

Export only

It will be automatically updated, whenever you change the Product data.

Allowed Values

Date & Time

Example
2018-12-17 18:20:07 +0200
Status Status of the Product in Shopify.
Can be imported and exported.

  • Active – The product is ready to sell and is available to customers on the online store, sales channels, and apps.
  • Archived – The product is no longer being sold and isn’t available to customers on sales channels and apps.
  • Draft – The product isn’t ready to sell and is unavailable to customers on sales channels and apps. By default, duplicated and unarchived products are set to draft.

By default, new Products are set to the Active status. (This default can be changed for specific stores by our support).

If the field is imported as empty then it will be ignored as you cannot set the Status to nothing in Shopify.

Allowed Values
Active
Archived
Draft
Example
Draft
Published Tells, whether this Product should be Published on any of your Channels.

It works in combination with the column Published Scope.

If you will leave this cell empty, then it will treat it as a FALSE value.

Allowed Values
TRUE
FALSE
Example
TRUE
Published At This column can be exported and imported.

It will be automatically updated, whenever you publish the Product.

You can set the product publication date in the past, by importing the specific date you like.

If there will be no Published column present, then having a date in this column will publish a previously unpublished product. Basically, if you import this column with the date value, then it will mean that Published = TRUE.

Allowed Values

Date & Time

Example
2018-12-17 18:20:07 +0200
Published Scope Tells Shopify, where to publish this Product.

This column works in combination with the Published column the following way;

Published Published Scope Result
TRUE global Will publish the product to Online Store and POS channels.
TRUE web Will publish the product to Online Store, but not to the POS channel.
FALSE global Will publish the product on POS, but not on the Online Channel.
FALSE web Will not publish the product on any of the channels.

Changes to any other channels like Facebook, Wholesale, etc. are not available through this import as Shopify API doesn’t allow that at the moment. But you can follow this video tutorial to still change all the channels in bulk through the Admin, and play with filters and Tags (which you can import with Matrixify), to identify particular Products to publish/unpublish.

By default, the published scope is set to global if POS sales channel is added to the store.
Otherwise, the default value is web.

Allowed Values
global
web
Example
global
Template Suffix Template Suffix allows you to specify another Template from your Theme for this specific Product. For example, you might want to specify different template for a Featured product, which has different page layout.

Work with your developer to create new Template or read Shopify documentation about adding additional Product templates. Once new Template is created, you can set in this column to activate it for needed Products.

That different template will show as dropdown for Products in Shopify Admin, when new Product Template will be created in your Theme. For example, if the new Template file name is “product.featured.liquid”, then – to activate this Template for this Product, write “featured” as the Template Suffix.

Allowed Values

Text

Example
featured
Gift Card Tells, whether this Product is a Gift Card Product.

Can be set only when creating a product, cannot be updated!

Check our tutorial on how to bulk import Gift Card Products.

Setting value TRUE in this field will automatically override the following variant field values to what Shopify requires for creating a Gift Card:

Gift Card product in the Admin -> Products looks exactly the same as other Products.
To check your Gift Card Products go to Admin -> Products -> Gift cards -> Manage gift card products.

Allowed Values
TRUE
FALSE
Example
FALSE
URL

Export only

The Product page URL.

Total Inventory Qty

Export only

All variant inventory quantity sum.
Row #

Export only

Will have row number from 1 till the end for each row. So that if you change the sorting in your exported file to easier update your data, you can sort it back by “Row #” and return it to the original sorting. Because, you know, all the item data should be together – and if you change the sorting, you need to sort it back.
Top Row

Export only

It will have value TRUE for each “top row” of the item. That can help you filter in Excel to get only the base rows, in case you need to get rid of repeated rows for each item. Some sheets already had this as Primary Row column earlier, but we have added it now to all the sheets now and renamed to Top Row so it’s more clear.

Category

Shopify Product Category.
You can see all Shopify available categories in Shopify Product Taxonomy page.

When updating Category, you do not need to use all 3 category columns. You can use any 1 or more columns from the list below. If importing from multiple columns, make sure that they reference the same category.

Column Description / Example Value
Category: ID
ID for the Category that product is in.

See each category ID in the Shopify Product Taxonomy page by selecting a category and opening Category mappings > Shopify section.

Alternative column headers
  • Type: Standard ID – for legacy Matrixify template
Allowed Values

Number

Example
127
Category: Name Category name.

You can see all Shopify available categories in Shopify Product Taxonomy page.

When importing Product Categories using only the “Category: Name” column, if you have an error that multiple categories match the same name then you must also use “Category: ID” with the specific category ID or “Category” column with ID and/or breadcrumb for the specific category you need to set.

Alternative column headers
  • Type: Standard Name – for legacy Matrixify template
Allowed Values

Text

Example
Clothing
Category Full path/breadcrumb of the Shopify Product Category.

When importing, in this column you can set this column value as:

  • full path/breadcrumb for the Category.
    Example – Apparel & Accessories > Clothing.
  • only the category name.
    Example – Clothing.
  • only id.
    Example – 127.
  • id with the full path.
    Example – 127 - Apparel & Accessories > Clothing.

In the Shopify Product Taxonomy page select your category to find details about each category – in Category mappings > Shopify section you can see the category ID and in the “Breadcrumb” section the category full path.

Alternative column headers
  • Product Category – for Shopify Transporter CSV and Shopify native CSV
  • Standard Product Type – for legacy Shopify native CSV
  • Type: Standard – for legacy Matrixify template
Allowed Values

Text

Example
Apparel & Accessories > Clothing

Collections

Each Product can exist in several Custom Collections and Smart Collections.

Column Description / Example Value
Collection

Import only

This column is only imported to maintain compatibility to Shopify CSV import. It doesn’t show up in the export, because all current collections are in “Custom Collections” column.

It contains the Collection Title where this product should be added.

The Matrixify app will search for an existing Custom Collection by this title, and if it is found, then it will add this Product to that Custom Collection.

If it finds several collections with the same Title, then it will add this product to the first of them.

If such Custom Collection doesn’t exist, the Matrixify app will create it for you, and add this product there.

You can add this product to several Custom Collections at once by repeating the product row and putting each Custom Collection title in its own row.

Allowed Values

Text

Custom Collections This column is exported and imported.

It contains a comma-separated list of Custom Collections where this product is appearing.

The values of this column are repeated for all the product rows (image rows and variant rows). This would allow tricks like – finding out which SKU is in which collection.

When importing, the comma-separated list of those Custom Collection handles is being read from all the rows – so you can have several product rows with several comma-separated Handles there.

If this cell is empty in the export, it means that this particular product is not included in any of the Custom Collections.

If you are importing empty value for this column, it will not remove this product from any collection – it will just add it to whatever collection is mentioned here.

To work with Custom Collections in more detail, please, refer to the Custom Collections documentation or see the tutorial: How to add Products to Shopify Custom Collections (also known as Manual Collections).

You can also list Custom Collection Titles and Matrixify will generate Handle from that and search for collection with such Handle.
If listing Titles you can escape comma with “\”, for example, “Me\, You Collection” would be handled as single collection with a comma in the Title.

Allowed Values

Comma-seperated Collection Handles

Example
daily-picks, our-bestsellers
Smart Collections

Export only

This column is only exported.

It contains a comma-separated list of Smart Collections where this product is appearing.

The values of this column are repeated for all the product rows (image rows and variant rows). This would allow tricks like – finding out which SKU is in which collection.

If this cell is empty, it means that this particular product is not included in any of the Smart Collections.

To include the product in a Smart Collection, please, refer to the Smart Collections documentation or see the tutorial: Create Smart Collections in bulk by Product Tags.

Allowed Values

Comma-seperated Collection Handles

Example
red-shirts, discounted

Media

Each Product can have several media files.
In the Matrixify export, each of those will be exported in a different row with all the media file details in that row for each file.

Each variant can be linked to one of the images. Variants can only be linked to images (media with Image Type as IMAGE)

Columns and rows of media files do not correlate with Variant columns and rows. So Variant Image and Image Src rows are not aligned. Each of the column groups lives their own life.

Don’t let the “image” word in the media column names confuse you (Image Type, Image Src, Image Postion, etc.) – that’s because some time ago the Shopify allowed to add just images to their products, but now you can add all sorts of media like video and 3D models. For the sake of compatibility, we decided to keep the column names unchanged (for now).

Column Description / Example Value
Image Type

Export only

Type of the media file in Shopify.

  • EXTERNAL_VIDEO – externally hosted video such as link to a YouTube video.
  • IMAGE – Shopify-hosted image.
  • MODEL_3D – Shopify-hosted 3d model.
  • VIDEO – Shopify-hosted video.
Allowed Values
IMAGE
VIDEO
EXTERNAL_VIDEO
MODEL_3D
Image Src Link to the media file. This link must be publicly available and direct link so that Shopify is able to download file from it.

Once files are imported, those don’t need to be hosted anymore with this link, because Shopify will download this it and store on their own servers.
Except when having externally hosted video.

To import several media files for the same Product, you have multiple options:

  1. repeat the new row with the same ID or Handle, or Title values
  2. have several links in the same Image Src column cell, separated by ; (semicolon)
  3. have multiple Image Src columns – the column header would need to be the same, so you would have multiple duplicate columns.
  4. any combination of both above options.

If you need to add an additional media files, you don’t need to mention existing files – just mention those files, which you need to import, and use MERGE as Image Command.

If the Image Src column will be empty, or will not exist, the media files will stay unchanged.
Unless Image Command REPLACE is used, as then existing files set for that product will be replaced with nothing, and thus all existing media files will get removed from it.

If Shopify will not be able to download all files, the warning about that will be put in the Import Results file “Import Comment” column.

Links listed in this column need to be direct and public links.
You can always test your links by trying to add media from URL links manually in Shopify Admin to any product. If it works manually in admin, it should work with Matrixify import.
Google Drive and DropBox shared links also will work as the app will correctly convert them to direct links when sending them to the Shopify API.

You can also import images from FTP/SFTP links by using image links in the following structure: ftp://username:password@server:port/path/file_name

When exporting, the Matrixify app will export associated media links, but not the media files themselves. If you are looking to export actual media files please refer to Matrixify tutorial “Download all files from Shopify Files to your computer“.

Supported file types:

  • Images: JPG, PNG, GIF, HEIC, WEBP, SVG
  • Animated images: GIF (animated gif), PNG (apng)
  • Video: MP4, MOV, WEBM
  • 3D: GLB, USDZ

See Shopify manual on file types, sizes, and other limitations for product media.

Allowed Values

URL

Example
https://images.com/image.jpg;
https://images.com/another-image.jpg
Image Command Here you define the action what to do with media:

  • MERGE – will keep all existing media for your product, update data of specified media from this import by the file name, and add any new media files.
  • DELETE – if put next to the media link, then this particular media file will be deleted from the Product in Shopify, while all other images will be kept.
  • REPLACE – will delete all media files from the product and add back those that are included in this import.

Media is never deleted or removed by default – only when you will give the explicit command to do so.

If Image Command is empty or such column doesn’t exist, then the MERGE command will be assumed.

Allowed Values
MERGE
DELETE
REPLACE
Example
MERGE
Image Position The position of the particular media file within the product.

You can reorder media files inside one product by doing Export, changing those Position values, and importing back as an image column update.
To change the positions you also need to have the Image Src column in the same import, so that app knows, which media file you are talking about.

When importing several media files with the semicolon, the media position numbers will be auto-incremented starting from this given number.

If you import different product or variant media files with the same position number, the Matrixify app will not overwrite the existing image at that position.
Instead, if this is a new media file, for example, at position 1 then the app will add it, set it to position 1 and thus other media files will be moved down one position.
If multiple media files and images have the same position in the file such as 1 and 1 then the app will add those as the first product media with the first being the one that is first in the file.

The numbers you assign to the “Image Position” column do not have to be in a sequential order.

Allowed Values

Number

Example
5
Image Width

Export only

The width of the image, in pixels.

Allowed Values

Number

Image Height

Export only

The height of the image, in pixels.

Allowed Values

Number

Image Alt Text By SEO best practices, it is strongly suggested that media files have “alt text” specified, because this is how search engines know, what’s inside that file.

Allowed Values

Text

Example
T-shirt small size
Image Attachment

Import only

Import without a public link but list actual data encoded in Base64.

Data URL is supported as a value according to this specification, however, if there is no data: prefix, then the base64 encoded image data is assumed.

Allowed Values

Base64 encoded media file.

Example 1
data:image/png;base64,PGJhc2U2NC1lbmNvZGVkPg==
Example 2
iVBORw0KGgoAAAANSUhEUgAAAL4AAAC+CAIAAAAEFiLKAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAN8SURBVHhe7dc9ThtbGIDhu7PbZiFU7MMNC0FiH0g0t6WkiCJRpk3JHXvG9ozBRHmlSMnR82gKmD9bOi/fEf+8QSIdIukQSYdIOkTSIZIOkXSIpEMkHSLpEEmHSDpE0iGSDpF0iKRDJB0i6RBJh0g6RNIhkg6RdIikQyQdIukQSYdIOkTSIZIOkXSIpEMkHSLpEEmHSDpE0iGSDpF0iKRDJB0i6RBJh0g6RNIhkg6RdIikQyQdIukQSYdIOkTSIZIOkXSIpEMkHSLpEEmHSDpE0iGSDpF0iKRDJB0i6RBJh0g6RNIhkg6RdIikQyQdIukQSYdIOkTSIZIOkXSIpEMkHSLpEEmHSDpE0iGSDpF0iKRDJB0i6RBJ56e+77789++Xl8fl1/cubvhxfzv9+vkjIxgmnXn99sfuaTm19+31Zjn/yULOi33thl9L5+vD8+V3GNRg6TzfTBHcvn5dTs4LeTjZ0/k10vnrLH/694dW7r+tTt69bsp4epmH03TcPPxY7S+HY8ruMKhuHl6Ps+Qc1pzF4anlPas37G94vDu+Z/+ql93+/PbLrLL+242WzuOy8OfV3T2thsp0dVm89aRZ/3ze446TY331+CmbDjaPr6fOldQGMVw680IeFvUwA45njkt7crg6j4SP0jmPh+3V1dD6qK2LDetc2OrjBjFeOvPiPd8/HQq4+36xtJs95ZN09g/OtleXD7ra1jadUzGHe86PjGDAdFb/VV2WsV7Xn0ydK+nMb5iP4+7zWTrLlLp9nt450m41GTGdZS1Pf+UX6cy5zPfPP293k0/SOe9l7z/uSjqnL3N6/yiGTGdZv4+mwnzb/tjdTfNgm8t0TFlcT2fe7OYslvHzbkN8l87xzrF2q8kw6fzBhvvfaiad3249q0Yind9s2QqX7Wwk0iGSDpF0iKRDJB0i6RBJh0g6RNIhkg6RdIikQyQdIukQSYdIOkTSIZIOkXSIpEMkHSLpEEmHSDpE0iGSDpF0iKRDJB0i6RBJh0g6RNIhkg6RdIikQyQdIukQSYdIOkTSIZIOkXSIpEMkHSLpEEmHSDpE0iGSDpF0iKRDJB0i6RBJh0g6RNIhkg6RdIikQyQdIukQSYdIOkTSIZIOkXSIpEMkHSLpEEmHSDpE0iGSDpF0iKRDJB0i6RBJh0g6RNIhkg6RdIikQyQdIumQvL39Dxdu/LzXDU5QAAAAAElFTkSuQmCC

Inventory / Variants

Each Product can have several variants, that is a different version of a product, for example, size or color.

All those variants can be imported, as well as exported.

To add several Variants to a Product, you need to add an additional row for each Variant. Import will know that the Variant belongs to the same Product, if that added spreadsheet row will have the same ID, Handle or Title (whichever comes first). All the other Product base columns (which are not variants) are ignored for Variant rows. That means that you can either leave them empty, or just copy the same previous line – which in some cases can be much more convenient. Basically, when you are copying rows, you don’t need to empty the cells of copied product information.

Those all are columns, which are accessible in Shopify Admin, when adding new product Variant.

Shopify allows maximum of 100 Variants per Product.

Column Description / Example Value
Variant Inventory Item ID

Export only

Global Inventory Item identifier. It is the new way of how Shopify identifies inventory item across many locations. We are transitioning the app gradually to this new approach. Read more here.

Allowed Values

Number

Variant ID

 

Shopify internal ID for each product variant.

If the Product in the store has no Variants, it will still have Variant ID as such Products still have default Variant that has variant-specific attributes such as price, inventory, SKU, and others.

Importing:

Each Variant, after imported, gets its own Variant ID, assigned by Shopify.
When you import new Variants or replace all existing Variants for Product, you need to leave Variant ID column empty, or remove that column from the spreadsheet file.

You can also use Variant ID to identify Products when updating them.
See more on how Matrixify identifies existing products.

When importing, if you also have the ID column with an existing ID value and have a Variant ID that does not exist within the Product, then the app will fail the product to ensure that the IDs are valid and correct in the file. This is a special validation in the app to ensure that if the file has IDs they are correct and not mixed up or broken.

Exporting:

When you will Export Products, then Variant ID will serve as a reference to whichever Variant you want to update. You can update one or many columns for Variant by keeping the Variant ID in the import file. That way the import will know precisely, which Variant you need to update.

Allowed Values

Number

Example
41920047632
Variant Command Whenever variants are imported, there is always one of those commands executed for each of variant rows:

  • MERGE – merges new variants into existing product variants. Updates those that can be found by Variant ID, Variant SKU, Variant Barcode or Option Values. If it will not find such a variant to update, then it will add new.
  • UPDATE – will update variants that can be found by Variant ID, Variant SKU, Variant Barcode or Option Values. If a variant cannot be found to update, will fail the Product.
  • DELETE – will delete the listed variant. Requires Variant ID, Variant SKU, Variant Barcode, or Option Values – so that it can identify, which variant you want to delete.
  • REPLACE WARNING! Use this Variant Command value to fully replace all variants in the product, not individual variant fields. Using this Command value, the app will delete all the variants from the product and create a add new ones only from data in the file, resulting in losing all data that is not included in the import file.
    Will replace all existing product variants with the ones that are listed in the import. This will delete all variants from the product and create only the ones you have in the file.

If no Variant Command is specified, then the MERGE will be assumed.

See this Tutorial for more details about adding variants: How Add Variants To Existing Product.

Allowed Values
MERGE
UPDATE
DELETE
REPLACE
Example
MERGE
Option1 Name Each product can have 3 Options, with many values per option.

This Option1 Name column is the name of 1st Option. The value of this 1st option is to be written in the Option1 Value column, which becomes so-called Variant of the product.

You can have those options empty, if you don’t have any options to choose from. Then you need to keep Option Values empty as well.

Allowed Values

Text

Example
Color
Option1 Value The Value of Option1 Name.

For example, if we considered the Option1 Name to be a “Color”, then Option1 Value need to contain colors, like, Red, Blue, Green, and so on.

You can have as many Option Values as you like. The Shopify global limitation here is that you can have up to 100 Variants per Product.

All option value combinations must be unique, meaning that there is not allowed to be two variants with the same Option Values. For example, you can’t have two Variants with the same Color, Size and Fabric. At least one of those must be different.

If you need to generate several options from the same cell, split them by ; (semicolon). The app will generate the combinations of all 3 option values – they all can have values split by ; (semicolon).

Allowed Values

Text

Example
Red
Option2 Name The name of the 2nd Option.

Allowed Values

Text

Example
Size
Option2 Value The Value of the 2nd Option.

Allowed Values

Text

Example
XS
Option3 Name The name of the 3rd Option.

Allowed Values

Text

Example
Fabric
Option3 Value The Value of the 3rd Option.

Allowed Values

Text

Example
Cotton
Variant Generate From Options

Import only

You can also generate Variants from Options by having Option Values listed with a semi-colon.
Then you will need to also specify in this field the value TRUE to tell the app that you wish to generate options.Check out tutorial for more details.

Allowed Values
TRUE
FALSE
Example
TRUE
Variant Position Variants can be sorted in specific order. This Variant Position tells that order.

You can update order of existing Variants by changing those numbers and importing them back as an update.

And of course, you can import only this column. To do so you need to include the ID, Variant ID and Variant Position columns in your import file. Then app will determine which Product and which Variant you need to update.

If the field is imported as empty then it will be ignored.

Allowed Values

Number

Example
17
Variant SKU SKU number is a “Stock Keeping Unit” reference number, usually used in wholesale to uniquely identify and reference the Product Variant. Some companies organize all their inventory by SKU numbers, which allows them to track items with precision.

When you import data from any dropshipping company, they will almost always have SKU number to identify their Product variants. It’s good practice to keep those SKU numbers from wholesale company or dropshipper in this column. It will be useful when your customer will place an order through your store, you will be able to tell the dropshipper this SKU number, and they will instantly know, which Product Variant is being ordered.

If you have your own inventory, you can create your own SKU numbers, as simple as 1, 2, 3, or something more complex, which encodes your product category, or some other important information, like: TS000001RXSC.

Variant SKU can also be used as a “key” to identify existing Products if the ID or handle is not known for the product. Read Tutorial: How to update Product by SKU?
You can also force the app to identify Product by the SKU, even if your file contains Handle and Title, by adding [ID] to the column header. More info about it here.

Allowed Values

Text

Example
TS000001RXSC

 

Variant Barcode Shopify officially supports UPC or ISBN barcode types, but you can put here any other barcode format.

You can also use Variant Barcode to identify Products when updating them.
See more on how Matrixify identifies existing products.

Allowed Values

Text

Example
12500-00081
Variant Image Link to your Variant image.

Rows of Variant Images are not aligned with rows of Image Src images. They each live their own life.

It can be the same link, as you use in your Image Src for product image, or it can be a different link, which is specific to this Variant.

If this link will be one of those, which you also have for Image Src column, then it will recognize it and use the same Product image for Variant.

If that will be a link, which is not listed in Image Src column, then it will add this image to Product images too.

Each Variant can have only one image.

If the app will not be sure that the correct image is mapped to a variant image, due to missing images, then warning about that will be written in Import Results file “Import Comment” column.

Allowed Values

URL

Example
https://images.com/image.jpg
Variant Grams Imported only (to be compatible with Shopify CSV columns format).

Regardless of the weight that you will show on your Store, you can specify weight in grams.

Will use the value of this column only when there is no Variant Weight column.

When showing Product information, Shopify will convert those grams to whatever Weight Unit you will need to use.

Allowed Values
Whole Number
Example
200
Variant Weight The variants shipping weight in the specified Variant Weight Unit.

If imported empty, the resulting value in Shopify will be 0.0.
Same as in Shopify admin manually, you cannot set the weight to an empty value.

Allowed Values

Number

Example
1.2345
Variant Weight Unit The variants shipping weight unit to show Clients. Shopify will automatically convert grams to this weight unit.

If imported empty, Shopify will set the weight unit to the store’s default weight unit (set in Shopify Admin > Settings > Store details > Time zone and units of measurement).
Same as in Shopify admin manually – you cannot set the weight unit to an empty value, but only choose from available weight units.

Allowed Values
g
kg
oz
lb
Example
lb
Variant Price The price of the Variant item in the currency, which you have set for your Store.

Allowed Values

Decimal Number

Example
389.99
Variant Compare At Price The original price, if your Variant Price is a discounted price.

Which means – if you want to show that a Variant is being sold at a discount, then you set your Variant Price to a new, discounted price, and set this “Variant Compare At Price” to the old, original price.

Neat Trick

If you want to create a Smart Collection, which shows all Discounted Products, you can create a Smart Collection with a Rule, which says: include all Products with Variant Compare At Price is greater than 0.

Even Neater Trick

If you want to create a Discount Code and allow to use it only for Products which are not sold already at a discount – you can create a Smart Collection, which includes only Products, where Variant Compare At Price equals 0. And then attach that Collection to your Discount Code.

But here is the problem – if your Variant Compare At Price will be empty, those Products will not be included in this list, and basically Customer will not be able to use their Discount code for them. To make those Products appear in that “Undiscounted Products” Collection, you need to set all non-discounted product variants Variant Compare At Price to be exactly 0. Voalá!

Allowed Values

Decimal Number

Example
499.99
Variant Taxable If you set it to TRUE, then Shopify will charge additional Tax on the item price, taking in account your store Tax settings.

If you set it to FALSE, then Tax will not be added to the Price.

If you leave it empty, then it will be assumed as FALSE – that it’s not taxable.

Allowed Values
TRUE
FALSE
Example
TRUE
Variant Tax Code Specifies the Avalara tax code for the product variant. Will export and import only for stores that have the Avalara AvaTax app installed.

Allowed Values

Text

Example
DA040000
Variant Inventory Tracker Inventory of the Variant can be tracked by Shopify, or not.

To have Inventory Tracking means that somebody will look after the available quantities in your inventory stock.
Whenever item will be purchased, the quantity of this Variant will be decreased.

This value is required if you are setting any inventory quantity.

Some dropshippers provide the inventory tracking service and automatic updating of available quantity. In that case you need to keep this value empty, so that Shopify won’t track it.

Some variants can have Shopify to track inventory, and some can be empty, meaning, that inventory here will not be tracked by Shopify.
In Shopify admin, this value shows as “Track Quantity” checkbox, whether the tracking is enabled or not.

In regular usage, you would have value shopify to enable Shopify to track the inventory and leave the column as empty to disable Shopify inventory tracking.
You cannot use values “True” and “False” in the column as in Shopify back-end this is not a boolean, and using boolean values will return an error when importing.

Allowed Values
shopify
<empty>
<Handle-of-tracking-service>
Example
shopify
Variant Inventory Policy When Shopify is tracking your inventory, it needs to know, what to do, when Variant quantity reaches 0, which means, you are out of stock.

This column manages the Shopify Admin attribute checkbox “Continue selling when out of stock”.

Allowed values are:

  • deny: Shopify will not allow to purchase this item on your Store. It will tell your Customers that item is out of stock.
  • continue: Shopify will still allow Customers to purchase orders from your Store, even when you are out of stock.

If the field is imported as empty then it will be ignored as you cannot set the Inventory Policy to nothing in Shopify.

Allowed Values
deny
continue
Example
deny
Variant Fulfillment Service There are warehouses or dropshippers who can package and ship the item to your Customer, when they place an order. That is called a Fulfillment Service. You can connect this, so that whenever item is ordered from your Store, the Fulfillment Service provider instantly ships that order to your Customer – automatically.

You can have several Fulfillment Services connected to your store, and each Variant can be linked with one of them.

If you want to fulfill orders manually, you can enter the value manual.

If you want a Fulfillment Service to ship your orders, then you should enter here the Handle of the Fulfillment Service. You can find this Handle by setting a chosen fulfillment service for one of your Variants in your store, and then doing the Export. In the Export file you will see the Handle of this Fulfillment Service.

If the field is imported as empty then it will be ignored as you cannot set the Fulfillment Service to nothing in Shopify.

Allowed Values

Text

Example
manual
Variant Requires Shipping Variants can be shippable or not. Non-shippable Variant would be a digital good, which you sell.

If you set it to TRUE, then Shopify will ask Customer for Shipping address.

If this is FALSE, then Shopify will not ask for Shipping address.

If you leave this empty, then it will be assumed as FALSE – that it doesn’t require shipping.

Allowed Values
TRUE
FALSE
Example
TRUE
Variant Inventory Qty Quantity of available Product Variants in your stock.

Will be automatically updated, when items are sold, if Variant Inventory Tracker is set to shopify.

This number is the total quantity across all your locations.

If you will import the number in this column and will have no columns with Inventory Available: … or Inventory Available Adjust: … then this quantity number will be set for your primary location.

Allowed Values

Number

Example
5839
Variant Inventory Adjust The number to adjust the inventory difference – a positive number will add inventory to existing quantity, a negative number will subtract the inventory quantity.

When importing this column, the Variant Inventory Qty cannot be imported (because it doesn’t make sense to set and adjust the inventory at the same time).

Allowed Values

Number

Example
-20

Variant Cost

When exporting, selecting “Variant Cost” will include this field in the exported file for each Variant with the value that each Variant has set.

If no “cost” value is set for the Variant in Shopify then this field will be empty for that Variant,

Column Description / Example Value
Variant Cost The “Cost Per Item” value which is usually the cost of this item from your supplier.

Alternative column headers
  • Variant Inventory Cost – for Shopify Transporter CSV
  • Cost per item – for Shopify native CSV
Allowed Values

Decimal Number

Example
200.22

Customs Information

Column Description / Example Value
Variant HS Code The general Harmonized System (HS) code for the Variant.

Allowed Values

Number

Example
123456
Variant Country of Origin The two-digit code for the country where the Variant was made.

Allowed Values

Country Code

Example
CA
Variant Province of Origin The two-digit code for the province where the Variant was made.
Used only if the shipping provider for the inventory item is Canada Post.

Allowed Values

Province Code

Example
QC

Multi-Location Inventory Levels

Column Description / Example Value
Inventory Available: <Location Name> The quantity of available stock in certain Location.

There will be this kind of column for each of your locations.

  • If you need to enable the inventory at that location then import value 0 or greater.
  • If you need to remove the inventory at that location then import the empty value.
  • If you need not to change the inventory quantity at that location then don’t import that particular location column.
  • If you need to adjust your inventory by a certain quantity, then don’t include this column in the import, but use the Inventory Available Adjust: … column for the delta number.
  • If you are not tracking inventory you can use value Stocked to tell Shopify in which locations the inventory is stocked.

Read more about Multi-Location Inventory.

Allowed Values

Number or value Stocked

Example
1000
Inventory Available Adjust: <Location Name> The quantity you need to adjust for each of your locations, for each Variant.

There will be this kind of column for each of your locations.
With this column, you can adjust your inventory by a certain quantity instead of setting fixed number.

If you need to import fixed quantity for each location, then don’t import this column or import it empty. Use the Inventory Available: … column for that.

Read more about Multi-Location Inventory.

Allowed Values

Number

Example
-5

Pricing by Markets

Import and export market-specific fixed pricing and manage if products are included in individual Shopify market catalogs.

To import/export pricing by markets, your market names in the store need to be unique.

Column Description / Example Value
Included / <Market Name> Indicates if the whole Product is included/published in the specific Market.

Set only in the first row of each product as in Shopify only the whole product can be included in the market, not individual variants.

Example column header – Included / North America

Allowed Values
TRUE
FALSE
Example
TRUE
Price / <Market Name> Fixed Variant price in the specific Market.

Importing this field empty for a market, will also clear that compare at price in the market for this variant.
Shopify does not allow for fixed compare at price to exist/be set in a market if it does not have a fixed price set.

Example column header – Price / North America

Allowed Values

Number

Example
53
Compare At Price / <Market Name> Fixed Variant compare at price in the specific Market.

To set a fixed compare at price in a market, also price in that market is required.

Example column header – Compare At Price / North America

Allowed Values

Number

Example
84

Metafields

Read the more detailed documentation on Metafields page.

Metafields for SEO

Metafield Column Name SEO Field
Metafield: title_tag [string] SEO Title.

Alternative column headers
  • Metafields Global Title Tag – for Shopify Transporter CSV
  • SEO Title – for Shopify native CSV
Metafield: description_tag [string] SEO Description

Alternative column headers
  • Metafields Global Description Tag – for Shopify Transporter CSV
  • SEO Description– for Shopify native CSV

Metafields for Google Shopping

Those are the same fields that you import and export with Shopify CSV files, just they are actually stored as the following Metafields in Shopify:

Metafield Column Name Google Shopping Field
Metafield: mm-google-shopping.gmc_id [single_line_text_field] Comma separated relationships between product and its variant(s).

“shopify_US_”+”product ID”+”_”+”variant product ID”

Example
shopify_US_286247125016_3126953639960, 
shopify_US_286247125016_3126954328088
Metafield: mm-google-shopping.custom_product [single_line_text_field] If this is a custom product.
Metafield: mm-google-shopping.mpn [single_line_text_field] MPN
Product’s Manufacturer Part Number.Required if your product isn’t custom and doesn’t have a barcode (GTIN). More info here.

Example
GO12345OOGLE
Metafield: mm-google-shopping.google_product_category [single_line_text_field] Google Product Category. More info here.

Example
Clothing & Accessories > Clothing > Dresses
Metafield: mm-google-shopping.age_group [single_line_text_field] Age Group. More info here.

Allowed values
  • newborn
  • infant
  • toddler
  • kids
  • adult
Example
adult
Metafield: mm-google-shopping.gender [single_line_text_field] Gender

Allowed values
  • male
  • female
  • unisex

More info here.


Example
male
Metafield: mm-google-shopping.condition [single_line_text_field] Condition. More info here.

Allowed values
  • new
  • refurbished
  • used
Example
used
Metafield: mm-google-shopping.color [single_line_text_field] Color. More info here.

Example
Red
Metafield: mm-google-shopping.material [single_line_text_field] Material. More info here.

Example
Leather
Metafield: mm-google-shopping.size [single_line_text_field] Size. More info here.

Example
XL
Metafield: mm-google-shopping.size_system [single_line_text_field] Size System
With the “size_system” attribute you can explain which country’s sizing system your product uses. More info here.

Allowed values
  • AU
  • BR
  • CN
  • DE
  • EU
  • FR
  • IT
  • JP
  • MEX
  • UK
  • US
Example
US
Metafield: mm-google-shopping.size_type [single_line_text_field] Size Type. More info here.

Allowed values
  • regular
  • petite
  • plus
  • big and tall
  • maternity
Example
regular
Metafield: mm-google-shopping.unit_pricing_measure [single_line_text_field] Unit pricing measure

Example
176
Metafield: mm-google-shopping.unit_pricing_measure_unit [single_line_text_field] Unit for the pricing measure

Example
lb
Metafield: mm-google-shopping.unit_pricing_base_measure [single_line_text_field] Unit pricing base measure

Example
743
Metafield: mm-google-shopping.unit_pricing_base_measure_unit [single_line_text_field] Unit for the pricing base measure

Example
ml
Metafield: mm-google-shopping.custom_label_0 [single_line_text_field] Custom label 0
Metafield: mm-google-shopping.custom_label_1 [single_line_text_field] Custom label 1
Metafield: mm-google-shopping.custom_label_2 [single_line_text_field] Custom label 2
Metafield: mm-google-shopping.custom_label_3 [single_line_text_field] Custom label 3
Metafield: mm-google-shopping.custom_label_4 [single_line_text_field] Custom label 4

 

Note that other Google Shopping apps might store Google Shopping data in other Metafields – so be sure to Export a sample product to see in which Metafields the data you need to change, is stored.

Variant Metafields

Variant Metafields are metafields that are attached to each Variant. The column name for variant metafield starts with “Variant Metafield: “, followed by the namespace.key – the same way as the Metafields.

For example:

  • The variant metafield with name “buy_price” in the global namespace should be called “Variant Metafield: buy_price”.
  • The variant metafield with name “description” in the “details” namespace should be called “Variant Metafield: details.description”.

Note that exporting and importing Variant Metafields will significantly increase the time it takes to process the items because each variant metafield needs separate request to the Shopify API. Therefore, be mindful and export/import variant metafields only when you really need them.

Read the more detailed documentation on Metafields page.

Export Filters

In the Matrixify app, you can apply filters to Export only specific items from your Shopify Store.
When creating new export, select what you wish to export, and under that entity click on the “Filters” button.

Note: total displayed item count and estimated time won’t be affected by the filters applied.

Filter Description
ID Allows you to list specific Product IDs to export, separated by a comma.

Possible Conditions
  • equals to any of
  • not equal to any of
Example
12311123423,2342342342
Handle Allows you to export specific product by its Handle.

Possible Conditions
  • equals to any of
  • contains any of
  • contains none of
Example
my-product-handle
Title Allows you to export Products whose Title contains specific text.

“Matches pattern” condition allows entering wildcard symbols.
* – asterisk symbol will represent any amount of any characters
? – question mark will represent any one character

Possible Conditions
  • contains any of
  • equals to any of
  • matches pattern
  • contains none of
Example
Part of Title, other title
Title * End of Title
Body HTML Allows to export Products which does or does not contain specific string of text in their description.

Possible Conditions
  • contains
  • does not contain
Example
Part of product description
Vendor Allows you to export Products that have specific Vendors, separated by a comma.

Possible Conditions
  • equals any of
  • not equal to any of
  • contains none of
  • contains any of
Example
Vendor-1, Vendor Other
Type Allows you to filter by many Type values, separated by a comma.

Possible Conditions
  • equals to any of
  • contains any of
Example
Type-1, Type-2
Tags Allows to export Products that have all listed tags, any of listed tags or none of the listed tags. Separated by a comma.

Possible Conditions
  • contains any of
  • contains all of
  • contains none of
  • equals to any of
  • equals to all of
  • not equal to any of
  • starts with any of
  • matches pattern
Example
tag1, tag2, tag3
Created At Allows exporting Products which were created in the Shopify within a specific date range.Relative date condition allows you to export Products that have been created in the last full amount of time.

For example – Last 1 Days, would export Products from last full day, so yesterday.

Possible Conditions
  • on or after
  • on or before
  • date range
  • relative date
Updated At Allows exporting Products which were last updated in the Shopify within a specific date range.Relative date condition allows you to export Products that have been updated in the last full amount of time.

For example – Last 1 Days, would export Products from last full day, so yesterday.

Possible Conditions
  • on or after
  • on or before
  • date range
  • relative date
Status Allows filtering Products export by the Products status in Shopify.

You can select multiple conditions in this filter. Selecting all would be the same as not applying the filter.

Possible Conditions
  • Active
  • Draft
  • Archived
Published At Allows exporting Products which were published in the Shopify within a specific date range.Relative date condition allows you to export Products that have been published in the last full amount of time.

For example – Last 1 Days, would export Products from last full day, so yesterday.

Possible Conditions
  • on or after
  • on or before
  • date range
  • relative date
Published Allows exporting only Products that are Published or Unpublished.

Possible Conditions
  • Yes
  • No
Collection Allows to export Products who are in any of the collections with matching collection IDs, Handles or Titles. Separated by a comma.

Possible Conditions
  • equals to any of
  • not equal to any of
Example
123111222333, my-collection-handle, My Collection Title
Variant ID Allows to export Products that have variant/s with specific variant IDs.

Possible Conditions
  • equals to any of
  • not equal to any of
Example
123111222333, 354287234843, 89721346781
Variant SKU Allows you to export only those Products whose Variants have any or none of the listed SKU or SKU fragments. Separated by a comma.

Possible Conditions
  • equals to any of
  • contains any of
  • contains none of
  • not equal to any of
  • starts with any of
Example
sku1 fragment, sku2
Variant Barcode Allows exporting products with or without specific Barcode.

Possible Conditions
  • equals to any of
  • contains any of
  • not equal to any of
  • starts with any of
Example
12395876123
Variant Taxable Exports only Products where at least one variant is or is not taxable.

Possible Conditions

Yes
No

Variant Weight Allows you to export only those Products whose Variants have this specific weight.

Possible Conditions
  • equals
  • less than
  • less than or equal to
  • greater than
  • greater than or equal to
  • between
Example
29.46
Variant Price Allows you to export only those Products whose Variants have this specific price.

Possible Conditions
  • equals
  • less than
  • less than or equal to
  • greater than
  • greater than or equal to
  • between
Example
5.99
Variant Inventory Qty Allows you to export only those Products whose Variants have this specific quantity.

Possible Conditions
  • less than
  • greater than
  • equals
Example
5
Metafield Filters the Orders export by Product level Metafields.

Specify Metafield by:

  • Namespace
  • Key
  • Value
Possible Conditions for Text value
  • equals to any of
  • not equal to any of
  • contains any of
  • contains all of
  • contains none of
  • matches pattern
  • contains
  • does not contain
  • is empty
  • is not empty
Possible Conditions for Number value
  • equals
  • less than
  • less than or equal to
  • greater than
  • greater than or equal to
  • between
  • is empty
  • is not empty

 

Good To Know

  • To import several images and variants to Product, just repeat the row with the same ID, Handle or Title (whichever comes first).
  • To repeat rows, you can copy the whole row as it is, and you don’t have to delete contents of Product base rows – that makes copying easier.
  • Shopify exported CSV file, pasted to Excel [Products] Sheet, can be imported with the same columns. You just need to change SEO Description and SEO Title columns to Metafield columns, as shown in the table above.
  • To not update some columns, remove those columns from Excel file. Then the Import will not touch them.
  • If you will have the Column with an empty value, then this field will be changed to empty.
  • To update existing Variant columns, remember to keep the “Variant ID” column.
  • You can have an unlimited count of Metafields.
  • Check out Matrixify tutorial on how to import your Products.