Minimum required columns to update specific Product fields

This guide is designed to help you understand the minimum required columns you need to update specific fields for your products using the Matrixify app.
Whether you’re looking to update your product’s handle, title, body HTML, vendor, type, or any other field, we’ve got you covered.

The following list of fields contains every field that can be updated for products. Find a column you wish to update and under it, you will see a minimum required columns you need to update it.

We will not use the Command column as when this column is not used the app assumes the MERGE command by default which will update products.

Basic Columns

Handle

Tutorial – Bulk update Products Handles.
Documentation – Handle.

Minimum required columns

Updating by ID

• ID
• Handle

Force updating by Variant

• Variant ID [ID] or Variant SKU [ID] or Variant Barcode [ID]
• Handle

Recommended columns

• ID
• Handle

Title

Documentation – Title.

Minimum required columns

Update searching by product

• ID or Handle
• Title

Force updating by Variant

• Variant ID [ID] or Variant SKU [ID] or Variant Barcode [ID]
• Title

Recommended columns

• ID
• Handle
• Title

Body HTML

Documentation – Body HTML.

Minimum required columns

Update searching by product

• ID or Handle or Title
• Body HTML

Update searching by variant

• Variant ID or Variant SKU or Variant Barcode
• Body HTML

Recommended columns

• ID
• Handle
• Body HTML

Vendor

Documentation – Vendor.

Minimum required columns

Update searching by product

• ID or Handle or Title
• Vendor

Update searching by variant

• Variant ID or Variant SKU or Variant Barcode
• Vendor

Recommended columns

• ID
• Handle
• Vendor

Type

Documentation – Type.

Minimum required columns

Update searching by product

• ID or Handle or Title
• Type

Update searching by variant

• Variant ID or Variant SKU or Variant Barcode
• Type

Recommended columns

• ID
• Handle
• Type

Tags

Tutorial – How to update tags on Shopify in bulk.
Documentation – Tags.

Minimum required columns

Update searching by product

• ID or Handle or Title
• Tags
• Tags Command

Update searching by variant

• Variant ID or Variant SKU or Variant Barcode
• Tags
• Tags Command

Recommended columns

• ID
• Handle
• Tags
• Tags Command

Status

Documentation – Status.

Minimum required columns

Update searching by product

• ID or Handle or Title
• Status

Update searching by variant

• Variant ID or Variant SKU or Variant Barcode
• Status

Recommended columns

• ID
• Handle
• Status

Published

Tutorial – Publish or Unpublish Products in bulk.
Documentation – Published.

Minimum required columns

Update searching by product

• ID or Handle or Title
• Published

Update searching by variant

• Variant ID or Variant SKU or Variant Barcode
• Published

Recommended columns

• ID
• Handle
• Published

Published At

Tutorial – Publish or Unpublish Products in bulk.
Documentation – Published At.

Minimum required columns

Update searching by product

• ID or Handle or Title
• Published At

Update searching by variant

• Variant ID or Variant SKU or Variant Barcode
• Published At

Recommended columns

• ID
• Handle
• Published At

Published Scope

Tutorial – Publish or Unpublish Products in bulk.
Documentation – Published Scope.

Minimum required columns

Update searching by product

• ID or Handle or Title
• Published Scope

Update searching by variant

• Variant ID or Variant SKU or Variant Barcode
• Published Scope

Recommended columns

• ID
• Handle
• Published Scope

Template Suffix

Documentation – Template Suffix.

Minimum required columns

Update searching by product

• ID or Handle or Title
• Template Suffix

Update searching by variant

• Variant ID or Variant SKU or Variant Barcode
• Template Suffix

Recommended columns

• ID
• Handle
• Template Suffix

Category

Category: ID

Documentation – Category: ID.

Minimum required columns

Update searching by product

• ID or Handle or Title
• Category: ID

Update searching by variant

• Variant ID or Variant SKU or Variant Barcode
• Category: ID

Recommended columns

• ID
• Handle
• Category: ID

Category: Name

Documentation – Category: Name.

Minimum required columns

Update searching by product

• ID or Handle or Title
• Category: Name

Update searching by variant

• Variant ID or Variant SKU or Variant Barcode
• Category: Name

Recommended columns

• ID
• Handle
• Category: Name

Category

Documentation – Category.

Minimum required columns

Update searching by product

• ID or Handle or Title
• Category

Update searching by variant

• Variant ID or Variant SKU or Variant Barcode
• Category

Recommended columns

• ID
• Handle
• Category

Collections

Collection

Documentation – Collection.

Minimum required columns

Update searching by product

• ID or Handle or Title
• Collection

Update searching by variant

• Variant ID or Variant SKU or Variant Barcode
• Collection

Recommended columns

