Minimum required columns to update specific Product fields


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:


Bulk import Shopify product variants by generating combinations of Options

Shopify product variant combinations generated from Options - thumbnail

If you need to generate variants in bulk for your Shopify products, you can enter Option values split by ; (semicolon) in columns:

  • Option1 Value
  • Option2 Value
  • Option3 Value

As a result, the Excelify app will generate your variants as combinations of all those options.

For example, if you have the import file Options like this:

Shopify variant options to bulk generate variants from

It will result in imported variants like this – all of their semicolon-separated-value combinations:Shopify bulk generated variants for Products

Of course, you don’t have to fill all 3 options. You can do it with just one or two option value cells, too.

Edit generated variants before importing

If you need to fine-tune your generated variants or delete some of them before importing, you can run the import with the “Dry Run” (select Options button after uploading the file).

Shopify generate variants from options - generate file with dry runThen press the “Import” button. After the dry run is complete, press the “Download Import Results” button.

Shopify download import results file after dry run of generated variants from options

You will get the Import Results file with all the generated variants – change them as you like, and then import this changed file again with Excelify – as the normal import.

Shopify bulk generated product variants in Excel from Options values

Good to know

  • Shopify allows a maximum of 100 Variants so be cautious not to exceed that when multiplying your option values.
  • All of the other values for the variants will get duplicated from that one import row for all the variants.


Rearrange Product Variant Positions

Shopify Product Variants

To rearrange Shopify product variants:

  1. Export Products + Inventory / Variants (without images or Metafields)
  2. Find the column “Variant Position” and change the numbers as you like them to be. (no need to change the row order, just change the numbers)
  3. You could just import that same file back but it will update all the columns that you import. So, to make the import smaller and quicker, and to update just the positions and nothing else, you can select just the following columns:
    • ID
    • Handle
    • Variant ID
    • Variant Position
  4. Copy those columns to new empty Excel file.
  5. Set the name of the sheet “Products” (so that the app knows that those are the Products data there).
  6. Import that file. It will just update the variant positions of those variants.

You can, of course, import only the product rows that you really want to change. No need to import all the products back.

See the full tutorial in the video.

Product Variant Metafields

Shopify variant metafields

The same way as you have “Metafield:” columns, you now have the “Variant Metafield:” columns for Products where you can export and import variant metafields.

For example:

  • The variant metafield with name “buy_price” in the global namespace should be called “Variant Metafield: buy_price”.
  • The variant metafield with name “description” in the “details” namespace should be called “Variant Metafield: details.description”.

Note that exporting and importing Variant Metafields will significantly increase the time it takes to process the items because each variant metafield needs separate request to the Shopify API. Therefore, be mindful and export/import variant metafields only when you really need them.

To start using variant metafields, refresh the app page.

Filter Export by Product Price

When exporting from Shopify, you can filter Products by Price with the following conditions:

  • equals
  • less than
  • less than or equal to
  • greater than
  • greater than or equal to

When doing the export, it will look into all your product prices and will include in the export only those products, where the price of the product or at least one of its variants will match your given criteria.

Shopify filter by product price

Update Variants by SKU, Barcode, or Options

Update your products by Variant SKU, Variant Barcode or even by Option values, if you don’t have SKUs or Barcodes. It will MERGE Variants in such a smart way that you almost never ever need to use Variant ID to update your variants.

When importing, remember that still you will have to identify the Product as well, by specifying “ID” or “Handle” values.

The import file to update specific variant fields now can look like this:

Update Shopify Variants by SKU, Barcode or Options

You have waited so long, but it’s finally here!!! I hope it was worth the waiting…

“Variant Command” for Product Variants

To be more safe and exact, what should happen to Product Variants, when you import them, now you need to provide the “Variant Command” for each Variant row:

  • 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 variant to update, then it will add new.
  • 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 any variants that are not included in the import for that product.

If the Variant Command column is not provided, then app will assume the MERGE command.

Shopify add variants to existing product variantsFor more information, read the detailed field descriptions about Products.

How to group products into products with variants

Products into Variants

If you have products without variants which you want to group into fewer products with variants, this is how you do it.

Step 1: Export products to Excel

Export products into Excel spreadsheet and open it to edit.

Shopify group products without variants into fewer products with variants

Step 2: Add data to variant columns

I will use following approach: Will add all products as new, but with variants, and then remove old products, which were without variants. I will do it, because this will save me in case something will go wrong (will add tag “new” for all newly imported products and they can be deleted easily, if imported incorrectly) and it will allow me to save images.

If you delete old products first, then Shopify will delete also attached images, and you will not be able to import them. That’s why you first need to import new Products, and then you are safe to delete the old Products.

