Black Friday All Access $999 $399 lifetime or 30% off any plugin with Ends in -- See deals
WooCommerce Guides November 18, 2026 12 min read

WooCommerce Bulk Stock Update: The Fast Way to Update Inventory

WooCommerce Bulk Stock Update: The Fast Way to Update Inventory

Quick Answer: WooCommerce Bulk Stock Update

A WooCommerce bulk stock update means changing the stock quantity of many products in one action instead of editing each product page by hand. WooCommerce has a built-in bulk editor, but it only reaches the products on the page in front of you and can’t pull quantities from a supplier list, which is where a stocktake of 300 items turns into an afternoon. The faster route is to edit stock in a spreadsheet and upload it once, using a tool like Products Stock Manager with Excel.

  • Native bulk editor: fine for a few products on one screen, but page-by-page and no file import.
  • Excel method: export your products, type the new quantities in one sheet, upload it, and every product updates at once.

The worked example below shows a 300-product update done in one upload, and the calculator further down puts a number on the hours it saves you.

A delivery just landed. Three hundred items, new quantities for every one of them, and a warehouse team waiting on you to mark them in stock.

You open WooCommerce and start the slow march.. click a product, change the stock number, update, wait for the reload, move to the next.

By item forty your eyes are crossing, and you still have 260 to go.

Every store that holds real inventory knows this grind.

Stock moves constantly, deliveries arrive, counts drift, and keeping WooCommerce in sync one product at a time stops being realistic the moment your catalog grows.

A WooCommerce bulk stock update fixes that. Instead of touching products one by one, you change them as a group.

This guide shows you the native way, where it hits a wall, and the faster method that handles hundreds of products in a single upload.

What a WooCommerce bulk stock update means

A bulk stock update is any change to the stock levels of a group of products made in one pass, rather than editing each product on its own screen.

Store owners reach for it in a few familiar situations:

  • After a delivery: a supplier shipment arrives and dozens or hundreds of quantities need raising at once.
  • After a stocktake: a physical count rarely matches the system, so you correct many products together.
  • Seasonal resets: restocking a whole category ahead of a busy period, or zeroing lines you are clearing out.
  • Supplier feeds: a vendor sends an updated quantity list and you push it into your store.

WooCommerce can do some of this on its own. The built-in editor is a reasonable starting point, so it is worth knowing exactly what it covers before you decide you need more.

The native WooCommerce method, and where it stops

WooCommerce ships with a bulk editor, and you can reach it without installing anything.

Go to Products in your WordPress dashboard.

Tick the products you want, choose Edit from the Bulk actions dropdown, and click Apply.

In the panel that opens, you can change stock status, and if a product has stock management enabled you can set, increase, or decrease its quantity.

For a handful of products on a single screen, that works.

The wall arrives quickly once you are dealing with real volume. The native bulk editor has limits that store owners run into fast:

  • It only touches the products on the current page

If your product list is paginated, the bulk action applies to that page alone. Updating 300 products means repeating the process page after page.

  • You type every number by hand

There is no way to feed it a supplier list or a stocktake sheet. The new quantities live in your head or on paper, and you key them in one at a time.

  • No per-product values in one go

The bulk editor is built for applying the same change to a selection, not for giving product A a quantity of 12 and product B a quantity of 47 in the same action.

  • No safety net

There is no preview and no built-in backup before the change is written.

None of this makes the native editor useless. It is built for small, same-value changes, not for pushing a whole inventory sheet into your store. For that, you want the data in a spreadsheet.

The faster way: a bulk stock update with Excel

When the native editor runs out of road, the quickest route for a WooCommerce bulk stock update is a spreadsheet.

The idea is simple. You export your products to an Excel file, type the new stock numbers in a column, and upload the file back. Every row updates in one action, however many products you have.

Products Stock Manager with Excel from WPFactory is built around exactly this flow. Here is what it gives you, and why each piece matters.

Products Stock Manager with Excel woocommerce plugin

Edit stock in a sheet you already know

You work in Excel or Google Sheets, not a cramped admin screen. Type quantities down a column the same way you would in any inventory sheet.

Match products by ID or SKU

Each row is tied to a product by its ID or SKU, so the right quantity lands on the right product with no guesswork.

Update stock and more in the same pass

The same sheet can carry stock number, stock status, regular price, and sale price. You choose which fields the update is allowed to change.

Handle simple and variable products

Each variation exports as its own row, so you can set one size’s stock without touching the others.

See a per-row result

After the upload, each row reports back whether it updated, so a mistyped ID shows up instead of failing silently.

One honest point worth making plainly.. this is an export-and-upload tool, not an on-screen grid you edit live.

The editing happens in your spreadsheet, and the plugin moves those numbers into WooCommerce.

For a bulk stock update driven by a supplier list or a stocktake, that is exactly the shape you want, because the data usually starts in a spreadsheet anyway.

How to install and set up Products Stock Manager with Excel

Setup takes a few minutes. The steps below follow the plugin’s own documentation.

Install the plugin

  1. Download the plugin zip from your WPFactory account. A free version is also available on the WordPress plugin directory.
  2. In WordPress, go to Plugins → Add New → Upload Plugin, choose the file, and click Install Now, then Activate.
  3. For the Pro version, add your license key under WPFactory → Key Manager to receive updates.

Choose what the update can change

Open WooCommerce → Stock Manager (also listed under the WPFactory menu). You will see four tabs: Update, Export, Report, and Settings.

