Skip to main content

🟦 Inventory Count (Stocktaking)

L
Written by Lassi kähkönen
Updated over a week ago

Correcting Inventory Balances in Eemel

Eemel provides two methods for updating product stock balances during an inventory process:


Method 1: Manual Correction via Stock Adjustment Document

  1. Navigate to Stock Adjustment
    Go to Inventory Management > Stock Adjustment.

  2. Create New Inventory Adjustment
    Click New Stock Adjustment (+).

  3. Select Warehouse
    Choose the warehouse from the dropdown menu.

  4. Select Products
    Use the Product Search and Selection section:

    • Click Select on the desired product row to move it to the inventory list,
      OR

    • Scan or enter the product's EAN code to select it automatically.

  5. Set Event Type
    Above the event column, choose Inventory as the event type.

  6. Enter Actual Stock
    In the Quantity field, enter the product’s real balance.

  7. Add Product Line
    Click the Add (+) button to save the row.

  8. Repeat for More Products
    Continue scanning or selecting new products to add them to the inventory.


Method 2: Update Stock in Bulk via CSV File (Excel)

  1. Export Product List
    Go to Sales > Products and click Export Search Results as CSV.

  2. Open CSV File
    Open the downloaded CSV file in Excel or other spreadsheet software.

  3. Edit Stock Balances

    • Enter the actual stock balances in the column corresponding to your warehouse name.

    • If you have multiple warehouses, each has its own column.

    ✅ Tip: Use bold formatting (Ctrl+B) to mark the rows you’ve updated.

  4. Save File
    Save the edited file in CSV (UTF-8) format.

  5. Import CSV Back to Eemel

    • Go to Sales > Products > Import Products.

    • Upload the CSV file and click Continue.

  6. Match Fields

    • Make sure to match each column correctly.

    • It’s crucial to include and match the product ID (tuoteid) to prevent creating duplicate products.

  7. Finalize Import
    Click Save Selected Products.

✅ Your stock balances are now updated across the system.

Did this answer your question?