# Import serial /IMEI number wise bulk purchase from external file (Excel/Text)

YouTube: [Import Serial numbers from Excel](https://youtu.be/DdTZGsfCuxc?si=KzhKIFhKSgtFtIV0)

### 📥📱 **Import Mobile/SIM Serial Numbers via Excel – Step-by-Step Guide**

This tutorial provides a comprehensive walkthrough for **importing🔑 mobile or SIM serial numbers from an Excel sheet** and **linking them to specific items** within a purchase voucher. This process is designed to **streamline inventory management**, **eliminate** the need for **manual data entry** and **saves time ⏱️.**

***

### 🧾**Overview**

When mobile devices or SIM cards are purchased, it's essential to **track their unique serial numbers**🔢 for inventory, warranty, and compliance purposes. The system provides a feature to **import** these serial numbers directly from an **Excel file**📊, making the process **quick** and **error-free**✅.

***

### 🛠️**Step-by-Step Instructions**

#### 🔹**Step 1: Navigate to the Purchase Menu**

* 🔐Log into **Logic ERP**.
* 📁From the **main menu**, click and expand the **Purchase** option.
* 🧾Then select to open **Assign SIM/Mobile Numbers against Purchase** option. 
* 📋This option opens the **serial number assignment** window, where you can associate serial numbers with purchased items.

This section displays all purchase-related activities, including invoices, vouchers, and stock entries.

***

#### 🔹**Step 2: Select a Purchase Voucher**

1. 🧾 View the list of purchase vouchers.
2. 🔍 Use **search** or **filters** to find the relevant voucher quickly.
3. ✅ Select the voucher for which you want to assign serial numbers.

***

#### 🔹**Step 3: Choose the Relevant Items**

* 📦Once the **voucher is selected**, a list of items included in the purchase will be displayed.
* 📱Select the specific items **(e.g., mobile phones, SIM cards)** that require serial number entry.

***

#### 🔹**Step 4: Import Serial Numbers from Excel**

* 📤Click on the **Import from Excel** or **Upload Excel** button available in the toolbar.
* 🗂️A file browser window will appear. 
* 📑Locate and select the Excel file from your device that contains the list of serial numbers.

  > 📌**Note**: Ensure the Excel sheet is properly formatted. Each serial number should be listed in a single column, and the number of serials must match the quantity of the selected item(s).

***

#### 🔹**Step 5: Automatic Assignment of Serial Numbers**

* 🤖After selecting the file, the system will automatically **read the serial numbers** and **assign them to the respective items** in the purchase voucher.
* ✅You will see a **confirmation message** once the **import is successful**.
* ⚠️If there are any **mismatches** or errors **(e.g., missing serials, invalid formats)**, the system will notify you for correction.

***

### ✅**Final Confirmation**

* 🔍**Review** the assigned serial numbers to ensure accuracy.
* 💾**Save** or **confirm** the assignment to finalize the process.

***

### 🏁**Conclusion**

By using the **Excel import feature**, you can efficiently assign mobile or SIM serial numbers without:

* ❌ Manual errors
* 🚀 You speed up the process
* 📊 Keep accurate inventory trail for future tracking and audits.
* 💼 Especially useful for **bulk purchases**!

Stay organized, stay efficient! 💡📦📈


---

# 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/distribution/purchase/import-serial-imei-number-wise-bulk-purchase-from-external-file-excel-text.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.