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
- Select 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 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.
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.
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:
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:
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:
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:
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.
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.
Let’s check the data. As you can see, the products with all their fields were successfully exported.
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!