Products

Allowed Values

Number

Example

11920047631

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

• 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.
• 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

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

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>

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

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

Allowed Values

Text

Example

T-shirt

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

• 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

Allowed Values

Date & Time

Example

2018-12-17 18:20:07 +0200

Export only

Allowed Values

Date & Time

Example

2018-12-17 18:20:07 +0200

• 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

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

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.

Can be set to a future date to schedule publishing of the Product to the Online Store. To schedule publishing a product that is already published in the Online Store, make sure to also include the Published column with value FALSE.

Allowed Values

Date & Time

Example

2018-12-17 18:20:07 +0200

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

• Publish to the Online Store and PoS sales channels:
  • “Published Scope” value global
  • “Published” value TRUE

• Publish to the Online Store and unpublish from PoS sales channel:
  • “Published Scope” value web
  • “Published” value TRUE

• Publish to the PoS and unpublish from the Online sales channel:
  • “Published Scope” value global
  • “Published” value FALSE

• Unpublish from both the Online Store and PoS sales channels:
  • “Published Scope” value web
  • “Published” value FALSE

Changes to any other channels like Facebook, Wholesale, etc. are not available through this import. 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

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.

The default product theme template in Shopify is “Default product”.
This theme template is exported as empty in the “Template Suffix” column.
To update Product theme template to the default template, import the “Template Suffix” column empty.

Allowed Values

Text

Example

featured

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:

• Variant Taxable: FALSE
• Variant Requires Shipping: FALSE
• Variant Fulfillment Service: 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

Export only

Export only

Export only

Export only

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

aa-1

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

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 – aa-1.
• id with the full path.
  Example – aa-1 | 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

Import only

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

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

Export only

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

Export only

• 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

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

• 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 removed from the Product and deleted from Shopify admin > Content > Files section (Shopify CDN). Other Product 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

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.
To set positions for each image, you should use multiple rows for the same product, each with a different Image Src and Image Position, or use multiple Image Src columns along with multiple corresponding Image Position columns.

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

Export only

Allowed Values

Number

Export only

Allowed Values

Number

Allowed Values

Text

Example

T-shirt small size

Import only

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

A 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

Export only

Allowed Values

Number

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

• 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

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

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

Allowed Values

Text

Example

Size

Allowed Values

Text

Example

XS

Allowed Values

Text

Example

Fabric

Allowed Values

Text

Example

Cotton

Import only

Allowed Values

TRUE
FALSE

Example

TRUE

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

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

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

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

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

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

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

Allowed Values

Decimal Number

Example

389.99

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

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

Allowed Values

Text

Example

DA040000

To enable Shopify to track inventory, set the cell value to shopify.
To disable inventory tracking, leave the cell value empty.

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
<Handle-of-tracking-service>

Example

shopify

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

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

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

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

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

Alternative column headers

• Variant Inventory Cost – for Shopify Transporter CSV
• Cost per item – for Shopify native CSV

Allowed Values

Decimal Number

Example

200.22

Allowed Values

Number

Example

123456

Allowed Values

Country Code

Example

CA

Allowed Values

Province Code

Example

QC

If you need to adjust your available inventory by a certain delta quantity, then don’t include this column in the import, but use the Inventory Available Adjust: … column for the delta number.

Allowed Values

Number or value Stocked

Example

1000

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

Allowed Values

Number

Example

-5

On Hand inventory in Shopify is linked to Available inventory and changing it will also change the Available inventory quantity values.
Setting both On Hand and Available inventory with the same Import could result in the Available quantity being adjusted automatically by Shopify due to setting or changing the On Hand quantity.

If you need to adjust your on-hand inventory by a certain delta quantity, then don’t include this column in the import, but use the Inventory On Hand Adjust: … column for the delta number.

Allowed Values

Number

Example

1000

On Hand inventory in Shopify is linked to Available inventory and changing it will also change the Available inventory quantity values.
Setting both On Hand and Available inventory with the same Import could result in the Available quantity being adjusted automatically by Shopify due to setting or changing the On Hand quantity.

If you need to import a fixed on-hand quantity for each location, then don’t import this column or import it empty. Use the Inventory On Hand: … column for that.

Allowed Values

