WooCommerce Google Sheets Import
By default, WooCommerce only allows importing data from CSV. So, you will need an external solution to integrate with Google Sheets.
Store Manager for WooCommerce import tool provides this functionality along with other import possibilities. Below you’ll find a guide showing how to connect to Google Drive and import products from Google Sheets to WooCommerce successfully.
Connect Google Drive to WooCommerce
First of all, download a free trial version of Store Manager for WooCommerce, install the application and connect it to your store. When you’ve finished with the connection setup, you will see your category tree and products displayed in the application.
To connect to your Google cloud storage, launch any export or import tool with Store Manager. Let’s, for example, try to import products from a Google Sheet as we don’t have any of them in our test store yet.
In the open wizard among the available import sources, switch to “Google Spreadsheets”. Now you can add your Google Drive:
Enter a cloud storage name and press “Authenticate”:
A browser with a Google signin form will open. If you’re following the steps with us, select the account you want to connect to and press “Allow” to grant access to it:
After you’ve finished, close the browser and return to Store Manager.
Import products to WooCommerce from a Google Sheet
Now, when you have connected to Google Drive, open Drive Explorer. We’ve previously prepared a spreadsheet with products, so, we’ll select this document:
Next, select a Google sheet to import data from. If there are no column headers in your file, you just need to specify that in the settings. You’ll be able to assign columns to the database fields later in the mapping step.
The next important step is mapping spreadsheet columns to the database fields. Follow our tutorial for more information on mapping and other import settings: https://woocommerce-manager.com/useful-articles/woocommerce-product-management/woocommerce-import-step-by-step-tutorial/
When you’ve finished with mapping, check the identifier that will be used during import. You can leave SKU as an identifier if you are adding new products. If you previously exported products with IDs and now are importing them back, you can use ID as an identifier.
Move to the subsequent step where you can choose whether you want to update existing records, create new ones or do both. There are four options available:
- Add and Modify - speaks for itself:)
- Add Only - only add new products from the file and do not modify existing.
- Modify Only - update existing products and do not add new.
- Just Add - this option is used to import products to a new store. Because Store Manager doesn’t search for existing products, import completes faster.
Also, expand the Advanced options section to select a correct delimiter for the category path and specify other settings related to your specific task.
This is the final step in the wizard. You can preview data and change some settings if necessary. To begin the upload, press “Import”.
After products have uploaded, look through the results, and press “Finish” to exit.
As you can see, products with images were created in Store Manager. Let’s right-click on a product to view it at the store front:
Here is one of the imported product on our test WooCommerce store:
Use Store Manager to perform Google Drive and WooCommerce Integration. Easily import data from your multiple suppliers, export/import data for analyses and updates.