# Import Item Masters from Excel

YouTube: [How to import item master from an excel sheet?](https://www.youtube.com/watch?v=kTRYxH3vIPA)

## 📥🧾 How to Import Item Master from Excel in Logic ERP

Importing your **Item Master** from Excel 💻 into Logic ERP 📦 helps save time ⏱️ and reduce manual entry errors 📝❌. Let’s walk through the entire process step-by-step! 🧭

***

### 🚪 Accessing the Import Feature

1. Open **Logic ERP** 🖥️
2. Navigate to the **Main Menu** 🧭
3. Go to **Utilities** 🔧
4. Click on **Import Masters from External File** 📂

***

### ⚙️ Configuring Import Settings

1. Under **Import Configuration**, select **Items** 📦
2. Give your configuration a **unique name** 🏷️ (for reuse later)
3. Press **Tab** ⌨️ to move to the next step

***

### 🔗 Establishing a Connection with Excel

1. Go to the **Connection** section 🔌
2. Choose **Microsoft Excel** as the source 📊
3. Click **New Connection** ➕
4. Name your connection 🏷️
5. Select it and open your **Excel file** 📂
6. Ensure the file is `.xls`  (**Excel 97-2003 Workbook)** or `.xlsx`  (**Excel Workbook)** format 📁
7. Pick the appropriate worksheet 🧾 and **Save Configuration** 💾

***

### 🗂️ Selecting Data Source & Mapping Columns

1. Press **Tab** ➡️ to continue
2. Select the right sheet as your **Data Source** 📋
3. Identify and select all the columns that need to be imported from the Excel sheet:
   * 🏷️ Item Name
   * 🏢 Company
   * 🎨 Shade
   * 📚 Grouping
   * 🧾 GST
   * 📐 Sizes

***

### 🔄 Refreshing Data & Mapping Fields

1. Click **Refresh** 🔃 to update the imported data
2. Map the selected columns from the Excel sheet with the corresponding fields in Logic ERP. 📌
3. In the **Field Expression Column**, press **Spacebar** ⌨️ to open the dropdown.
4. Carefully choose the appropriate field from the list to ensure correct data mapping. 🧠
5. This process ensures that each data field is correctly linked, reducing errors in data transfer.
6. Leave **Item Code** blank if you want to generate it automatically in the next step🆓

***

### 🔢 Creating an Expression for Item Code

1. Define a **prefix** for item codes ➕
2. Open the **Expression Generation Window** 🪟
3. Type the required special characters and values manually. 
4. Enter characters, values & pick:
   * 🆔 **Item Code Prefix**
   * 📏 **Max Item Code Field**
5. Click **Save Expression** 💾 and assign a name to the newly created expression.
6. In the **Field Expression Column** for Item Code, right-click and **➡️**insert the saved expression.
7. Apply and **save configuration** ✅

***

### 📤 Importing the Item Master Data

1. Click on **Import button** 📥 to transfer the item master data into Logic ERP.
2. System will generate **Item Codes** automatically 🆗
3. Alternatively, import them manually from Excel ✍️

***

### 🔍 Verifying Imported Data

1. Review all imported data carefully 👁️
2. Check if fields are correctly populated in Logic ERP 🧾
3. Click **Save** once everything looks good 💾

***

### ✅ Confirming the Imported Items

1. Go to **Item List** 📃
2. Right-click and select **Refresh Tree** 🌳
3. The latest item should appear on the list ✅
4. Confirm & Verify that all details:
   * ✔️ Item Name
   * ✔️ Company
   * ✔️ Shade
   * ✔️ Grouping
   * ✔️ GST
   * ✔️ Sizes
   * ✔️ Item Code
   * ✔️ Rates and other details

***

### 📌 Conclusion

By following this emoji-powered guide 🚀, you’ll easily import your **Item Master** in Logic ERP:

💡 Save time.\
🧠 Reduce manual errors.\
♻️ Reuse saved configurations.\
📊 Keep your data organized & up-to-date.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://kb.logicerp.com/logic-erp-in-action-a-feature-overview/retail/inventory-management/import-item-masters-from-excel.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.