• ID
• Handle
• Collection

Custom Collections

Documentation – Custom Collections.

Minimum required columns

Update searching by product

• ID or Handle or Title
• Custom Collections

Update searching by variant

• Variant ID or Variant SKU or Variant Barcode
• Custom Collections

Recommended columns

• ID
• Handle
• Custom Collections

Media

Image Src

Tutorial – find all image-related tutorials here.
Documentation – Image Src.

Minimum required columns

Update searching by product

• ID or Handle or Title
• Image Src
• Image Command

Update searching by variant

• Variant ID or Variant SKU or Variant Barcode
• Image Src
• Image Command

Recommended columns

• ID
• Handle
• Image Src
• Image Command

Image Position

Tutorial – find all image-related tutorials here.
Documentation – Image Position.

Minimum required columns

Update searching by product

• ID or Handle or Title
• Image Src
• Image Command
• Image Position

Update searching by variant

• Variant ID or Variant SKU or Variant Barcode
• Image Src
• Image Command
• Image Position

Recommended columns

• ID
• Handle
• Image Src
• Image Command
• Image Position

Image Alt Text

Tutorial – Update Image Alt Text.
Documentation – Image Alt Text.

Minimum required columns

Update searching by product

• ID or Handle or Title
• Image Src
• Image Command
• Image Alt Text

Update searching by variant

• Variant ID or Variant SKU or Variant Barcode
• Image Src
• Image Command
• Image Alt Text

Recommended columns

• ID
• Handle
• Image Src
• Image Command
• Image Alt Text

Image Attachment

Find all image-related tutorials here.
Documentation – Image Attachment.

Minimum required columns

Update searching by product

• ID or Handle or Title
• Image Attachment
• Image Command

Update searching by variant

• Variant ID or Variant SKU or Variant Barcode
• Image Attachment
• Image Command

Recommended columns

• ID
• Handle
• Image Attachment
• Image Command

Inventory / Variants

Option Name and Option Value

Documentation – Option columns.

Minimum required columns

To identify the variant you need at least one of the following columns:

• Variant ID
• Variant SKU
• Variant Barcode

To update Option Name you need all of the following columns:

• Option1 Name
• Option1 Value
• Option2 Name
• Option2 Value
• Option3 Name
• Option3 Value

Columns necessary:

• Variant ID or Variant SKU or Variant Barcode
• Option1 Name
• Option1 Value
• Option2 Name
• Option2 Value
• Option3 Name
• Option3 Value

Recommended columns

For faster import, you can also search by the product not variant columns such as ID or Handle or Title.
In this case, you will also need to include Variant ID or Variant SKU or Variant Barcode to find the variant within the product.

• ID
• Variant ID
• Option1 Name
• Option1 Value
• Option2 Name
• Option2 Value
• Option3 Name
• Option3 Value

Variant Position

Tutorial – Rearrange Product Variant Positions.
Documentation – Variant Position.

Minimum required columns

• Variant ID or Variant SKU or Variant Barcode
• Variant Position

Recommended columns

For faster import, you can also search by the product not variant columns such as ID or Handle or Title.
In this case, you will also need to include Variant ID or Variant SKU or Variant Barcode to find the variant within the product.

• ID
• Variant ID
• Variant Position

Variant SKU

Tutorial – Bulk update Shopify Product SKU.
Documentation – Variant SKU.

Minimum required columns

• Variant ID
• Variant SKU

Recommended columns

For faster import, you can also search by the product not variant columns such as ID or Handle or Title.
In this case, you will also need to include Variant ID to find the variant within the product.

• ID
• Variant ID
• Variant SKU

Variant Barcode

Documentation – Variant Barcode.

Minimum required columns

• Variant ID or Variant SKU
• Variant Barcode

Recommended columns

For faster import, you can also search by the product not variant columns such as ID or Handle or Title.
In this case, you will also need to include Variant ID or Variant SKU to find the variant within the product.

• ID
• Variant ID
• Variant Barcode

Variant Image

Documentation – Variant Image.

Minimum required columns

• Variant ID or Variant SKU or Variant Barcode
• Variant Image

Recommended columns

For faster import, you can also search by the product not variant columns such as ID or Handle or Title.
In this case, you will also need to include Variant ID or Variant SKU or Variant Barcode to find the variant within the product.

• ID
• Variant ID
• Variant Image

Variant Grams

Documentation – Variant Grams.

Minimum required columns

• Variant ID or Variant SKU or Variant Barcode
• Variant Grams

Recommended columns

For faster import, you can also search by the product not variant columns such as ID or Handle or Title.
In this case, you will also need to include Variant ID or Variant SKU or Variant Barcode to find the variant within the product.

• ID
• Variant ID
• Variant Grams

