The WooCommerce Bulk Product Editor – Google Sheet Integration is a WooCommerce plugin that connects your WooCommerce store with Google Sheets, enabling bulk editing and real-time syncing of product data. It helps store owners and managers bulk update or create products and categories without having to manually update each product within the WooCommerce dashboard.

Google Sheets offers flexibility, real-time collaboration, and cloud-based storage. Instead of struggling with manual updates, you can:

• Edit multiple product listings simultaneously
• Share access with your team
• Track changes with Google Sheets’ version history
• Perform advanced calculations for pricing and stock adjustments
• Use formulas to update prices or stock even other columns
• Use Sheet search filters to find products easily for update

• Two-way synchronization between WooCommerce and Google Sheets
• Bulk editing of product attributes such as price, stock, SKU, and descriptions
• Automatic syncing to reflect changes in real-time
• Variable product managment to handle different sizes, colors, and styles
• Scheduled updates to automate routine changes
• Multi-user collaboration for teams managing large inventories

1. Install the Plugin

• Download the free version from WordPress.org and install the WooCommerce Bulk Product Editor plugin.
• Alternatively, you can install it directly from your WordPress dashboard:
  • Go to Plugins > Add New
  • Search for sync-wc-google
  • Click Install Now and then Activate

2. Connect Google Sheets

• After installing the plugin, you need to clone the Google Sheet from this template:
  Google Sheets Template
• While you can use your own new sheet, this template includes built-in scripts required for AutoSyncing and other automation features.
• Once your sheet is ready, follow these steps:
  • Click Extensions > Bulk Product Sync with Google Sheets > Setup
  • This will launch the setup wizard, which will guide you through the configuration process.

Follow these steps to get started quickly and begin managing your WooCommerce products seamlessly! 

After setting up the integration, you can start adding products in Google Sheets, then click the sync menu option. It will update your store in a few seconds and all new products can be created. Once the product is created, its ID is assigned back to Sheet. Do not add ID for the new products. Only existing product ids can be added if you know or fetch which are described below. The columns includes:

id | name | slug | permalink | date_created | date_created_gmt | date_modified | status | date_modified_gmt | type | shipping_class_id | catalog_visibility | sold_individually | short_description | price | download_expiry | date_on_sale_from | regular_price | date_on_sale_to | sale_price | date_on_sale_from_gmt | sku | date_on_sale_to_gmt | price_html | on_sale | purchasable | downloads | download_limit | tags | virtual | button_text | tax_status | tax_class | weight | external_url | stock_status | manage_stock | grouped_products | backorders | backorders_allowed | backordered | downloadable | description | categories | brands | shipping_required | shipping_taxable | dimensions | shipping_class | reviews_allowed | average_rating | rating_count | related_ids | upsell_ids | parent_id | menu_order | purchase_note | cross_sell_ids | attributes | default_attributes | variations | stock_quantity | images | image | total_sales | featured | sync

After assigning IDs, you can edit any column and click sync to update the changes back to your store. Make sure the sync column is empty before syncing to avoid unnecessary updates. If needed, you can use the Sync All option, which ignores the sync column and updates all products at once.

Simply click the Fetch Data menu to retrieve existing products. Within seconds, all products will be loaded, allowing you to update their columns as needed.

There is a unique feature called ‘Update by SKU’, which allows you to quickly update product prices and stock. This feature uses a separate sheet named ‘SKU’, containing the following columns:

• sku
• regular_price
• sale_price
• manage_stock
• stock_quantity

Instead of updating each product manually, this feature matches SKUs with your store’s products and updates their prices and stock instantly.

To use this feature, simply click New Feature > Update by SKU, and the changes will be instantly applied to your store. This is a one-way operation, meaning updates are sent from the sheet to the store without fetching any existing data back.

With Google Sheets, you can easily:

• Apply bulk price changes using formulas (e.g., increase all prices by 10%)
• Update stock levels across multiple products in one go.

If you frequently update your products, you can automate the syncing process using Auto Sync and Auto Fetch. These features ensure your WooCommerce store and Google Sheet remain synchronized without manual effort.

With Auto Sync, you can enable a Google Sheets trigger that automatically sends changes from your sheet to your WooCommerce store. This eliminates the need for manual syncing every time you make an update.

• The trigger can be set to run based on time intervals or whenever a change is made in the sheet.
• Make sure the Sync column is empty for the products that need to be updated or created.
• This ensures only the necessary changes are sent, preventing unnecessary updates.

