WooCommerce – Copy Variations from One Product to 100 Products with a few Clicks

In this tutorial, we will show you how to copy product variations and attributes from one product to other products. This is useful if you are creating a new WooCommerce store and Your Variable Products contain similar attributes, prices, and other information.

So it’s easier to set up One Product and Copy the Variation to the Other Products, and after that, you just change one or two fields that require unique values. For example, if you sell t-shirts and all t-shirts have sizes: “Small, Medium, Large” and color “Red, Blue, White”.

You can set up one t-shirt, and just copy all the information to the other t-shirts.

Yes. It’s that easy. Let’s begin 🙂

For this tutorial, we will use the “WP Sheet Editor” plugin.

Install the “WP Sheet Editor” plugin

WP Sheet Editor plugin provides a Spreadsheet that you can use to edit WooCommerce products and all the product information.

It also provides Amazing Tools for Editing Products Quickly. These tools include:

  • Copy Variations between Products
  • Copy downloadable files between products
  • Create hundreds of products quickly in the spreadsheet
  • Auto-fill product information in the spreadsheet
  • Update hundreds of posts in seconds by executing Formulas in the Spreadsheet
  • And more

You can skip this step if you already have the plugin installed and activated.

You can download the plugin here:

- or - Read more about it

Before starting…

WP Sheet Editor gives you the option of displaying or not product variations in the spreadsheet, so if you want to display product variations in the spreadsheet, just hit the “Display variations” button on the toolbar.

1- Copy product variations on individual products

If you want to copy product variations from one product to another or from one product to three or four, you need to take these simple steps:

Open the Create variations tool by clicking it on the toolbar.

Once you open the tool, you’ll see two options: create and copy variations, so you need to click on the Copy variations button.

After that, you need to set these values:

  • Enter the product from which you’ll copy in the Copy variations and attributes from this product field.
  • Enter the products to which you’ll copy the variations in The variations are for these products.
  • Hit the Execute button.

That way you can copy variations from one product to one, three, five, etc.

2- Copy variations from one product to 100 products

Another way you have to copy product variations is copying from one product to groups of products. For example, you can copy from one product to all products containing a keyword, category, attribute, tag, date, etc.

For this, you need to take these simple steps:

Open the Create variations tool by clicking it on the toolbar.

Once you open the tool, you’ll see two options: create and copy variations, so you need to choose the Copy variations button.

Enter the product from which you’re copying the variations in the Copy variations and attributes from this product field.

Select Multiple products in The variations are for these products.

When you select Multiple products, it will open a search tool in which you can look for all the products you want.

SEARCH OPTIONS:

  • Contains keyword: Enter any product keyword to look for all products containing it.
  • Status: Published, Draft, Scheduled, etc.
  • Enter Tags: Categories, Attributes, Tags, Shipping Classes.

When you have chosen one search method, just hit the Run search button.

Then, just hit the Execute button to apply the copying of the variations and that’s it.

IMPORTANT

  • The copy includes all the fields of the variations added by other plugins.
  • Also, we have the Do not copy the variation images in the Show advanced options popup for you to use the image of the parent product.

Bonus: Video Tutorial

Done!

As you can see, you can Copy Product Variations from One Product to Unlimited Products very quickly.

Just take into account your server. If you have a powerful server you can copy to hundreds of products at once, otherwise, you can do it in smaller batches.

You can download the plugin here:

- or - Read more about it

Do you need help?

You can receive instant help in the live chat during business hours, or you can contact us and we will help you via email.

Close Menu