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.
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 Syncvalues 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 IDvalue 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.
Products sync column status when not linked.
When a product or category is linked, the Sync Row # column will show the row number.
Requirements
Minimum PHP version: 7.1