Go to the Settings tab first. Every field is off by default, so tick Update Stock Number, plus any of stock status, regular price, or sale price you want this update to touch. Leave the rest unticked, then click Save Changes.

One requirement to check: each product you want to update must have Manage stock enabled, or its stored quantity is ignored.

Export, edit, and upload

  1. On the Export tab, click Search, then download your products as an .xlsx file. (You can also grab a sample file from the Update tab.)
  2. Open the file. Keep the headings on row 1 and start products on row 2. Put the new quantities in the STOCK column, and make sure every row has an ID or SKU.
  3. Save the file as an Excel Workbook (.xlsx). Only .xlsx is processed.
  4. On the Update tab, choose your file and confirm the prompt. Each row reports back “[ID] updated successfully” or flags a missing ID or SKU.

Back up your database before a large update, since the plugin writes changes straight to your products.

A worked example: updating 300 products after a delivery

Here is the flow with real numbers. A supplier delivery lands and 300 products across your store need new stock quantities.

Step Action Result
1. Settings Tick Update Stock Number, save Only stock will change, prices stay safe
2. Export Search, then download the .xlsx 300 products in one sheet, with IDs
3. Edit Type new quantities in the STOCK column Per-product values, done in the sheet
4. Upload Choose the file on the Update tab, confirm All 300 update in one action
5. Check Read the per-row results Any missing ID is flagged, not skipped silently

By hand, at roughly 20 seconds per product to open, edit, and save, 300 products is well over an hour of clicking.

The spreadsheet route is one export, a few minutes of typing, and one upload.

Turn a stock update into a single upload

Export your products, edit the quantities in Excel, and push them all back in one action with Products Stock Manager with Excel. It matches by ID or SKU, handles simple and variable products, and reports back on every row.

Native editor vs. Excel upload vs. CSV import

There are three common ways to run a WooCommerce bulk stock update. Each suits a different situation. Here is how they compare.

Capability Native editor Excel upload CSV import
Works across the whole catalog Page by page only Yes, one sheet Yes
Per-product quantities in one pass No Yes Yes
Works from a supplier or stocktake sheet No Yes Yes
Per-row success feedback No Yes Limited
Best for A few quick edits Regular stock updates Full catalog rebuilds

It is worth reading every row. The split is not always where store owners expect, and the “works from a supplier sheet” line is usually the one that decides which method actually fits your week.

Calculate the time a bulk stock update saves you

The number that matters is how much of your week manual stock editing eats. Enter your product count and how long one manual update takes, and the tool below shows the gap against a single upload.

The pattern is the point. Manual time climbs with every product you add. One upload stays flat whether you update 50 products or 5,000, because it is always a single action. The bigger your store, the wider that gap grows in your favor.

Which method fits your store

The right choice depends on how your stock behaves.

  • Small store, occasional edits

If you have a few dozen products and adjust stock now and then, the native editor is enough. Don’t over-tool a simple job.

  • Growing store, regular restocks

If deliveries and stocktakes are a weekly reality across hundreds of products, the Excel method pays for itself the first time you skip an hour of manual clicking.

  • Supplier-driven catalog

If a vendor sends you quantity lists, the spreadsheet route lets you push their file almost straight into your store, matched by SKU.

  • Full catalog rebuild

If you are rebuilding your entire product set from scratch, a CSV import is the right tool. For ongoing stock changes to an existing catalog, an Excel upload is faster and gives clearer feedback.

Related resources

These guides cover the wider topic of bulk editing in WooCommerce:

Run your next WooCommerce bulk stock update in minutes

For fast, accurate stock changes across your whole catalog, from a supplier sheet or a stocktake, Products Stock Manager with Excel is built for the job. A free version is on the WordPress directory if you want to try it first.

Every Pro purchase is backed by a 14-day money-back guarantee.

Frequently asked questions

How do I do a bulk stock update in WooCommerce?

You can select products under Products, choose Edit from the bulk actions, and set stock for the page you see.

For a larger WooCommerce bulk stock update, export your products to Excel, type the new quantities, and upload the file so every product updates at once.

Does WooCommerce let me update stock from a spreadsheet?

Not on its own. The native editor has no file import for stock. A plugin like Products Stock Manager with Excel adds that.. you export to .xlsx, edit the STOCK column, and upload the sheet back to update products by ID or SKU.

Can I bulk update stock for variable products?

Yes. With the Excel method, each variation exports as its own row, so you can set a different quantity for every size or color without touching the others.

Will a bulk stock update change my prices too?

Only if you let it. In the plugin’s Settings tab, every field is off by default. Tick Update Stock Number alone and your prices stay exactly as they are.

What is the fastest way to update stock for hundreds of products?

Editing in a spreadsheet and uploading it once is the fastest route for an existing catalog. The work scales with typing, not clicking, so a 500-product update takes about the same single upload as a 50-product one.

Do I need to back up before a bulk stock update?

It is wise to. The update writes changes straight to your products, so a database backup before a large upload means you can roll back if a quantity was typed wrong in the sheet.

used in this guide

Cost of Goods

Your store is leaking margin. Let's show you where. Pay once, use it on every store you run.

all access · lifetime

The plugins behind most of what we write about.

A lot of the posts here reference WPFactory plugins because that's what we build with. All Access gets you every plugin we make, on as many sites as you run. Pay once. Own it.

lifetime, once
$ 499 once
vs. $199 per plugin lifetime, pays back at your 3rd plugin
  • Every WPFactory plugin, current and future
  • Unlimited sites, no per-site caps
  • Lifetime updates, no renewals
  • 30-day refund, no questions asked