WooCommerce Products – Recurring Imports from Google Sheets

In this tutorial, we will see how to create recurring imports from Google Sheets to WooCommerce.

We are going to import WooCommerce products from Google Sheets at recurring intervals or on a periodic basis.

This will allow you to schedule recurring imports that will run in the background every X minutes, hours, days, weeks or months.

To connect your WordPress site to your Google Sheets account, you don’t need browser extensions or complicated scripts.

You will be able to connect to the Google account from your WordPress website and start scheduling exports and imports between WordPress and Google Sheets easily.

For this you need the WP Sheet Editor – WooCommerce Products plugin, which allows you to view and edit all your WooCommerce products using an intuitive spreadsheet.

You also need to sign up to the Google Sheets Sync service. This is a service provided by wpsheeteditor.com, which allows you to export and import content between your WordPress websites and your Google Sheets account.

1- Connect your WordPress site to Google Sheets

To get started, we need to connect our WordPress website to our Google Sheets account, the Google API, and the WP Sheet Editor API.

You can follow this guide to install and configure the plugin helper that you will receive when you sign up to the Google Sheets Sync service.

2- Prepare your Google Sheet with WooCommerce products

The first thing you need to do is to prepare the Google Sheet you want to import into WooCommerce. This Google Sheet can have both new products and changes to existing products.

Please note that our Google Sheets Sync service only recognizes Google Sheet files that have been created with our service.

This means that you first need to export even one product from your website to Google Sheets. Follow this tutorial.

This ensures that we do not have access to other files in your Google account. We do not store the content of your Google Sheets.

3- Create recurring imports from Google Sheets

Once you have prepared the Google Sheets of WooCommerce products you want to import, you can open the WooCommerce products spreadsheet by going to WP Sheet Editor > Edit products in wp-admin.

After that, you can open the Import tool.

Now you need to select these values to import WooCommerce products in recurring intervals from Google Sheets:

• Tick the Run this in the future checkbox.
• Select the date and time: Use this field to select when you want the first import to run.
• Notify this email address when the process finishes: You can enter your email address here, and we will notify you when the first import runs, and when a recurring interval is imported as well.
• Select the Run in recurring intervals option.
• Now you need to select the recurrence using the Run every field. After that, select the time unit, which can be Minutes, Hours, Days, Weeks, or Months.
• Name: Here you need to add a name for this recurring import from Google Sheets.
• Source: Google Sheets
• Google Sheet file: You can use this field to select the Google Sheet you want to import. If you can’t find it, you can click the refresh button to refresh the list.
• Click on Next to go on to the next step.

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

You can either Import all the columns or Select individual columns to import.

If you select the second option, you can ignore specific columns and manually map into which fields you want to import each column.

Now you can select the way you want to import the information, using the following values:

• Do you want to update or create items: You have these 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
• If you select any option that requires to “update existing items”, you will need to match the Google Sheet columns with the fields in WordPress. In this case, we are going to synchronize the information using the product IDs, although you can select other fields such as the product SKU, for example.
• Click on Next.

Finally, you will see a preview of what the information will look like in the WP Sheet Editor spreadsheet after it is imported into WordPress.

If everything is OK, click on The preview is fine, start import to schedule this recurring import.

Once you have scheduled the recurring import, you can click on View scheduled imports.

Here you can see the scheduled imports list. Follow this guide to understand how to have complete control on your scheduled jobs.

When the import process from Google Sheets is complete, you will receive an email notifying you that the process is finished. We will also notify you by email each time a recurring interval is run.

This email will contain all the details of the process and a link to download the log file of this scheduled job.

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
• Real-time import

In this tutorial, we have shown you how to schedule recurring exports from Google Sheets to WooCommerce. You can automate changes to your WooCommerce products from Google Sheets. Just apply the changes to your Google Sheet, and they will be imported to WooCommerce at the scheduled date and time.

The Google Sheets Sync service allows you to automate WordPress content management using Google Sheets. It works with all spreadsheets in WP Sheet Editor plugin, so you can export and import posts, pages, products, donation forms, courses, lessons, forums, users, orders, customers, coupons, or any other type of posts and taxonomies.