WEBSTATION COMPUTER CENTRE

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== How to Perform Stock Adjustment with Excel (Batch Edit) ======

{{ :home:knowledge_base:sitegiant:inventory:sitegiant_inventory_update.mp4?direct 750 |SiteGiant Inventory Update}} \\ \\ 

1. Go to **All Inventory Items** from the Inventory menu.

{{:home:knowledge_base:sitegiant:inventory:all_inventory_items.png?direct 200 |All Inventory Items}} \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ 

2. Then, click on the **Batch Edit** button.

{{:home:knowledge_base:sitegiant:inventory:batch_edit_button.png?direct 150 |Batch Edit Button}} \\ \\ \\ \\ 

3. **Generate** the existing ‘**Inventory**‘ for Stock Adjustment.

{{:home:knowledge_base:sitegiant:inventory:generate_inventory.png?direct 600 |Generate Inventory}} \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ 
4. **Download** the generated excel file (zipped).

{{: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.

{{:home:knowledge_base:sitegiant:inventory:inventory_stock_adjustment.png?direct 750 |Inventory Stock Adjustment}} \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ 

Note: Column with * is __**Not Editable**__.

Update either one, for quantity_changed or new_stock_on_hand field. Else, the system will update based on the quantity_changed.


^ Column            ^ Description                                                         ^
^ *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.            |

 \\ 

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.

{{:home:knowledge_base:sitegiant:inventory:proceed.png?direct 750 |Proceed}} \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ 

8. System will notify for the successfully imported data, then click on ‘**Done**‘.

{{:home:knowledge_base:sitegiant:inventory:done.png?direct 750 |Done}} \\ \\