1. Documentation /
  2. Bulk Product Sync with Google Sheets

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.

  1. First, the free version of Bulk Product Sync with Google Sheets will need to be installed (if not already).
  2. Next, install the Pro version of Bulk Product Sync with Google Sheets by going to: WordPress Admin > Plugins > Add New > Upload Plugin.
  3. Choose File for the file you downloaded.
  4. Install Now and Activate Plugin.
  5. After installation, extension settings can be accessed from WooCommerce > Settings > Google Sync.

Connect Google sheet with your store ↑ Back to top

We have created a short video explaining how to connect your store with Google sheet. Please watch this video and perform the same steps on your site inside plugin settings.

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 Google 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 Google 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:

Products sync column status when not linked.

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

Video Tutorials ↑ Back to top

All features explained in video

How to AutoSync and Fetch Products

How to add custom meta columns for products

WooCommerce

The most customizable eCommerce platform for building your online business.

  • 30 day money back guarantee
  • Support teams across the world
  • Safe & Secure online payment