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

WooCommerce Store Manager Export Products To Spreadsheet
Press Export data to export products to Google Sheets

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.


WooCommerce Store Manager Product Google Sheet Export Filter Products
Filter products before export

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.

WooCommerce Store Manager Export Product Add Cloud Storages
Add Cloud Storage and give it a meaningful name for faster recognition

After you press OK, 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:


WooCommerce Store Manager Allow Access To Google Drive
Allow 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:


WooCommerce Store Manager Product Google Sheet Export New Sheet
Select or add new Google Sheet

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:


WooCommerce Store Manager Product Google Sheet Export Date Macro
Add Date macro to automatically name new sheet after current date

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:


WooCommerce Store Manage Product Google Sheet Export Select Fields
Select product fields to export

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.

WooCommerce Store Manager Spreadsheets Product Export Options
Configure product export options

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.


WooCommerce Store Manager Product Google Sheet Export Finish
Finish the export and send or check file

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


WooCommerce Products Exported To Google Sheets
Check the products exported to Google Sheets

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.