Sync Product Information with Google Sheets™

Bulk Product Sync with Google Sheets™ for WooCommerce is a plugin that can import and export store products and categories via Google Sheets. Just one click will fetch all the existing products from your store to a Google Sheet or from a Google Sheet to your store.

Users report that Bulk Product Sync with Google Sheets™ is a lifesaver! They love using it to manage bulk products in their stores.

Video Tutorial Explaining All Features Of Bulk Product Sync

Quick Time-based links inside the video.

00:32 Install WP Plugin
02:00 Install Bulk Product Sheet Addon
02:48 Setup/Connect Sheet with Your Store
04:32 Syncing (import products from sheet to store)
05:30 Adding a New Column
05:33 Adding External Images with URL
06:45 Adding Attributes Column
08:00 Manage Column Names
08:38 Generating Attributes for Simple Products (Global Attributes vs Local Attributes)
10:12 Creating a Variable Product with Attributes
12:39 Creating Variations of A Variable Product
15:50 How to Fetch Products/Categories from Store to Sheet
17:45 Creating Meta Data (custom fields, like with ACF or custom fields)
19:25 Enabling the Auto Update Sheet (when products are updated or created in the store, they will also be updated in the sheet without any manual process)

Bulk Product Sync Plugin Features

• Sync products and categories between Google Sheets and the store
• Add, update, or remove products and categories from the sheet and have them automatically reflected in the store
• Quickly add new columns or remove existing ones from the sheet to accommodate changes in the product data
• Customize column titles using the Fields Manager menu to match the specific needs of the store
• Create attributes for simple and variable products directly from the sheet
• Create variations for variable products in a matter of seconds from the sheet
• Fetch all existing products and categories from the store into the sheet for easy management and editing
• Automatically update all products in the sheet when changes are made in the store
• Eliminate the need for manual entry of each product and category into the store
• Cloud-based solution that allows for easy management of products and SKUs from anywhere
• Share the Google Sheet with anyone to manage inventory without giving them access to the store
• Manage inventory anytime and anywhere with Google Sheets.

How do you synchronize (import products from sheet to site)?

Make sure you always have the ID column in the first place and the Sync column must be in the last place as seen in the screenshot below.

More columns can be added between the ID and Sync column and these column names must be the same as described in the products keys here.

Add product data inside each row under the headers and leave the ID and Sync values blank. And then, click on Extension > Bulk Product Sync > Sync Data. See the screenshot below.

When the sync operation is done, the product automatically gets assigned the ID value and the Sync column also sets its value to OK.

How do you update the product?

When the product(s) need to be updated from sheet to site, the sync column value must be blank, which means remove the OK value and click again on Extension > Bulk Product Sync > Sync Data.

How do you fetch products and categories from site to sheet?

To populate your sheet with existing products in your store click Extension > Bulk Product Sync > Fetch Data (select products). It will fetch all the products from your store to the sheet4

Resetting or unlinking data

At any point, the link between a sheet and the store can be reset. This means there will not be any connection between store products, categories, and sheet data. The Sync Row # will be set to “Not synced” as seen below.

When a product or category is linked, the Sync Row # column will show the row number.

Requirements

Minimum PHP version: 7.1