Export WooCommerce Products to Google Sheets

A possibility to export WooCommerce products to Google Sheets comes in handy when you need to analyze or massively edit products in the file, or, for example, share product stock with a supplier for replentishment.

Store Manager for WooCommerce allows you to establish a connection between your WooCommerce store and Google Drive in a few clicks. Below, you’ll find a step-by-step tutorial on exporting WooCommerce products to Google sheets.

Steps to Export WooCommerce Products to Google Sheets

Open Store Manager for WooCommerce and run the Export Wizard
Connect to your Google Drive
Select/create a spreadsheet
Choose what fields will be exported
Consider additional options: number of records to export, image export, and other
Run the export and check data in a spreadsheet

Let's go through each step in detail.

1. Open Store Manager for WooCommerce and run the Export Wizard

To export WooCommerce products to Google Sheets, open Store Manager, and press the “Export data” button on the toolbar.

If you don’t have Store Manager installed yet, download the free trial, install the application on your computer, and connect to your store database following the Quick Start Guide.

Export WooCoommerce to Google Sheets Option

If you want to export specific products, filter them before you start the Wizard.

Use the advanced filtering and sorting functionality to sort products by ID, type, stock, and other parameters.

Custom WooCommerce Product Filtering Before Export to Google Sheets

2. Connect to Your Google Drive

In the Product Export Wizard, you will be prompted to select a location of the export file. Switch to the “Google Drive” option and add a new Google Drive account. Learn how to generate Google API key to get access to Google Sheets with Store Manager in this article.

Tip You can add several Google accounts and select among them during future exports.

WooCommerce Google Sheets Authentication in Store Manager

You will be redirected to the Google authentication window that provides your Google account sign in to Google Drive Integration. Selecting the account, you need to grant the addon access to view, modify, create and delete all your files on Google Drive; view and manage your Google Drive files and folders that are open or created with this Integration; view, modify, create and delete your spreadsheets in Google Drive.

Sign In to Google Account via Store Manager for WooCommerce

After you’ve finished, you will see a message that Store Manager now has access to Google Sheets. Close the browser window and proceed with the export.

3. Select/Create a Spreadsheet

Browse your Drive to select an existing spreadsheet or press the plus (+) icon to create a new one:

Browse Google Drive for Further WooCommerce Product Export

Next, select whether you want to replace sheet values, append exported data to a sheet, or insert a new sheet.

Below in the dropdown, you can select a certain sheet to export data to. To automatically set the date of export as a sheet title, click the browse icon and select the DATE macro:

Insert New Sheet for WooCommerce Product Export

Press Next to proceed.

4. Select Fields for Export

In this window, you’ll see a list of product fields. You can drag required fields one by one or press the upper button with arrows to select all fields at once:

Select the WooCommerce Product Fields for Export to Google Sheets

Step 5. Consider Additional Options: Number of Records to Export, Image Export, and Other

At this final step, you will be offered to define the records that will be exported (all or selected). In the Advanced options section, you can also configure:

time and date formats,
separators and delimiters
how and where to save images,
how to identify up/cross-sells and parent products - by SKU or ID.

Advanced Options During WooCommerce Product Export to Google Sheets

6. Run the Export and Check Data in the Spreadsheet

When you are all set, press Export. After the task is finished, you can view the export file or just copy a URL and send it directly to your supplier, employee.