WooCommerce – How to Bulk Edit Composite Products

To bulk edit WooCommerce composite products, install WP Sheet Editor, navigate to WP Sheet Editor > Setup Spreadsheet, select Products, and click Save. All composite product custom fields will load as spreadsheet columns. You can manually edit cell values or use the Bulk Edit tool to search and batch-update pricing, component options, selection modes, and layout styles across hundreds of product kits at once without facing server timeout errors.

The WooCommerce Composite Products plugin allows store owners to create complex product kits and customizable bundles, such as custom computer builds, sports equipment setups, and camera kits. While this plugin provides advanced inventory management for component-based items, managing hundreds of kit configurations in default WooCommerce requires opening each item individually—a process that is slow, tedious, and prone to server performance bottlenecks.

Using WP Sheet Editor alongside the WooCommerce Composite Products integration allows you to view, search, and bulk-update all kit components within an interactive spreadsheet directly inside WordPress.

Key Takeaways

• Centralized Management: View and edit all WooCommerce composite products and individual component parameters in a single spreadsheet screen.
• Advanced Search Capability: Filter product kits by composite layout style (`Bto Style`), edit-in-cart settings, or component query types (`product_ids` or `category_ids`).
• Batch Updating: Mass-update component visibility, discounts, default options, and selection modes across thousands of kit items simultaneously.
• Database Auto-Detection: Use the built-in database scanner to automatically detect and display custom fields added by the Composite Products extension.
• Import & Export: Move composite product data between stores or external spreadsheet programs using CSV files.

Besides the main WP Sheet Editor plugin, install and activate the following extension to enable composite product management:

1. How to View and Manage Composite Products in a Spreadsheet

To generate and display your WooCommerce products inside the spreadsheet interface, follow these steps:

1. Navigate to WP Sheet Editor > Setup Spreadsheet in your WordPress wp-admin dashboard.
2. Select the Products post type and click Save.
3. Click Save again to include all available database columns in your spreadsheet layout.

Important: If the custom fields generated by the WooCommerce Composite Products extension do not appear immediately in your spreadsheet columns, hover over Settings in the top toolbar and click Scan DB to find fields. If they still do not appear, edit one composite product using the standard WooCommerce product editor, save it, and run the database scan again.

Standard WooCommerce Editor vs. WP Sheet Editor Spreadsheet

In the standard WooCommerce editor, composite settings (such as Layout, Catalog Price, Edit in Cart, and individual component settings) are hidden across various tabs within the Product Data meta box. WP Sheet Editor converts every setting into an actionable cell, displaying each product kit as a single spreadsheet row.

For additional details regarding technical values and database structure, consult the WooCommerce Composite Products REST API Reference.

Note: Columns containing Bto Data : 1 correspond to Component 1 of a composite product. Additional components added to product kits will automatically generate corresponding columns labeled Bto Data : 2, Bto Data : 3, and so on.

2. How to Direct-Edit Composite Products in the Spreadsheet

You can edit composite product values directly within spreadsheet cells without opening individual product settings screens.

1. Locate the composite product row and the specific column you need to modify.
2. Click on the target cell and enter or select the updated value.
3. Click Save on the top toolbar to execute the batch update process safely in the background.

3. How to Identify and Convert Composite Product Types

To confirm which products are configured as product kits, locate the Product Type column in the spreadsheet. You can also convert simple or variable products into composite products directly from this column.

1. Scroll to the Product Type column.
2. Click the dropdown cell for the target product row and select composite.
3. Click Save on the toolbar to apply the structural changes.

4. How to Search for WooCommerce Composite Products Using Custom Parameters

The standard WooCommerce admin panel limits product filtering options. WP Sheet Editor includes an advanced search tool that allows you to isolate composite products based on specific metadata parameters.

a) Search Composite Products by Product Type

1. Click Search on the top toolbar to open the search modal.
   
2. In the Enter Product type field, enter composite.
3. Click Run Search.
   

The spreadsheet will display only composite product types, excluding simple, variable, and grouped products.

b) Search for Composite Products Editable in Cart

1. Click Search on the top toolbar.
2. Enter composite in the Enter product types field.
3. Check the Enable advanced filters checkbox.
4. Set Field to Bto Edit in Cart.
5. Set Operator to =.
6. Set Value to yes (to locate editable kits) or no (for non-editable kits).
7. Click Run Search.

c) Search for Composite Products Sold Individually

1. Click Search on the top toolbar.
2. Enter composite in the Enter product types field.
3. Check the Enable advanced filters checkbox.
4. Set Field to Bto Sold Individually.
5. Set Operator to =.
6. Set Value to product or configuration.
7. Click Run Search.

d) Search Composite Products by Layout Style

WooCommerce Composite Products supports four frontend layout options:

