WPSyncSheets For WooCommerce

Documentation

How to Import Group Product?

Step 1

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

Find 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

  1. Leave the Product ID and Product Variation ID blank. 
  2. Set Product Type as grouped. 
  3. Set the Product Status as publish
  4. Fill in the required product details, such as:
    Product Name, Regular Price , Any other required columns like SKU, Category, etc.
  1. Assign products to the group:
  • In the Group Product Id column, enter the Product IDs of the individual products you want to include in the group.
  • Use comma-separated values (e.g., 276,281,282) to list multiple Product IDs.
  • Product IDs must already exist in your WooCommerce store.
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 Button

Final Spreadsheet

Final Spreadsheet

Update Products

Step 1

Enable Update to update your desired data.

Enable Update Product

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.

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 Button

Final Spreadsheet

Final Spreadsheets

Delete Product

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 column.

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 Button

Final Spreadsheet

Delete Final Spreadsheet

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!