Number

Example

-5

Export only

Example

58

Export only

Example

25

If you need to adjust your damaged inventory by a certain delta quantity, then don’t include this column in the import, but use the Inventory Damaged Adjust: … column for the delta number.

Allowed Values

Number

Example

1000

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

Allowed Values

Number

Example

-5

If you need to adjust your safety stock inventory by a certain delta quantity, then don’t include this column in the import, but use the Inventory Safety Stock Adjust: … column for the delta number.

Allowed Values

Number

Example

1000

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

Allowed Values

Number

Example

-5

If you need to adjust your quality control inventory by a certain delta quantity, then don’t include this column in the import, but use the Inventory Quality Control Adjust: … column for the delta number.

Allowed Values

Number

Example

1000

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

Allowed Values

Number

Example

-5

Export only

Example

73

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

Example column header – Included / North America.

Alternative column header

• Included Market <Catalog Name> – some systems might not support generating files with / in the column header. For Matrixify Imports you can exchange character / with a word market.
  Example – Included Market North America.

Allowed Values

TRUE
FALSE

Example

TRUE

Importing this field empty for a Catalog, 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 Catalog if it does not have a fixed price set.

Example column header – Price / North America

Alternative column header

• Price Market <Catalog Name> – some systems might not support generating files with / in the column header. For Matrixify Imports you can exchange character / with a word market.
  Example – Price Market North America.

Allowed Values

Number

Example

53

Alternative column header

• Compare At Price Market <Catalog Name> – some systems might not support generating files with / in the column header. For Matrixify Imports you can exchange character / with a word market.
  Example – Compare At Price Market North America.

Allowed Values

Number

Example

84

Alternative column headers

• Metafields Global Title Tag – for Shopify Transporter CSV
• SEO Title – for Shopify native CSV

Alternative column headers

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

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

Example

shopify_US_286247125016_3126953639960, 
shopify_US_286247125016_3126954328088

Example

GO12345OOGLE

Example

Clothing & Accessories > Clothing > Dresses

Allowed values

• newborn
• infant
• toddler
• kids
• adult

Example

adult

Allowed values

• male
• female
• unisex

More info here.

Example

male

Allowed values

• new
• refurbished
• used

Example

used

Example

Red

Example

Leather

Example

XL

Allowed values

• AU
• BR
• CN
• DE
• EU
• FR
• IT
• JP
• MEX
• UK
• US

Example

US

Allowed values

• regular
• petite
• plus
• big and tall
• maternity

Example

regular

Example

176

Example

lb

Example

743

Example

ml

Possible Conditions

• equals to any of
• not equal to any of

Example

12311123423,2342342342

Possible Conditions

• equals to any of
• contains any of
• contains none of

Example

my-product-handle

“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

Possible Conditions

• contains
• does not contain
• is empty
• is not empty

Example

Part of product description

Possible Conditions

• equals any of
• not equal to any of
• contains none of
• contains any of

Example

Vendor-1, Vendor Other

Possible Conditions

• equals to any of
• contains any of
• is empty
• is not empty

Example

Type-1, Type-2

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
• is empty
• is not empty
• matches pattern

Example

tag1, tag2, tag3

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

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

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

Possible Conditions

• Active
• Draft
• Archived

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

Possible Conditions

• Yes
• No

Possible Conditions

• equals to any of
• not equal to any of

Example

123111222333, my-collection-handle, My Collection Title

Possible Conditions

• equals to any of
• not equal to any of

Example

123111222333, 354287234843, 89721346781

Possible Conditions

• equals to any of
• contains any of
• contains none of
• not equal to any of
• starts with any of
• is empty
• is not empty

Example

sku1 fragment, sku2

Possible Conditions

• equals to any of
• contains any of
• contains none of
• not equal to any of
• starts with any of
• is empty
• is not empty

Example

12395876123

Possible Conditions

Yes
No

Possible Conditions

• equals
• less than
• less than or equal to
• greater than
• greater than or equal to
• between

Example

29.46

Possible Conditions

• equals
• less than
• less than or equal to
• greater than
• greater than or equal to
• between

Example

5.99

Possible Conditions

• less than
• greater than
• equals

Example

5

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