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?

Download Products Demo file

See Tutorials about Products

Columns Available For Export And Import

Basic Columns

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. • 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. • Unlisted – The product is active, but you need a direct link to view it. The product doesn’t show up in search, collections, or product recommendations. 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 Unlisted Example

Draft | | Published | Tells, whether this Product should be Published in Online Store sales channel. 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. 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 | | Published Scope | Tells Shopify, where to publish this Product. 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 | | 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. 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 | | 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: • 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

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