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.

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 import your desired data.

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 “Insert” column in your connected Google Spreadsheet parallelly Import Product option in the settings page.

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.

Step 5
Click on the Import Product button.

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

Final Spreadsheet

Update Products
Step 1
Enable Update to update your desired data.

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 column.
External Product Button Text: Buy Now → Add to cart

Step 5
Click on the Import Product button.

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

Final Spreadsheet

Delete Products
Step 1
Enable Delete to delete your desired data.

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

Step 5
Click on the Import Product button.

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

Final Spreadsheet