The Auto Fetch feature ensures that any changes made in your WooCommerce store are automatically fetched into your Google Sheet. This keeps your store and sheet perfectly in sync.

• Any updates made directly in WooCommerce will be reflected in your Google Sheet without needing to fetch manually.
• This feature runs in the background, making sure your inventory data is always up to date.

By using Auto Sync and Auto Fetch, you can fully automate your WooCommerce product updates, saving time and ensuring accuracy across your store and Google Sheet.

Managing variations for variable products can be a time-consuming task, especially when a single product has dozens of variations. Manually adding each variation in WooCommerce can be frustrating and inefficient.

With our plugin, we have simplified this process, making it quick and hassle-free. Now, you can generate variations effortlessly in just a few steps.

This feature saves you time and effort, allowing you to focus on growing your store instead of manually managing variations.

By default, we provide a set of essential columns in the Google Sheet, but you can add more columns as needed. Simply type the new column name directly in the Google Sheet and set its name accordingly.

• To add a new column (e.g., images), create a new column and name it “images”.
• Ensure the column name matches the field names listed in Manage Fields from the plugin menu.
• If a column name doesn’t match, you’ll see an “Invalid Header” error.

• You can also rename columns. For example, if you want to change “categories” to “Product Categories”, update the label in Manage Fields before making changes in the sheet.

Important Rules to Follow

• The ‘id’ column must be the first column, and the ‘sync’ column must be the last.
• All other columns should be placed between these two.
• If you need additional reference columns or formulas that are not related to WooCommerce fields, you can add them after the ‘sync’ column without affecting the syncing process.

By following these guidelines, you can customize your Google Sheet layout while ensuring smooth and error-free syncing with your WooCommerce store!

Our plugin allows you to add custom meta fields, attach products to custom taxonomies, and even manage SEO-related fields from plugins like Yoast SEO. Whether you need to store additional product details, categorize products with a custom taxonomy, or optimize your store for search engines, everything can be managed within the Manage Fields menu.

How to Add Custom Meta Fields & Taxonomies

1. Navigate to the Manage Fields menu.
2. Scroll down to the Add Custom Meta Field or Add Custom Taxonomy section.
3. Enter the meta field key or taxonomy key you want to add.
4. Once added, these fields can be used as columns in your Google Sheet.

• SEO-related fields such as SEO titles, descriptions, and focus keywords can also be handled using custom meta fields.
• For example, the Yoast SEO plugin uses the following meta keys:
  • _yoast_wpseo_focuskeywords → Focus Keyword
  • _yoast_wpseo_metadesc → Meta Description
• You can check the documentation of third-party plugins to find relevant meta keys for additional fields.

• For custom taxonomies, the column must contain the term_id (ID value) of the taxonomy, not the slug or name.
• Once configured, you can manage and sync these custom fields just like any other product data.

This feature gives you full flexibility to extend your WooCommerce product data while integrating essential SEO and custom taxonomy options seamlessly!

Categories can be managed in the same way as products, allowing you to create and update categories directly from Google Sheets. The only difference is that Auto Sync and Auto Fetch features are not available for categories.

Available Columns for Categories:

• id – Unique identifier for the category
• name – Category name
• slug – URL-friendly version of the category name
• parent – Parent category ID (if applicable)
• description – Category description
• image – Category image ID
• sync – Used to track and update changes

You can easily create and update categories by modifying the relevant columns and syncing the changes back to your WooCommerce store.

Many WooCommerce store owners have significantly reduced their workload by using this tool. For example, an eCommerce fashion brand managed to cut their product update time by 70% by switching to this integration.

The WooCommerce Bulk Product Editor – Google Sheet Integration is a game-changer for eCommerce store owners. It simplifies bulk product updates, enhances accuracy, and saves valuable time. If you’re looking for a seamless way to manage your WooCommerce inventory, integrating Google Sheets is the perfect solution.

1. Is the WooCommerce Bulk Product Editor – Google Sheet Integration free?

Some plugins offer free versions with basic features, while premium versions provide advanced capabilities.

2. How often can I sync product data?

You can manually sync anytime or set up automated schedules for regular updates.

3. Can multiple users edit product data simultaneously?

Yes, since Google Sheets allows real-time collaboration, multiple users can make edits before syncing changes.

4. What happens if a sync fails?

Check for API errors, ensure proper permissions, and verify internet connectivity.

5. Can I add new products through Google Sheets?

Yes, you can enter new product details in Google Sheets and sync them to WooCommerce.