Сүрөттөө

Bulk Product Sync with Google Sheets™ is a creative, quick, and easy way to use Google Sheets™ to bulk update or create products and categories for your WooCommerce store.
Normal way to manage products/categories hactic,time-wasting,boring,difficult
To add new products to WooCommerce or even to make a single adjustment, you must go through a long-form (product edit page). Your time is wasted while you wait for login, website updates, and several clicks.

**With Bulk Product Sync ** quick,smart,few-clicks,managed
Use Google Sheets™ to add products and categories, and it only takes one click to add thousands of products to your store. Please watch this video instruction to learn more about the features and how to use it.

How It Works?

Bulk Product Sync Demo

How to use Demo

Migrations to Version 7?

Just create new sheet and connect as described in video and fetch all existing products
No need to use Template, just use your own Google Sheet.

Features

One Click Import
Sync All Your Products
Sync All Your Categories
Add/remove product fields
Sync from Store to Google Sheet™
Build using the latest Google App Script API

PRO Features

Variable Products Supported
Auto-Sync [hourly, twice daily, daily]
Logging Auto Sync
Export Existing Products into Google Sheet™
Export Existing Categories into Google Sheet™
Export Existing Variations into Google Sheet™
Metadata columns

Learn More Bulk Product Sync PRO

Use Cases

Opening a new store Add all of your products to the Google sheet, select Sync Products and bask in the joy.
Managing an existing store To manage any updates or new products, export all of your products from your store to Google Sheets.™
Managing the stock If the present solution’s stock management is driving you crazy, use Bulk Product Sync to add manage_stock and quantity columns to the sheet, and you’ll be free of the problem.
Managing the price Price changes were frequent due to the economy’s instability; however, Bulk Product Sync will now adjust product prices in bulk for your store.
Variable products In WooCommerce, it is difficult to create variations and variable products; however, Bulk Product Sync has made this process quite simple and quick.
Much more … As per your needs

Скриншоттор

Import products from Google Sheet™ to store
Showing products sync status in admin
Google Sync™ columns
Settings page

Орнотуу

Download the plugin and activate it
Go to WooCommerce > Settings > Google Products
Enter your Google Credentials
Enter WooCommerce API/Secret Keys

FAQ.KG

What is the difference between Pro and Free versions?: The only import option in the free version is from a Google Sheet™ to the store, and some fields, such as images, and variable products, cannot be imported. As mentioned above in the PRO features list, you can export (from store to Google Sheet™) and do much more when using the Pro version.
Can I fetch my existing products/categories?: Yes, in Pro version
Should I need to connect with my own Google Account?: Yes
When connecting for the first time to Google Sheet™, why do we notice a warning? Is this harmful?: It’s because the scripts we uploaded to the Google Sheet™ require certain permissions in order to run. Allowing these permissions is not problematic, since, for privacy reasons, we only have access to the current Google Sheet™, not the whole Google Drive.
How to link product metadata (custom fields)?: Watch this video
How to set up AutoSync?: Watch this video

Сын-пикирлер

mudassarhanif Июнь 4, 2023-ж. 1 reply

Our store has over 10,000 products and it's always a hassle managing and maintaining big inventory, we tried Uncanny and Zapier and found those two complex and pricy whereas this Bulk Sync by N Media is the best solution we have found so far. The installation and set-up instructions were fairly easy, now we can make changes to the products in bulk and it works both ways, it lets us fetch data from the store and lets us sync back to the store as well. There was only one column "tags" not fetching data properly and the team was really quick to communicate back and forth with us and they resolved the issue quickly. Thank you guys, your plugin is great and your team was very helpful!

ncamino Апрель 10, 2023-ж. 2 replies

It really helps to improve the administration of your business in a very easy way, through a simple google sheet. In particular, I needed support and the service was and is professional, kind and, above all, you can trust him.

Diego de Guindos Февраль 28, 2023-ж.

This plugin is amazing. It makes so easy managing a Woocommerce store especially when having lots of products. It is not very intuitive but there are step-by-step tutorials that guide you through the process and once you have use it a couple of times it is super easy to use and can literally make hundreds of changes on a Google Sheets and sync them with a click. I've used it with a few clients and has saved me hundreds of hours. Also, the support is really good. They are constantly improving the product and answer very quickly to requests. Top plugin!!

eldeco Февраль 24, 2023-ж.

It is great to be able to threat all your products in a spreadsheet sync with your woocommerce, makes very easy bulk changes and also apply them calculations on. About support I can only say that two times I need them it is been quick and helpful. 5 STARS!

kalex777 Февраль 23, 2023-ж.

I have been discouraged from officially opening our multi-vendor eCommerce store for three years just because of how tedious it was to get new products into the system. I am glad I crossed paths with this plugin. Now, I'm set to run.

khansenwest Ноябрь 23, 2022-ж.

I was looking specifically for something that would create a link between a spreadsheet and Wordpress and this does a fantastic job! It took me a bit to get it setup, but after some quite support from Najeeb we are rocking over 1000 products for quick updates of prices and categories. Thanks so much!

Read all 15 reviews

Contributors & Developers

“Bulk Product Sync – Bulk Product Editor for WooCommerce with Google Sheets™” is open source software. The following people have contributed to this plugin.