Variant Weight

Documentation – Variant Weight.

Minimum required columns

• Variant ID or Variant SKU or Variant Barcode
• Variant Weight

Recommended columns

For faster import, you can also search by the product not variant columns such as ID or Handle or Title.
In this case, you will also need to include Variant ID or Variant SKU or Variant Barcode to find the variant within the product.

• ID
• Variant ID
• Variant Weight

Variant Weight Unit

Documentation – Variant Weight Unit.

Minimum required columns

• Variant ID or Variant SKU or Variant Barcode
• Variant Weight Unit

Recommended columns

For faster import, you can also search by the product not variant columns such as ID or Handle or Title.
In this case, you will also need to include Variant ID or Variant SKU or Variant Barcode to find the variant within the product.

• ID
• Variant ID
• Variant Weight Unit

Variant Price

Tutorial – Bulk update Shopify Product prices.
Documentation – Variant Price.

Minimum required columns

• Variant ID or Variant SKU or Variant Barcode
• Variant Price

Recommended columns

For faster import, you can also search by the product not variant columns such as ID or Handle or Title.
In this case, you will also need to include Variant ID or Variant SKU or Variant Barcode to find the variant within the product.

• ID
• Variant ID
• Variant Price

Variant Compare At Price

Tutorial – Bulk update Shopify Product prices.
Documentation – Variant Compare at Price.

Minimum required columns

• Variant ID or Variant SKU or Variant Barcode
• Variant Compare at Price

Recommended columns

For faster import, you can also search by the product not variant columns such as ID or Handle or Title.
In this case, you will also need to include Variant ID or Variant SKU or Variant Barcode to find the variant within the product.

• ID
• Variant ID
• Variant Compare at Price

Variant Taxable

Documentation – Variant Taxable.

Minimum required columns

• Variant ID or Variant SKU or Variant Barcode
• Variant Taxable

Recommended columns

For faster import, you can also search by the product not variant columns such as ID or Handle or Title.
In this case, you will also need to include Variant ID or Variant SKU or Variant Barcode to find the variant within the product.

• ID
• Variant ID
• Variant Taxable

Variant Tax Code

Documentation – Variant Tax Code.

Minimum required columns

• Variant ID or Variant SKU or Variant Barcode
• Variant Tax Code

Recommended columns

For faster import, you can also search by the product not variant columns such as ID or Handle or Title.
In this case, you will also need to include Variant ID or Variant SKU or Variant Barcode to find the variant within the product.

• ID
• Variant ID
• Variant Tax Code

Variant Inventory Tracker

Documentation – Variant Inventory Tracker.

Minimum required columns

• Variant ID or Variant SKU or Variant Barcode
• Variant Inventory Tracker

Recommended columns

For faster import, you can also search by the product not variant columns such as ID or Handle or Title.
In this case, you will also need to include Variant ID or Variant SKU or Variant Barcode to find the variant within the product.

• ID
• Variant ID
• Variant Inventory Tracker

Variant Inventory Policy

Documentation – Variant Inventory Policy.

Minimum required columns

• Variant ID or Variant SKU or Variant Barcode
• Variant Inventory Policy

Recommended columns

For faster import, you can also search by the product not variant columns such as ID or Handle or Title.
In this case, you will also need to include Variant ID or Variant SKU or Variant Barcode to find the variant within the product.

• ID
• Variant ID
• Variant Inventory Policy

Variant Fulfillment Service

Documentation – Variant Fulfillment Service.

Minimum required columns

• Variant ID or Variant SKU or Variant Barcode
• Variant Fulfillment Service

Recommended columns

For faster import, you can also search by the product not variant columns such as ID or Handle or Title.
In this case, you will also need to include Variant ID or Variant SKU or Variant Barcode to find the variant within the product.

• ID
• Variant ID
• Variant Fulfillment Service

Variant Requires Shipping

Documentation – Variant Requires Shipping.

Minimum required columns

• Variant ID or Variant SKU or Variant Barcode
• Variant Requires Shipping

Recommended columns

For faster import, you can also search by the product not variant columns such as ID or Handle or Title.
In this case, you will also need to include Variant ID or Variant SKU or Variant Barcode to find the variant within the product.

• ID
• Variant ID
• Variant Requires Shipping

Variant Inventory Qty

Documentation – Variant Inventory Qty.

Minimum required columns

• Variant ID or Variant SKU or Variant Barcode
• Variant Inventory Qty

Recommended columns

For faster import, you can also search by the product not variant columns such as ID or Handle or Title.
In this case, you will also need to include Variant ID or Variant SKU or Variant Barcode to find the variant within the product.

• ID
• Variant ID
• Variant Inventory Qty

Variant Inventory Adjust

