Skip to content

Stock Adjustments ​


Table of Contents ​


1. Use Cases ​

Quick links: Shelf count doesn't match the system | Write off damaged or expired goods | Trace why one product keeps going short

Case 1: The physical count on the shelf doesn't match the system ​

Situation: While working a location, you find a product has only 8 units on the shelf, but the system keeps showing 10. You don't need to recount the whole shelf with a full stock take — you just want to fix this one already-confirmed discrepancy so the book matches reality.

Use this feature: Create a stock adjustment, pick this inventory, enter the actual quantity, and the system works out the difference for you. See Create Stock Adjustment for how.

Result: The adjustment goes to pending first; once a colleague with approval rights checks it and approves, the system quantity is corrected from 10 to 8, and the correction is fully logged.


Case 2: Deduct damaged or expired goods and record why ​

Situation: A box of three units gets damaged in transit, or a batch has passed its expiry date and can no longer ship. These goods are effectively unsellable, but the system still counts them as available. You need to deduct them and clearly state why, so it can be traced later.

Use this feature: Create an adjustment, deduct the damaged or expired items, and pick a reason (such as Damaged or Expired) for each line.

Result: After approval, those quantities are deducted from stock with their reasons on record. If you later need to investigate a product's losses, you can trace who applied, who approved, and why.


Case 3: Find out why one product keeps going short ​

Situation: A warehouse supervisor notices a fast-moving product keeps needing deductions and suspects fragile packaging, a handling problem, or frequent short-counts at receiving. You need one place to see the adjustment history and the reason behind each one.

Use this feature: In the list, use the reason filter to pull out adjustments for a specific reason (such as Damaged), and open them one by one to see which products and which locations keep causing trouble.

Result: You can see where the losses concentrate — by product and by reason — and use that to improve packaging or workflow, rather than quietly topping the numbers back up each time.


2. Features ​

When the stock quantity recorded by the system doesn't match what's physically on the shelf — count discrepancies, damaged or expired goods, earlier keying errors, failed quality checks — come here to create a stock adjustment and bring the book directly in line with reality. It differs from a stock take: a stock take recounts an entire shelf and settles it, whereas an adjustment directly corrects a single, already-confirmed item. Every adjustment must be submitted and reviewed before it actually changes stock.

Stock Adjustments - Page Overview

Quick jump: Search & Filter | List Columns | Status & Reasons | Create & Approve

The search box at the top finds adjustments by keyword in "Adjustment No" or "Note"; press Enter after typing.

FilterHow to use
StatusMulti-select dropdown. To find adjustments awaiting your review, choose "Pending"
Adjustment ReasonSelect reasons (such as Damaged or Expired) to surface adjustments containing those line reasons — used to trace a specific source of loss
Created AtPick a date range to filter adjustments created within a period

"Adjustment No" can also be used as a filter (supports multiple values, pinned by default).

2.2 List Columns ​

ColumnDescription
Adjustment No.Click to open the adjustment's detail; sortable
StatusA colored tag showing current progress; see Status & Reasons
NoteThe whole-adjustment note entered at creation
ApplicantThe person who created this adjustment
Created AtSortable, newest first by default

2.3 Status & Reasons ​

Status ​

StatusWhat it means
PendingSubmitted, stock not yet changed, awaiting review. Still editable or can be rejected at this point
CompletedApproved, stock has actually changed, can no longer be edited
RejectedRejected, stock did not change

Adjustment Reasons ​

Every line item must have a reason, which makes loss analysis traceable later:

ReasonWhen it applies
DamagedGoods damaged, unsellable
ExpiredGoods past their expiry date
Count ErrorActual quantity doesn't match the system
Data Entry ErrorAn earlier keying error to correct
Quality Check FailedFailed quality inspection
OtherOther reasons; explaining in the note is recommended

2.4 Create & Approve ​

▸ Create an adjustment ​

The "New" button at the top right opens the create page, where you pick inventory, enter actual quantities, choose reasons, and submit. See Create Stock Adjustment for the full walkthrough.

▸ Import adjustments ​

To handle a large number of items at once, "Import" at the top right lets you download a template, fill it in, and upload. You need import-related permission to see this button. After submitting, check the result in the "Background Tasks" panel.

Each row finds the inventory to adjust by SKU, shelf, inventory type, batch, expiry date, manufacturing date, and custom attributes.

For the expiry date and manufacturing date, write them as YYYY-MM-DD (YYYY/MM/DD is also accepted). ⚠️ The system never guesses a date: ambiguous day/month orders such as "01/02/2026" or "01-02-2026", and two-digit years or month abbreviations such as "8-Jul-29" or "8-Jul", are rejected — that row reports an invalid date format and none of the file is imported. The safest approach is to set those two cells to text format before filling them in.

Whether the template's "Inbound Number" column is used, and what happens when no inventory matches, depends on the merchant's Inventory Traceability:

Merchant mode"Inbound Number" columnWhen no inventory has these attributes
Aggregated ModeNot used; ignored if filled. When several inventory records share the attributes, the most recently created one is adjustedA new inventory record is created (e.g. opening stock); quantities post only after approval
Isolated ModeIf filled, only the inventory created by that inbound is adjusted; blank rows follow the rules belowThe row fails; import never creates inventory

