Product Stock Sync with Google Sheet for WooCommerce
Introducing the Product Sync Master Plugin with Google Sheets! This handy tool simplifies WooCommerce product management by syncing products between Google Sheets and your website. Easily edit or update product information using a convenient table on Google Sheets, ensuring changes reflect on both the site and the sheet in seamless two-way sync. Stay organized and save time with this user-friendly plugin.
First, install and activate WooCommerce Plugin if you haven’t already on your website.
Steps of Activating the Product Sync Master Plugin for WooCOmmerce Product with Google Sheets:
Product Sync Master Plugin’s Settings Page:
Need your Google Spread Sheet Full URL for Product Stock Sync plugin. See following screenshot.
Paste the URL Link and Sheet’s Tab name and save the settings.
Remember: input spread sheet url again, If you change Sheet name. (Optional)
Copy the Apps Script Code from here:
Go to the Google Sheets and Click on Extensions > Apps Script:
Apps Script Code of Google Sheets:
Save and Run the Code and follow the Execution Log Message:
Trigger: Add Trigger for Google Sheets:
Set Trigger Function as Link:
Step 1: First Create New Project for Making Service JSON file.
Step 2: Now Create Service Account. and Choose a project.
Step 3: Click at CREATE CREDENTIALS Button. See screenshot
Step 4: Need to create a service account under this project:
Set the service account name:
Step 5: Click on the Created Service Account. see screenshot.
Step 6: Create new key. Follow screenshot.
Step 7: Create a JSON File by following this documentation:
Step 8: Upload your JSON file at Service File. see screenshot:
Step 9: Create API Key from this section. Click on CREATE CREDENTIALS button and then Click API Key.
Step 10: Copy the API Key following the screenshot:
Step 10: Paste your Copied API Key at API Key field. See screenshot.
Step 11: Enable the SHEET API Key from Enable SHEET API.
Step 11: Add Client Email as Editor. See following two screenshots.
Step 12: Ensure, you have already input API and Uploaded JSON file. like following screenshot.
Synchronize Product’s data to the Sheet:
Product Sync from Site to Google Sheet:
This is Google Spread sheet is Automatic connected now with your WooCommerce Site. If you change any content from Site, Google Sheet will update and And If you change anything from Google Sheet, Automatically that info will update to your site.
Quick Edit Table from Plugin:
(You can edit WooCOmmerce Product data as a Table from here by using the Quick Edit Function, it will be an easy function to edit from the site and sheet from the site easily – 2-way Sync)