Tutorial – How to adjust inventory quantity for Shopify Products.
Documentation – Variant Inventory Adjust.

Minimum required columns

• Variant ID or Variant SKU or Variant Barcode
• Variant Inventory Adjust

Recommended columns

For faster import, you can also search by the product not variant columns such as ID or Handle or Title.
In this case, you will also need to include Variant ID or Variant SKU or Variant Barcode to find the variant within the product.

• ID
• Variant ID
• Variant Inventory Adjust

Variant Cost

Variant Cost

Documentation – Variant Cost.

Minimum required columns

• Variant ID or Variant SKU or Variant Barcode
• Variant Cost

Recommended columns

For faster import, you can also search by the product not variant columns such as ID or Handle or Title.
In this case, you will also need to include Variant ID or Variant SKU or Variant Barcode to find the variant within the product.

• ID
• Variant ID
• Variant Cost

Customs Information

Variant HS Code

Documentation – Variant HS Code.

Minimum required columns

• Variant ID or Variant SKU or Variant Barcode
• Variant HS Code

Recommended columns

For faster import, you can also search by the product not variant columns such as ID or Handle or Title.
In this case, you will also need to include Variant ID or Variant SKU or Variant Barcode to find the variant within the product.

• ID
• Variant ID
• Variant HS Code

Variant Country of Origin

Documentation – Variant Country of Origin.

Minimum required columns

• Variant ID or Variant SKU or Variant Barcode
• Variant Country of Origin

Recommended columns

For faster import, you can also search by the product not variant columns such as ID or Handle or Title.
In this case, you will also need to include Variant ID or Variant SKU or Variant Barcode to find the variant within the product.

• ID
• Variant ID
• Variant Country of Origin

Variant Province of Origin

Documentation – Variant Province of Origin.

Minimum required columns

• Variant ID or Variant SKU or Variant Barcode
• Variant Province of Origin

Recommended columns

For faster import, you can also search by the product not variant columns such as ID or Handle or Title.
In this case, you will also need to include Variant ID or Variant SKU or Variant Barcode to find the variant within the product.

• ID
• Variant ID
• Variant Province of Origin

Multi-Location Inventory Levels

Inventory Available: …

Tutorial – Update Shopify Multi-Location inventory in bulk.
Documentation – Inventory Available.

Minimum required columns

• Variant ID or Variant SKU or Variant Barcode
• Inventory Available: Location Name

Recommended columns

For faster import, you can also search by the product not variant columns such as ID or Handle or Title.
In this case, you will also need to include Variant ID or Variant SKU or Variant Barcode to find the variant within the product.

• ID
• Variant ID
• Inventory Available: Location Name

Inventory Available Adjust: …

Tutorial – Update Shopify Multi-Location inventory in bulk.
Documentation – Inventory Available Adjust.

Minimum required columns

• Variant ID or Variant SKU or Variant Barcode
• Inventory Available Adjust: Location Name

Recommended columns

For faster import, you can also search by the product not variant columns such as ID or Handle or Title.
In this case, you will also need to include Variant ID or Variant SKU or Variant Barcode to find the variant within the product.

• ID
• Variant ID
• Inventory Available Adjust: Location Name

Metafields

Metafield: …

Tutorial – Import, Export and Update Shopify Shop Metafields in bulk.
Documentation – Metafield.

Minimum required columns

Update searching by product

• ID or Handle or Title
• Metafield: namespace.key [type]

Update searching by variant

• Variant ID or Variant SKU or Variant Barcode
• Metafield: namespace.key [type]

Recommended columns

• ID
• Handle
• Metafield: namespace.key [type]

Variant Metafields

Variant Metafield: …

Tutorial – Import, Export and Update Shopify Shop Metafields in bulk.
Documentation – Variant Metafield.

Minimum required columns

• Variant ID, Variant SKU or Variant Barcode
• Variant Metafield: namespace.key [type]

Recommended columns

For faster import, you can also search by the product not variant columns such as ID or Handle or Title.
In this case, you will also need to include Variant ID or Variant SKU or Variant Barcode to find the variant within the product.

• ID
• Variant ID
• Variant Metafield: namespace.key [type]

Good to know!

• For information what values goes into fields you require please see documentation about product sheet columns.
• ‘Recommended’ sections use Product and/or Variant IDs, because importing by IDs reduces import time. These sections also add text based identification for Products and/or Variants if possible, for easier debugging if an issue arises.
• If you are unsure about what option would be the best for you, or need an assistance, please, contact support.
• You can update multiple fields with the same import by merging minimum required columns. Example – columns to update Tags and Variant Price
  • ID (or other Product identification column)
  • Tags
  • Variant SKU (or other Variant identification column)
  • Variant Price