Array ( [0] => Array ( [0] => Array ( [label] => Home [link] => https://support.sitegiant.com/en [title] => Home [type] => blog_home ) [1] => Array ( [label] => Inventory [link] => https://support.sitegiant.com/en/article-categories/inventory-en/ [title] => View all posts in Inventory [type] => kb_tax ) [2] => Array ( [label] => How To Perform Stock Adjustment With Excel (Batch Edit) [link] => https://support.sitegiant.com/en/knowledge-base/how-to-perform-stock-adjustment-with-excel/ [title] => How To Perform Stock Adjustment With Excel (Batch Edit) [type] => kb_current_page ) ) )
  1. Inventory
  2. 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
*stock_on_handThe 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