Rating 0 stars - 0 votes

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

  1. Open Store Manager for WooCommerce and run the Export Wizard
  2. Connect to your Google Drive
  3. Select/create a spreadsheet
  4. Choose what fields will be exported
  5. Consider additional options: number of records to export, image export, and other
  6. 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
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
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.


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

Add Google Account for WooCommerce Product Export to Sheets
Add Google Account for WooCommerce Product Export to Sheets

After you press "Authenticate", the Google authentication window will open in a browser. Select the account to which you want to connect and grant eMagicOne Store Manager Import/Export tool the permission to access the drive:


Grant Store Manager for WooCommerce Access to Google Drive
Grant Store Manager for WooCommerce Access to Google Drive

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
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
Insert New Sheet for WooCommerce Product Export

Press Next to proceed.

4. Select what fields will be exported

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
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
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.


Export WooCommerce Products to Google Sheets Preview
Export WooCommerce Products to Google Sheets Preview

Let’s check the data. As you can see, the products with all their fields were successfully exported.


WooCommerce Product Export to Google Sheets Result
WooCommerce Product Export to Google Sheets Result

You can make the changes in the file and update existing products by importing them back via the import wizard.

Try Store Manager to integrate your WooCommerce store with Google Drive to speed up product management!

Export products to Google Sheets via Store Manager for WooCommerce!

Try now FREE

COMMENTS
Be the first to comment.