Skip to content

Importing data

When you move to Customry One from another system, you can bring your records across with spreadsheets instead of typing them in. Administration → Company → Data Import does it in three steps: choose what to import, get a template or check a filled file, then import it. Nothing changes until you choose Import.

You can import:

  • Lists, such as regions, titles, job roles, product brands, competitors, Product categories and Product properties
  • Staff
  • Customers, then their Addresses, Contacts, Price lists, special Prices, Discounts, Alerts and Contact consent
  • Suppliers, then their Addresses and Contacts
  • Products, then their Product prices (their prices on each price list), Components and bills of materials, Stock at locations (opening stock and reorder levels), Routings, Competitor prices and Product suppliers (who each product is bought from, and at what price)
  • Notes on customers, suppliers and their contacts
  • Opportunities that are still open
  • Sales: open enquiries, quotes and orders, and completed orders, with their lines
  • Purchase orders: drafts, orders placed with nothing received yet, and orders received in full, with their lines

Each is a separate file. Addresses and contacts name the customer or supplier they belong to, and product suppliers name a product and a supplier, so import those first.

The list on the left is in the order to import in: each one needs the ones above it. On a wide screen it scrolls on its own, so it stays where it is while you work on the one you chose. The number beside each is how many there are now. The short lists are under Lists at the top: choose it to open them.

You can also go straight there from the Staff, Customers, Suppliers or Products list with Import.

Download template gives you an Excel workbook ready to fill in:

  • One column for each field, with a note on each heading saying what to put. Columns marked * are needed for new records.
  • Drop-down lists for fields that come from a list, such as Customer type or Region.
  • A Read me sheet explaining the columns.
  • For addresses and contacts, an All customers (or All suppliers) sheet of account refs to copy from. Product suppliers get an All products and an All suppliers sheet.

Tick With the records there now to fill the template with your existing records, for example to correct or fill in a field for many at once. Tick Include less-used columns for fields most companies don’t need.

You don’t have to use the template. Any Excel (.xlsx) or CSV file works if its column headings match the field names. Columns can be in any order, and columns you don’t need can be left out.

Email columns need whole email addresses (name@example.com), and website and web columns whole web addresses (www.example.com). The check lists any that aren’t.

Fields like Customer type, Region or Title take the name as it’s set up in Administration, for example Trade or North West. Capitals, spaces and punctuation don’t matter. If a name doesn’t match, the check says so and suggests the nearest one.

A customer or supplier is named by its Account ref, and a product by its Product code. If your records came from another system, fill in Old system ID on each one. The files that point at them can then name them as # and that number, for example #1234, even if the account ref or code changed on the way across.

A product’s Category is its path, such as Doors / Internal, or just its own name when no other category has that name. Its Unit of measure, Type, Brand and Range are written as names too, for example Each. Missing brands and ranges can be added from the file, as below.

Each of your product properties is a column of the products template, named as the property. Fill them in as you would on a product’s Properties tab:

  • A number with or without its unit, for example 44 or 44 mm.
  • A date as 2026-11-08 or 08/11/2026, and Yes or No.
  • One of a list’s values by its name. Where a product can have several, separate them with commas.

As on the product form, a new product must be given every required property of its category, and so must a product moved to a category that needs properties it doesn’t have yet. A property that doesn’t apply to a product’s category is a problem, unless the product has it already. A property can’t be cleared from a file: remove it on the product’s Properties tab.

If you can manage pricing and see costs, the products template also has a Standard cost column.

If a property has the same name as one of the product’s own fields, such as Height, its column is called Height (property).

A product’s Kind is set when it’s made. Leave it blank to use its type’s kind, or a stock item when the type has none. To change the kind of a product that’s there already, use its page, which checks its stock and orders first.

Each row of a Product prices file is one price: a product on a price list, by the list’s name. Leave Currency blank for your company’s own currency, and From qty blank for a price from 1. Give another row with a higher From qty for a quantity break, and a Start date to load a price change ahead of time. Configured products are priced by the configurator, so they can’t have prices here.

  • Price lists puts a customer on a price list. Priority 1 is looked at first, and each number is used once per customer. Leave it blank to put the list after the customer’s others. To swap two priorities, move one to a free number in one file and the other in the next.
  • Prices are a customer’s special prices for products, found by customer, product, Quantity and Start date.
  • Discounts take a percentage off a product category (and the categories under it) for a customer, found by customer, category and Start date.

Each row is one line of a kit’s components or an assembly’s bill of materials: the kit or assembly, the component and how many make one. Components are stock items, services and, in an assembly, sub-assemblies. An assembly can’t end up containing itself. On the Components tab a kit you add is replaced by its own components; in a file, list those components yourself. Only an assembly’s lines take a Note.

