Skip to main content

Adjust stock across many materials

A bulk adjustment corrects the stock of several materials in one request, each named by its SKU within a single store. No control for it exists on the Materials page. It is reached through the Etch Express API.

How quantities are applied

Each line carries a SKU and a quantity change. It is a change, not a new count: a positive number is added to the quantity available, a negative number subtracted. Reserved quantity is untouched. Every line is recorded as an Adjustment transaction, labelled with its own reason or, failing that, the batch reference.

Lines that fail

Lines are checked before anything is written. A SKU that is not an active item in the store fails with Item not found. A negative line larger than the quantity available fails with Insufficient stock, naming the available and requested figures. Those lines are dropped and the rest of the batch still applies. A SKU listed twice is checked against a running quantity, in the order given.

The remaining lines are written together, so if one of those items was changed by someone else in the meantime, nothing is applied and all of them are reported as failed. The result gives the number processed, succeeded, and failed, with a reason for each.

How it differs from a single transaction

Record Transaction acts on one item chosen from the materials list, and offers five types: Usage, Purchase, Adjustment, Return, and Waste. A bulk adjustment is always an Adjustment, and reports counts rather than a new quantity.

Requirements

Manager permission on Materials is required; editor is not enough. The store must also hold the Material Management addition to Core, which is checked first.

Did this answer your question?