AI Smart Detection

LOP uses AI to automatically understand the structure and column layout of your packing list files. Instead of manually mapping every column, AI Smart Detection analyzes your file and suggests the correct mappings with confidence scores — so you can review and import in seconds.

How It Works

AI Smart Detection runs a two-stage pipeline when you upload a file:

Stage 1 — Structural Analysis

This runs instantly on every file and detects:

• Header row — finds the actual header row even if it is not in row 1. Summary rows, title rows, and metadata above the header are identified and skipped.
• Footer rows — totals, averages, and summary rows at the bottom are excluded from import.
• Decimal separator — European format (comma as decimal: 1.200,50) and US format (period as decimal: 1,200.50) are detected automatically.
• Combined dimensions — columns containing values like 1200x800x600 or 4 x 2.4 x 2.3 are identified and split into separate Length, Width, and Height values.
• Merged cells — Excel files with merged header cells are expanded automatically.
• Transposed layouts — detects if data runs in rows instead of columns.

Stage 2 — AI Column Mapping

After structural analysis, AI examines your column headers and sample data to map each column to the correct item property (Name, Length, Width, Height, Weight, Quantity, etc.).

Each mapping receives a confidence score shown as a colored badge:

Unit Detection

AI Smart Detection identifies dimension and weight units through a priority chain:

1. Header hints — if your column header contains a unit like [mm], (cm), Length (m), or Gewicht (kg), that unit is used directly.
2. AI detection — the AI analyzes header text and sample values to infer the most likely unit.
3. Magnitude inference — if no unit is found in headers or by AI, the system looks at value ranges. For example, values like 1.2, 2.4, 0.8 are likely meters, while 1200, 2400, 800 are likely millimeters.
4. Default — if no unit can be determined, millimeters (mm) is used as the default.

You will see labels next to the unit dropdown indicating how the unit was detected:

• "AI detected: meters" — the AI identified the unit from your data
• "Inferred from values — verify" (amber) — the unit was guessed from value magnitudes; double-check it is correct

You can always override the detected unit manually using the dropdown.

Enabling AI Smart Detection

1. Open the import dialog (from the Items Panel or Item Library)
2. Upload your Excel or CSV file
3. Check the "AI Smart Detection" checkbox
4. The system runs structural analysis, then AI enhancement
5. Review the suggested column mappings and confidence badges
6. Adjust any amber or red mappings, confirm units, then import

Supported File Formats

Multi-Language Support

AI Smart Detection recognizes column headers in:

• English — Name, Length, Width, Height, Weight, Quantity
• Turkish — Malzeme Adı, Uzunluk, Genişlik, Yükseklik, Ağırlık, Miktar
• German — Bezeichnung, Länge, Breite, Höhe, Gewicht, Menge
• French — Nom, Longueur, Largeur, Hauteur, Poids, Quantité

Regional variations and abbreviations (e.g., "Qty", "Brüt Ağırlık", "Bruttogewicht") are also recognized.

Tips for Best Results

• Use descriptive column headers. "Length (mm)" will always be detected correctly. "Col A" may not.
• Keep data clean. Remove images, charts, and decorative formatting from your spreadsheet before uploading.
• One item per row. Each row should represent one item type with its dimensions and quantity.
• Check combined dimensions. If your file has "1200x800x600" in a single column, AI Smart Detection will split it automatically — but verify the L/W/H assignment is correct for your orientation.

Next Steps

• Importing from Excel or CSV — the standard import workflow
• ERP Import — importing from enterprise systems
• Item Properties — understanding what each imported field controls