Start Free Trial
Start Free Trial
Tutorials

Minimum required columns to update specific Product fields

Update Import Product Variants
Minimum required columns to update specific Product fields
UnknownExcelColumns|Excelify Logo|UnknownExcelColumns

Minimum required columns to update specific fields for Products.

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

We will not use Command column as when this column is not used the app assumes UPDATE command by default.

Product fields

Handle

Tutorial – Bulk update Products Handles.

Columns if:

  1. Updating by ID
    • ID
    • Handle
  2. Force updating by SKU
    • Variant SKU [ID]
    • Handle

Recommended

  • ID
  • Handle

Title

Columns if:

  1. Updating by ID
    • ID
    • Title
  2. Updating by Handle
    • Handle
    • Title
    • Body HTML
  3. Force updating by SKU
    • Variant SKU [ID]
    • Title

Recommended

  • ID
  • Handle
  • Title

Body HTML

Columns if:

  1. Updating by ID
    • ID
    • Body HTML
  2. Updating by Handle
    • Handle
    • Body HTML
  3. Updating by Title
    • Title
    • Body HTML
  4. Updating by SKU
    • Variant SKU
    • Body HTML

Recommended

  • ID
  • Handle
  • Body HTML

Vendor

Columns if:

  1. Updating by ID
    • ID
    • Vendor
  2. Updating by Handle
    • Handle
    • Vendor
  3. Updating by Title
    • Title
    • Vendor
  4. Updating by SKU
    • Variant SKU
    • Vendor

Recommended

  • ID
  • Handle
  • Vendor

Type

Columns if:

  1. Updating by ID
    • ID
    • Type
  2. Updating by Handle
    • Handle
    • Type
  3. Updating by Title
    • Title
    • Type
  4. Updating by SKU
    • Variant SKU
    • Type

Recommended

  • ID
  • Handle
  • Type

Tags

Tutorial – How to update tags on Shopify in bulk.

Columns if:

  1. Updating by ID
    • ID
    • Tags
    • Tags Command
  2. Updating by Handle
    • Handle
    • Tags
    • Tags Command
  3. Updating by Title
    • Title
    • Tags
    • Tags Command
  4. Updating by SKU
    • Variant SKU
    • Tags
    • Tags Command

Recommended

  • ID
  • Handle
  • Tags
  • Tags Command

Published

Tutorial – Publish or Unpublish Products in bulk.

Columns if:

  1. Updating by ID
    • ID
    • Published
  2. Updating by Handle
    • Handle
    • Published
  3. Updating by Title
    • Title
    • Published
  4. Updating by SKU
    • Variant SKU
    • Published

Recommended

  • ID
  • Handle
  • Published

Published At

Tutorial – Publish or Unpublish Products in bulk.

Columns if:

  1. Updating by ID
    • ID
    • Published At
  2. Updating by Handle
    • Handle
    • Published At
  3. Updating by title
    • Title
    • Published At
  4. Updating by SKU
    • Variant SKU
    • Published At

Recommended

  • ID
  • Handle
  • Published At

Published Scope

Tutorial – Publish or Unpublish Products in bulk.

Columns if:

  1. Updating by ID
    • ID
    • Published Scope
  2. Updating by Handle
    • Handle
    • Published Scope
  3. Updating by Title
    • Title
    • Published Scope
  4. Updating by SKU
    • Variant SKU
    • Published Scope

Recommended

  • ID
  • Handle
  • Published Scope

Template Suffix

Columns if:

  1. Updating by ID
    • ID
    • Template Suffix
  2. Updating by Handle
    • Handle
    • Template Suffix
  3. Updating by Title
    • Title
    • Template Suffix
  4. Updating by SKU
    • Variant SKU
    • Template Suffix

Recommended

  • ID
  • Handle
  • Template Suffix

Image Src

Find all Image related tutorials here.

Columns if:

  1. Updating by ID
    • ID
    • Image Src
    • Image Command
  2. Updating by Handle
    • Handle
    • Image Src
    • Image Command
  3. Updating by Title
    • Title
    • Image Src
    • Image Command
  4. Updating by SKU
    • Variant SKU
    • Image Src
    • Image Command

Recommended

  • ID
  • Handle
  • Image Src
  • Image Command

Image Position

Find all Image related tutorials here.

Columns if:

  1. Updating by ID
    • ID
    • Image Src
    • Image Command
    • Image Position
  2. Updating by Handle
    • Handle
    • Image Src
    • Image Command
    • Image Position
  3. Updating by Title
    • Title
    • Image Src
    • Image Command
    • Image Position
  4. Updating by SKU
    • Variant SKU
    • Image Src
    • Image Command
    • Image Position

