Skip to main content
Updates / How to Update Stock in WooCommerce
← All updates
 
Blog

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

There are three typical scenarios when updating stock in WooCommerce:

  1. You have products already in WooCommerce, but a third party maintains the stock count and sends you a file you haven’t imported before.
  2. A third party sends you an updated version of a file you’ve imported previously.
  3. 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.

Update Stock WooCommerce - New Product Import

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.

Update Stock WooCommerce - Review Import File

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:

Update Stock WooCommerce - Map Data Elements to Fields

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:

  1. Choose Custom Field in the section titled Records in this import file will be matched with Products on your site based on…
  2. Drag and drop the sku data element to the Value field.
  3. 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…
Update Stock WooCommerce - Import Settings

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:

Update Stock WooCommerce - Import Settings 2

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.

Update Stock WooCommerce - Confirm and Run

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.

Update Stock WooCommerce - Manage Imports

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:

Update Stock WooCommerce - New 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:

Update Stock WooCommerce - Drag & Drop Export

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

Update Stock WooCommerce - Confirm and Run Export

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:

Update Stock WooCommerce - Manage Exports

This will create a new import:

Update Stock WooCommerce - Reimport Updated File

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:

Update Stock WooCommerce - Automatic Mapping for Reimport

It also knows which fields to update:

Update Stock WooCommerce - Automatic Mapping for Reimport 2

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:

  1. Create a new import and load a file containing SKU and stock data.
  2. Choose Existing Items and select WooCommerce Products as the import type.
  3. Map the stock column to the Stock Qty field.
  4. Match records to existing products by SKU.
  5. 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.

Get Oxygen

Build it your way with Oxygen.

$199.50 once — unlimited sites, no renewal

Not per year, not per site, not per seat. 60 day money back guarantee.