Importing Stock Adjustments

When you need to adjust stock levels for many products at once, you can upload a CSV file instead of making each adjustment manually. This is useful for bulk corrections, initial stock setup, or periodic reconciliation.

How to Import

1. Go to Inventory and click Import Stock.
2. Download the CSV template to see the required format.
3. Fill in your adjustment data in the spreadsheet. Each row is one adjustment.
4. Save the file as CSV.
5. Upload the file and click Import Stock.

Required Columns

• product_sku - the SKU of the product to adjust.
• zone_barcode - the barcode of the zone where the adjustment applies.
• quantity - the quantity to set, add, or subtract.
• adjustment_type - one of set, add, or subtract.

Adjustment Types

• set - sets the stock level to the exact quantity specified.
• add - increases the current stock level by the specified quantity.
• subtract - decreases the current stock level by the specified quantity.

Tips

• Start with a small test file to check the format before importing a large batch.
• Make sure all SKUs and zone barcodes exist in the system before importing.
• Every adjustment creates a stock movement, so you always have a full audit trail.