Import WooCommerce Coupons from Google Sheets

In this tutorial, we will show you how to import or create WooCommerce coupons from Google Sheets. As you will see, we will just need a few clicks to easily connect our WordPress site to our Google Sheets account, in order to import WooCommerce coupons from a Google Sheets file.

Related tutorial: How to Export WooCommerce Coupons to Google Sheets

Something great about importing coupons from Google Sheets with our method is that you don’t need to install any browser extensions nor run any complicated scripts. This means you don’t need to be a programmer because everything is done from the WordPress dashboard.

In order to connect our WordPress site with Google Sheet and import coupons, we need two important elements:

WP Sheet Editor – WooCommerce Coupons – This displays all your WooCommerce coupons in a spreadsheet on WordPress. You can easily manage your coupons with advanced search, easy bulk edit, export and import coupons with CSV files.

Google Sheets Sync Service – This is an online service provided by wpsheeteditor.com, which allows you to export and import content between WordPress and Google Sheets with a few clicks. You can create immediate exports/imports, schedule exports/imports to run once or at recurring intervals, and live sync your content with Google Sheets. Since this service works with all the WP Sheet Editor spreadsheets that run in the backend, the possibilities are endless because you can export and import posts, pages, products, coupons, orders, events, user profiles, customers, etc.

By signing up to the Google Sheets Sync service, you’ll receive two plugins:

• Automations – This plugin allows you to create automatic scheduled bulk edits, exports, imports and cell change saving for all the WP Sheet Editor spreadsheets.
• Google Sheets Sync helper plugin – This plugin allows you to connect any WP Sheet Editor spreadsheet to your Google Sheets account.
• You can follow this guide to learn how to install and set up the plugin, and how to connect your WordPress site to your Google Sheets account, the Google API, and the WP Sheet Editor API.

After installing and setting up everything you need, you can proceed to import WooCommerce coupons data from Google Sheets.

1- Prepare the Google Sheets file with your coupons data

You need to have a Google spreadsheet containing your WooCommerce coupons data, it should look something like this:

Important. The Google Sheets Service only recognizes Google Sheets files that have been generated with the service. This means that, in order to import a file, you need to previously export it. If you want to create new coupons by importing the data, a useful idea could be exporting at least one row (coupon), and then adding the information for new coupons.

Here is a tutorial on how to export WooCommerce coupons to Google Sheets.

2- Open the WooCommerce Coupons Spreadsheet

There are at least two ways to open the WooCommerce coupons spreadsheet:

• You can go to Marketing > Coupons and click on the Open in a spreadsheet button
• You can go to WP Sheet Editor > Edit Coupons

Once you do that, you will see all your WooCommerce coupons displayed in the spreadsheet.

3- Import your WooCommerce coupons from Google Sheets

In order to import your WooCommerce coupons data from Google Sheets into WordPress, you need to start by opening the “Import” tool with one click. It’s on the plugin’s top toolbar.

Second, you need to select the Google Sheets app as the source from which we will import the coupons data, and select the Google Sheets file containing your coupons information.

Note – If you don’t find the file you want to import, you can click on the refresh button.

Once you have selected the file, click on Next.

Third, you need to select which columns you will import into your WordPress site.

In this case, we will Import all the columns, but you could manually map specific columns and ignore any column.

Fourth, you need to select how you will import the coupons. You can create new items and update existing items, import all rows as new, only create new items, or only update existing items.

Note – If you’re updating existing items, you need to match them using a specific field. We suggest using the ID field.

Click on Next once you’ve selected these values.

Finally, you will see a preview of what the data will look like once the import is complete. If everything is OK, click on The preview is fine, start import.

After that, the import process will start and your coupons will be created or updated.

WP Sheet Editor and Google Sheets Sync service allow you to manage your WooCommerce coupons with Google Sheets. You can save a lot of time because you’ll avoid opening a lot of pages to create or update coupons.