Step by step
- Go to Settings → Data → Data maintenance, open Inventory adjustment and click Stock CSV at the top right, next to New adjustment. You need permission to edit Products, and your role must also have Settings → Edit, because the stock adjustment is the same one used in Data maintenance. If it is missing, the window says so.
- Step 1: click Download. The file has the columns ID, Product Name, Category, Product Code and Stock, with today's stock.
- Step 2: open it in Excel, change only the Stock column and save it as CSV. Do not change the ID column: that is how each row is matched to its product. A blank Stock cell leaves that product as it is.
- Step 3: click Upload and pick the file. The preview compares it with the stock right now: how many change, how many stay the same and the rows with problems (an ID that is not recognized, a quantity that is not a number, or the same product twice with different quantities, which is not applied).
- Check the reason and click Apply. Everything is saved together in one adjustment: if something fails, nothing is saved. Each product gets its movement in the Kardex with your user and the reason. The adjustment shows up right away in the Inventory adjustment list.
Full guide in the help center →
Published: