WooCommerce stock updates by CSV: quantities, variations and timing

Agree what the quantity means

Record the source system, export time and meaning of the quantity. Is it physical stock, available-to-sell stock or a count that already deducts reserved units? Confirm how the source treats backorders and zero. Do not infer ‘out of stock’ from a missing supplier cell.

Decide whether this is a one-time correction or a recurring synchronization. For a one-time correction, coordinate a controlled import window and pause competing stock writers where appropriate. A recurring stock feed needs ownership and conflict-handling rules beyond a manual CSV upload.

Check where inventory is managed

Inspect representative products in staging. A simple product and a size variation may track stock at different levels. WooCommerce supports parent-level and variation-level inventory arrangements; its variable-product and inventory guides below explain the settings. Match the record being updated to the store’s actual model.

Build a narrow file using exact identifiers and the approved stock fields from an export. Keep pricing and descriptions out of a stock-only correction. Include one ordinary quantity and one deliberate zero in the pilot, and inspect stock status and backorder behavior as well as the numeric value.

Reconcile against the import window

Capture a before-export and the source timestamp. After importing, compare the intended target records with a fresh export. If orders were allowed during the run, reconcile their stock movements instead of treating every difference as a parser error.

Our synthetic update changes one mug from stock 8 to stock 12 in an isolated test store. That test has no live order traffic or inventory connector, so it cannot establish concurrency safety for a production stock feed. Use it as a field-mapping exercise, then test your own operational process with the relevant integrations enabled.

Check the result

• Quantities have a known source timestamp and business meaning.
• Parent and variation stock settings match the intended model.
• Zero stock, backorders and any concurrent order movements are reconciled.