How can I perform inventory adjustment for my products?

Inventory adjustment methods


You can adjust inventory in two ways:


  1. By system for single-item adjustments.
  2. 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.


How to check stock movement for an inventory item


To view the stock movement history of an item, go to Inventory > All Inventory Items > click item name > Stock Movement. This shows all stock changes, including adjustments made via the mobile app. You can also export the Stock Movement report for a full history.


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.


Go to Inventory > All Inventory Items > Bulk Tools > Batch Edit > Inventory > Generate to download the Excel file. Update the quantities, then upload the file and click Proceed if there is no error.


Tip: If you only want to adjust specific items, tick the selected items before generating the Excel file — this will export only those items instead of the full list.


Reserved stock and bulk edits


If an item has Reserved Stock, the system will not allow you to bulk edit its inventory directly. You must first clear the reserved stock to zero (using the Reserved Stock Excel), then proceed with the inventory batch edit.


If the reserved stock is already 0, no action is needed before the bulk update.


Three methods to perform stock adjustment


  1. Via Inventory Adjustment — Go to Inventory > Inventory Adjustment > Stock Adjustment / Stock In / Stock Out.

Guides: How to manage inventory stock | How to stock in and stock out inventory


  1. Via Excel (Bulk Edit) — Go to Inventory > All Inventory Items > Bulk Tools > Batch Edit > Inventory > Generate, edit the exported file, then upload and proceed.

Guide: How to perform stock adjustment with Excel


  1. Via SiteGiant One App — Use the Stock Adjustment feature in the SiteGiant One App.

Guide: How to perform stock adjustment with SiteGiant One App


Related guides:

  • How to perform stock adjustment with Excel
  • How to perform inventory adjustment

Updated on: 25/06/2026

Was this article helpful?

Share your feedback

Cancel

Thank you!