In Isolated Mode, the same product is split into separate inventory records per inbound even when its attributes match, and the import does not guess the source for you:

  • Inbound number filled: it must be an inbound of this merchant in the current warehouse, otherwise the whole file is rejected (a missing inbound, another merchant's, or another warehouse's all return the same error). If that inbound has no inventory with these attributes, the row fails. Quantities are not checked at import; whether a deduction is covered is checked at approval, the same as a manually created adjustment.
  • Blank, deduction: stock is deducted in the same order as outbound allocation (expiry date → manufacturing date → received date, with stock received on the same day in a fixed order), record by record, from sourced inventory that still has deductible quantity on that shelf; sources already used up are skipped. One row may split into several adjustment items, each tied to one inbound source. Quantities allocated to orders or held, and quantities reserved on that shelf by paper picking lists, cannot be deducted, nor can quantity already used by rows processed earlier in the same file (see "Accumulation within one file" below). If the deductible total is short, the row fails — nothing is partially deducted.
  • Blank, gain: if exactly one sourced inventory record has these attributes, the quantity is added to it; if there are several (including ones already used up), the row fails and you need to fill in the inbound number.
  • Accumulation within one file: adjustments are processed one by one in the order each adjustment number first appears in the file, and rows within an adjustment in row order. If the same adjustment number appears in separate places in the file, its later rows are processed before the other adjustments in between. Deductions processed earlier use up deductible quantity, including deductions with an inbound number; gain rows do not add back to the deductible quantity; an adjustment that is not created uses nothing.
  • Unknown-source inventory is not used by import: if the only inventory with these attributes has an unknown source, or no inventory has them at all, the row fails. See Unknown-source goods or goods with no inventory yet for what to do.

File-level errors, such as missing columns or an inbound that cannot be found, reject the whole file and create nothing. Once the file passes, adjustments are created one by one: if any row of an adjustment fails, that whole adjustment is not created while the others are, the result shows as partially completed, and each error names its Excel row number.

▸ Approve an adjustment ​

Click the "Adjustment No" to open the detail page for review — verify the items and reasons, then approve or reject. Approving actually changes stock and cannot be undone; for the steps and resulting effects, see Stock Adjustment Detail.


3. FAQ ​

Quick jump: FAQ | Notes

3.1 FAQ ​

▪ What's the difference between a stock adjustment and a stock take? ​

A stock take recounts an entire shelf and settles it in one batch; an adjustment directly and individually corrects a single, already-confirmed item. To quickly handle a known situation like "three units in this box are broken," an adjustment is fastest. For full counts, use Stock Takes.


▪ A batch number or expiry date was recorded wrong — do I use an adjustment too? ​

No. An adjustment only changes "quantity." For attributes like batch number, expiry date, or inventory type recorded in error, use a Stock Transformation; don't deduct and re-add stock with an adjustment.


▪ Why must it be submitted first and then reviewed before taking effect? ​

Adjusting stock is the same as directly editing the books — it affects sellable quantity and cost. A second pair of eyes prevents slips and mis-entries, and leaves a record of "who applied, who approved, and why" for every adjustment so it can be reconciled later.


▪ What if I can't see the "New" button or the approval buttons? ​

Creating and importing need stock-edit permission, while approving and rejecting need review permission — the two are separate. If you can't see the relevant button, ask your administrator to confirm your permissions.


▪ Why does an imported gain ask me to fill in the inbound number? ​

When the merchant uses Isolated Mode, inventory of the same product and attributes is split per inbound. If a gain row leaves the inbound number blank and two or more sourced inventory records have these attributes (including ones already used up), the system won't guess which one to add to, and the row fails. Check the "Inbound Source" of each record for this product in Inventory List, decide which inbound to add to, enter its number in the template's "Inbound Number" column, and import again.


▪ An imported deduction says the deductible quantity is short, but there is stock? ​

In Isolated Mode, a deduction with a blank inbound number only draws on quantity that is on that shelf, has an inbound source, is not allocated to orders or held, and is not reserved by a paper picking list. Common causes: the goods are on another shelf, part of the quantity is allocated to orders or held, the stock on that shelf is reserved by a paper picking list, what remains is unknown-source inventory, or deductions processed earlier in the same file (including ones with an inbound number) already used up the quantity on that shelf — see Import adjustments for the processing order. Check the shelf and quantity, fix the row, and import again; for the unknown-source part, see the next question.


▪ How do I adjust unknown-source goods or goods with no inventory yet? ​

In Isolated Mode, import only adjusts existing inventory with an inbound source and never creates inventory.

  • Unknown-source inventory (usually a stock-taking overage recorded as a new batch; the "Inbound Source" on the detail page and in the picker shows "-"): pick that record manually in Create Stock Adjustment. The picker only lists inventory that still has available quantity; if the record is not listed, use "Record Surplus" on a stock take.
  • Goods with no inventory yet (e.g. opening stock): receive and put them away through an inbound, or create them on a stock take with "Record Surplus" → "New Batch".

▪ Where do I confirm that stock actually changed after an adjustment? ​

Check the latest quantities in Inventory List, or look up the movement records sourced from stock adjustments in Inventory Movements.

3.2 Notes ​

⚠️ Important ​

  • No turning back after approval: stock truly changes the moment you approve and cannot be undone; to correct it, you can only create a reversing adjustment. Verify carefully on the detail page before approving.
  • Don't use an adjustment for attribute errors: for batch number, expiry date, or inventory type errors, use a Stock Transformation instead.

💡 Tip: Before adjusting, check Inventory Movements to see where the discrepancy came from, so you don't simply patch the number and mask a real workflow problem.


FeatureDescriptionLink
Inventory ListConfirm the latest stock quantities after adjustmentGo
Stock TakesRecount a whole shelf and settle the differenceGo
Stock TransformationsChange attributes like batch / expiry / inventory type without changing quantityGo
Inventory LedgerView the full history of stock increases and decreasesGo

Last updated 2026-11-16 19:57