Minimum required columns to update specific Product fields

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

Can be updated only by product ID.

Columns:

  • ID
  • Title

Columns if:

  1. Updating by ID
    • ID
    • Title
  2. Updating by Handle
    • Handle
    • Title
  3. Recommended
    • ID
    • Handle
    • Title

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
  5. Recommended
    • ID
    • Handle
    • Body HTML

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
  5. Recommended
    • ID
    • Handle
    • Vendor

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
  5. Recommended
    • ID
    • Handle
    • Type

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
  5. Recommended
    • ID
    • Handle
    • Tags
    • Tags Command

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
  5. Recommended
    • ID
    • Handle
    • Published

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
  5. Recommended
    • ID
    • Handle
    • Published At

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
  5. Recommended
    • ID
    • Handle
    • Published Scope

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
  5. Recommended
    • ID
    • Handle
    • Template Suffix

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
  5. Recommended
    • ID
    • Handle
    • Image Src
    • Image Command

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
  5. Recommended
    • ID
    • Handle
    • Image Src
    • Image Command
    • Image Position

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
  5. Recommended
    • ID
    • Handle
    • Image Src
    • Image Command
    • Image Alt Text

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: …
  5. Recommended
    • ID
    • Handle
    • Metafield: …

Variants

To update variant columns you need to identify Variant and Product

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 (recommanded):
    • 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

 

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 (recommanded):
    • 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

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 (recommanded):
    • 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

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 (recommanded):
    • ID
    • Handle
    • Variant ID
    • Variant SKU

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 (recommanded):
    • 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

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 (recommanded):
    • 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

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 (recommanded):
    • 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

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 (recommanded):
    • 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

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 (recommanded):
    • 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

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 (recommanded):
    • 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

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 (recommanded):
    • 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

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 (recommanded):
    • 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

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 (recommanded):
    • 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

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 (recommanded):
    • 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

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 (recommanded):
    • 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

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 (recommanded):
    • 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

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 (recommanded):
    • 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

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 (recommanded):
    • 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

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 (recommanded):
    • 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

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 (recommanded):
    • 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: …

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 (recommanded):
    • 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: …

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 (recommanded):
    • 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 – https://excelify.io/shopify-excel-import-export-detailed-documentation/products/
  • ‘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 – https://excelify.io/contact-us/
  • 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