How to Import Google Sheets to WooCommerce

To import Google Sheets to WooCommerce, use the Google Sheet’s sharing URL in All Import › New Import › Download a file › From URL, map columns to corresponding product fields using the drag & drop interface. WP All Import lets you schedule updates, control which fields to update, and even remove items that disappear from your Google Sheets.

If you'd like to watch a video on this topic:

Otherwise, you can keep reading the written article below.

Before Starting

There are two ways to make a Google Sheets file accessible to WooCommerce:

• Share Link: Choose the "Anyone with the link" option. This is the recommended and fastest way for imports. Copy the link and paste it in the Download a file › From URL. WP All Import will use the first sheet.
• Publish to the web: Choose the "Comma-separated value (CSV)" option. This produces a direct URL to access the chosen sheet/tab as a CSV.

Both methods work, but we're going to use the share link method in this guide. You also need to make sure that you have WP All Import Pro and the WooCommerce Import Add-On Pro active and installed on your site.

If you don't know which method to use, start with the regular share link that uses the first sheet by default. You can switch to the published CSV URL if you need to import a different sheet from your spreadsheet.

Step 1: Obtain "Share link" from Import File in Google Sheets

If you don't have a spreadsheet already, go to Google Sheets and start a new spreadsheet. Set up columns for each product field you plan to import like title, description, price, SKU, images, categories, etc. We recommend one row per record. Add the data into the first sheet of your spreadsheet.

Once the data looks OK, make the Google Spreadsheet accessible to anyone by obtaining a sharing link.

Click Share, then under General Access choose Anyone with the link and copy the link.

This method shares the first sheet found in the Google Spreadsheet by default. If there are more sheets to import, you can move the data into the first sheet or publish the other sheets as CSVs.

Step 2: Create New Import Using Google Sheets URL

Next proceed to create the import process for WooCommerce. In your WordPress site, go to All Import › New Import, select Download a file › From URL and then paste the sharing link we previously obtained as the source URL.

Proceed to select the target post type, WooCommerce Products in this case, and click Set Up Import. You could also import WooCommerce Orders, Coupons, Reviews, or Customers.

WP All Import will download the latest version of the import file and detect the columns. It will retrieve all data from the first sheet and you can then proceed to map the retrieved data to WooCommerce.

Step 3: Map Import Template to Configure Google Sheets to WooCommerce Import

Next you'll find the Drag & Drop screen. This lets you map all of your CSV data and fields into the corresponding WooCommerce fields. The data from the Google Sheets appears on the right.

To import from Google Sheets to WooCommerce, drag each element from the right into its matching field on the left. You are able to map title, description, excerpt, prices, SKU, inventory data, attributes, taxonomies like product categories or tags, custom fields, images, etc. You'll find a corresponding field to map all the WooCommerce data you're importing into.

There is no limitation or imposition on how the data gets imported or how it should be formatted. You just need to map the data accordingly. WP All Import allows you to filter records, use PHP to modify data on the fly, and map to any third-party plugin or theme by using the custom fields feature.

To import images, provide the complete URL to access the images so they can be added into the Media Library.

Once all fields have been correctly mapped, proceed to click Continue to Import Settings at the bottom of the page.

Step 4: Configure Import Settings

Now you see the Import Settings screen. In here, you can assign a Unique Identifier using the Auto-detect button. This identifier allows WP All Import to match rows to existing records whenever the import runs again.

You also decide what's to happen in future import runs: either to create or not create new records, update existing ones, and/or remove items missing from the imported Google Sheets.

• What to update: Use the Choose which data to update option to update only specific fields (like stock or price) while leaving other fields intact.
• Remove or modify missing items: If rows are removed from Google Sheets and you want them removed or modified in WordPress, enable the Remove or modify records not present in this import file option.
• Scheduling: Define manual cron jobs or enable the Automatic Scheduling Service so the import runs on a schedule (like hourly, daily, weekly, etc.). This is ideal to keep your WooCommerce data synchronized with ongoing changes in your Google Sheets.

When you complete your settings, click on Continue. Next you can confirm the import details and double-check what happens when the import runs. Once everything is confirmed and you're ready to run the import, click Confirm & Run Import.

Now the import runs and processes all records, importing all of your data from Google Sheets to WooCommerce.

Step 5: Review Google Sheets to WooCommerce Import

Once the import is done, you can check the target post type (e.g., products, or orders, reviews, etc) and review some of the imported records to ensure everything looks correct.

You can confirm titles, descriptions, SKUs, prices, product type, images, etc. If you have to adjust something, just modify the field mappings or update the import data and re-run the import process. When the import runs again, WP All Import will respect import mappings and settings, but it will update imported matching items with the new data.

That's it! You've successfully imported data from Google Sheets into WooCommerce using WP All Import and the WooCommerce Import Add-On.

Import Google Sheets to WooCommerce – Advanced Topics

Run Automatic Imports from Google Sheets to WooCommerce

WP All Import allows you to keep your Google Sheets synchronized with WooCommerce by scheduling imports so they run automatically. This can be done with two methods:

