SKSolveKit

Neither file is uploaded

WooCommerce · Stock

Update WooCommerce Inventory from a Supplier File

Needs two files: your WooCommerce products export and the supplier's CSV or XLSX stock sheet. Matches by ID or SKU, applies a safety buffer and cap, and updates stock only.

Versión en español

Runs on this device

You need two files

  1. Your WooCommerce products export

    CSV or XLSX, exported from your store admin.

  2. The supplier's file

    Any CSV or Excel layout, read as it comes.

Your store export

Supplier price list

Preparing the local workbench: it reads both files in this tab, matches them by SKU or barcode and writes a WooCommerce update file for stock.

Nothing is uploaded — both files are open only in this tab.

Before you import it

Exactly which columns reach your store.

The file contains

ID · SKU
Identity only — used to find the row, never rewritten.
Stock · In stock?
Only when you confirm stock updating and the supplier covers the row.

Nothing else is emitted at all: a row that does not match an existing ID or SKU never reaches the file, so the importer cannot create or overwrite anything you did not review.

It never touches

  • Titles and descriptions
  • Images
  • SEO, URLs and handles
  • Categories and attributes
  • Publication status
  • Products and variants: none created or deleted

Every change is reviewed on screen before a file exists.

How it decides

The method, in three steps.

  1. 01Supplier quantities are matched with the fresh WooCommerce export by SKU or ID. Numeric quantities and common available, yes, no, and out-of-stock labels are converted to non-negative stock values.
  2. 02A safety buffer is subtracted from supplier quantity and an optional maximum limits how much stock is advertised. The result never falls below zero.
  3. 03Supplier zero can produce Stock 0 and In stock? 0 when chosen. A product absent from the supplier file is always report-only because absence is not reliable evidence of zero inventory.
  4. 04Only matched rows with changed stock enter the CSV. New supplier references, disappeared store references, and mapping exceptions stay in the audit report and no product is created.

What it assumes

Said before you upload, not after.

  • 01

    The selected supplier column must represent available quantity or a supported availability label. Ranges and supplier-specific status codes should be reviewed in the preview.

  • 02

    The update changes stock status and quantity only; it does not alter backorders, low-stock thresholds, warehouse allocation, product content, or product type.

  • 03

    Variations require their own matching SKU or ID in both files. Parent and attribute relationships are preserved because those columns are not emitted.

  • 04

    Run the import with Update existing products selected, and use a backup, staging site, or a small first batch before a store-wide update.

A real run

Publish less than the distributor physically holds

Goes in

Supplier quantity 20 for SKU ABC-001, safety buffer 2, maximum published stock 10, current WooCommerce stock 14.

Comes out

A reviewed target stock of 10 and one CSV row containing only ID, SKU, Stock, and In stock?.

Same engine, different job

If this is not the one you needed.

Questions people ask

Before trusting it with a catalog.

01Can I update WooCommerce stock by SKU from a supplier CSV?

Yes. Match the supplier reference column to WooCommerce SKU, review the match rate and quantities, then import the minimum output with Update existing products selected. ID matching is also available when the two files share product IDs.

02Will a missing supplier row set my WooCommerce stock to zero?

No. Missing rows are listed for review and receive no update. Only an explicit matched supplier quantity of zero can produce Stock 0, so an incomplete supplier file cannot silently empty the catalog.

03What do the stock buffer and maximum do?

The buffer is subtracted first to reduce overselling risk when the same distributor stock serves several retailers. The maximum then caps the published amount; for example 20 minus 2, capped at 10, becomes 10.

04Does inventory mode create new WooCommerce products?

No. Supplier references not found in the current store export are report-only. The CSV contains only IDs or SKUs already present in that export and fields for stock quantity and stock status.

05Can this synchronize multiple WooCommerce warehouses automatically?

No. It prepares a reviewed native product-import file for one catalog snapshot. It does not connect to APIs, schedule synchronization, or allocate quantities across warehouses or inventory extensions.

Where the rules come from

Checked against the importer's own documentation.

Reviewed

Share this tool

Referencing this tool on a website?

Copy an attribution link. It is optional and does not change free access.

Useful next stepWooCommerce Price & Stock UpdateNeeds two files: your WooCommerce products export and the supplier's CSV or XLSX. Review price and stock changes and download a minimum update CSV for existing products only.