User Tools

Site Tools


home:knowledge_base:sitegiant:inventory:perform_stock_adjustment

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
home:knowledge_base:sitegiant:inventory:perform_stock_adjustment [2022/06/24 09:19] webstationhome: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) ====== ====== 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}} \\ \\ 
  
 1. Go to **All Inventory Items** from the Inventory menu. 1. 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}} \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ 
  
 2. Then, click on the **Batch Edit** button. 2. 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}} \\ \\ \\ \\ \\ \\ \\  {{:home:knowledge_base:sitegiant:inventory:download_generated_excel_file.png?direct 750 |Generate Excel File}} \\ \\ \\ \\ \\ \\ \\ 
  
-5. Update the ‘**quantity_changed**‘ or ‘**new_stock_on_hand**‘ for inventory stock adjustment.+5. 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}} \\ \\ \\ \\ \\ \\ \\ \\ \\ \\  {{:home:knowledge_base:sitegiant:inventory:inventory_stock_adjustment.png?direct 750 |Inventory Stock Adjustment}} \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ 
Line 31: Line 31:
 ^ *isku             | The iSKU of the Inventory Item.                                     | ^ *isku             | The iSKU of the Inventory Item.                                     |
 ^ *warehouse        | The allocated warehouse of the Item.                                |  ^ *warehouse        | The allocated warehouse of the Item.                                | 
-^ *rack             | If there is a rack set for your Item, you may insert the rack name. |+^ *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.                        | ^ *in_hand_stock    | The current stock you have in the warehouse.                        |
 ^ quantity_changed  | The stock level that you wish to adjust (+/-).                      | ^ 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.            | ^ new_stock_on_hand | Adjust the total new Stock On Hand quantity of the item.            |
  
 + \\ 
  
 6. Next, **upload** your excel file and click ‘**Next**‘ to continue. 6. Next, **upload** your excel file and click ‘**Next**‘ to continue.
 +
 +{{:home:knowledge_base:sitegiant:inventory:upload_excel_file.png?direct 750 |Upload Excel File}} \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ 
  
 7. Click on the ‘**Proceed**‘ button if there is no error. 7. Click on the ‘**Proceed**‘ button if there is no error.
 +
 +{{:home:knowledge_base:sitegiant:inventory:proceed.png?direct 750 |Proceed}} \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ 
  
 8. System will notify for the successfully imported data, then click on ‘**Done**‘. 8. System will notify for the successfully imported data, then click on ‘**Done**‘.
 +
 +{{:home:knowledge_base:sitegiant:inventory:done.png?direct 750 |Done}} \\ \\ 
home/knowledge_base/sitegiant/inventory/perform_stock_adjustment.1656062399.txt.gz · Last modified: 2022/06/24 09:19 by webstation