Products

Allowed Values

Number

Example

11920047631

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

• NEW: will try to create a new Product with the provided details. If such Product will already exist (with the same ID or same Handle), 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: at first, if such Product with provided ID or Handle 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, which is found by ID or Handle. 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.

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, if Title is used as main identification for Product (there is no ID or Handle) then, as Title is not guaranteed to be unique in Shopify, the app will generate Handle from Title and search for that Handle in your store.
If your store has custom Handles then the app will not be able to find existing Product and by default will attempt to create a new Product. So if your store does not have default Product Handles then use ID or Handle in your file to identify existing Product.

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

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.

Allowed Values

Text

Example

Nike

To import/export Shopify Product Standard Type, use Standard Type 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).

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.

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

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

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

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

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 force these variant fields to required params to create 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

Allowed Values

URL

Export only

Allowed Values

Number

Export only

Allowed Values

TRUE
FALSE

See each standard types ID in the Shopify Product Taxonomy page.

Alternative column headers

• Type: Standard ID – legacy Matrixify template column

Allowed Values

Number

Example

127

Alternative column headers

• Type: Standard Name – legacy Matrixify template column

Allowed Values

Text

Example

Clothing

When importing, in this column you can specify the standard types full path, only last category name, only id, or id with the full path as from the Shopify Product Taxonomy page.
For example, 127 - Apparel & Accessories > Clothing.

Alternative column headers

• Product Category – Shopify Transporter CSV and Shopify native CSV
• Standard Product Type – legacy Shopify native CSV column
• Type: Standard – legacy Matrixify template column

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

Allowed Values

Number

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 Excel file.

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.

To add several Variants to a Product, you need to add an additional row. Import will know that the Variant belongs to the same Product, if that added Excel 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.

Your Product can have no Variants, in this case it will have one Variant, which will hold information like inventory quantity and price for this Product.

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

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

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

Allowed Values

Number

Example

1.2345

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

If you will set the value to shopify, then Shopify will track and update your inventory quantities for each Variant.

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.

Allowed Values

shopify
<empty>
<Handle-of-tracking-service>

Example

shopify

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 you will leave this value empty, and Shopify will be set to track your inventory, then Shopify will consider this to be deny policy by default.

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.

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 – Shopify Transporter CSV
• Cost per item – 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

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

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

Import only

Allowed Values

A Base64 encoded image.

Example

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

Once images are imported, those don’t need to be hosted anymore with this link, because Shopify will download this image and store on their own servers.

To import several images 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 image links in the same Image Src cell, separated by ; (semicolon)
3. have multiple Image Src columns
4. any combination of both above options.

If you need to add an additional image, you don’t need to mention other images – just mention those images, which you need to import, and use MERGE as “Image Command”.

If the Image Src column will be empty, or will not exist, the images will stay unchanged. Unless Image Command REPLACE is used, as then the images will be replaced with nothing, and all existing images will get deleted.

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

Image links listed in this column need to be direct and public image links.
You can always test your links by trying to add images 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 image links also will work as app will correctly convert them to direct image links when sending them to the Shopify API.

Allowed Values

URL

Example

https://images.com/image.jpg;
https://images.com/another-image.jpg

• MERGE – will keep all existing images for your product, update data of specified images from this import, and add any new images.
• DELETE – if put next to the image, then this particular image will be deleted, while all other images will be kept.
• REPLACE – will delete all other images, and keep only those, which are included in this import.

Images are 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 don’t exist, then the MERGE command will be assumed.

Allowed Values

MERGE
DELETE
REPLACE

Example

MERGE

You can reorder images inside one product by doing Export, changing those Position values, and importing back as an image column update.

To change the positions of images, you also need to have the Image Src column in the same import, so that it knows, which image you are talking about.

When importing several images with the semicolon, the image numbers will be auto-incremented starting from this given number.

Allowed Values

Number

Example

5

Export only

Allowed Values

Number

Export only

Allowed Values

Number

Allowed Values

Text

Example

T-shirt small size

Alternative column headers

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

Alternative column headers

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

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

Example

shopify_US_286247125016_3126953639960, 
shopify_US_286247125016_3126954328088

Example

GO12345OOGLE

More info here.

Example

Clothing & Accessories > Clothing > Dresses

More info here.

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

More info here.

Example

Red

More info here.

Example

Leather

More info here.

Example

XL

Allowed values

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

Example

US

More info here.

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

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

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
• 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
• contains any of
• not equal to any of
• starts with any of

Example

sku1 fragment, sku2

Possible Conditions

• equals to any of
• not equal to any of

Example

12395876123

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