Sticker Sticker
Sticker Sticker
  • 00 :

    Days
  • 00 :

    Hours
  • 00 :

    Minutes
  • 00

    Seconds
Sticker Sticker

How to install and activate Stock Sync for WooCommerce with Google Sheet Ultimate

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 activate Stock Sync for WooCommerce with Google Sheet Ultimate

Then install and activate the plugin. Now you’ll need to download the Premium plugin and license key. To do that go to https://wppool.dev/my-account/.

Login to your account to find a similar interface. From here download the Premium plugin and get your License.

How to install and activate Stock Sync for WooCommerce with Google Sheet Ultimate

Go back to the WordPress dashboard and navigate to the Plugin menu. Click on Add New and select Upload Plugin. Choose the premium plugin file you just downloaded from your account and upload it here. Also, activate the plugin on the next step.

How to install and activate Stock Sync for WooCommerce with Google Sheet Ultimate

Insert your license key on the license menu.

How to install and activate Stock Sync for WooCommerce with Google Sheet Ultimate

Next, follow the below steps to complete the setup.

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 activate Stock Sync for WooCommerce with Google Sheet Ultimate

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

How to install and activate Stock Sync for WooCommerce with Google Sheet Ultimate

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

How to install and activate Stock Sync for WooCommerce with Google Sheet Ultimate

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

How to install and activate Stock Sync for WooCommerce with Google Sheet Ultimate

Then click on Continue and then select DONE.

How to install and activate Stock Sync for WooCommerce with Google Sheet Ultimate

Finally, click on the service account ID. 

How to install and activate Stock Sync for WooCommerce with Google Sheet Ultimate

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

How to install and activate Stock Sync for WooCommerce with Google Sheet Ultimate

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 activate Stock Sync for WooCommerce with Google Sheet Ultimate

Next from the Google Cloud Platform, click on Enable.

How to install and activate Stock Sync for WooCommerce with Google Sheet Ultimate

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 activate Stock Sync for WooCommerce with Google Sheet Ultimate

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

How to install and activate Stock Sync for WooCommerce with Google Sheet Ultimate

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

How to install and activate Stock Sync for WooCommerce with Google Sheet Ultimate

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 activate Stock Sync for WooCommerce with Google Sheet Ultimate

Step 4: Adding script code

Copy the script code and go back to Google Sheets.

How to install and activate Stock Sync for WooCommerce with Google Sheet Ultimate

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

How to install and activate Stock Sync for WooCommerce with Google Sheet Ultimate

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 activate Stock Sync for WooCommerce with Google Sheet Ultimate

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 activate Stock Sync for WooCommerce with Google Sheet Ultimate
How to install and activate Stock Sync for WooCommerce with Google Sheet Ultimate

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

How to install and activate Stock Sync for WooCommerce with Google Sheet Ultimate

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 activate Stock Sync for WooCommerce with Google Sheet Ultimate

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 activate Stock Sync for WooCommerce with Google Sheet Ultimate

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