Image & Data
Update WooCommerce Inventory from a Supplier File
Match supplier quantities to WooCommerce IDs or SKUs, apply a safety buffer and cap, and update only stock for existing products.
Price & stock update
Drop your store export and the supplier's price list — everything runs on this device.
Loading the workbench…
Share this tool
Referencing this tool on a website?
Copy an attribution link. It is optional and does not change free access.
Transparent methodology
What the result includes—and what it does not
Built for wooCommerce sellers without a live supplier integration who need to apply a recurring stock sheet without overselling or zeroing absent products.
Calculation method
- 1Supplier 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.
- 2A safety buffer is subtracted from supplier quantity and an optional maximum limits how much stock is advertised. The result never falls below zero.
- 3Supplier 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.
- 4Only 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.
Assumptions and limits
- 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.
- The update changes stock status and quantity only; it does not alter backorders, low-stock thresholds, warehouse allocation, product content, or product type.
- Variations require their own matching SKU or ID in both files. Parent and attribute relationships are preserved because those columns are not emitted.
- Run the import with Update existing products selected, and use a backup, staging site, or a small first batch before a store-wide update.
Worked example
Publish less than the distributor physically holds
Input: Supplier quantity 20 for SKU ABC-001, safety buffer 2, maximum published stock 10, current WooCommerce stock 14.
Output: A reviewed target stock of 10 and one CSV row containing only ID, SKU, Stock, and In stock?.
How to use it
Three steps. One clear answer.
- 1Enter or paste the values requested by the tool.
- 2Review the input units and choose any relevant options.
- 3Calculate, then copy or download the result you need.
Built for trust
Useful without the friction.
- No registration or paywall before your result.
- Responsive controls for phone, tablet, and desktop.
- Clear assumptions and warnings where estimates have limits.
Frequently asked questions
Can 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.
Will 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.
What 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.
Does 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.
Can 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.
Keep solving
Related image & data tools
WooCommerce Price & Stock Update
Match a WooCommerce product export with a supplier file, review price and stock changes, and download a minimum update CSV for existing products only.
Image & DataImage Compressor
Compress JPEG, PNG, or WebP images locally with adjustable quality.
Image & DataImage Resizer
Resize an image to exact dimensions while preserving aspect ratio.
Image & DataQR Code Generator
Create downloadable QR codes for text, links, Wi-Fi, or contact data.
Image & DataCompress Images to 100 KB or Any Target Size
Compress whole batches of JPG, PNG, or WebP images to 50 KB, 100 KB, 200 KB, or any custom maximum size locally.
Image & DataRemove Image Metadata
Remove EXIF, GPS, and other metadata from whole photo batches without re-encoding a single pixel.
Image & Data