• Stacked: Displays all components stacked vertically in a single view (`single`).
• Progressive: Displays components in sequential, toggleable accordions (`progressive`).
• Stepped: Displays components step-by-step with a final review step (`paged`).
• Componentized: Displays a configuration summary first, allowing users to configure components in any sequence (`paged-componentized`).

To filter product kits by layout style:

1. Click Search on the top toolbar.
2. Enter composite in the Enter product types field.
3. Check the Enable advanced filters checkbox.
4. Set Field to Bto Style.
5. Set Operator to =.
6. Enter one of the target database values: single, progressive, paged, or paged-componentized.
7. Click Run Search.

e) Search Composite Products by Catalog Price Setting

1. Click Search on the top toolbar.
2. Enter composite in the Enter product types field.
3. Check the Enable advanced filters checkbox.
4. Set Field to Bto Shop Price Calc.
5. Set Operator to =.
6. Enter the relevant value: defaults (Use defaults), min_max (Calculate from/to), or hidden (Hide).
7. Click Run Search.

5. How to Bulk Edit WooCommerce Composite Products

To make mass changes to multiple composite products, combine WP Sheet Editor’s search filters with the Bulk Edit tool.

a) Bulk Edit Component Title, Description, or Price Visibility

1. Filter your target composite products using the Search tool.
2. Click Bulk Edit on the top toolbar.
3. Set Select the rows that you want to update to Edit all the rows from my current search.
4. Set What field do you want to edit to Bto Data : 1 : Hide Product Title (or Thumbnail, Description, or Price).
5. Set Select type of edit to Set value.
6. Set Replace existing value with this value to yes (to hide the element) or no (to make it visible).
7. Click Execute Now.

b) Bulk Assign a Component Product to Multiple Composite Kits

1. Open Search, set Field to Bto Data : 1 : Query Type, set Operator to =, and enter product_ids. Click Run Search.
2. Open the Bulk Edit tool.
3. Set Select the rows that you want to update to Edit all the rows from my current search.
4. Set What field do you want to edit to Bto Data : 1 : Assigned Ids : 0 (adjust component index number as needed).
5. Set Select type of edit to Set value.
6. Enter the target Product ID in Replace existing value with this value.
7. Click Execute Now.

c) Bulk Enable the “Optional” Setting Across Components

1. Filter the composite products you wish to edit.
2. Open Bulk Edit and choose Edit all the rows from my current search.
3. Set What field do you want to edit to Bto Data : 1 : Optional.
4. Set Select type of edit to Set value.
5. Set Replace existing value with this value to yes.
6. Click Execute Now.

d) Bulk Change Component Options Selection Style

1. Isolate target product kits using the Search tool.
2. Open Bulk Edit and select Edit all the rows from my current search.
3. Set What field do you want to edit to Bto Data : 1 : Selection Mode.
4. Set Select type of edit to Set value (or Replace to change specific existing values).
5. Enter defaults, thumbnails, or radios in Replace existing value with this value.
6. Click Execute Now.

Set value:

Replace:

e) Bulk Set a Default Component Option ID

1. Filter your product kits in the search modal.
2. Open Bulk Edit and select Edit all the rows from my current search.
3. Set What field do you want to edit to Bto Data : 1 : Default Id.
4. Set Select type of edit to Set value.
5. Enter the target product or variation ID into Replace existing value with this value.
6. Click Execute Now.

f) Bulk Modify Component Price Display Settings

1. Locate your composite products using the Search tool.
2. Open Bulk Edit and choose Edit all the rows from my current search.
3. Set What field do you want to edit to Bto Data : 1 : Display Prices.
4. Set Select type of edit to Set value (or Replace).
5. Enter absolute, relative, or hidden in the value field.
6. Click Execute Now.

Frequently Asked Questions

Can I edit multiple components within the same composite product at once?

Yes. Each component added to a product kit is represented by its own set of columns (e.g., `Bto Data : 1`, `Bto Data : 2`). You can modify multiple component columns across different rows and save all changes in a single batch.

Will bulk updates cause server timeouts on large WooCommerce stores?

Attention: WP Sheet Editor updates data in controlled background batches rather than processing everything in a single HTTP request. This prevents memory exhaustion and server timeout errors even when updating thousands of products.

Can I import composite products from a CSV file using WP Sheet Editor?

Yes. You can import composite products from a CSV file. Ensure your CSV columns map to the corresponding `Bto` custom fields so that component choices, selection modes, and pricing rules import accurately.

What should I do if my composite product fields don’t appear in the spreadsheet?

Go to Settings > Scan DB to find fields within WP Sheet Editor. If the fields remain hidden, open and save one composite product in the standard WooCommerce editor to generate the required database keys, then re-run the scanner.

Can I undo a bulk edit if I enter incorrect values?

Attention: WP Sheet Editor applies updates directly to your WordPress database. To safeguard your site, perform a full database backup before running mass updates, or test edits on a small batch of selected rows first.