So, to prepare the import Excel file I need to update following columns:

  1. Product ID – remove all data, so that it knows to create new Products with this import.
  2. Handle – set new handle for each product. For example, if the handle was: dress-anna-red-s, now I will have only dress-anna. This handle will be set for each variant of Dress Anna product. You can use formulas or play with Excel “split data” features to split your old handle into portions and then combine back as you need.
  3. Title – set appropriate Title (if there was a colour or size, now you can remove this data from the Title). You can also do that with formulas in Excel.
  4. Tags – add some tag for every row, that is absolutely new and use can use later to distinguish newly added products with variants. I used tag “new”.
  5. Variant ID – remove all data, so that it knows that those are new Variants.
  6. Option1 Name – set name for the first Variant option. In my case this is “Color”. Set it only in the first row of the product (no need to copy it for the each Variant.
  7. Option1 Value – set values for the option1. In my case these will be Variant colours: Black, Red, Blue, etc.
  8. Option2 Name – If you have more then 1 option for the Variant, like Colour and Size, set 2nd option Name here. In my case: Size.
  9. Option2 Value – Set sizes, L, M, S, XS.
  10. Variant Image – if your old Products has just one image per Product, copy Image Src column data here – then it will assign that same image to variant image.
  11. Image Src – Keep them as they are, with whatever images you have for your Products.

Shopify group products without variants into fewer products with variants


Step 3: Mark existing Products with tag “old”

Set tag for all existing products, so that you can filter them later. I added tag “old” for all existing products before importing the new ones, as will delete old products after the import:

Shopify group products without variants into fewer products with variants

Step 4: Import updated Excel

Import updated Excel file:

Shopify group products without variants into fewer products with variants

Shopify group products without variants into fewer products with variants

I have old products without variants and new products, but with variants.


Step 5: Delete old products

Now I can delete old products, by filtering them by the tag “old”, and doing “bulk delete” in Shopify Admin.

Or follow this tutorial: How to bulk delete Products.

Shopify group products without variants into fewer products with variants


Good To Know

  1. It is important, that you firstly add new Products with variants and only then delete old Products without variants, to keep all you images.
  2. Set some unique tag for new products to distinguish them from the old ones, in case something will go wrong.
  3. Delete old products only after you are sure that all new Products and imported correctly!
  4. After import is complete, you can download the “Import Results” Excel file, where the last 2 columns (Import Result and Import Comment) will show you the result for each row. This is helpful, when something failed in the import – you will see the failure reason there.


Where To Go From Here?

  1. Install the Bulk Import Export Update with Excel app to your Shopify store.
  2. Read the detailed Column Descriptions of all columns (fields) that you can export and import.
  3. Write us a Review and give some stars along with your story, how it helped.

Add Variants To Existing Product

Add Variants to existing Product

You already have Products with Variants, and you just want to add Variants without touching existing Variants.

You can do that the following way. Let’s assume, we have this Product with one Variant:

Add Variants to existing Product

Step 1: Construct the Import File

Construct the Import Excel file, which contains only new Variants you want to add.

Make sure that you copy the ID or Handle rows for each new Variant row, so that app knows that those rows belong to the same Product:

Add Variants to existing Product

Now the most important part. Set the value of column “Variant Command” to MERGE for each Product, where you want to add variants. This will make the import to append Variants to existing, if the “Variant ID” will be empty. It will update those variant, which have the “Variant ID” provided.

It looks like this:

Shopify add variants to existing product variants

Also, you need to make sure that the following columns have unique values (if you import them):

  • Variant SKU
  • Variant Barcode
  • Option values

That’s because – if they will not be unique for this product, then the app will consider them as an update to existing variant which will be found by any of those.

A word about images. If you want it to use the existing images from your Product, then do the Export, and take the same link from the Product Image, and put it in “Variant Image” column. However, if you will take the link from somewhere else, it will add that image to Variant and to the Product itself.

Step 2: Add Variants by Importing That Excel File

Add Variants to Product

Step 3: Check The Added Variants on Product

Add Variants to Product

By looking at the Product you see that it still has its previous Variant, and 3 new variants are added after that.

Also, you see that new Variant images are added to the Product.

Additional Tips

  • To find out Product Handles, you can take that information from Product SEO Description section, or do the Export.
  • If you update Products by ID, then remember to copy ID value for each Variant row, and make sure Excel didn’t increment it, when you copied.
  • You can remove from Excel file all columns which you don’t want to update.

Where To Go From Here?

  1. Install the Bulk Import Export Update with Excel app from Shopify AppStore and try Free version to add variants on your own store Products.
  2. Get the Template Excel file, or to the Export to generate it from your own store.
  3. Read the Products Field Descriptions.
  4. Read other Tutorials.
  5. If you are not sure how to prepare the import file, ask our Support, we will teach you, or do that for you.