Bulk Product Editing Made Easy

Bulk Product Edit with BPS for WooCommerce is a powerful plugin that streamlines the process of managing and editing your online store’s products in bulk. Say goodbye to manual product updates and tedious data entry.

Discover how Bulk Product Edit with BPS can save you time, increase efficiency, and make your online store management a breeze.

Video Tutorial – Get Started with Bulk Product Editing

Watch our comprehensive video tutorial to learn how to use Bulk Product Edit with BPS to its full potential. We cover all the essential features and provide step-by-step guidance to make your product management effortless.

Key Features of Bulk Product Edit with BPS

• Edit product details, prices, stock levels, titles, and more in bulk using Google Sheets
• Effortlessly manage variable products and attributes with just a few clicks
• Utilize Google Query for lightning-fast data retrieval from your sheet
• Sync products and categories between Google Sheets and your WooCommerce store
• Add, update, or remove products and categories with ease
• Create custom columns in your sheet to match your store’s specific needs
• Generate attributes for simple and variable products directly from your sheet
• Create variations for variable products quickly and efficiently
• Fetch existing products and categories from your store into your sheet for easy management and editing
• Automatically update products in your sheet when changes are made in your store
• Eliminate the need for manual data entry
• Cloud-based solution for convenient product management from anywhere
• Share your Google Sheet for collaborative inventory management
• Manage inventory effortlessly with Google Sheets

How to Synchronize (Import Products from Sheet to Site)

Ensure you have an ID column as the first column and a Sync column as the last column in your sheet, as shown below:

You can add more columns between the ID and Sync columns as needed

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.

Frequently Asked Questions (FAQs)

Requirements

Minimum PHP version: 7.1