• Automatic Scheduling: this method can be configured from within WP All Import.
• Manual cron jobs: this method requires setting up cron jobs in your server that call WP All Import's endpoints on a defined interval.

Both methods will check the source Google Sheets URL, download a fresh copy, and then apply any updates automatically based on the defined import settings and import template.

Scheduled imports don't run the moment you edit your sheet—they run on their configured interval, so there's a delay between your edit and WooCommerce updating.

Import Any WordPress Data from Google Sheets

You are able to import any WordPress data like posts, pages, comments, users, taxonomies, or any other custom post type available during the setup and use the main WP All Import capabilities.

You map your Google Sheets columns and data to their corresponding WordPress field during import (title, description, custom fields, etc.). You can then schedule that import so it runs automatically and keeps the data in sync.

To update only specific data pieces from your sheet, use Choose which data to update and select the specific fields you want to update. This lets you run frequent import updates without touching or modifying existing data.

Transform Data On the Fly Using PHP

Use PHP built-in functions or your own custom PHP functions to transform the imported data on the fly. This lets you modify any imported data to whatever is required by your import process, or perhaps clean up the imported WooCommerce data so that you remove anything that shouldn't be imported.

Learn more about using PHP code when importing into WP All Import here: Calling PHP Functions In Your Import Configuration.

Delete Products Removed From Google Sheets

Use the Remove or modify records not present in this import file option to automatically delete products removed from your Google Sheets spreadsheet. You enable that option in the import settings, and you need to ensure that it's set up correctly since it can damage your site and remove all products if it's not properly configured. To test it out, you can use a sandbox environment. To learn more about this feature, please read: Remove or Modify Data Missing From the Import File.

Update Google Sheets Source URL

Whenever your Google Sheets file changes (for example, due to having a new Google Sheets document), you can update the source URL like this:

1. Locate your import in All Import › Manage Imports
2. Click on Settings for the import.
3. Change the source under Download a file › From URL, found in the Import File section. Use the new Google Sheets URL
4. Save the settings and the next time the import runs, it will use the new Google Sheets.

Go back to All Import › Manage Imports to confirm that the new Google Sheets URL is saved and synced, as it will appear for the changed import under the import name.

Update Stock or Price for Existing Products

To update only stock or prices for existing products, use the Choose which data to update in the Import Settings and tick just the fields you want to change: stock and prices. Everything else is left untouched. That way, you can update only the specific products data pieces you want to update. You maintain the SKUs, prices and stocks in a Google Sheet and then tell the import to only update those specific fields. Finally, you can enable a schedule to make this import run automatically.

Import Google Sheets to WooCommerce — Frequently Asked Questions

How do I pull data from Google Sheets to WordPress?

You would use a plugin like WP All Import to import the Google Sheet's rows into WordPress as content. Then, you can automate that import so the pulling happens automatically on a schedule.

How do I connect Google to WooCommerce?

When it comes to Google Sheets data, you would use a plugin like WP All Import and the WooCommerce Import Add-On to connect your Google Sheets with WooCommerce and import the data directly, without having to manually input data pieces.

Can WooCommerce handle 50,000 products?

Even though WooCommerce is a plugin on top of blogging software (WordPress), yes, it should be able to handle 50,000 products as long as the web host and server have enough resources.

Can you embed Google Sheets into WordPress?

Yes, you could embed a published Google Sheet in a WordPress page or a WordPress post by using File › Share › Publish to the web and then embedding the Google Sheet's link. You can also import the sheet’s rows into WordPress as content.

How do I import WooCommerce product images from Google Sheets?

You would add the full image URL to each WooCommerce product in your Google Sheets. When creating the import template, map those image URLs into the Images fields found in WP All Import. The plugin will download those images into the Media Library, or match existing images on your site. You should avoid hosting images in Google Drive due to rate limits imposed by Google. Instead, use a CDN or a conventional server to host your images.

How do I limit updates to specific fields (e.g., only stock & price)?

This is done in the Import Settings by using the Choose which data to update option. You would enable that and then tick which specific fields you want to change. Everything else that's unticked will be left unchanged. This way, you only update the specific data pieces you want to update, like price or stock.

What if my Google Sheet has multiple tabs?

You would need to move your data into the first tab to use the "Sharing link" method described above. Alternatively, you can publish the CSV which is done per tab and then use the CSV URL as source in WP All Import.

What plugin do I need to import Google Sheets to WooCommerce?

You would need WP All Import Pro and the WooCommerce Import Add-On Pro to import data from Google Sheets to WooCommerce easily and without hassle.

How do I keep WooCommerce in sync when Google Sheets changes?

You can use WP All Import's manual cron jobs or the Automatic Scheduling Service. Just configure what happens on each run (creating, updating, removing) and then set up the import schedule. Since schedules always run at the same time and are asynchronous, this means the import won't process any change when you update the Google Sheet, only when the import runs next.

Import Google Sheets to WooCommerce — Related Information

Learn how to import data from Google Sheets to WordPress using WP All Import.

Learn how to import your data into your WordPress site using WP All Import and its add-ons.

Use manual cron jobs to schedule and automate your WordPress import process.