Bulk Product Sync with Google Sheets

Getting Started

↑ Back to top

Installation

↑ Back to top

Instructions below to install and set up Bulk Product Sync with Google Sheets plugin.

First, the free version of Bulk Product Sync with Google Sheets will need to be installed (if not already).
Next, install the Pro version of Bulk Product Sync with Google Sheets by going to: WordPress Admin > Plugins > Add New > Upload Plugin.
Choose the File for the file you downloaded.
Install Now and Activate Plugin.
Now you are done here, next you need to connect your Google Sheets, watch the video below

Full Guide About Bulk Product Sync

↑ Back to top

Install Google Addon:

Visit Google Workspace Marketplace to install Bulk Product Sync Addon.

How to sync (import products from Google sheet to site)?

↑ Back to top

Within the “products” tab in the spreadsheet, make sure the id column is always the first column and the sync column must always be the last column (as shown in the screenshot below):

More columns can be added between the id and sync columns. These column names must be the same as listed in products keys here.

Enter product data within each row under and leave the id and sync values blank. Next, click on Extension > Bulk Product Sync > Sync Data in the menu bar. See screenshot below:

When the sync operation is done, the product automatically pulls the id value and the sync column is also set to OK.

How to update product?

When the product(s) need to be updated from the Google spreadsheet to the site, the sync column value must be blank. Simply remove the “OK” value and again click on Google sync > Sync Data in the menu bar.

How to fetch products/categories from site to sheet?

↑ Back to top

To populate your Google sheet with existing products in your store, click Extension > Bulk Product Sync > Fetch Products (or Category). It will fetch all the products from your store and populate within the Google sheet.

Resetting / Unlinking the Data

At any point, the link between the Google sheet and store can be reset. This means there will not be any connection between store products and categories and sheet data. The Sync Row # column (on the Products page in the WP admin panel) will be set to “Not synced” as shown below:

When a product or category is linked, the Sync Row # will list the row value.