Can you bulk edit stock quantities on WooCommerce variations for free? Yes. WooCommerce ships with a basic bulk stock action, but it only sets every selected variation to the exact same quantity, which is rarely what a real inventory update needs. To set different stock numbers per variation in one pass, and do it for free, you need a spreadsheet-style bulk editor added on top of the default admin screen.
Here is what that actually looks like in practice, plus where the built-in tools stop being useful.
What WooCommerce Gives You Out of the Box
Open any variable product’s Variations tab and you will find a bulk edit dropdown at the top. It includes options like “Set stock” which lets you type one number and apply it to every variation you have selected. That is genuinely useful in one narrow case: restocking a product where every variation should hold the same quantity, like a batch of identical items that only differ by color.
It breaks down immediately once your variations need different numbers. A shirt in Small might have 40 units left while XL has 6. A phone case in black might be your bestseller with 200 in the warehouse while a limited color has 15. The built-in bulk action cannot express “set these different amounts for these different rows” in one action. You are back to opening each variation panel individually, which for a product with 40 or 60 variations turns a five-minute stock sync into a task you keep putting off.
Why Stock Updates Are Different From Price Updates
Stock numbers change more often than prices. Prices might get touched once a season. Stock changes every time you receive a shipment, run a sale, or reconcile your warehouse count against what WooCommerce shows online. That frequency is exactly why a slow editing process becomes a real cost. If updating stock takes an hour, you either do it less often than you should, which risks overselling, or you eat the hour every time, which adds up over a year.
The Free Spreadsheet Approach
The plugin Variation Spreadsheet for WooCommerce is built specifically to close this gap, for free. It adds a grid view to your variable products so every variation shows up as its own row with an editable stock column, alongside SKU, price, and the attribute values. You type a new number into any cell, and it behaves like an actual spreadsheet, including the ability to fill a value down multiple rows at once when several variations received the same shipment quantity.
| Task | Default WooCommerce editor | Spreadsheet-style bulk editor |
|---|---|---|
| Set all variations to the same stock number | Built-in bulk action, works fine | Also works, one click |
| Set different stock numbers per variation | Manual, one panel at a time | Type into each row’s cell directly |
| Update 50+ variations after a shipment | Slow, high chance of missed rows | Fast, all rows visible at once |
| See SKU and stock together while editing | Requires switching between fields | Both columns shown side by side |
Step-by-Step: Updating Stock Across Many Variations
- Install and activate Variation Spreadsheet for WooCommerce from Plugins, Add New in your WordPress dashboard. The free version needs no license key.
- Open the variable product you need to restock, in Products.
- Switch to the spreadsheet grid view added by the plugin.
- Find the stock quantity column. Each row corresponds to one variation, shown with its size, color, or other attribute so you know exactly what you are updating.
- Type the new quantity into each cell that changed. For rows that received the same amount, set one and copy it down to the rest instead of retyping.
- Double check any variation you are setting to zero, since that should usually also flip its stock status to out of stock rather than just show a zero with the product still marked available.
- Save the grid to apply every change in one update.
- Refresh the storefront product page to confirm stock and availability labels are showing correctly for a couple of the variations you just changed.
Keeping Stock Status in Sync
One detail that trips up a lot of store owners: WooCommerce variations have both a stock quantity number and a separate stock status field (in stock, out of stock, on backorder). If you are managing stock manually and only touch the quantity number, a variation can end up showing zero units but still marked “in stock” if the status field was never updated to match. When you enable manage stock at the variation level, WooCommerce normally updates status automatically as quantity hits zero, so this mostly matters if you have manage stock turned off for some variations or you are bulk-editing status separately from quantity. Worth a quick check after any large stock update.
Low Stock Thresholds
If you use WooCommerce’s low stock notification, remember it applies per variation based on the store-wide threshold set under WooCommerce Settings, Products, Inventory, unless you override it individually. After a big restock, you generally will not need to touch this. After a bulk stock reduction, such as correcting a count that was wrong for a while, check that your threshold still makes sense so you are not flooded with notification emails for variations that were always going to run low.
CSV Import as an Alternative
You can also update stock through WooCommerce’s CSV import tool, mapping a stock column and re-importing. This suits businesses that already generate stock counts from a warehouse system as a CSV export and want to feed that file straight in. For manual updates typed by a person, though, it adds friction: exporting, opening the file, editing the right column among many others, saving it correctly, and re-importing with the right settings. A spreadsheet grid inside WordPress skips all of that and lets you type the numbers where you can see them next to the product.
Paid Tools Cover the Same Ground
Plugins like WP Sheet Editor and Barn2 offer comparable bulk stock editing, but both sit behind a paid license. If your store’s need is a working spreadsheet view for stock and price across variations, including catalogs well past a hundred variations, a free plugin handles that without a subscription. Reach for a paid tool only if you find yourself needing a specific feature the free version genuinely lacks.
Bottom Line
Stock updates should not eat into your week. A free spreadsheet grid turns a repetitive, error-prone task into a five or ten minute job you can actually keep on top of every time inventory changes.