GSheet For Woo Importer

May 21, 2023

GSheet For Woo Importer Plugin

This plugin extends standard woocommerce import products functionality and lets you import, not only from a local file, but also from your google shee …

This plugin 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 this plugin is a great choice that lets you not to do it anymore. Just set your google sheet 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 you can use shorter version with screenshots below.

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 connect your Google sheet and woocommerce import.
  4. Full instruction about plugin options you can find on our github plugin page

Screenshots

  1. <p>Go to plugin settings and press "Get Code" button in "One Click Auto Connect" tab.</p>

    Go to plugin settings and press "Get Code" button in "One Click Auto Connect" tab.

  2. <p>You will be redirected to google plugin application page. Please choose google account where you store your google sheet import file on google drive.</p>

    You will be redirected to google plugin application page. Please choose google account where you store your google sheet import file on google drive.

  3. <p>In the next page you need provide access "See and download all your Google Drive files." to plugin application.</p>

    In the next page you need provide access "See and download all your Google Drive files." to plugin application.

  4. <p>Then you will be redirected back to the plugin settings page with your access code on it. Please press "Save Options" button.</p>

    Then you will be redirected back to the plugin settings page with your access code on it. Please press "Save Options" button.

  5. <p>If code valid you will see corresponding message and new select for google sheet title where you should to choose google sheet title that become your import file.</p>

    If code valid you will see corresponding message and new select for google sheet title where you should to choose google sheet title that become your import file.

  6. <p>Sheet title you can find in upper left corner of your sheet on google drive.</p>

    Sheet title you can find in upper left corner of your sheet on google drive.

  7. <p>That all. If you set all settings properly you will receive success connection message with link to standard woocommerce import page where you can process import products with your google sheet file.</p>

    That all. If you set all settings properly you will receive success connection message with link to standard woocommerce import page where you can process import products with your google sheet file.

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 above.

Changelog

2.3

  • Fix – ‘One Click Auto Connect’ Google API connect method and remove deprecated oob link functionality.

2.2.0

  • Fix – fix error with csv get functinality.

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.

Details

  • Version: 2.3
  • Active installations: 100
  • WordPress Version: 4.7
  • Tested up to: 6.2.6
  • PHP Version: 5.6

Ratings


5 Stars
4 Stars
3 Stars
2 Stars
1 Stars