This project is a desktop-based integration system that processes Excel files and synchronizes data with Logo ERP (Enterprise Resource Planning) system.
The application allows users to import Excel data, validate it, and automatically create:
- Sales orders
- Purchase invoices
- Customer accounts (CARİ)
- Stock and material records
- Lot-based inventory transactions
The system acts as a bridge between Excel-based operational data and ERP infrastructure.
The project follows a layered architecture:
- DAL (Data Access Layer) → ERP & database operations
- BLL (Business Logic Layer) → Business rules and processing logic
- EL (Entity Layer) → Data models
- UI (Windows Forms) → User interface for Excel upload & control
- User uploads an Excel file
- Data is parsed and displayed in a DataGridView
- System validates data (stock, customer, warehouse checks)
- User triggers processing via UI buttons
- Application:
- Groups and processes data
- Creates or updates ERP records
- Sends data to Logo ERP via API/helper library
- Results are reflected in ERP system
- 📂 Excel file import and parsing
- 📊 Data visualization in DataGridView
- 🔍 Data validation (stock, customer, warehouse checks)
- 🧾 Automatic sales order creation in Logo ERP
- 🧾 Purchase invoice generation
- 👤 Automatic customer (CARİ) creation
- 📦 Stock and material synchronization
- 🔖 Lot tracking (batch, warehouse, expiration date)
- ⚙️ ERP integration via Logo Helper API
- 🧠 Grouped data processing (customer-based & product-based logic)
- C#
- Windows Forms
- Dapper (Micro ORM)
- MSSQL
- Logo ERP Integration (LogoHelper SDK)
- LINQ
- Excel Data Processing
The application uses appsettings.json for ERP and database configuration:
{
"ConnectionStrings": {
"DefaultConnection": "Data Source=YOUR_SERVER;Initial Catalog=YOUR_DB;Integrated Security=True;"
}
}Through this project, I gained experience in:
ERP system integration (Logo ERP) Real-world data flow design (Excel → ERP) Business logic for enterprise systems Grouping and transformation of large datasets Layered architecture in production-like systems Working with external APIs and ERP libraries
This project was developed during my education and internship period.
Dapper was preferred in this project for lightweight, high-performance database access and fine-grained SQL control during ERP integration operations.
Many operational teams manage order and inventory data in Excel files, while ERP systems require structured and validated data input.
This project was developed to automate the transformation of Excel-based operational data into ERP transactions, reducing manual processing time and minimizing human error.
This project represents my experience in building real-world ERP integration systems.
The main focus was on transforming raw Excel data into structured ERP transactions such as orders, invoices, and inventory movements.
While the system is functional and used as a working prototype, future improvements may include better error handling, UI enhancements, and performance optimization for large datasets.
The application integrates with Logo ERP Enterprise/Tiger systems through helper libraries and ERP-side operations.