How to Update Stock in WooCommerce
WooCommerce can automatically track stock quantities for products and variations, reducing available inventory as products are sold. But when you need to update stock levels in bulk, it’s important to match each new quantity to the correct existing product without changing its price, description, or other details.
In this article, we’ll show you how to use WP All Import to update stock for a variety of scenarios.
Table of Contents
- Typical Scenarios When Updating Stock in WooCommerce
- Updating Stock in WooCommerce Using a New Import File
- Updating Stock in WooCommerce Using an Updated Import File
- Updating Stock in Woocommerce Through Bulk Edits
- Final Thoughts
Typical Scenarios When Updating Stock in WooCommerce
There are three typical scenarios when updating stock in WooCommerce:
- You have products already in WooCommerce, but a third party maintains the stock count and sends you a file you haven’t imported before.
- A third party sends you an updated version of a file you’ve imported previously.
- You need to edit stock levels across your store more efficiently than the WooCommerce interface allows.
WP All Import handles all three scenarios by matching import file data to existing products and updating only the stock field, without creating duplicate listings or altering unrelated product data. I cover each scenario below.
Updating Stock in WooCommerce Using a New Import File
In this scenario, a third party has sent you a file with a structure you haven’t imported before, and it contains stock levels for products you’ve already created or imported. The goal is to update those existing products, not create new ones.
WP All Import matches incoming file data to existing WooCommerce products by SKU and applies only the fields specified in the import settings, so a stock-only file changes stock quantity and nothing else.
Step 1: Create a New Import for WooCommerce Products
Navigate to All Import › New Import, load the product file, choose Existing Items, and select WooCommerce Products as the import type.

Step 2: Review the Product Import File
This screen lets you check the structure and content of the import file. As you can see below, the file is very simple, containing only a few key product fields along with the stock field.

Step 3: Map Incoming Stock Level Data to the Stock Qty Field
Map the incoming stock data element to the Stock Qty field in the Inventory tab of the WooCoommerce Add-On section of the Drag & Drop screen:

Click the Continue to Step 4 button at the bottom (not shown).
Step 4: Match Existing Products and Update the Stock Qty Field Only
In the Import Settings screen:
- Choose Custom Field in the section titled Records in this import file will be matched with Products on your site based on…
- Drag and drop the sku data element to the Value field.
- Select the Choose which data to update option in the section titled For each record in this import file, every time this import is run…

In other words, you’re matching the incoming data to your existing products based on SKU, and you’re only going to update specific fields, which you get to specify further down the screen:

Click Continue at the bottom of the screen (not shown).
Step 5: Finish the Update
Click the Confirm & Run Import on the next screen. When the import completes, your WooCommerce stock levels should be updated as expected.

Updating Stock in WooCommerce Using an Updated Import File
In this scenario, a supplier or distributor sends you a new version of a file you’ve already imported once.
WP All Import saves every setting from an import the first time you run it, including field mappings and matching rules. This means updating stock from a revised file only requires re-running the saved import. You do not need to reconfigure anything.
Go to All Import › Manage Imports and click Run Import for the import you ran previously. WP All Import applies the updated stock levels to the matching products automatically.

Updating Stock in WooCommerce Through Bulk Edits
In this scenario, you need to change stock levels across your store more efficiently than the WooCommerce interface allows, and there’s no supplier file driving the update.
WP All Import exports existing products to a spreadsheet, letting you edit stock quantities using copy-and-paste, search-and-replace, or formulas across hundreds of rows at once. Re-importing the edited file applies the changes directly to the matching products.
Step 1: Export the Products You Want to Edit
Navigate to All Export › New Export and create a new product export:

In Action 3 above, you can see that we created a filter to limit the export to simple products only. For more information on filters, see Filtering Import Data with XPath.
After you click the Customize Export File button, you’ll be brought to the Drag & Drop interface. Here, you simply drag and drop your export columns from the available fields on the right into the column selection area on the left. In this case, make sure you drag and drop the Stock field:

Click the Continue button, followed by the Confirm & Run Export button on the next screen. When the export completes, you’ll see this screen:

To download your export file, click the blue CSV button.
Step 2: Change the Stock Levels in a Spreadsheet
Open the product CSV file in your favorite spreadsheet and use copy-and-paste, search-and-replace, and formulas to make large-scale changes to your stock quantity data.
Save your changes.
Step 3: Reimport the Updated Stock Levels
Go to All Export › Manage Exports and locate your recent export. To import your changed file, simply click the Import with WP All Import option on the right:

This will create a new import:

Upload your changed file, then click Continue to Step 2. This will bring you to the Drag & Drop screen. If you look at the relevant fields, you will see that WP All Import has used the information from the export to automatically map the correct fields:

It also knows which fields to update:

To apply your changes, just complete the import.
Final Thoughts
Stock data rarely arrives once. Suppliers send updated files on a schedule, inventory counts happen periodically, and bulk corrections come up as a store grows. WP All Import handles this by saving an import’s field mapping and SKU-matching settings after the first run, so applying a new round of numbers is a matter of clicking Run Import rather than rebuilding the setup.
The three methods in this article all rely on that same saved configuration, just with different starting points for the data.
How to Update Stock in WooCommerce — FAQs
Can I update stock in WooCommerce without creating duplicate products?
Yes. WP All Import matches each row in an import file to an existing product using SKU, so a stock update file changes the quantity on the matched product instead of creating a new one. Selecting the update-only matching option, rather than allowing new records, ensures no duplicates are added during the import.
Can I update WooCommerce stock without changing other product data?
Yes. WP All Import updates only the fields explicitly mapped in an import’s settings, so a file containing just SKU and stock data changes stock quantity and leaves price, description, and every other product attribute untouched.
How do I bulk update stock quantity in WooCommerce?
To bulk update stock quantity in WooCommerce using WP All Import:
- Create a new import and load a file containing SKU and stock data.
- Choose Existing Items and select WooCommerce Products as the import type.
- Map the stock column to the Stock Qty field.
- Match records to existing products by SKU.
- Select the option to update only the mapped fields, then run the import.
Can I automatically update WooCommerce stock from a supplier’s file?
Yes. WP All Import saves an import’s field mappings and matching settings after the first run, so a new file from the same supplier only requires clicking Run Import to apply the updated stock levels. The import can also be scheduled to run automatically whenever the supplier delivers a new file.
How to Update Stock in WooCommerce — Related Info
- Official Documentation: Syncing Stock Levels
- Official Documentation: How to Import WooCommerce Products from CSV and XML
- Official Documentation: How to Export WooCommerce Products to CSV, Excel, and XML
- Official Documentation: How to Bulk Edit WooCommerce Products
- The 5 Best WooCommerce Product Import Plugins
- The 5 Best WooCommerce Product Export Plugins
How to Update Stock in WooCommerce — Related Videos
Get Oxygen
Build it your way with Oxygen.
Not per year, not per site, not per seat. 60 day money back guarantee.