N-Media

Translate “Bulk Product Sync – Bulk Product Editor for WooCommerce with Google Sheets™” into your language.

Interested in development?

Browse the code, check out the SVN repository, or subscribe to the development log by RSS.

Өзгөртүүлөр

7.5.3 June 4, 2023

Bug fixed: Debuggin removed which cause error in fetching.

7.5.2 June 3, 2023

Bug fixed: Larger chunks for product issue is fixed.

7.5 May 24, 2023

Bug fixed: Due to PHP version code is updated to work with all versions.

7.4 May 10, 2023

Bug fixed: Sync operation slow issue fixed.

7.3.1 May 8, 2023

Bug fixed: During sync operation old installations were stucked.

7.0 April 5, 2023

Feature: Bulk Product Sync is now released as Google Addon
Feature: Removed Time-out issues for larger chunks of products
Feature: Manage columns names
Feature: Product attributes generator for variable and variations in one click

6.15 March 4, 2023

Feature: Googleclient libraries updated

6.14 December 1, 2022

Bug fixed:Data validations applied as per standards
Due to some branding issues name changed from GoogleSync to Bulk Product Sync

6.13 December 1, 2022

Bug fixed: Grouped products were not being synced and fetched, now it is fixed.

6.12 September 1, 2022

Bug fixed: HTML entities were not decoding in short_description and title

6.11 August 22, 2022

Bug fixed: All categories were being pulled, now it is fixed now
Feature: Categories and Tags now can be set with Names also.

6.10.3 July 19, 2022

Bug Fixed: Upsell Ids issue fixed

6.10.2- May 11, 2022

Bug fixed: Variation image was not being fetched. Now it is fixed.

6.10.1 – May 11, 2022

Feature: Fetch operation is optimized to make it more speedy.
Bug fixed: A minor bug fixed due to the last update regarding the Reset function.

6.10 – May 11, 2022

Bug fixed: Product fetch issue fixed

6.9 – April 28, 2022

Bug fixed: Variations were not being fetched

6.8 – March 14, 2022

Feature: Disconnect with current connect feature added.

6.7 – February 21, 2022

Bug fixed: Dimensions update issue fixed
Bug fixed: Fetch issue fixed when the dimensions are added

6.6 – February 1, 2022

Bug fixed: Product fetch issue fixed in PRO version

6.5 – January 31, 2022

Bug fixed: Meta data export issue fixed

6.4 – January 26, 2022

Bug fixed: Synback issue fixed with some keys like variations, cross_sell etc
Tweaks: set_transient replaced with udpate_option function to save chunks.

6.3 – December 20 2021

Feature: Now product status can be set for syncback (exporting to sheet) as pro feature

6.2 – December 2 2021

Tweaks: Some links added on the admin side

6.1 – November 17 2021

Connection issue fixed

6.0, October 13, 2021

Feature: Now sheet will connect is much easier with Google Service Account

5.2.1, October 13, 2021

Bug fixed: Fetch products issue fixed when some fields have NULL values

5.2, October 13, 2021

Fetch products issue fixed in PRO version

5.1, October 13, 2021

Tweaks: Some error messages optimized
Tweaks: IDs not pull issue explain here

5.0, September 18, 2021

Feature: Removed un-used Google Libraries, now plugin files reduced from 17Mb to 1.5Mb
Feature: Large chunks of data can be exported
Feature: QuickConnect – No need to create Google credentials, all will be done via Najeebmedia Google App

4.0, August 22, 2021

Features: Now product meta can be added as a separate column
Features: Sync operation is optimized to handle more products in less time.

3.1 – August 4, 2021

Bug fixed: Tags were not adding from sheet to store, it is fixed

3.0 – June 14, 2021

Features: Major update to manage sync from the Google Sheet menu
Features: Google App script used to send products from Google Sheet™

2.6 – May 13, 2021

Bug fixed: Critical error fixed when google client is not set

2.5 – April 18, 2021

Bug fixed: Error occurred in last version

2.4 – April 18, 2021

Bug fixed: Images import issue fixed

2.3 – March 26, 2021

Tweaks: Unnecessary files removed
Bug fixed: Sync Back chunk size not linked, it is linked now.

2.2 – March 11, 2021

Feature: Now the Orders & Customers data can be synced with Add-on
Bug fixed: Metadata syncing issue fixed

2.1 – March 3, 2021

Bug fixed: Variations syncing-back issue fixed
Tweaks: Warnings removed, performance increased.

2.0 – February 23, 2021

Features: Chunked syncing – best approach for larger data sets
Features: Calling WC API internally, no need for WC API key and secret key

1.5 – February 10, 2021

Tweaks: Optimized the sync speed
Bug fixed: PRO: Variations images issue fixed when import/sync

1.4 – February 8, 2021

Features: Response message added for sync-back
Bug fixed: REST API endpoint warning issue fixed
Bug fixed: PRO: Sync-back products/categories limits removed

1.3 – February 1, 2021

Features: Now existing products can be added to Google Sheet™

1.2 – December 11, 2020

Features: Now images can be added via URL

1.1 – November 10, 2020

Bug fixed: Product delete sync-back not working, fixed now

1.0.0

Initial Release