Import WooCommerce Products from Google Sheets in Real Time

In this tutorial, we will show you how to import WooCommerce products from Google Sheets in real time.

You will be able to update product data in Google Sheets, and the data will be automatically imported into WooCommerce.

Why import WooCommerce products from Google Sheets in real time

There are some important advantages of importing WooCommerce products from Google Sheets in real time:

• Create thousands of products in Google Sheets and import them into WooCommerce
• Bulk edit WooCommerce products from Google Sheets
• Create and edit variations from Google Sheets
• Edit prices, stock and descriptions from Google Sheets automatically
• Save a lot of time working in Google Sheets and collaborate with your team
• No need to import manually, data is automatically imported from Google Sheets to WooCommerce

Plugins to add real-time sync from Google Sheets to WordPress

To add real-time sync between your Google Sheets account and your WordPress site, you need two things.

First, you need the WP Sheet Editor – WooCommerce Products plugin.

It allows you to view and manage your WooCommerce products in a spreadsheet. You can run advanced searches, bulk edit hundreds of products at once, export and import data with a few clicks.

Second, you need to sign up to the Google Sheet Sync service.

This plugin allows you to connect your WordPress sites to your Google Sheets account to export and import content easily. You don’t need to use browser extensions nor run any scripts. You do it all on WordPress.

When you sign up to our service, you’ll get a helper plugin that will allow you to connect your WordPress site to your Google Sheets account, to the Google API, and to the WP Sheet Editor API.

Follow this guide to do it.

Once you have set everything up, you need to follow the steps below to auto import WooCommerce products from Google Sheets in real time.

Step 1. Add products data in Google Sheets

The first thing you need to do to import products from Google Sheets to WooCommerce is to add your product data in Google Sheets.

It is important to note that our service only recognizes Google Sheets files that have been generated with the service itself.

This means that you must first export at least one product from WooCommerce using our service, and then you can add the data of the products you want to import in the Google Sheet generated by the export.

You can follow this tutorial to export products to Google Sheets.

The advantage of this is that your data is protected because we don’t have access to other files in your Google account. We do not even save the content of your Google spreadsheets. The data is only stored on your WordPress site and in your Google account.

Once you’re ready, you’ll have a spreadsheet on Google Sheets containing all your products data:

Step 2. Open the WooCommerce products spreadsheet

On your wp-admin dashboard, go to WP Sheet Editor – Edit Products to open the products spreadsheet.

Step 3. Import WooCommerce products from Google Sheets in real time

Now you need to open the Import tool.

You need to select the following values to add real-time synchronization between your Google Spreadsheet and your WordPress site:

• Tick the Run this in the future checkbox.
• Select the date and time: Use this field to select when you want to import the Google Sheet and start monitoring the changes in real time.
• Select the Run once option.
• Name: You need to add a name for this scheduled real-time import.
• Source: Google Sheets
• Google Sheet File: You can use this field to select the Google Sheet you want to import. It will recognize the spreadsheets generated through our service only. If you can’t find the Google Sheet file, you can refresh the list.
• To monitor future changes to import them in real-time, you need to tick the Monitor and import changes made on Google Sheets checkbox.
• Synchronization delay: We allow a synchronization delay to make sure you have finished making changes on Google Sheets and avoid importing incomplete data. You can select from 15 minutes after your last edit in Google Sheets up to 12 hours.
• Click on Next.

Now you need to select the columns you want to import.

You can Import all the columns and automatically map them to the fields in WordPress.

Or you can Select individual columns to import and manually map the columns to the fields in WordPress.

If you decide to Select individual columns to import you will be able to manually map the columns you ignore specific columns if you want.

Once done, click on Next.

Now you need to select how you want to import the information by selecting these values:

• Do you want to update or create items: You have four options:
  • Create new items and update existing items
  • Import all the rows as new
  • Only create new items, ignore existing items
  • Update existing items, ignore new items
• Notes:
  • Since we are creating a real-time sync, most commonly we want to edit our WooCommerce products from Google Sheets and have the changes imported into WooCommerce. So, in this case we are going to select any of the options that include “update existing items”.
  • If you are only going to edit existing products in Google Sheets, you can match the products using the ID field.
  • But if you are going to edit AND CREATE products, we recommend using other fields such as the product SKU.
• Click on Next.

Now you will see a preview of the information in the spreadsheet inside WordPress.

If everything is fine, you can click on the The preview is fine, start import button.

After that, the real-time import will be scheduled to run at the selected date and time.

You will be able to see it in the scheduled imports popup.

You can read this guide to know how this popup allows you to have full control of your scheduled jobs.

Sync WooCommerce and Google Sheets

You can automate your WooCommerce products with Google Sheets exports and imports:

• Immediate export
• Scheduled export
• Recurring exports
• Real-time bidirectional sync
• Immediate import
• Scheduled import
• Recurring import

In this tutorial, we have shown you how to import WooCommerce products in real time from Google Sheets. This is a great way to have your products always up to date. You can have one person in your team in charge of editing your product data in Google Sheets, and you don’t have to import manually every time changes are applied. The data will be automatically imported in the background.

The Google Sheets Sync service works with all spreadsheets of the WP Sheet Editor plugins running in the backend. You can automate exports and imports using Google Sheets for posts, pages, products, courses, donation forms, forums, events, and any other post types. It works with multilingual plugins (WPML, Polylang, and others), and with custom field plugins (ACF, Pods, and others.).