How can I perform inventory adjustment for my products?
Inventory adjustment methods
You can adjust inventory in two ways:
- By system for single-item adjustments.
- By Excel for bulk updates across multiple items.
Which adjustment type to use
- Use Stock In when you want to add stock.
- Use Stock Adjustment or Stock Out when you want to deduct stock.
If your stock cannot be adjusted to zero
If Sellable Stock shows a lower quantity than Stock on Hand, the remaining quantity may be under Non-sellable Stock because of pending or allocated orders.
Example:
- Stock on Hand: 2
- Sellable Stock: 1
- Non-sellable Stock: 1
In this case, you can adjust the Sellable Stock to 0 so the item is no longer available for sale. The Stock on Hand may still show a balance until the related order is completed. Once the order is shipped and completed, the stock will be released and deducted accordingly.
You can check this under Edit Inventory Item > Stock Movement.
If you need to stop new orders temporarily
If an item is already out of stock but orders are still coming in, you can set the item status to Out of Stock temporarily.
Path:
Edit Inventory Item > Restock Details
This will make the marketplace listing show as out of stock.
Inventory adjustment for kit items
If you are using Kit inventory, adjust the stock on the original component item, not the kit SKU.
For example:
- Adjust the single item iSKU directly if you want to change the main product quantity.
- Adjust the packaging or add-on item iSKU separately if you want to change that component quantity.
Kit quantity follows the component with the lowest available quantity.
Bulk stock adjustment
For bulk stock updates, use the Excel stock adjustment method.
Related guides:
- How to perform stock adjustment with Excel
- How to perform inventory adjustment
Updated on: 11/05/2026
Thank you!