logisticaHQ Client Portal
Importing and exporting with Excel
This page shows you how to create and update many Products, Customers or Vendors at once with an Excel spreadsheet, and how to download your lists as Excel files. It is for client users who manage Products, Customers or Vendors; anyone who can view them can use the exports.
Who can use this
- Importing (the Import from Excel button, the Download template link and the import pages) needs Manage Products, Manage Customers or Manage Vendors, depending on the list. A user with view access only does not see these buttons, and opening an import page shows You don't have access to this section.
- Exporting (Export and Export to Excel) is available to everyone who can view the list.
How to get there
Start on the list you want to work with: Master data > Products, Customers or Vendors. The import and export buttons are at the top of each list.
The two exports
Every list has two different ways to export. Choose by what you need.
| Compare | Export (toolbar) | Export to Excel |
| What you get | A copy of the list as you see it: the rows that match your current search and filters, in your current order, with only the columns that are shown. All pages are included, not only the page on screen. | Your whole list as a workbook you can edit and import again: for Customers and Vendors in exactly the columns of the import template, for Products in the older product layout, which still imports. |
| File name | PortalProducts.xlsx, PortalCustomers.xlsx or PortalVendors.xlsx | Products.xlsx, Customers.xlsx or Vendors.xlsx |
| Filters | Respected. | Ignored: you always get the whole list, sorted by SKU (Products) or by code (Customers and Vendors). |
| Dates | Written like Jan 05, 2026 - 03:30 PM. | The workbook has no date columns. |
| Best for | Sharing or printing what you are looking at. | Backups, bulk edits and moving data back into the portal. |
The product workbook from Export to Excel includes discontinued Products, although the product list does not show them. It is in the older, shorter product layout, which still imports, so it does not contain data that layout cannot carry, such as stock quantities, packsizes or components. The customer workbook does not contain delivery addresses.
In the product workbook, the three columns IsLotControlled, IsSerialControlled and IsExpiryControlled are written as the words True and False.
Tip: The quickest way to learn how a value is written is to click Export to Excel and look at a row you already have. For bulk changes, export, change the cells, save and import the same file.
How an import works
There are two kinds of import. The product import shows you a preview and saves nothing until you confirm. The customer and vendor imports have no preview: they save the file as soon as you click Import. The steps and results of each are below, followed by the rules that apply to all of them and the rules that apply to one kind only.
- On the product list, click Download template (the small link next to Import from Excel). Your browser saves
Products-import-template.xlsx, a workbook in your language with three sheets: Products, Example and Read me.
- Open it in Excel and fill in the Products sheet, one row per pack size of a product, starting at row 2. Keep the sheet name and the column names in row 1 as they are. Save the file as an Excel workbook (.xlsx). The columns and the rules for filling them in are on the Products page.
- Back in the portal, click Import from Excel. The page Import Products opens. A line under the title says: "Download the template, fill in your Products under its column names and upload the file here. The template comes in your language, with an example and instructions. Sku is always required, and your warehouse may require other fields too. You will see what the file would do before anything is saved."
- Choose your file with the file picker. Import is not available until a file is chosen.
- Click Import. The button reads Reading the file... while the file is checked. Nothing is saved yet. The page shows the preview: Nothing has been saved yet. Check what will happen with this file., then Rows in the file: 12, the figures, each a short sentence with its number, for example 2 Products to create, 1 product to update and 1 product that will be refused (and the three pack size figures when the file has pack size rows), the list Rows that will not be imported, any Notes on rows that will be imported, and the columns and sheets that will be ignored.
- If the preview is what you want, click the button that says what will be saved, for example Import 3 Products or Import 1 product and 2 pack sizes. If not, click Cancel or choose another file: nothing is created or changed.
- Read the result (below). Click Back to Products to return to the list, and use Refresh if you do not see the changes.
What every line of the preview means, the template's columns and the reasons a row is refused are described in Import Products from Excel on the Products page.
The result of a product import
After you confirm, the preview is replaced by the result and a green message appears:
- Import complete: {0} created, {1} updated. {0} is the number of new Products and {1} the number of Products that already existed and were updated. When the file had pack size rows, a second line follows: Pack sizes: {0} created, {1} updated.
- Rows that were not imported lists every row that was refused, each as the row number (as you see it in Excel) and the SKU, for example Row 4 ยท SKU-1, followed by the reason. The other rows were imported.
- Import failed: {0} in red: the file was refused and nothing was saved; {0} says why.
- Nothing was imported. Check the file and try again. Your data changed after the preview and nothing could be saved. Choose the file again and read the new preview.
- On the list, click Download template (the small link next to Import from Excel on the Customers list; under the button on the Vendors list). Your browser downloads an empty workbook,
Customers-template.xlsx or Vendors-template.xlsx, with one sheet, one bold heading row and no data.
- Open the file in Excel and type one record per row, starting at row 2 (see the column tables below). Keep the headings in row 1 exactly as they are. Save the file as an Excel workbook (.xlsx).
- Back in the portal, click Import from Excel. The page Import Customers or Import Vendors opens. A line under the title says what the import does, and a card lists the recognised columns.
- Choose your file with the file picker.
- Click Import. The button is not available until a file is chosen; if you reach it without a file, you see Choose a file first. While the file is processed the button reads Importing... The file is saved straight away: there is no preview and no confirmation.
- Read the result (below). Click Back to Customers or Back to Vendors to return to the list, and use Refresh if you do not see the changes.
The result of a customer or vendor import
When the import finishes the page shows four counters (rows, created, updated and skipped), a green message and, when there is something to report, a list headed Warnings.
- Import complete: {0} created, {1} updated. The import worked. {0} is the number of new records and {1} the number of records that already existed and were updated.
- Row {n}: missing CustomerCode - skipped. (Vendors: Row {n}: missing VendorCode - skipped.) appears under Warnings for a row that has no key. {n} is the row number in your sheet, where the heading row is row 1. The row is counted as skipped and nothing is saved for it. These warnings appear in English.
- Import failed: {0} in red. The whole file was refused; {0} says why.
- Choose a file first. You pressed Import without choosing a file.
Rules that apply to every import
- The key column decides create or update. The key is
Sku for Products, CustomerCode for Customers and VendorCode for Vendors. The key is compared ignoring capital letters and spaces at the ends. If your company already has a record with that key, the row updates it. If not, the row creates a new record.
- An empty cell keeps the current value. For an existing record, a cell you leave empty changes nothing. In the product template you can empty a text or number value by typing (clear) in its cell; in the customer and vendor imports you cannot empty a field by importing, so edit the record on its page.
- File size. A file larger than 15 MB is refused before it is sent, with Import failed: Supplied file with size {n} bytes exceeds the maximum of 15728640 bytes. The product template also accepts at most 5,000 rows at a time.
- Your own records only. An import only ever reads and changes records of your own company.
Important: An import changes live data and cannot be undone with one click. Try a small file first, and keep a copy of Export to Excel from before the change.
- Only the first sheet is read. Put your data on the first sheet of the workbook. Row 1 must hold the column headings.
- Headings. Use the headings of the template. They are matched without regard to capital letters or spaces. A column whose heading is not recognised is ignored without any message.
- A row without a key is skipped with the warning above. If the same key appears on several rows, the first row creates the record and the later rows update it. Other rows are still processed.
- One bad cell stops the whole file. If a number column holds text, or a TRUE / FALSE column holds anything other than a TRUE / FALSE value (for example the word Yes), the import fails with a message that starts Import failed: Row [n], Col [ColumnName]. Cannot convert [value] to [Decimal] (or [Boolean]) and may continue with technical text. Nothing is saved, including the good rows. Use the column name and the value in the message to find the cell, correct it and import again.
- Everything is saved at once. If the warehouse cannot save the changes, none of the file is saved.
Tip: Codes that start with a zero lose the zero when Excel treats them as numbers. Format such columns as Text before you type the values.
The product template, its 30 columns, the rules for filling it in, the preview and the reasons a row is refused are all described on the Products page, in the section Import Products from Excel. A file in the older, shorter product layout, such as the workbook from Export to Excel, still imports and shows the same preview; in it, write TRUE or FALSE in the lot, serial and expiry control columns.
The page Import Customers says: "Upload an Excel (.xlsx) file to create or update Customers in bulk. Rows are matched to your list by code." The template Customers-template.xlsx has one sheet, Customers, with these columns. Only CustomerCode is required.
| Column | Same as this field on the customer page | What to enter |
CustomerCode (required, the key) | Customer number | Your unique customer code. |
CompanyName | Company name | The legal or trading name. |
ContactPerson | Contact person | Who the warehouse should contact. |
Email | Email | One or several addresses separated by commas. |
Phone | Phone (section Details) | A contact number. |
Description | Description | Notes about the customer. |
TaxId | Tax ID | The tax registration number. |
BillToName | Bill to (section Bill to) | The name for Invoices when it differs from the company name. |
BillToPhone | Phone (section Bill to) | A phone number for the invoice recipient. |
BillToAddress1 | Address 1 | The invoice street address. |
BillToAddress2 | Address 2 | Suite, unit or floor. |
BillToCity | City | The city. |
BillToStateProvince | State/Province | The state or province. |
BillToZipPostal | Zip/Postal | The postal code. |
BillToCountry | Country | The country. |
The customer import never touches delivery (ship-to) addresses. It changes only the details and the Bill to fields. A customer created by import has no delivery addresses until you add them on the Addresses tab of its page, and existing addresses are never changed or removed by an import. The workbook from Export to Excel (Customers.xlsx, sheet Customers) has the same 15 columns.
The page Import Vendors says: "Upload an Excel (.xlsx) file to create or update Vendors in bulk. Rows are matched to your list by code." The template Vendors-template.xlsx has one sheet, Vendors, with these columns. Only VendorCode is required.
| Column | Same as this field on the vendor page | What to enter |
VendorCode (required, the key) | Vendor number | Your unique vendor code. |
CompanyName | Company name | The legal or trading name. |
Description | Description | Notes about the vendor. |
ContactPerson | Contact person | Who to contact about Purchase orders. |
Email | Email | One or several addresses separated by commas. |
Phone | Phone | A contact number. |
Address1 | Address 1 | The street address the goods ship from. |
Address2 | Unit | Suite, unit or floor. |
City | City | The city. |
StateProvince | State/Province | The state or province. |
ZipPostalCode | Zip/Postal code | The postal code. |
Country | Country | The country. |
The workbook from Export to Excel (Vendors.xlsx, sheet Vendors) has the same 12 columns.
Messages you may see
| Message | What it means | What to do |
| Choose a file first. | You pressed Import with no file chosen (Customers and Vendors). | Choose your .xlsx file and press Import again. |
| Import complete: {0} created, {1} updated. | The import worked. | Click Back to Products (or Customers, Vendors) and check the list. |
| Row {n}: missing CustomerCode - skipped. / Row {n}: missing VendorCode - skipped. | Row {n} of the sheet has no key, so it was skipped (Customers and Vendors). In a product import the same row is listed under Rows that will not be imported instead. | Fill in the key on that row and import again; rows that already worked are simply updated again. |
| Import failed: {0} | The whole file was refused. {0} gives the reason, such as a cell that is not a number or a file that is too large. | Correct the problem. Nothing was saved, so import the whole file again. |
| You don't have access to this section. | Your user cannot manage this list. | Ask your warehouse to turn on the Manage switch. |
Good to know
- In the customer and vendor imports you cannot clear a value: a blank cell always keeps what is there. In the product template, type (clear) to empty a text or number value.
- In the customer and vendor imports, a single wrong number or TRUE / FALSE cell stops the whole file and nothing is saved until the file is clean. In the product import, a row with a wrong value is refused in the preview and the other rows still import.
- There are no warnings for a value that is accepted but looks odd, such as a typo in a category. Check the list after importing.
- Re-importing a file is safe for rows that did not change: existing keys are updated, not duplicated.
Related pages