Opening stock

source_id: source id (required)
sku: sku (required)
warehouse_code: warehouse code (required)
unit_code: unit code (required)
quantity: quantity (required)
unit_cost: unit cost (required)
as_of_date: as of date (required)
batch_number: batch number (optional; blank preserves existing value on update)
expiry_date: expiry date (optional; blank preserves existing value on update)
serial_numbers: serial numbers (optional; blank preserves existing value on update)

Use one dataset per CSV file. Set schema_version to 1 on every row.
Examples are fictional: do not import example files into a live business.
Dates: YYYY-MM-DD. Money: NGN. Decimal numbers: no thousands separators, up to four decimal places. Booleans: true/false or 1/0.
Keep identifiers, barcodes and phone numbers as text in your spreadsheet. Version 1 exports add a protective apostrophe to formula-like text and leading-zero numbers; version 1 imports remove one protective apostrophe.
Blank optional values preserve existing values in update mode. Import does not delete missing rows or clear blank fields.
Use existing reference codes, or include prerequisite files in the same upload. Categories are sorted parent-first.
Opening stock uses base units only, before any stock at that location. One row per product/location; optional serial_numbers use | as separator. Unit cost must match the catalog.
Opening debts are positive amounts owed, one consolidated opening entry per account before trading. Credits/negative openings require a separate correction workflow.
Purchase headers and lines must be uploaded together. Imports create drafts; choose a warehouse and receive separately. Stock-count imports also require a separate approval.
Limits: 10,000 source rows and 8 MB combined per batch. Split larger datasets into dependency-ordered batches.