Sticker Sticker
Sticker Sticker
  • 00 :

    Days
  • 00 :

    Hours
  • 00 :

    Minutes
  • 00

    Seconds
Sticker Sticker

How to install and use Stock Sync with Google Sheet for WooCommerce

Video Tutorial: #

Go to your admin dashboard and navigate to Plugins > Add New. Then search for “Stock Sync for WooCommerce with Google Sheets”.

How to install and use Stock Sync with Google Sheet for WooCommerce

Then install and activate the plugin. 

Now follow the below part for step-by-step instructions on the setup procedure. You can also follow this video to follow visual instructions:

Step 1: Uploading credentials.json file

First, go to your admin dashboard and click on the Stock Sync with Google Sheet. Then click on Start Setup to initiate the setup steps.

How to install and use Stock Sync with Google Sheet for WooCommerce

In the next step, navigate to the Google Cloud Platform to create a service account. 

How to install and use Stock Sync with Google Sheet for WooCommerce

After navigating to the Google Cloud Platform, click on Create Credentials and select Service account from the dropdown menu.

How to install and use Stock Sync with Google Sheet for WooCommerce

Here, set the service account name and click on CREATE AND CONTINUE

How to install and use Stock Sync with Google Sheet for WooCommerce

Then click on Continue and then select DONE.

How to install and use Stock Sync with Google Sheet for WooCommerce

Finally, click on the service account ID. 

How to install and use Stock Sync with Google Sheet for WooCommerce

Navigate to the KEY tab from the top bar and click on Create new key followed by ADD KEY.

How to install and use Stock Sync with Google Sheet for WooCommerce

Choose the JSON file format. Then download the file and upload it to the plugin dashboard. 

Step 2: Enabling the Google Sheet API

Select the highlighted Click here from the plugin dashboard.

How to install and use Stock Sync with Google Sheet for WooCommerce

Next from the Google Cloud Platform, click on Enable.

How to install and use Stock Sync with Google Sheet for WooCommerce

Go back to the dashboard and make sure to tick the checkbox. Then click on next.

Step 3: Adding Google Sheet URL

Go to Google Sheets and open a new spreadsheet where you want to store your products. Copy the URL from the browser’s address bar.

How to install and use Stock Sync with Google Sheet for WooCommerce

Paste the URL in the URL section of the plugin. Also, paste your spreadsheet’s tab name.

How to install and use Stock Sync with Google Sheet for WooCommerce

Copy the editor access ID from the dashboard and go back to Google Sheets.

How to install and use Stock Sync with Google Sheet for WooCommerce

Click on the Share option from the top right corner of the screen and paste the editor access ID. Then click on Share. If Google Sheets ask for any permission make sure to provide that.

How to install and use Stock Sync with Google Sheet for WooCommerce

Step 4: Adding script code

Copy the script code and go back to Google Sheets.

How to install and use Stock Sync with Google Sheet for WooCommerce

From the navigation tab on the top bar, click on Extensions. Then from the drop-down menu choose Apps Script.

How to install and use Stock Sync with Google Sheet for WooCommerce

There remove the existing code and paste the code you just copied from the plugin dashboard. Next, click on Next and then Run.

How to install and use Stock Sync with Google Sheet for WooCommerce

Google might ask for authorization permission in this step. In that case, click on Review permissions. Then select Hide (Advanced) and then Go to Untitled project (unsafe).

How to install and use Stock Sync with Google Sheet for WooCommerce
How to install and use Stock Sync with Google Sheet for WooCommerce

Finally, click on Allow to provide access to provide editing access to the spreadsheet.

How to install and use Stock Sync with Google Sheet for WooCommerce

Step 6: Adding trigger  #

Go to the Apps Scripts from the Extensions menu again. Click on Triggers from the left navigation menu.

How to install and use Stock Sync with Google Sheet for WooCommerce

On this window choose Triggers to add triggers for the spreadsheet. From the dropdown menu in Choose which function to run option, choose onEdit. Then click on Select event type and from the dropdown menu select onEdit again. Finally, save the settings.

How to install and use Stock Sync with Google Sheet for WooCommerce

That’s it! Go back to the plugin dashboard and get ready to live sync from Google Sheets.

Easy Video Reviews

{{startingCount}}
{{time(finishingCount)}}
{{trans(`You have no camera installed on your device or the device is currently being used by other application`)}}
{{trans(`Please try visiting this page with a valid SSL certificate`)}}
{{trans(`You can record up to %s minutes, don't worry you will review your video before sending`, time(preference.max_video_length))}}
{{trans('Seconds')}}
{{trans(`You can record up to %s minutes, don't worry you will review your video before sending`, time(preference.limits))}}
{{trans('Uploading video...')}}
{{send.message}}

{{trans('Upload video')}}

{{trans('Drag your files here or click in this area')}}
{{uploader.file}} {{uploader.size}} x