Recommended

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

Image Alt Text

Find all Image related tutorials here.

Tutorial – Update Image Alt Text.

Columns if:

  1. Updating by ID
    • ID
    • Image Src
    • Image Command
    • Image Alt Text
  2. Updating by Handle
    • Handle
    • Image Src
    • Image Command
    • Image Alt Text
  3. Updating by Title
    • Title
    • Image Src
    • Image Command
    • Image Alt Text
  4. Updating by SKU
    • Variant SKU
    • Image Src
    • Image Command
    • Image Alt Text

Recommended

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

Metafield: …

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

Columns if:

  1. Updating by ID
    • ID
    • Metafield: …
  2. Updating by Handle
    • Handle
    • Metafield: …
  3. Updating by Title
    • Title
    • Metafield: …
  4. Updating by SKU
    • Variant SKU
    • Metafield: …

Recommended

  • ID
  • Handle
  • Metafield: …

Variants

To update variant columns you need to identify Variant and Product

Option Name

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

  • ID
  • Handle
  • Title

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

An example of columns necessary:

  1. Example 1:
    • ID
    • Variant ID
    • Option1 Name
    • Option1 Value
    • Option2 Name
    • Option2 Value
    • Option3 Name
    • Option3 Value
  2. Example 2:
    • Handle
    • Variant Barcode
    • Option1 Name
    • Option1 Value
    • Option2 Name
    • Option2 Value
    • Option3 Name
    • Option3 Value
  3. Example 3 (recommended):
    • ID
    • Handle
    • Variant ID
    • Variant SKU
    • Option1 Name
    • Option1 Value
    • Option2 Name
    • Option2 Value
    • Option3 Name
    • Option3 Value

Exception – you can use only column ‘Variant SKU’ as an identification of a Variant and a Product.

Example:

  • Variant SKU
  • Option1 Name
  • Option1 Value
  • Option2 Name
  • Option2 Value
  • Option3 Name
  • Option3 Value

Option Value

To identify the product you need one of the following columns:

  • ID
  • Handle
  • Title

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

  • Variant ID
  • Variant SKU
  • Variant Barcode

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

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

An example of columns necessary:

  1. Example 1:
    • ID
    • Variant ID
    • Option1 Name
    • Option1 Value
    • Option2 Name
    • Option2 Value
    • Option3 Name
    • Option3 Value
  2. Example 2:
    • Handle
    • Variant SKU
    • Option1 Name
    • Option1 Value
    • Option2 Name
    • Option2 Value
    • Option3 Name
    • Option3 Value
  3. Example 3 (recommended):
    • ID
    • Handle
    • Variant ID
    • Variant SKU
    • Option1 Name
    • Option1 Value
    • Option2 Name
    • Option2 Value
    • Option3 Name
    • Option3 Value

Exception – you can use only column ‘Variant SKU’ as an identification of a Variant and a Product.

Example:

  • Variant SKU
  • Option1 Name
  • Option1 Value
  • Option2 Name
  • Option2 Value
  • Option3 Name
  • Option3 Value

Variant Position

Tutorial – Rearrange Product Variant Positions.

To identify the product you need one of the following columns:

  • ID
  • Handle
  • Title

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

  • Variant ID
  • Variant SKU
  • Variant Barcode

To update Variant Position you need the following column:

  • Variant Position

An example of columns necessary:

  1. Example 1:
    • ID
    • Variant ID
    • Variant Position
  2. Example 2:
    • Handle
    • Variant SKU
    • Variant Position
  3. Example 3 (recommended):
    • ID
    • Handle
    • Variant ID
    • Variant SKU
    • Variant Position

Exception – you can use only column ‘Variant SKU’ as an identification of a Variant and a Product.

Example:

  • Variant SKU
  • Variant Position

Variant SKU

Tutorial – Bulk update Shopify Product SKU.

To identify the product you need one of the following columns:

  • ID
  • Handle
  • Title

To identify the variant you need the following column:

  • Variant ID

To update Variant SKU you need the following column:

  • Variant SKU

An example of columns necessary:

  1. Example 1:
    • ID
    • Variant ID
    • Variant SKU
  2. Example 2:
    • Title
    • Variant ID
    • Variant SKU
  3. Example 3 (recommended):
    • ID
    • Handle
    • Variant ID
    • Variant SKU

Variant Weight

To identify the product you need one of the following columns:

  • ID
  • Handle
  • Title

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

  • Variant ID
  • Variant SKU
  • Variant Barcode

To update Variant Weight you need the following column:

  • Variant Weight

