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.

    how_to_do_stock_opname_on_adjustment_mokapos.png

  5. Click Import/Export

    cara_melihat_stok_opname_mokapos.png

  6. Select Import Adjustment.

    how_to_do_stock_opname_on_adjustment_.png

  7. If you do not the template to import stock adjustment data, click Download Our Template.

    cara_melihat_stok_opname_moka_pos.png

  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.

      cara_melihat_stok_opname.png

    • Column B (Outlet Name) will be generated automatically, therefore just leave it blank.

      cara_melihat_stok_opname_di_adjustment.png

    • Column C (Ingredient Name/Item Name) will be generated automatically, therefore just leave it blank. 

      how_to_do_stock_opname.png

    • Column D (In Stock [Ingredient]) will be generated automatically, therefore just leave it blank.
       how_to_do_stock_opname_mokapos.png

    • Column D (Variant Name [Item Library]) will be generated automatically, therefore just leave it blank. 

      how_to_do_stock_opname_on_adjustment_moka_pos.png

    • Column E (Actual Stock [Ingredient]) is compulsory. Fill in the actual amount of ingredients stock. 

      how_to_do_stock_opname_moka_pos.png

    • Column E (SKU [Item Library]) will be generated automatically, therefore just leave it blank. 

      how_to_do_stock_opname_on_adjustment.png

    • Column F (Unit [Ingredient]) will be generated automatically, therefore just leave it blank. 

      how_to_do_stock_opname_moka.png

    • Column F (In Stock [Item Library]) will be generated automatically, therefore just leave it blank. 

      how_to_do_stock_opname_inventory_mokapos.png

    • Column G (Note [Ingredient]) is optional. Type any additional information related to ingredients on this column. 

      cara_melakukan_stok_opname_.png

    • Column G (Actual Stock [Item Library]) is compulsory. Fill in the actual amount of items stock. 

      how_to_do_stock_opname_inventory_moka_pos.png

    • Column H (Note [Item Library]) is optional. Type any additional information related to items on this column. 

      how_to_do_stock_opname_inventory_moka.png

  9. Save the file in .csv format. 

  10. Repeat steps 1-6, insert your file on the box, then click Upload.

    cara_melihat_stok_opname_moka.png
Was this article helpful?
43 out of 66 found this helpful

Comments

0 comments

Please sign in to leave a comment.

Still Have Questions?

Our customer care team is here for you!

Contact Us