📥 Import

The Import module allows you to upload and update data in the Pricelist Server via Excel files. It supports various types of content and ensures integrity through a preliminary check (pre-flight) before the final import.

Imports allow you to:
• add or update items and multilingual descriptions
• update multiple prices simultaneously
• upload or update multilingual headers
• define parent/child relationships between items
• import compositions with dedicated components, quantities, and price columns
Each import performs an automatic check on the file and reports any anomalies before proceeding.

🧱 Main Screen
The screen displays the available import types:
• Items and Descriptions
• Prices
• Headers
• Parent and Child
• Compositions
For each section, you can:
• select an Excel file
• click Import to start the verification
• click Cancel to stop the operation

🧪 Pre-Flight Check
Before importing data, the system verifies the file content.
Possible results:
• ✅ Valid file → proceed with the import
• ⚠️ Warnings → the file can be imported, but verification is recommended
• ❌ Errors → the file cannot be uploaded; correct and try again
At the end of the import, a confirmation message is displayed, and the data is immediately available in the system.

📦 Items and Descriptions
Allows importing items and their descriptions in the enabled languages in the catalog.
Required format:
• Column COD → item code
• Description columns per language → e.g., IT_DES, UK_DES, …
The first row of the file must contain the correct headers.

💰 Prices
Allows updating item prices on a price list.
Required format:
• Column COD → item code
• Price columns → corresponding to the columns defined in the price list (e.g., 001, 002, 100, …)
The first row of the file must contain the correct headers.

🏷️ Headers
Allows importing headers.
Required format:
• Column COD → item code
• Description columns per language → e.g., IT_DES, UK_DES, …

🧩 Parent and Child
Defines hierarchical relationships between items.
Required format:
• Column MASTER → parent item code
• Column CHILD → child item code
Child items automatically inherit the parent’s description and update when the parent is modified.

🧱 Compositions
Allows importing items composed of multiple components, with quantities and multi-column price management.
Required format:
• CODART → component item code
• CODCOMPO → composition code (header)
• RIGA → line number in the composition
• QTA → component quantity
• COLONNA1 … COLONNA5 → columns where to find the component price
• IT_DES + additional languages → line description for each catalog language
It is possible to specify up to 5 different price columns for the same item, useful for managing multiple price values associated with the composition.

💾 Actions
• Import → starts file analysis and possibly data loading
• Cancel → stops the operation without changes

🧠 Operational Tips
• ensure the first row of the file contains the correct headers
• import items first, then prices, then relationships and compositions
• use template files to avoid structural errors
• verify price column codes before loading

---