1. Home
  2. Inventory
  3. How To Perform Stock Adjustment With Excel (Batch Edit)

How To Perform Stock Adjustment With Excel (Batch Edit)

1. Introduction
2. Stock Adjustment With Excel

1. Introduction

This feature allows you to manage and update your inventory stock for SiteGiant and marketplaces with Excel.


2. Stock Adjustment With Excel

Step 1: Navigate to Inventory > All Inventory Items

Step 2: Click on Bulk Tools > choose Batch Edit

Step 3: Under download, select info type as Inventory > choose the warehouses > you can choose to filter by category or brands > Generate

Step 4: Download the generated excel file (zipped)

Step 5: Update either quantity_change or ‘new_stock_on_hand column for inventory stock adjustment

📌Note: If both quantity_change and new_stock_on_hand columns are filled, the system will update based on the quantity_changed.

Column with * is Not Editable.

ColumnDescription
*nameThe Inventory Item name
*iskuThe iSKU of the Inventory Item
*warehouseThe allocated warehouse of the Item
*rackIf there is a rack set for your Item, you may insert the rack name
*in_hand_stockThe current stock you have in the warehouse
quantity_changedThe stock level that you wish to adjust (+/-)
new_stock_on_handAdjust the total new Stock On Hand quantity of the item

Step 6: Back to SiteGiant Batch Edit Upload page > upload the Excel file > Next

Step 7: If there are any errors in the Excel uploaded, you will see the error message in Errors and Warnings and it will show the error column in the Data Preview. Amend the error column and reupload the file. Click on Proceed if the file uploaded does not have errors.

Step 8: Click Done to complete the process

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support