Differences

This shows you the differences between two versions of the page.

--- home:knowledge_base:sitegiant:inventory:perform_stock_adjustment [2022/06/24 09:15] – webstation
+++ home:knowledge_base:sitegiant:inventory:perform_stock_adjustment [2022/06/24 09:34] (current) – webstation
@@ Line 1: / Line 1: @@
 ====== How to Perform Stock Adjustment with Excel (Batch Edit) ======
-{{ :home:knowledge_base:sitegiant:inventory:sitegiant_inventory_update.mp4?direct 750 |SiteGiant Inventory Update}} \\ \\ \\
+{{ :home:knowledge_base:sitegiant:inventory:sitegiant_inventory_update.mp4?direct 750 |SiteGiant Inventory Update}} \\ \\
 . Go to **All Inventory Items** from the Inventory menu.
-{{:home:knowledge_base:sitegiant:inventory:all_inventory_items.png?direct 200 |All Inventory Items}} \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\
+{{:home:knowledge_base:sitegiant:inventory:all_inventory_items.png?direct 200 |All Inventory Items}} \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\
 . Then, click on the **Batch Edit** button.
@@ Line 18: / Line 18: @@
 {{:home:knowledge_base:sitegiant:inventory:download_generated_excel_file.png?direct 750 |Generate Excel File}} \\ \\ \\ \\ \\ \\ \\
-. Update the ‘**quantity_changed**‘ or ‘**new_stock_on_hand**‘ for inventory stock adjustment.
+. Update the ‘**//quantity_changed//**‘ or ‘**//new_stock_on_hand//**‘ for inventory stock adjustment.
 {{:home:knowledge_base:sitegiant:inventory:inventory_stock_adjustment.png?direct 750 |Inventory Stock Adjustment}} \\ \\ \\ \\ \\ \\ \\ \\ \\ \\
@@ Line 27: / Line 27: @@
-^ Column    ^ Description              ^
+^ Column            ^ Description                                                         ^
-^ name      | The Inventory Item name. |
+^ *name             | The Inventory Item name.                                            |
+^ *isku             | The iSKU of the Inventory Item.                                     |
+^ *warehouse        | The allocated warehouse of the Item.                                |
+^ *rack             | If there is a rack set for your Item, you may insert the [[home:knowledge_base:sitegiant:inventory:assign_item_with_rack|rack name]]. |
+^ *in_hand_stock    | The current stock you have in the warehouse.                        |
+^ quantity_changed  | The stock level that you wish to adjust (+/-).                      |
+^ new_stock_on_hand | Adjust the total new Stock On Hand quantity of the item.            |
+ \\
+. Next, **upload** your excel file and click ‘**Next**‘ to continue.
+{{:home:knowledge_base:sitegiant:inventory:upload_excel_file.png?direct 750 |Upload Excel File}} \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\
+. Click on the ‘**Proceed**‘ button if there is no error.
+{{:home:knowledge_base:sitegiant:inventory:proceed.png?direct 750 |Proceed}} \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\
-. Next, **upload** your excel file and click ‘**Next**‘ to continue.
+. System will notify for the successfully imported data, then click on ‘**Done**‘.
-. Click on the ‘**Proceed**‘ button if there is no error.
+{{:home:knowledge_base:sitegiant:inventory:done.png?direct 750 |Done}} \\ \\
-. System will notify for the successfully imported data, then click on ‘**Done**‘.