Stock at locations has a row for each product at each stock location, with its Opening stock and that location’s Reorder level and Minimum order quantity. Only stock items and assemblies hold stock.

Opening stock goes in as an Opening movement in the product’s stock history, so its balance, history and stock reports all agree. It’s for locations where the product’s stock hasn’t moved yet: after that, adjust the stock or count it. You need permission to adjust stock to see the Opening stock column. Undoing the import takes the opening stock back out, as long as nothing has moved there since.

Each row of Routings is one operation of a product’s routing: its Step, the Work centre, a Description and its minutes. Leave Step blank to add an operation after the product’s others. Only stock items and assemblies have routings.

  • Notes go on one customer or one supplier, and can name one of its contacts. Written keeps the old system’s date, so they sit in the right place in the record’s Activity. Notes have nothing else to be matched by, so give each an Old system ID: otherwise importing the file again adds them twice.
  • Alerts are the warnings or stops shown when a sale is made or confirmed. With neither column filled in, a new alert shows when a sale is made.
  • Contact consent is each contact’s answer to a consent question, with when they answered. The latest answer counts: C1 doesn’t follow up a quote with a contact whose latest answer is no.

A contact is named by their email, their name, or # and their old system ID.

Only open opportunities are imported. Each new one takes the next opportunity number. Leave Pipeline blank for the default pipeline, and give the Stage by its name. A file with a Reference column can update opportunities that are already there, for example to move them on a stage. Won and lost ones are left as they are.

Sales brings across the work in flight when you go live: enquiries and quotes the customer hasn’t answered, orders not yet delivered, and orders already finished in your old system.

  • One row per line. Rows with the same Old reference are one sale, in the order they come; they needn’t be next to each other. The sale’s own columns, such as Customer, Stage and the dates, go on its first row. On later rows leave them blank or repeat them: a different value is a problem.
  • A sale goes in whole or not at all. A problem on any of its rows leaves the whole sale out, and the check says which row it’s waiting on. The other sales still go in.
  • Stage is Enquiry, Quote or Order (in your own words for them), or Completed for an order delivered and invoiced in full in the old system. An order comes in untouched, with nothing delivered or invoiced, and is confirmed on its Order date. A completed one is history: it shows on the customer’s Sales tab and in sales figures, but it’s never on To despatch or To invoice, its stock isn’t allocated, and it can’t be reopened. An order delivered or invoiced only in part can’t be imported: finish it in the old system first, or split it there into what’s done and what isn’t.
  • Lines: a Product line (a kit brings its components, as on a sale), a non-stock line (a Description with a quantity or price) or a text line (a description alone). Leave Price blank on a product line to price it as a new line would be, and the check says what it came to; a price you give, 0 included, is kept. Configured products can’t be imported yet: enter those orders by hand.
  • Numbers: each sale keeps its old reference as its number, so SO-10231 stays SO-10231. It must end in a number, and new sales follow on from the highest one. The check says what the next new sale will be called; if the old references start differently, set the prefix under Administration → Numbering before you import.
  • Only before you start: sales can be imported until the first sale is made in Customry One, in as many files as you like. After that the import is closed. To start again, clear down the company’s documents.

A sale whose reference is here already is left alone, so the same file can be checked again safely. Sales are only added: to change an imported one, change it on its page.

Purchase orders work the same way as sales: one row per line, grouped by Old reference, with the order’s own columns on its first row, and an order goes in whole or not at all. They can be imported until the first purchase order is made in Customry One (including a draft from Reorder or a Buy panel), separately from sales, so you can go live with sales first.

  • Stage is Draft, Placed (nothing received yet) or Received (all of it received in the old system), as you call them. A placed order is placed on its Order date, without asking for approval and without emailing the supplier, and counts as on order straight away, so goods in can be booked against it. A received one is history: it isn’t on order, and no goods in is made for it, so your stock comes from the opening stock import. An order received only in part can’t be imported: finish it in the old system first, or split it there.
  • Lines: a Product line, a non-stock line (a Description with a quantity or price), a text line (a description alone), or a Charge (carriage, a certificate…) with Line type Charge. Leave Price blank on a product line to use the supplier’s last price, and the check says what it is; a placed order needs a price on every line, or Yes in Free of charge. Importing doesn’t change the supplier’s last prices.
  • Numbers work as for sales: each order keeps its old reference, and new purchase orders follow on from the highest number.
  • The order’s PDF is kept the first time it’s emailed from here.

Each row of Competitor prices is a price a competitor charges for one of your products, with when it was Seen. A row with a new date adds another sighting beside the earlier ones.

