Update Inventory from File

Upload Excel file to update quantities and prices.

Upload Excel File

Expected column positions in Excel file:

Column Content Example
A Material Name Required Sugar
B SKU Optional SKU-12345
C Supplier Name Optional Supplier Name
E Quantity Required 25.5
F Price Display only 10.40
G Total Cost Required 100.00
J Date Optional 2024-01-15
K Unit Optional ק״ג / ליטר
L Units/Pkg Optional 22.8
First row must be headers. Columns D, H, I are ignored.
Price per unit = G / E / L (Total Cost / Quantity / Units per package)