WPSyncSheets For WooCommerce

Documentation

How to Import Variation Products?

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.

Import Products

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.

Enable Import Products
Sheet Headers

Step 3

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

View Spreadsheets

Original Spreadsheet

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

Original Spreadsheets

Insert Products

Step 1

Enable Insert to import your desired data.

Enable Insert Product

Step 2

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

Sheet Headers

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.

Insert Google Sheet

Step 4

Add variation in existing products.

It counts every variation as a separate product. To add a new product, fill the required details like product name, product type, variation: size, variation: color etc.

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.

Leave the Product variation ID blank.

Go to the Insert column and type “1” in the row you want to create a new product.

Insert Product Id

Step 5

Click on the Import Product button.

Insert Import Product

Step 6

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

Insert Proceed Product

Final Spreadsheet

Final Spreadsheets

Update Products

Step 1

Enable Update to update your desired data.

Enable Update Products

Step 2

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

Update Sheet Headers

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.

Update Google Sheet

Step 4

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

Variation: size – L → XL

Variation: color – Red → Blue

Update Column

Step 5

Click on the Import Product button.

Update Import Product

Step 6

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

Update Proceed Products

Final Spreadsheet

Final Spreadsheet

Delete Products

Step 1

Enable Delete to delete your desired data.

Enable Delete Product

Step 2

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

Sheet Headers

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.

Delete Google Sheet

Step 4

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

Delete Column

Step 5

Click on the Import Product button.

Delete Import Product

Step 6

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

Delete Proceed Product

Final Spreadsheet

Final Spreadsheets

Real-Time Import, Export, and Migration of WooCommerce Data.

WPSyncSheets For WooCommerce

5.0
View Plugin

Have a question?

We’re here to help, just send us a message.

Need help?

We're ready to help out & answer questions!