Description
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.
Screenshots
Set your standard woocommerce import file to google drive. Click link where you can find google console developer. In the search input type "google drive" and click on the first tip "Google Drive API".
If it is your first project in google developer console and you have never created a project before, then the system will ask you to create a new one, click button "Create".
Then you will be redirected to the project settings page, for our needs, there will be enough standard project options and you can just click button "Create" on this page.
In the next page, the system will ask you to enable google drive api for your new project, then just press button "Enable".
Then you will be redirected to the main google drive api info page where you can create new credentials if you have not created them before. Just click button "Create Сredentials".
In the next page, the system will ask you to fill the form out with data for your credentials, please fill it in the same way as you can see on the screenshot below and press the button "What credentials do I need".
In the next page you will see the next form for your credentials, feel free to choose any service account name in the appropriate field and select role project -> editor, key button type leave default json and press button "Continue".
After all, the system will offer you to download the api key json file. Save it on your local machine and then you can close google developer console browser tab. Please copy the client_secret json key (all file content) that you have received in the previous step to appropriate input in option plugin page. Please find client_email in client_secret json file and copy it to your buffer for the next step.
Open your google sheet file that you set to your google drive in step 1 and share access to it with client_email email that you copy to buffer in previous step.
Then copy the name of the google sheet file to appropriate plugin setting field "Google sheet title" and press the submit button.
If you properly set your setting then after all you can find additional import button near standard import woocommerce button on a product page.
Installation
- 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.
- Full instruction about plugin options you can find on our github plugin page
FAQ
-
Where I can get “Google drive API client_secret json” for a plugin settings
-
Instructions about plugin options you can find on our github plugin page
Also you can follow instructions on a screenshots below.
Reviews
Contributors & Developers
“GSheet For Woo Importer” is open source software. The following people have contributed to this plugin.
Contributors
“GSheet For Woo Importer” has been translated into 1 locale. Thank you to the translators for their contributions.
Translate “GSheet For Woo Importer” into your language.
Interested in development?
Browse the code, check out the SVN repository, or subscribe to the development log by RSS.
Changelog
2.1.1
- Fix – move plugin functionality to new Google v4 API
2.0.3
- Fix – Php warnings with not stable google API library.
2.0.2
- Dev – Add new google API connection “Auth Code” method.
- Dev – Add notice on product page if plugin setting do not set completely.
- Dev – Add new system error notification.
1.1.5
- Fix – Fix PHP fatal error on a log activity #9
- Fix – Fix PHP warnings on setting plugin page.
- Fix – Fix link to setting page.
- Dev – Add WP v-5.6 and PHP v-8 compatibility.
1.0
- Initial release.