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
Navigate to Stock Adjustment
Go to Inventory Management > Stock Adjustment.Create New Inventory Adjustment
Click New Stock Adjustment (+).Select Warehouse
Choose the warehouse from the dropdown menu.Select Products
Use the Product Search and Selection section:Click Select on the desired product row to move it to the inventory list,
ORScan or enter the product's EAN code to select it automatically.
Set Event Type
Above the event column, choose Inventory as the event type.Enter Actual Stock
In the Quantity field, enter the product’s real balance.Add Product Line
Click the Add (+) button to save the row.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)
Export Product List
Go to Sales > Products and click Export Search Results as CSV.Open CSV File
Open the downloaded CSV file in Excel or other spreadsheet software.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.
Save File
Save the edited file in CSV (UTF-8) format.Import CSV Back to Eemel
Go to Sales > Products > Import Products.
Upload the CSV file and click Continue.
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.
Finalize Import
Click Save Selected Products.
✅ Your stock balances are now updated across the system.