Each list under Lists is a file with a Name column. A row with a name that’s already in the list updates that value, so you can make values inactive with No in Active. To rename values, give each one an Old system ID on a first import: a later file can then give it a new name.

Product categories is under Lists, and builds the category tree. Each row is one category: its own Name, and in Parent product category the path of the category it goes under, such as Doors / Internal, or its own name when no other category has that name. Leave the parent blank for a top-level category. A parent added by the same file goes in a row above its sub-categories. Nominal code is the sales nominal code for the category’s products; leave it blank to use the parent’s.

A row finds a category that’s there by its path. To rename or move categories, give each one an Old system ID on a first import: a later file can then give it a new name or parent, and everything under it moves with it. A category can’t go under itself or one of its own sub-categories, and names are unique under one parent.

Import categories before products, since each product names its category.

Product properties is under Lists too, and sets up the properties themselves, a row each, so the products template then has a column for each one. Give its Name and Type: Text, Number, Date or Yes/No. A number can have Decimal places and a Unit, such as mm.

  • Allowed values, separated by commas, make it picked from a list, in that order. Put Yes in Allow several values when a product can have more than one.
  • Product categories are the ones it applies to, by path, separated by commas; leave it blank for every product. Required Yes means a product it applies to must have a value.
  • A row finds a property by its name, or by its Old system ID, which lets a later file rename it. A property your products have values for keeps its type and whether it’s picked from a list. An allowed value left out of a later file is switched off, not removed, so products that have it keep it.

Import properties before products, then fill their values in on the products template.

Staff are matched by Old system ID, else by email, else by name. Set up their sign-in on the person’s page, as a file can’t make sign-in accounts.

First choose what happens to rows for records that are there already:

ChoiceRows for records already thereOther rows
Add new onlyLeft aloneAdded
Update existing onlyChangedA problem: there’s nothing to update
Add and updateChangedAdded

Then Choose file. Every row is checked, the same way as saving the record on its own page, and you see:

  • How many rows would be added, changed or left alone, and how many have problems.
  • Each row: what would happen to it, each change from old to new, and what’s wrong with it. Use the buttons above the rows to show only problems, new or changed rows, or the headings to sort and filter, for example by record or by what’s wrong.
  • Names that aren’t in a list, such as a region you don’t have yet.

A customer or supplier is matched to an existing one by its Old system ID, or else its Account ref, and a product by its Old system ID or else its Product code. An address is matched by its first line and post code, a contact by email or else by name, a product supplier by its product and supplier together, a price by its product, price list, currency, From qty and Start date, a component line by its kit or assembly and component, and stock by product and stock location.

When you update records, a blank cell changes nothing. To clear a field, put a single - in the cell.

Rows with problems are left out of the import, and the rest still go in. Download problems file gives you your file back with an Import problems column saying what’s wrong with each row, and the cells that need fixing shaded red. Fix them in Excel and check the file again.

Import brings in the rows that passed the check. It says how many will be added and how many rows with problems will be left out, and asks you to confirm.

A file of more than 1,000 rows is imported in the background, so you can carry on working. The Past imports tab shows it as Waiting, then Importing with how far it’s got, and then Imported.

If a customer or supplier has no primary address or contact yet, its first imported one becomes the primary. Put Yes in Primary to choose a different one.

In the same way, a product with no preferred supplier gets its first imported one. Put Yes in Preferred to choose a different one. Only products that are bought can have suppliers: stock items and services, not kits or assemblies.

The Past imports tab lists every import, with who ran it and what it added and changed. Like other lists, each heading sorts and filters it, for example to show only undone imports or one person’s, and the column picker adds more columns such as Rows and Message. It includes imports made elsewhere: leads imported on the Leads page and properties imported with Import properties on the Products list. Open takes you to the page where they were made. A lead import can be undone from either place.

Undo takes back out the records an import added, for 30 days afterwards. A record stays if it has been changed or used since, for example a customer that now has a sale. Undo the contacts and addresses for a customer or supplier before the record itself, and product suppliers before their products. A product category goes with the sub-categories under it, as long as the same import added them all and nothing has changed or used them since.

It also puts back what the import changed on records that were already there. Each field goes back to what it was, unless it’s been changed again since: then it stays as it is now, and the undo says so. A few things a file sets alongside the fields stay as they are, such as which contact is a customer’s primary one, or an opportunity’s stage: change those on the record. Opening stock given to a location goes back out too, as long as stock hasn’t moved there since. Imports made before November 2026 can’t put their changes back.

Uploaded files are kept for 30 days, so you can download the problems file again from Past imports.

To start again with a clean company before going live, clear it down: that empties the sales, purchase orders, stock and other documents made while trying things out, and the customers, suppliers and products too if you choose. Undo only takes back one import at a time.