Bulk Product Editor plugin allows you to create and edit your WooCommerce products and categories with Google Sheets.

Managing products like creating, updating inventory and prices, or updating images, short descriptions, or titles for SEO across multiple products is very hectic and time-consuming. So, rather than focusing on marketing or sales strategy, most of your time is being eaten up by bulk product or category management. Bulk Product Editor is the ultimate solution. Our plugin provides the easiest and quickest way to manage your products and categories with Google Sheets. Google Sheets are amazing when it comes to managing tabular data in the cloud. We have built a Google Sheet Addon, approved and listed by the Google Marketplace. No complex or tricky setup, no need to generate API keys — just run our connection wizard, and your store will be connected in less than a minute. Now you can manage your products and categories with ease. Adding a new product or updating an existing product in Google Sheets is really easy and quick, and thousands of products can be pushed or fetched in one click.

Watch Video Guide

What is Sync Vs Fetch?

Sync means to push your products from Google Sheets to your connected store, and Fetch is the reverse, i.e., to pull products from your store to Google Sheets.

How to fetch products from my store?

• Just click BPS Menu > Fetch
• Click Fetch Products
• Make sure you set the chunk size as per your need
• Chunk means how many products will be pushed and pulled in one round. Recommended: 200–300

Can custom fields or taxonomies be attached?

• Yes, create a new column in the sheet and set the header name.
• E.g., if you want to add seo_title as a custom field, set the header name to seo_title
• Note: this seo_title must be set inside the Manage Fields menu first

Live Demo

• Check all features in the Live Demo
• This demo has already installed BPS Free and Pro versions.
• When the demo is ready, please follow the instructions as explained here

Features

• One-Click Import
• Sync All Your Products
• Sync All Your Categories
• Add/remove product fields
• Sync from Store to Google Sheet™
• Built using the latest Google App Script API
• Dynamic Custom Taxonomy Support

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
• Custom Taxonomy Support (product_brand, etc.)

Start managing your store with WooCommerce Bulk Products Editor

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.