Importing needs the database connected. The templates below still download, so the format can be checked now.
Nothing is imported halfway. Rows that cannot be read are listed with their line number and the reason, and the rest still go in — so a sheet with three bad lines imports the other four hundred.
Product list
Item code, name, description, colour, m² per carton and price. An item code that already exists is updated rather than duplicated, so a corrected sheet can simply be re-imported.
Download a blank template if you would rather start from the right columns.
Stock received
A supplier packing list: item code, batch, order number and quantity. Lines for the same item and batch are added together, so a delivery split across pallets stays one receipt.
Download a blank template. Item codes must already exist in the product list — nothing is invented here.
PDF packing lists are not supported. Every supplier lays theirs out differently and the layout changes without warning, so a PDF importer is wrong more often than it is right. Save the sheet as .xlsx or .csv instead.