An example of columns necessary:

  1. Example 1:
    • ID
    • Variant ID
    • Variant Weight
  2. Example 2:
    • Handle
    • Variant SKU
    • Variant Weight
  3. Example 3 (recommended):
    • ID
    • Handle
    • Variant ID
    • Variant SKU
    • Variant Weight

Exception – you can use only column ‘Variant SKU’ as an identification of a Variant and a Product.

Example:

  • Variant SKU
  • Variant Weight

Variant Weight Unit

To identify the product you need one of the following columns:

  • ID
  • Handle
  • Title

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

  • Variant ID
  • Variant SKU
  • Variant Barcode

To update Variant Weight Unit you need the following column:

  • Variant Weight Unit

An example of columns necessary:

  1. Example 1:
    • ID
    • Variant ID
    • Variant Weight Unit
  2. Example 2:
    • Handle
    • Variant SKU
    • Variant Weight Unit
  3. Example 3 (recommended):
    • ID
    • Handle
    • Variant ID
    • Variant SKU
    • Variant Weight Unit

Exception – you can use only column ‘Variant SKU’ as an identification of a Variant and a Product.

Example:

  • Variant SKU
  • Variant Weight Unit

Variant Price

Tutorial – Bulk update Shopify Product prices.

To identify the product you need one of the following columns:

  • ID
  • Handle
  • Title

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

  • Variant ID
  • Variant SKU
  • Variant Barcode

To update Variant Price you need the following column:

  • Variant Price

An example of columns necessary:

  1. Example 1:
    • ID
    • Variant ID
    • Variant Price
  2. Example 2:
    • Handle
    • Variant SKU
    • Variant Price
  3. Example 3 (recommended):
    • ID
    • Handle
    • Variant ID
    • Variant SKU
    • Variant Price

Exception – you can use only column ‘Variant SKU’ as an identification of a Variant and a Product.

Example:

  • Variant SKU
  • Variant Price

Variant Compare At Price

Tutorial – Bulk update Shopify Product prices.

To identify the product you need one of the following columns:

  • ID
  • Handle
  • Title

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

  • Variant ID
  • Variant SKU
  • Variant Barcode

To update Variant Compare At Price you need the following column:

  • Variant Compare At Price

An example of columns necessary:

  1. Example 1:
    • ID
    • Variant ID
    • Variant Compare At Price
  2. Example 2:
    • Handle
    • Variant SKU
    • Variant Compare At Price
  3. Example 3 (recommended):
    • ID
    • Handle
    • Variant ID
    • Variant SKU
    • Variant Compare At Price

Exception – you can use only column ‘Variant SKU’ as an identification of a Variant and a Product.

Example:

  • Variant SKU
  • Variant Compare At Price

Variant Cost

Tutorial – Bulk update Shopify Product prices.

To identify the product you need one of the following columns:

  • ID
  • Handle
  • Title

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

  • Variant ID
  • Variant SKU
  • Variant Barcode

To update Variant Cost you need the following column:

  • Variant Cost

An example of columns necessary:

  1. Example 1:
    • ID
    • Variant ID
    • Variant Cost
  2. Example 2:
    • Handle
    • Variant SKU
    • Variant Cost
  3. Example 3 (recommended):
    • ID
    • Handle
    • Variant ID
    • Variant SKU
    • Variant Cost

Exception – you can use only column ‘Variant SKU’ as an identification of a Variant and a Product.

Example:

  • Variant SKU
  • Variant Cost

Variant Requires Shipping

To identify the product you need one of the following columns:

  • ID
  • Handle
  • Title

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

  • Variant ID
  • Variant SKU
  • Variant Barcode

To update Variant Requires Shipping you need the following column:

  • Variant Requires Shipping

An example of columns necessary:

  1. Example 1:
    • ID
    • Variant ID
    • Variant Requires Shipping
  2. Example 2:
    • Handle
    • Variant SKU
    • Variant Requires Shipping
  3. Example 3 (recommended):
    • ID
    • Handle
    • Variant ID
    • Variant SKU
    • Variant Requires Shipping

Exception – you can use only column ‘Variant SKU’ as an identification of a Variant and a Product.

Example:

  • Variant SKU
  • Variant Requires Shipping

Variant Taxable

To identify the product you need one of the following columns:

  • ID
  • Handle
  • Title

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

  • Variant ID
  • Variant SKU
  • Variant Barcode

To update Variant Taxable you need the following column:

  • Variant Taxable

An example of columns necessary:

  1. Example 1:
    • ID
    • Variant ID
    • Variant Taxable
  2. Example 2:
    • Handle
    • Variant SKU
    • Variant Taxable
  3. Example 3 (recommended):
    • ID
    • Handle
    • Variant ID
    • Variant SKU
    • Variant Taxable

