WPSyncSheets For WooCommerce

Documentation

How to Import External 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 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 import your desired data.

Enable Insert Product

Step 2

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

Insert 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 Column Added

Step 4

Leave the Product ID and Product Variation ID blank. Set Product Type as external. Fill other required data. 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 Products

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.

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.

External Product Button Text: Buy Now → Add to cart

Update Column

Step 5

Click on the Import Product button.

Import Product

Step 6

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

Proceed Update

Final Spreadsheet

Final Spreadsheets

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 Column Added

Step 4

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

Delete Column 1

Step 5

Click on the Import Product button.

Delete Import Products

Step 6

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

Delete Proceed Products

Final Spreadsheet

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!