GSheet For Woo Importer

Description

This is a wordpress 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.

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.

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

  1. Upload the plugin folder to the ‘/wp-content/plugins/’ directory
  2. Activate the Woocommerce Import Products Google Sheet plugin through the ‘Plugins’ menu in WordPress
  3. Go to Woocommerce Import Products Google Sheet Settings menu to make main settings.
  4. 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

February 26, 2020
Hello, 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.
December 11, 2019
This is a good plugin, simple and usable... will help you keep a Google Sheet to update your products, you can share that sheet and keep an online inventory and import it into WooCommerce anytime.
Read all 2 reviews

Contributors & Developers

“GSheet For Woo Importer” is open source software. The following people have contributed to this plugin.

Contributors

Changelog

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.