How to Import Variable Product?

Kindly make sure you have created the attribute as you want to assign to a respective product.

Step 1

Find and enable the Import Products option and after enabling the Import Products you will see three options.

Step 2

Enable/Disable the options insert/update/delete as per your requirement and Save Settings. Enabled options will be displayed in the Sheet headers.

Step 3

After that, in Google Spreadsheet Settings click on View Spreadsheet.

Original Spreadsheet

After save the settings, our plugin code will automatically add sheet headers respectively.

Insert Products

Step 1

Enable Insert to add your desired product in a new row.

Step 2

Enable/Disable the sheet headers as per your requirement and click on Save.

The attribute will be imported only if it is added. If it’s not added, the user will not be able to import the variable product.

Step 3

After you save the settings, you will have the “Insert” column in your connected Google Spreadsheet parallelly Import Product option in the settings page.

Step 4

Add variable products.

Categories and Tags: Add comma-separated names in Product Category and Product Tags columns.

Attributes: Add values in their respective attribute columns. When a product has multiple values for a single attribute (e.g., a T-shirt available in both red and blue), separate each value using a pipe symbol (|). (e.g., Red | Blue for Color).

Leave the Product ID and Product variation ID blank.
Product Name is mandatory.
Set Product Status as publish.
Set your Product Type as variable.
Go to the Insert column and type “1” in the row you want to create a new variable product.

Step 5

Click on the Import Product button.

Step 6

Now, you will have the Proceed option, click on it.

Final Spreadsheet

Insert Variation

To create variations:

1. Add variation rows below the parent variable product.
2. Set Product Type as variation.
3. Leave Product Variation Id blank.
4. Add the parent’s Product ID in the Product Id column.Do not leave the Product ID empty. If you’re creating a variation, make sure to use the same Product ID as the main (variable) product. This is important because the variation will fetch details from that main product.
5. Add 1 in the Insert column 
6. Ensure parent product type is set to variable.
   

2. Click Import Product. 

3. Click on Proceed.

Final Spreadsheet

If you want to update a variation within an existing product then go here.

Update Products

Step 1

Enable Update to update your desired product.

Step 2

Enable/Disable the sheet headers as per your requirement and click on Save.

Step 3

After you save the settings, you will have the “Update” column in your connected Google Spreadsheet parallelly Import Product option in the settings page.

Step 4

Make the changes you want and in the Update column of that row, type “1”, to update a particular product.

Product Description: Not Provided → Shoes 1

Variation: size – S → L

Step 5

Click on the Import Product button.

Step 6

Now, you will have the Proceed option, click on it.

Final Spreadsheet

Delete Product

Step 1

Enable Delete to delete your desired product.

Step 2

Enable/Disable the sheet headers as per your requirement and click on Save.

Step 3

After you save the settings, you will have the “Delete” column in your connected Google Spreadsheet parallelly Import Product option in the settings page.

Step 4

In the Delete column of that row, type “1”, to delete a particular row.

Step 5

Click on the Import Product button.

Step 6

Now, you will have the Proceed option, click on it.

Final Spreadsheet