P4 Software
/
logisticaHQ-en
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
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.
Setup > Products, then Import at the top of the list. The Download import template link is beside it.
The accepted rows are saved together: either every one is saved or none is. Importing the same file twice changes nothing the second time.
(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.)12,5 is refused, never read as 125.There are 28 columns, always in this order. Headings are compared ignoring capitals and spaces.
| Column | What it accepts |
|---|---|
| Sku | Required. A SKU that exists for that client is updated; a new one is created. |
| Upc, BarcodeValue | Text. The barcode must suit its type (digits, length, check digit), as on the product screen. |
| BarcodeType | Code128, ITF14, EAN13 or UPCA. |
| Category | Text. It is written on the product; no category is created. |
| Description | Text. On a product with pack sizes, the product's description is the one on its Each (x1) row. |
| Bill of material controlled | Y only for a product that already is a bill of material. The import never creates one and never changes its components. |
| Decimal controlled, Decimal UoM | Y 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 controlled | Y or N. |
| Packsize controlled | Y or N. A product with pack size rows needs Y. |
| Packsize name, Packsize barcode, Packsize type | The pack's name and barcode, and the barcode type (Code128, ITF14, EAN13 or UPCA). |
| Eaches | A whole number: how many single units the pack holds. |
| Width, Height, Length, Weight | A plain number, zero or more: the pack's own measures. On the Each (x1) row they are also the product's. |
| Length UoM, Weight UoM | Length: 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. |
| Client | The client's name as it appears under Clients. |
| Hazmat | Y or N. |
| Nmfc, Commodity | Text. |
| Freight class | 50, 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.
| 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. |
Was this page helpful?