How to Import Stock Adjustment Data Using Adjustment

You can import stock adjustment data using Excel in Adjustment. 

Here is the steps to import stock adjustment data using Excel: 

1. Login to backoffice Moka. 
   
   
2. Visit menu INVENTORY. 
   
   
3. Select Adjustment. 
   
   
4. Select Item Library or Ingredients to set which stock you want to adjust.
   
   
   
   
5. Click Import/Export. 
   
   
   
   
6. Select Import Adjustment.
   
   
   
   
7. If you do not the template to import stock adjustment data, click Download Our Template.
   
   
   
   
8. 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. 
     
     
     
     
9. Save the file in .csv format. 
   
   
10. Repeat steps 1-6, insert your file on the box, then click Upload.