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:
- Updating by ID
- ID
- Handle
- Force updating by SKU
- Variant SKU [ID]
- Handle
Recommended
- ID
- Handle
Title
Columns if:
- Updating by ID
- ID
- Title
- Updating by Handle
- Handle
- Title
- Body HTML
- Force updating by SKU
- Variant SKU [ID]
- Title
Recommended
- ID
- Handle
- Title
Body HTML
Columns if:
- Updating by ID
- ID
- Body HTML
- Updating by Handle
- Handle
- Body HTML
- Updating by Title
- Title
- Body HTML
- Updating by SKU
- Variant SKU
- Body HTML
Recommended
- ID
- Handle
- Body HTML
Vendor
Columns if:
- Updating by ID
- ID
- Vendor
- Updating by Handle
- Handle
- Vendor
- Updating by Title
- Title
- Vendor
- Updating by SKU
- Variant SKU
- Vendor
Recommended
- ID
- Handle
- Vendor
Type
Columns if:
- Updating by ID
- ID
- Type
- Updating by Handle
- Handle
- Type
- Updating by Title
- Title
- Type
- Updating by SKU
- Variant SKU
- Type
Recommended
- ID
- Handle
- Type
Tags
Tutorial – How to update tags on Shopify in bulk.
Columns if:
- Updating by ID
- ID
- Tags
- Tags Command
- Updating by Handle
- Handle
- Tags
- Tags Command
- Updating by Title
- Title
- Tags
- Tags Command
- Updating by SKU
- Variant SKU
- Tags
- Tags Command
Recommended
- ID
- Handle
- Tags
- Tags Command
Published
Tutorial – Publish or Unpublish Products in bulk.
Columns if:
- Updating by ID
- ID
- Published
- Updating by Handle
- Handle
- Published
- Updating by Title
- Title
- Published
- Updating by SKU
- Variant SKU
- Published
Recommended
- ID
- Handle
- Published
Published At
Tutorial – Publish or Unpublish Products in bulk.
Columns if:
- Updating by ID
- ID
- Published At
- Updating by Handle
- Handle
- Published At
- Updating by title
- Title
- Published At
- Updating by SKU
- Variant SKU
- Published At
Recommended
- ID
- Handle
- Published At
Published Scope
Tutorial – Publish or Unpublish Products in bulk.
Columns if:
- Updating by ID
- ID
- Published Scope
- Updating by Handle
- Handle
- Published Scope
- Updating by Title
- Title
- Published Scope
- Updating by SKU
- Variant SKU
- Published Scope
Recommended
- ID
- Handle
- Published Scope
Template Suffix
Columns if:
- Updating by ID
- ID
- Template Suffix
- Updating by Handle
- Handle
- Template Suffix
- Updating by Title
- Title
- Template Suffix
- Updating by SKU
- Variant SKU
- Template Suffix
Recommended
- ID
- Handle
- Template Suffix
Image Src
Find all Image related tutorials here.
Columns if:
- Updating by ID
- ID
- Image Src
- Image Command
- Updating by Handle
- Handle
- Image Src
- Image Command
- Updating by Title
- Title
- Image Src
- Image Command
- 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:
- Updating by ID
- ID
- Image Src
- Image Command
- Image Position
- Updating by Handle
- Handle
- Image Src
- Image Command
- Image Position
- Updating by Title
- Title
- Image Src
- Image Command
- Image Position
- 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:
- Updating by ID
- ID
- Image Src
- Image Command
- Image Alt Text
- Updating by Handle
- Handle
- Image Src
- Image Command
- Image Alt Text
- Updating by Title
- Title
- Image Src
- Image Command
- Image Alt Text
- 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:
- Updating by ID
- ID
- Metafield: …
- Updating by Handle
- Handle
- Metafield: …
- Updating by Title
- Title
- Metafield: …
- 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:
- Example 1:
- ID
- Variant ID
- Option1 Name
- Option1 Value
- Option2 Name
- Option2 Value
- Option3 Name
- Option3 Value
- Example 2:
- Handle
- Variant Barcode
- Option1 Name
- Option1 Value
- Option2 Name
- Option2 Value
- Option3 Name
- Option3 Value
- 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:
- Example 1:
- ID
- Variant ID
- Option1 Name
- Option1 Value
- Option2 Name
- Option2 Value
- Option3 Name
- Option3 Value
- Example 2:
- Handle
- Variant SKU
- Option1 Name
- Option1 Value
- Option2 Name
- Option2 Value
- Option3 Name
- Option3 Value
- 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:
- Example 1:
- ID
- Variant ID
- Variant Position
- Example 2:
- Handle
- Variant SKU
- Variant Position
- 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:
- Example 1:
- ID
- Variant ID
- Variant SKU
- Example 2:
- Title
- Variant ID
- Variant SKU
- 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:
- Example 1:
- ID
- Variant ID
- Variant Weight
- Example 2:
- Handle
- Variant SKU
- Variant Weight
- 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:
- Example 1:
- ID
- Variant ID
- Variant Weight Unit
- Example 2:
- Handle
- Variant SKU
- Variant Weight Unit
- 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:
- Example 1:
- ID
- Variant ID
- Variant Price
- Example 2:
- Handle
- Variant SKU
- Variant Price
- 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:
- Example 1:
- ID
- Variant ID
- Variant Compare At Price
- Example 2:
- Handle
- Variant SKU
- Variant Compare At Price
- 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:
- Example 1:
- ID
- Variant ID
- Variant Cost
- Example 2:
- Handle
- Variant SKU
- Variant Cost
- 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:
- Example 1:
- ID
- Variant ID
- Variant Requires Shipping
- Example 2:
- Handle
- Variant SKU
- Variant Requires Shipping
- 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:
- Example 1:
- ID
- Variant ID
- Variant Taxable
- Example 2:
- Handle
- Variant SKU
- Variant Taxable
- 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:
- Example 1:
- ID
- Variant ID
- Variant Tax Code
- Example 2:
- Handle
- Variant SKU
- Variant Tax Code
- 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:
- Example 1:
- ID
- Variant ID
- Variant Barcode
- Example 2:
- Handle
- Variant SKU
- Variant Barcode
- 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:
- Example 1:
- ID
- Variant ID
- Variant Image
- Example 2:
- Handle
- Variant SKU
- Variant Image
- 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:
- Example 1:
- ID
- Variant ID
- Variant Inventory Tracker
- Variant Inventory Qty
- Example 2:
- Handle
- Variant SKU
- Variant Inventory Tracker
- Variant Inventory Qty
- 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:
- Example 1:
- ID
- Variant ID
- Variant Inventory Policy
- Example 2:
- Handle
- Variant SKU
- Variant Inventory Policy
- 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:
- Example 1:
- ID
- Variant ID
- Variant Fulfillment Service
- Example 2:
- Handle
- Variant SKU
- Variant Fulfillment Service
- 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:
- Example 1:
- ID
- Variant ID
- Variant Inventory Qty
- Example 2:
- Handle
- Variant SKU
- Variant Inventory Qty
- 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:
- Example 1:
- ID
- Variant ID
- Variant Inventory Adjust
- Example 2:
- Handle
- Variant SKU
- Variant Inventory Adjust
- 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:
- Example 1:
- ID
- Variant ID
- Inventory Available: …
- Example 2:
- Handle
- Variant SKU
- Inventory Available: …
- 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:
- Example 1:
- ID
- Variant ID
- Inventory Available Adjust: …
- Example 2:
- Handle
- Variant SKU
- Inventory Available Adjust: …
- 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:
- Example 1:
- ID
- Variant ID
- Variant Metafield: …
- Example 2:
- Handle
- Variant SKU
- Variant Metafield: …
- 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