WooCommerce – How to Import Products from Google Sheets Directly

In this tutorial, we will show you how to import WooCommerce Products from Google Sheets directly.

We’re not talking about downloading a Google Sheets CSV file and then importing it from your computer to your WordPress website.

We are talking about directly connecting your WordPress website to your Google Sheets account and importing a Google Sheet file to your website.

And the best thing is that you can do it without having to install browser extensions or running complicated scripts.

Required plugin and service

To import WooCommerce products from Google Sheets, you need two elements in addition to the WooCommerce plugin.

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

This plugin allows you to save a lot of time managing your WooCommerce products, because you can view and edit thousands of products and variations in a spreadsheet within WordPress. You can do advanced searches, bulk changes, import and export products with a few clicks.

Second, you need the Google Sheets Sync service.

This is a service provided by wpsheeteditor.com that allows you to sync your WordPress website with your Google Sheets account to easily export and import content. It works with all WP Sheet Editor plugin spreadsheets running on the backend, so you can automate imports and exports for any post type and taxonomy.

Follow the steps below to import WooCommerce products directly from a Google Sheet.

1- Connect your WordPress site to Google Sheets

The first thing you need to do to be able to export and import WooCommerce products between your WordPress website and your Google Sheets account is to connect your website with the Google API and the WP Sheet Editor API.

You can do this using the helper plugin that you will receive when you sign up to our Google Sheets Sync service.

You can follow this guide.

2- Prepare your Google Sheet with WooCommerce products

It is important to note that our Google Sheets Sync service will only read the files in your Google Sheets account that have been created with our service itself.

This means we don’t have access to other files in your Google account, not even to other Google Sheets files.

We don’t store any data from the content of your Google Sheets, so you can be sure that your privacy is well taken care of.

This has a practical implication for importing products from Google Sheets to WooCommerce: You’ll need to first export at least one product from WooCommerce to Google Sheets in order for us to import that file you previously exported.

You can add new products or edit existing products, but it must be a file generated with our service, or else we won’t be able to import.

Here’s a tutorial on how to do immediate exports from WooCommerce to Google Sheets.

 

Once you have added the information you want to import into your WordPress site, you can proceed to import your WooCommerce products from Google Sheets.

3- Import WooCommerce products from Google Sheets

You need to go to WP Sheet Editor > Edit products to open the products spreadsheet.

Then you need to open the Import tool.

Once you have open the Import tool, you need to select these values to import a Google Sheet containing WooCommerce products data:

• Source: Google Sheets
• Google Sheet file: This field allows you to select the Google Sheet file you want to import. If you can’t find the file, you can refresh the Google Sheets list.
• Click on Next.

The plugin will scan the columns in the Google spreadsheet and will allow you to choose if you want to Import all the columns mapping them automatically, or if you want to Select individual columns to import and map the columns manually.

This last option is useful if you want to ignore specific columns.

Here’s what you’ll see if you decide to manually map the columns you want to import.

Now you need to select how you want to import WooCommerce products from Google Sheets:

• Do you want to update or create items: In this dropdown field, 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
• 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.
• Click on Next.

Finally, you’ll see a preview of what the data will look like when imported into the products spreadsheet. If everything is OK, you can click on The preview is fine, start import.

The immediate import process from Google Sheets will run and you will see the details at the end of the process. You will also be able to download the log file of this import.

As you can see, we have updated more than 60 WooCommerce product rows from Google Sheets.

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

Importing WooCommerce products from Google Sheets is very easy with the WP Sheet Editor plugin and the Google Sheets Sync service.

This service works with all WP Sheet Editor spreadsheets used in the backend, so the possibilities are limitless.

You can export and import posts, pages, products, orders, customers, discount coupons, donation forms, events and much more.