WPSyncSheets For WooCommerce

Documentation

Import WooCommerce Products with WPSyncSheets For WooCommerce plugin

If users want to add new products in bulk, update prices, descriptions, or stock levels, they need to import products. It saves time, reduces manual errors, and avoids repetitive products edits within WooCommerce.

There are 4 types of Import Products in WooCommerce.

  1. Simple Product Import
  2. Variable Product Import
  3. Group Product Import
  4. External Product Import

How to Import Simple Products?

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 Spreadsheet

Original Spreadsheet

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

Original Spreadsheet

Insert Products

Step 1

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

Enable Import Products

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

If you add the data manually then make sure you have used the similar format as above row(s) or else you can copy the existing products.
Leave the Product ID blank. Go to the Insert column and type “1” in the row you want to create a new product.

Insert Column Sheet

Step 5

Click on the Import Product button.

Import Products

Step 6

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

Insert Proceed Product

Final Spreadsheet

Final Spreadsheet

Update Products

Step 1

Enable Update to update your existing product.

Update Products

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 “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 product.

Update Column Sheet

Step 5

Click on the Import Product button.

Update Product

Step 6

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

Update Proceed Product

Final Spreadsheet

Final Spreadsheet

Delete Products

Step 1

Enable Delete to delete your desired product.

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 Sheet

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 Spreadsheet

The other three types of this product.

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!