In this tutorial, we will see how to bulk enable Sold Individually in WooCommerce. We will use WP Sheet Editor to update this setting for hundreds or thousands of products at once.
The Sold individually option limits customers to one unit of a product per order. You can enable it for all products or specific products based on categories, tags, attributes, and other search filters.
In this tutorial, we’ll show you how to bulk edit the WooCommerce Sold Individually setting using WP Sheet Editor – WooCommerce Products.
1. Install WP Sheet Editor – WooCommerce Products
We’ll use the WP Sheet Editor – WooCommerce Products plugin to bulk enable or disable the Sold Individually setting.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features
After installing and activating the plugin, go to WP Sheet Editor > Edit Products to open the products spreadsheet.
You can follow the steps below or watch the video tutorial:
2. Open the WooCommerce Bulk Edit Tool
Click Bulk Edit on the spreadsheet toolbar to open the bulk editing options.
3. Select the WooCommerce Products to Update
You can enable Sold Individually for all products or filter the products you want to update.
To update specific products, select I want to search rows to update under Select the rows that you want to update.
You can filter products using the following fields:
- Contains keyword: Find products by name or keyword.
- Status: Filter products by publication status.
- Categories, tags, attributes, or shipping classes: Find specific groups of products.
Click Run search to select the matching products.
If you want to update your entire catalog, select the option to edit all rows instead.
4. Bulk Enable Sold Individually in WooCommerce
Configure the Bulk Edit settings as follows:
- Select the rows that you want to update: Use your selected search results or all rows.
- What field do you want to edit: Sold individually
- Select type of edit: Set value
- Replace existing value with this value: Check the box to enable Sold Individually.
Click Execute now to apply the change to the selected products.
The matching WooCommerce products will now have the Sold individually setting enabled, limiting purchases to one unit of each product per order.
How to Bulk Disable Sold Individually in WooCommerce
To allow customers to purchase multiple units of a product again, repeat the bulk editing process with these settings:
- What field do you want to edit: Sold individually
- Select type of edit: Set value
- Replace existing value with this value: Leave the checkbox unchecked.
Click Execute now to disable Sold Individually for the selected products.
Bulk Manage the WooCommerce Sold Individually Setting
With WP Sheet Editor – WooCommerce Products, you can bulk enable or disable Sold Individually for your entire catalog or selected products.
You can also use the spreadsheet and Bulk Edit tool to manage other WooCommerce product fields, including prices, stock quantities, descriptions, categories, and attributes.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features




