# Edit Item / Lot Rates from Barcodes
**YouTube:** [Bulk Rates Update through Excel](https://www.youtube.com/watch?v=8qjtiu8a2HM)
## Bulk Rates Update through Excel
This tutorial explains how to **perform bulk rate updates using an Excel sheet** in Logic ERP. It demonstrates how to import updated item or lot rates efficiently using barcodes, saving time and minimizing manual effort.
***
### **Objective of This Feature**
* Update **item or lot rates in bulk**
* Reduce **manual data entry efforts**
* Ensure **accuracy and consistency** in pricing
* Improve **operational efficiency**
***
### **Accessing the Bulk Update Module**
* Navigate to **Main Menu → Inventory Module**
* Open: **“Edit Item / Lot Rates from Barcodes”**
* Click on **“Import from File”.**
***
### **Prepare Excel Sheet**
**Use Help Option**
* Click on **Help Button**
* Review required columns
**Mandatory Requirement**
* **Barcode Column must be included**
***
### **Import Excel Data**
* Click **Browse** and select the Excel file
* Enable: **“Overwrite Existing Rates”** (if required)
**Refresh and Load Data**
* Click **Refresh**
**Result**
* Rates from Excel sheet are imported instantly
* Click **Save** to finalize updates
***
### **Key Benefits**
* Saves **significant time** in bulk updates
* Reduces **manual errors**
* Enables **quick price revisions**
* Improves **data accuracy and efficiency**
***
### **Best Practice Tips**
* Always verify Excel data before importing
* Ensure barcode mapping is correct
* Use overwrite option carefully
***
### **Final Outcome**
* Item/Lot rates are **updated in bulk within seconds**
* Pricing data becomes **accurate and consistent**
* Business operations become **faster and more 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-learning-hub-tutorials-and-best-practices/inventory/edit-item-lot-rates-from-barcodes.md?ask=
```
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.