Bulk Product Sync — Bulk Product Editor for WooCommerce with Google Sheets™

Description

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

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

Screenshots

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

Installation

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

FAQ

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.

Reviews

6 Փետրվարի, 2024 1 reply
For a long time, I was looking for a system that I can give to the sellers of my site so that they can directly update the products without entering the site and…This plugin is really strong, even its free version can meet all the needs of a store with a small number of products.I bought the pro version because there were many products on our siteReally great in every way
4 Հունվարի, 2024
The product didn't meet our expectations - it's frustrating, hard to operate, some functions make it even slower to do it than just do it 1 by 1 on the website, the tool lack video tutorials and support service is bad - the only thing they say is to watch 1 single tutorial they have. The Refund Guarantee doesn't work - the seller didn't respond to our emails and didn't issue the refund. Please be aware !
21 Հոկտեմբերի, 2023
Very happy with this plugin, to be able to pull this info to a google sheet and run script on the data and return it to the website with extra help from the plugin developer has been great. Would recommend and if you want to keep a stock list in google sheets it’s definitely worth the premium version. Does what it says it will and additional customisation and help from N-Media is amazing!!
23 Օգոստոսի, 2023 1 reply
We had a massive challenge to sync 30,000 products pricing every week with multiple pricing levels, sequence and stock needing updates every Monday. We were using an import tool and it was taking several days to get through it AND slowing the site down drastically. Then we found this plugin. We are now able to update our entire pricing levels, sale items, stock, sequence and more in less than 30 minutes!! Its really incredible how the brilliant authors of this plugin leverage the power of Google to get yours site updates on steroids. We also tried a few other sync plugins that were supposed to do the same thing but wouldn't work. Support from Najeeb was timely and accurate and guided us in setting up our custom fields. This has saved us a huge amount of time and headaches. The team should be commended for a great product that does exactly what it says. Thank you N-Media!!!
Read all 22 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.

Contributors

Changelog

8.2 November 13, 2023

  • Tweaks: AuthCode added in options

8.1 November 5, 2023

  • Feature: Product attributes now can be fetched

8.0 October 30, 2023

  • Feature: Setup wizard now is super easy in less than 10 secconds.

7.15 October 18, 2023

  • Bug fixed: Fetch failed when pro version deactivated, not it has message

7.14 October 16, 2023

  • Bug fixed: AutoSync issue fixed, stop sending Fetch request on AutoSync

7.13 October 10, 2023

  • Bug fixed: AutoFetch not working now it is fixed.

7.12.2 September 20, 2023

  • Tweaks: Check with latest version of WordPress

7.12.1 August 24, 2023

  • Tweaks: Demo link updated & some code optimized.
  • Info: No Major bug found

7.12 July 27, 2023

  • Bug fixed: When type column is not given it show warning

7.11 July 20, 2023

  • Bug fixed: categories sync issue fixed

7.10.1 June 25, 2023

  • Feature: Sync operation is more optimized for larger set of data
  • Feature: Fetch now has option to Reset/Refresh.

7.8 June 20, 2023

  • Bug fixed: Tags by names were not syncing, now these are fixed

7.7 June 17, 2023

  • Bug fixed: Fetch error fixed when used few columns like cross_sell_ids, upsell_ids etc

7.6 June 6, 2023

  • Feature: Settings page added inside plugin for connection status
  • Feature: Pro activate process made easy

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.3 May 6, 2023

7.2 May 2, 2023

7.1 April 20, 2023

7.0 April 5, 2023

6.15 March 4, 2023

  • Feature: Googleclient libraries updated

6.14 December 1, 2022

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

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

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

6.5 — January 31, 2022

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

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

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

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

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