Skip to content
P4 Software P4 Software / logisticaHQ-en

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 products from Excel

Importing products from Excel
← Back to Products

Applies to: every logisticaHQ tenant. The Import button arrived in version 2.64.5, the template of the previous system (one row per pack size) in 2.64.8, and the template in your own language and the word that empties a value in 2.64.13

Roles required: a user who can enter data. The Import button and the Download import template link are not shown to anyone else

Overview

On the Products list, Import reads an Excel file, shows you what it would do, and saves only after you confirm. Use it to load a whole catalogue or to change many products at once. For a few products, New on the list is quicker.

Good to know: nothing is saved until you press the import button in the preview. If you close the window or press Cancel, nothing has changed.

Navigation

Setup > Products, then Import at the top of the list. The Download import template link is beside it.

Import a file, step by step

  1. Click Download import template. Excel receives a workbook in your own language with three sheets: Products (the sheet you fill in, and the only one the import reads), Example (one product on three rows, with made-up data) and Read me (the rules, and the allowed values of every column that chooses from a list).
  2. Fill in the Products sheet. One row is one pack size of a product. The product's own columns are written again on every row of the same SKU; only the pack size columns, and the description and measures of that pack, change. A product with no pack sizes has one row, and its four pack size columns stay empty.
  3. Click Import and choose your file. The Import products window opens. Nothing has been saved yet.
  4. Read the preview. It shows how many products will be created and updated, how many pack sizes will be created and updated, how many rows will be refused, and the columns that were not recognised and will be ignored. Each refused row is listed with its sheet row, its SKU and the reason. Notes about rows that will be imported are listed apart; they are not refusals.
  5. To save what is accepted, press the import button, for example Import 12 products. The refused rows are not imported. To fix them first, press Cancel, correct the file and import it again.

The accepted rows are saved together: either every one is saved or none is. Importing the same file twice changes nothing the second time.

Rules worth knowing

  • An empty cell keeps what the product already has. It never clears a value. To empty a value, type (clear) in its cell ((borrar) in a Spanish file). This works on the text and number columns, not on Sku, the Y or N columns or the columns that choose from a list. (The previous system emptied a value when the cell was empty; here a file with gaps no longer wipes what the product has.)
  • Y or N columns also accept Yes, No, S, Si, X, True, False, Verdadero, Falso, 1 and 0, in any capitals. Anything else refuses that product.
  • Numbers use a point for decimals. 12,5 is refused, never read as 125.
  • Pack sizes are never deleted by the import. The row with Eaches 1 is the product's own Each (x1), which the system keeps; its measures and description become the product's.
  • The rows of one SKU must agree on every product column. Where two rows disagree, all the rows of that SKU are refused together, and the reason names the column and the rows.
  • Tracking cannot change on a product that has stock. Lot, serial, expiry, manufacture date, decimal, pack size and catch weight control, and the unit of measure, are refused while the product has stock, and, unless the setting Allow attribute change is on, while it is on an open document. See Products.
  • The same rules as the product screen apply. A row that the screen would silently change is refused instead (for example serial control with pack size control). If your company has a rule for required fields and allowed units, the import applies it too: see Working with products under a rule.
  • The client must already exist, written as it appears under Clients. A client that does not exist is refused, never created. On a company with clients, a new product needs its client; a user who works for one client may leave the column empty (it is that client).
  • At most 5,000 rows in one file. A larger file is refused whole: split it. Only one product import runs at a time for a company.
  • Files made for the previous system import as they are. A file made with the Spanish template imports like the English one. A file has one heading language: English headings are read as English, and extra columns with Spanish titles are not read and are listed in the preview. A file that mixes English headings with two or more of the specific Spanish column names is refused.

The columns of the Products sheet

There are 28 columns, always in this order. Headings are compared ignoring capitals and spaces.

Column What it accepts
SkuRequired. A SKU that exists for that client is updated; a new one is created.
Upc, BarcodeValueText. The barcode must suit its type (digits, length, check digit), as on the product screen.
BarcodeTypeCode128, ITF14, EAN13 or UPCA.
CategoryText. It is written on the product; no category is created.
DescriptionText. On a product with pack sizes, the product's description is the one on its Each (x1) row.
Bill of material controlledY only for a product that already is a bill of material. The import never creates one and never changes its components.
Decimal controlled, Decimal UoMY or N. A decimal controlled product needs a Decimal UoM (Gr, Kg, Oz, Lb, Ml, L, Pt, Gal, Mm, Cm, M, In or Ft), and only those do.
Serial controlled, Lot controlled, Expiry controlledY or N.
Packsize controlledY or N. A product with pack size rows needs Y.
Packsize name, Packsize barcode, Packsize typeThe pack's name and barcode, and the barcode type (Code128, ITF14, EAN13 or UPCA).
EachesA whole number: how many single units the pack holds.
Width, Height, Length, WeightA plain number, zero or more: the pack's own measures. On the Each (x1) row they are also the product's.
Length UoM, Weight UoMLength: M, Cm, Mm, In or Ft. Weight: Kg, Gr, Lb or Oz. When empty on a new product, your company's default unit is used.
ClientThe client's name as it appears under Clients.
HazmatY or N.
Nmfc, CommodityText.
Freight class50, 55, 60, 65, 70, 77.5, 85, 92.5, 100, 110, 125, 150, 175, 200, 250, 300, 400 or 500. Anything else is refused.

Fields the template does not carry (GTIN, Subcategory, reference numbers, expiry allowances, patterns, unit cost and others) can be added as extra columns to the right of the 28, with one-word headings such as Gtin, Subcategory, ReferenceNumber or UnitCost: they are read with the same rules.

Troubleshooting

What you see What it means What to do
The file could not be read as an Excel workbook The file is not an .xlsx workbook. Save it as an .xlsx file and import it again.
This file has [n] rows. Import at most 5000 rows at a time. The file is over the limit. Split it into several files.
Another product import is running. Try again in a moment. Someone else in your company is importing. Wait a moment and try again. Nothing was saved.
The rows [2, 3, 4] of the SKU [X] do not agree on the column [Category] Rows of one SKU carry different product values. Write the same value on every row of that SKU, or leave the cell empty on all but one.
Cannot change [...] because it has stock A tracking control of a product with stock cannot change. Move or consume the stock first, or leave that column as it is.
A row for a client that does not exist The client name is not under Clients. Correct the name. The import never creates a client.
Columns listed as not recognised The heading is not one of the 28, or it is the same column as one already read. Use the headings of the template. Extra columns are ignored.

Related features

Was this page helpful?