What should I input if I want to adjust stock quantities in SiteGiant?
To perform stock adjustment with Excel, go to Inventory > All Inventory Items > Bulk Tools > Batch Edit > Inventory > Generate.
- Use Quantity Change if you want to add or deduct a quantity.
- Use New Stock On Hand if you want to set the final stock quantity directly.
- Do not put
0if the item's original quantity is already0, because the system will reject a zero adjustment. If you want to restock the item, enter the target quantity in New Stock On Hand instead. - If an item's stock has no changes, remove that item row from the file.
- If you upload a file and see "Quantity Change cannot be zero", it means that row has no actual stock change. Remove that row before uploading again.
- If you want to clean up all inventory in one batch, the system still only accepts rows where the quantity is different from the current stock.
- Use Quantity Change if you want to add or deduct a quantity.
- Use New Stock On Hand if you want to set the final stock quantity directly.
- Do not put
0if the item's original quantity is already0, because the system will reject a zero adjustment. If you want to restock the item, enter the target quantity in New Stock On Hand instead. - If an item's stock has no changes, remove that item row from the file.
Once done, go to the Upload section and upload the file. If there is no error message or warning, click Proceed to complete the upload.
Updated on: 11/05/2026
Thank you!