이 플러그인은 최근 3개의 주요 워드프레스 출시와 시험 되지 않았습니다. 워드프레스의 좀 더 최근 버전으로 이용할 때 더 이상 관리되지 않고 지원되지 않고 호환성 문제가 있을 수 있습니다.

GSheet For Woo Importer

설명

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.

스크린샷

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

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

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

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

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

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

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

설치

  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

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.

후기

2024년 7월 4일
Was having a issue with the new excel update and needed to upload a ton of products, this worked as it said it would, very happy from the start.Thank you, please keep this going!
2023년 8월 30일 답글 1개
This is a great plugin, and it does what it said! Set-up is so easy comparing to other similar plugins from the market. It works by converting the first sheet of a Google Sheet into CSV then pass it to the default WooCommerce product importer, making the import smooth and the use of the official importer is a great idea, as it will be always the most updated way to import products. What I would like from the further releases: Option to automatically delete the CSV after the import is finished, as it will add a few files to the Media Gallery; Automatically product import cron, daily, hourly, etc. Export products from WooCommerce to Google Sheets using like it does when importing, only that when you export to put CSV data automatically into the selected Google Sheet Automatically product export cron, daily, hourly, etc. Ideally would be to support multiple Google Sheets, as it can differ from use-case to use-case, for example I would like to have a category of products, let’s say clothes, permanently synced with Google Sheet in an hourly basis, both directions, and also would like to manually import new products from another Google Sheet.
2021년 8월 12일
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).
2020년 2월 26일
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.
2019년 12월 11일
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.
모든 5 평가 읽기

기여자 & 개발자

“GSheet For Woo Importer”(은)는 오픈 소스 소프트웨어입니다. 다음의 사람들이 이 플러그인에 기여하였습니다.

기여자

“GSheet For Woo Importer”(이)가 1 개 언어로 번역되었습니다. 기여해 주셔서 번역자님께 감사드립니다.

자국어로 “GSheet For Woo Importer”(을)를 번역하세요.

개발에 관심이 있으십니까?

코드 탐색하기는, SVN 저장소를 확인하시거나, 개발 기록RSS로 구독하세요.

변경이력

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.