Do you need to enable “Sold Individually” for many products in your WooCommerce store? Whether you’re selling limited-edition items, personalized products, high-value goods, or simply want to prevent customers from adding multiple quantities of the same item to their cart in one order, this setting is incredibly useful.
When “Sold Individually” is enabled, customers can only purchase **one unit** of that product per order. If they want more, they’ll need to place a separate order. This helps control inventory for unique or restricted items like custom prints, event tickets, exclusive merchandise, or downloadable files.
Manually editing hundreds of products one by one in WooCommerce can take hours or even days. Imagine updating 300 products — it’s tedious and time-consuming. Fortunately, you can bulk enable Sold Individually for hundreds or thousands of WooCommerce products in just a few minutes using a powerful spreadsheet tool.
Why Use the WP Sheet Editor WooCommerce Products Spreadsheet Plugin?
The WP Sheet Editor – WooCommerce Products plugin turns your entire product catalog into an intuitive spreadsheet inside your WordPress dashboard. It includes a robust Bulk Edit tool that lets you apply changes across many products instantly. Perfect for bulk updating inventory settings like “Sold Individually,” stock levels, prices, categories, and more.
This method saves massive amounts of time compared to the default WooCommerce editor and works seamlessly with simple products, variable products, and more.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features
How to Open the WooCommerce Products Spreadsheet
After installing and activating the plugin, go to WP Sheet Editor > Edit Products. You’ll see a clean spreadsheet displaying all your WooCommerce products, where you can view, search, and edit data efficiently.
Video Guide: Bulk Enable Sold Individually in WooCommerce
Watch this quick tutorial to see the process in action:
Text Step-by-Step Guide: Bulk Set Products to Sold Individually
Follow these simple steps to enable the “Sold Individually” option for multiple products at once.
1. Open the Bulk Edit Tool
The Bulk Edit tool is your go-to for making large-scale changes quickly. It’s located in the plugin’s toolbar; simply click on it to get started.
2. Filter the Products You Want to Update (Optional)
If you want to apply the change to all products in your store, skip to Step 3.
If you only want to enable “Sold Individually” for specific products (for example, only T-shirts, only products in the “Limited Edition” category, only items with a certain tag, or only downloadable products), use the filtering options:
Select “I want to search rows to update” in the “Select the rows that you want to update” dropdown.
You’ll then see powerful search fields:
- Contains keyword — Search by product name or keywords, e.g., “Shirt”, “Jeans”, “Personalized Mug”, or “Event Ticket”.
- Status — Filter by Published, Draft, Pending, etc.
- Enter Tags / Categories / Attributes / Shipping Classes — Target specific groups, such as products in the “Clothing” category, with the “Red” attribute, or tagged “Exclusive”.
Once you’ve set your filters, click Run search to display only the relevant products.
3. Enable Sold Individually for the Selected Products
Now configure the Bulk Edit settings to set the “Sold Individually” option to Yes for all filtered (or all) products:
- Select the rows that you want to update: I want to search rows to update (or the appropriate option if editing all)
- What field do you want to edit: Sold individually
- Select type of edit: Set value
- Replace existing value with this value: Tick this checkbox (to enable it)
- Click on Execute now
Done! Your Products Are Now Sold Individually
That’s it. In just three quick steps, you’ve successfully bulk enabled the “Sold Individually” setting across hundreds of WooCommerce products. No more manual editing or hours wasted in the admin panel.
This approach works great for stores selling unique items, preventing overselling of limited stock, or enforcing one-per-customer rules for promotions and exclusives.
Common Use Cases for “Sold Individually” in WooCommerce
- Limited edition or handmade products
- Personalized gifts and custom orders
- Event tickets or bookings (one per order)
- High-value or fragile items
- Digital downloads where licensing restricts multiples
Frequently Asked Questions
Can I bulk disable Sold Individually later? Yes. Simply repeat the process and uncheck the box or set the value to “No”.
Is there a way to do this without a plugin? WooCommerce doesn’t offer native bulk editing for this field, so WP Sheet Editor is the fastest and most reliable solution.
The WooCommerce Products Spreadsheet plugin makes managing your store effortless. Bulk edit prices, stock, descriptions, images, attributes, and more… all from one powerful interface.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features