Importing & Exporting Data
Move your business into Kerno
Move your whole business into Kerno by bringing your lists in, in the order below. Some lists need others to be in Kerno first, so start at the top. Move your…
On this page (3)
Move your whole business into Kerno by bringing your lists in, in the order below. Some lists need others to be in Kerno first, so start at the top.
Move your business, step by step
- Choose your business type. Do it in step 1 of the Onboarding Guide, because it sets the product types Kerno suggests.
- Import your suppliers.
- Import your materials, with stock on the same file or at quantity 0.
- Import opening stock if you kept it in a separate file. Give every row a lot number: without one, a second upload adds the lot again.
- Import supplier SKUs, if your file has more than the materials import made. See My supplier SKU import skips every row.
- Import your products, with their variants. See Import products from a spreadsheet.
- Import your BOMs. Each one lands as a draft to open, check and publish.
- Import soap recipes. They land as drafts in the Soap Calculator.
- Add the finished goods you already have. See Add finished goods you already have.
- Check the result. Export CSV on Materials, Suppliers and Products, Export SKUs, Export lots and Export BOM lines give back what went in, which is the quickest way to compare with your old system.
Good to know
- Keep one product's BOM lines together in one file. See My BOM came in as two versions.
- Material costs keep four decimals: $0.0555 stays $0.0555.
- A file is limited to 5 MB and 2,000 rows.
- Importing fills Cost Changes in Reports with one change per material with a cost. That's expected on day one.
- Not built yet: importing customers and orders. Tell us if you need it.
Related articles
Still need a hand?
Our support team is here when you need a person.