Exception – you can use only column ‘Variant SKU’ as an identification of a Variant and a Product.

Example:

  • Variant SKU
  • Variant Taxable

Variant Tax Code

To identify the product you need one of the following columns:

  • ID
  • Handle
  • Title

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

  • Variant ID
  • Variant SKU
  • Variant Barcode

To update Variant Tax Code you need the following column:

  • Variant Tax Code

An example of columns necessary:

  1. Example 1:
    • ID
    • Variant ID
    • Variant Tax Code
  2. Example 2:
    • Handle
    • Variant SKU
    • Variant Tax Code
  3. Example 3 (recommended):
    • ID
    • Handle
    • Variant ID
    • Variant SKU
    • Variant Tax Code

Exception – you can use only column ‘Variant SKU’ as an identification of a Variant and a Product.

Example:

  • Variant SKU
  • Variant Tax Code

Variant Barcode

To identify the product you need one of the following columns:

  • ID
  • Handle
  • Title

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

  • Variant ID
  • Variant SKU

To update Variant Barcode you need the following column:

  • Variant Barcode

An example of columns necessary:

  1. Example 1:
    • ID
    • Variant ID
    • Variant Barcode
  2. Example 2:
    • Handle
    • Variant SKU
    • Variant Barcode
  3. Example 3 (recommended):
    • ID
    • Handle
    • Variant ID
    • Variant SKU
    • Variant Barcode

Exception – you can use only column ‘Variant SKU’ as an identification of a Variant and a Product.

Example:

  • Variant SKU
  • Variant Barcode

Variant Image

To identify the product you need one of the following columns:

  • ID
  • Handle
  • Title

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

  • Variant ID
  • Variant SKU
  • Variant Barcode

To update Variant Image you need the following column:

  • Variant Image

An example of columns necessary:

  1. Example 1:
    • ID
    • Variant ID
    • Variant Image
  2. Example 2:
    • Handle
    • Variant SKU
    • Variant Image
  3. Example 3 (recommended):
    • ID
    • Handle
    • Variant ID
    • Variant SKU
    • Variant Image

Exception – you can use only column ‘Variant SKU’ as an identification of a Variant and a Product.

Example:

  • Variant SKU
  • Variant Image

Variant Inventory Tracker

To identify the product you need one of the following columns:

  • ID
  • Handle
  • Title

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

  • Variant ID
  • Variant SKU
  • Variant Barcode

To update Variant Inventory Tracker you need all of the following columns:

  • Variant Inventory Tracker
  • Variant Inventory Qty

An example of columns necessary:

  1. Example 1:
    • ID
    • Variant ID
    • Variant Inventory Tracker
    • Variant Inventory Qty
  2. Example 2:
    • Handle
    • Variant SKU
    • Variant Inventory Tracker
    • Variant Inventory Qty
  3. Example 3 (recommended):
    • ID
    • Handle
    • Variant ID
    • Variant SKU
    • Variant Inventory Tracker
    • Variant Inventory Qty

Exception – you can use only column ‘Variant SKU’ as an identification of a Variant and a Product.

Example:

  • Variant SKU
  • Variant Inventory Tracker
  • Variant Inventory Qty

Variant Inventory Policy

To identify the product you need one of the following columns:

  • ID
  • Handle
  • Title

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

  • Variant ID
  • Variant SKU
  • Variant Barcode

To update Variant Inventory Policy you need the following column:

  • Variant Inventory Policy

An example of columns necessary:

  1. Example 1:
    • ID
    • Variant ID
    • Variant Inventory Policy
  2. Example 2:
    • Handle
    • Variant SKU
    • Variant Inventory Policy
  3. Example 3 (recommended):
    • ID
    • Handle
    • Variant ID
    • Variant SKU
    • Variant Inventory Policy

Exception – you can use only column ‘Variant SKU’ as an identification of a Variant and a Product.

Example:

  • Variant SKU
  • Variant Inventory Policy

Variant Fulfillment Service

To identify the product you need one of the following columns:

  • ID
  • Handle
  • Title

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

  • Variant ID
  • Variant SKU
  • Variant Barcode

To update Variant Fulfillment Service you need the following column:

  • Variant Fulfillment Service

An example of columns necessary:

  1. Example 1:
    • ID
    • Variant ID
    • Variant Fulfillment Service
  2. Example 2:
    • Handle
    • Variant SKU
    • Variant Fulfillment Service
  3. Example 3 (recommended):
    • ID
    • Handle
    • Variant ID
    • Variant SKU
    • Variant Fulfillment Service

