You can import stock adjustment data using Excel in Adjustment.
Here is the steps to import stock adjustment data using Excel:
- Login to backoffice Moka.
- Visit menu INVENTORY.
- Select Adjustment.
- Select Item Library or Ingredients to set which stock you want to adjust.
- Click Import/Export.
- Select Import Adjustment.
- If you do not the template to import stock adjustment data, click Download Our Template.
- Open the file in Microsoft Excel and follow these steps to fill in the template:
- Column A (Internal ID) will be generated automatically, therefore just leave it blank. Do not edit the ID that is on the column.
- Column B (Outlet Name) will be generated automatically, therefore just leave it blank.
- Column C (Ingredient Name/Item Name) will be generated automatically, therefore just leave it blank.
- Column D (In Stock [Ingredient]) will be generated automatically, therefore just leave it blank.
- Column D (Variant Name [Item Library]) will be generated automatically, therefore just leave it blank.
- Column E (Actual Stock [Ingredient]) is compulsory. Fill in the actual amount of ingredients stock.
- Column E (SKU [Item Library]) will be generated automatically, therefore just leave it blank.
- Column F (Unit [Ingredient]) will be generated automatically, therefore just leave it blank.
- Column F (In Stock [Item Library]) will be generated automatically, therefore just leave it blank.
- Column G (Note [Ingredient]) is optional. Type any additional information related to ingredients on this column.
- Column G (Actual Stock [Item Library]) is compulsory. Fill in the actual amount of items stock.
- Column H (Note [Item Library]) is optional. Type any additional information related to items on this column.
- Column A (Internal ID) will be generated automatically, therefore just leave it blank. Do not edit the ID that is on the column.
- Save the file in .csv format.
- Repeat steps 1-6, insert your file on the box, then click Upload.
Comments
0 comments