Import woocommerce products from google sheet by using native woocommerce importer.
Standard woocommerce import, that was introduced by woocommerce team since version 3.1, became a great plugin feature that lets you not use additional plugins and extensions for product import processes. However, if it’s a pain every time when you’re loading csv import files from your local machine, then import-products-from-gsheet-for-woo-importer is a great choice that lets you not to do it anymore. Just set your google sheet name that you store on your google drive once and in the future you will only have to press the button “Import” as usual. Plugin itself will pull the new data from the specified google sheet table.
This plugin that extends standard woocommerce import products functionality and lets you import, not only from a local file, but also from your google sheet file which you store on your google drive and can be edited by any member of your store team.
Full instruction about plugin options you can find on our github plugin page or in a section with screenshots below.
Upload the plugin folder to the ‘/wp-content/plugins/’ directory
Activate the Woocommerce Import Products Google Sheet plugin through the ‘Plugins’ menu in WordPress
Go to Woocommerce Import Products Google Sheet Settings menu to make main settings.
Connecting to the Google Drive API to import a spreadsheet of all product information is so much faster than updating them one-by-one on WordPress.
This allows a quick connection to your Google account and product spreadsheet.
The only error I've encountered was choosing to import products by both ID and SKU at the same time (just choose one).
I tried various plugins for bulk edit and import Woocommerce products and only this one worked perfect.
Google Sheets can import properly .csv file exported from Woocommerce products page. After edit table, you can import and update products with this plugin. You can match fields while import, so i think this way will work for other e-commerce softwares's product table files.
Oleg Apanovich, thank you so much.