Skip to content
P4 Software P4 Software / logisticaHQ Client Portal

Add these docs to Claude

Ask Claude questions about these docs. Claude reads the published pages and links you back to them. Copy this address:

https://p4-software.opendocs.page/mcp

In claude.ai or Claude Desktop: open Settings, then Connectors, choose Add custom connector and paste the address.

In Claude Code, run:

claude mcp add --transport http docs https://p4-software.opendocs.page/mcp

Importing and exporting with Excel

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.

CompareExport (toolbar)Export to Excel
What you getA 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 namePortalProducts.xlsx, PortalCustomers.xlsx or PortalVendors.xlsxProducts.xlsx, Customers.xlsx or Vendors.xlsx
FiltersRespected.Ignored: you always get the whole list, sorted by SKU (Products) or by code (Customers and Vendors).
DatesWritten like Jan 05, 2026 - 03:30 PM.The workbook has no date columns.
Best forSharing 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.

Step by step: Products

  1. 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.
  2. 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.
  3. 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."
  4. Choose your file with the file picker. Import is not available until a file is chosen.
  5. 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.
  6. 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.
  7. 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.

Step by step: Customers and Vendors

  1. 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.
  2. 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).
  3. 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.
  4. Choose your file with the file picker.
  5. 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.
  6. 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.

Rules for Customers and Vendors

  • 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.

Importing Products

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.

Importing Customers

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.

ColumnSame as this field on the customer pageWhat to enter
CustomerCode (required, the key)Customer numberYour unique customer code.
CompanyNameCompany nameThe legal or trading name.
ContactPersonContact personWho the warehouse should contact.
EmailEmailOne or several addresses separated by commas.
PhonePhone (section Details)A contact number.
DescriptionDescriptionNotes about the customer.
TaxIdTax IDThe tax registration number.
BillToNameBill to (section Bill to)The name for Invoices when it differs from the company name.
BillToPhonePhone (section Bill to)A phone number for the invoice recipient.
BillToAddress1Address 1The invoice street address.
BillToAddress2Address 2Suite, unit or floor.
BillToCityCityThe city.
BillToStateProvinceState/ProvinceThe state or province.
BillToZipPostalZip/PostalThe postal code.
BillToCountryCountryThe 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.

Importing Vendors

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.

ColumnSame as this field on the vendor pageWhat to enter
VendorCode (required, the key)Vendor numberYour unique vendor code.
CompanyNameCompany nameThe legal or trading name.
DescriptionDescriptionNotes about the vendor.
ContactPersonContact personWho to contact about Purchase orders.
EmailEmailOne or several addresses separated by commas.
PhonePhoneA contact number.
Address1Address 1The street address the goods ship from.
Address2UnitSuite, unit or floor.
CityCityThe city.
StateProvinceState/ProvinceThe state or province.
ZipPostalCodeZip/Postal codeThe postal code.
CountryCountryThe country.

The workbook from Export to Excel (Vendors.xlsx, sheet Vendors) has the same 12 columns.

Messages you may see

MessageWhat it meansWhat 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

Was this page helpful?