Exception – you can use only column ‘Variant SKU’ as an identification of a Variant and a Product.

Example:

  • Variant SKU
  • Variant Fulfillment Service

Variant Inventory Qty

To identify the product you need one of the following columns:

  • ID
  • Handle
  • Title

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

  • Variant ID
  • Variant SKU
  • Variant Barcode

To update Variant Inventory Qty you need the following column:

  • Variant Inventory Qty

An example of columns necessary:

  1. Example 1:
    • ID
    • Variant ID
    • Variant Inventory Qty
  2. Example 2:
    • Handle
    • Variant SKU
    • Variant Inventory Qty
  3. Example 3 (recommended):
    • ID
    • Handle
    • Variant ID
    • Variant SKU
    • Variant Inventory Qty

Exception – you can use only column ‘Variant SKU’ as an identification of a Variant and a Product.

Example:

  • Variant SKU
  • Variant Inventory Qty

Variant Inventory Adjust

Tutorial – How to adjust inventory quantity for Shopify Products.

To identify the product you need one of the following columns:

  • ID
  • Handle
  • Title

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

  • Variant ID
  • Variant SKU
  • Variant Barcode

To update Variant Inventory Adjust you need the following column:

  • Variant Inventory Adjust

An example of columns necessary:

  1. Example 1:
    • ID
    • Variant ID
    • Variant Inventory Adjust
  2. Example 2:
    • Handle
    • Variant SKU
    • Variant Inventory Adjust
  3. Example 3 (recommended):
    • ID
    • Handle
    • Variant ID
    • Variant SKU
    • Variant Inventory Adjust

Exception – you can use only column ‘Variant SKU’ as an identification of a Variant and a Product.

Example:

  • Variant SKU
  • Variant Inventory Adjust

Inventory Available: …

Tutorial – Update Shopify Multi-Location inventory in bulk.

To identify the product you need one of the following columns:

  • ID
  • Handle
  • Title

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

  • Variant ID
  • Variant SKU
  • Variant Barcode

To update Inventory Available you need the following column/s:

  • Inventory Available: …

An example of columns necessary:

  1. Example 1:
    • ID
    • Variant ID
    • Inventory Available: …
  2. Example 2:
    • Handle
    • Variant SKU
    • Inventory Available: …
  3. Example 3 (recommended):
    • ID
    • Handle
    • Variant ID
    • Variant SKU
    • Inventory Available: …

Exception – you can use only column ‘Inventory Available: …’ as an identification of a Variant and a Product.

Example:

  • Variant SKU
  • Inventory Available: …

Inventory Available Adjust: …

Tutorial – Update Shopify Multi-Location inventory in bulk.

To identify the product you need one of the following columns:

  • ID
  • Handle
  • Title

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

  • Variant ID
  • Variant SKU
  • Variant Barcode

To update Inventory Available Adjust you need the following column/s:

  • Inventory Available Adjust: …

An example of columns necessary:

  1. Example 1:
    • ID
    • Variant ID
    • Inventory Available Adjust: …
  2. Example 2:
    • Handle
    • Variant SKU
    • Inventory Available Adjust: …
  3. Example 3 (recommended):
    • ID
    • Handle
    • Variant ID
    • Variant SKU
    • Inventory Available Adjust: …

Exception – you can use only column ‘Variant SKU’ as an identification of a Variant and a Product.

Example:

  • Variant SKU
  • Inventory Available Adjust: …

Variant Metafield: …

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

To identify the product you need one of the following columns:

  • ID
  • Handle
  • Title

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

  • Variant ID
  • Variant SKU
  • Variant Barcode

To update Variant Metafield you need the following column/s:

  • Variant Metafield: …

An example of columns necessary:

  1. Example 1:
    • ID
    • Variant ID
    • Variant Metafield: …
  2. Example 2:
    • Handle
    • Variant SKU
    • Variant Metafield: …
  3. Example 3 (recommended):
    • ID
    • Handle
    • Variant ID
    • Variant SKU
    • Variant Metafield: …

Exception – you can use only column ‘Variant SKU’ as an identification of a Variant and a Product.

Example:

  • Variant SKU
  • Variant Metafield: …

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

Similar tutorials

How existing Shopify Products are identified when imported

Product Variants Update Import

Add Variants To Existing Product

Product Variants Update Import

Bulk update Shopify product prices

Product Variants Update Import
More tutorials

Start managing your Shopify data today!

Get Matrixify now
Excelify Facebook channel Excelify Twitter channel Excelify Youtube channel
Newsletter
Thank you for subscribing!
© 2023 Matrixify.app
Made in Latvia Latvia