Automated Price Import as a Smart Sales Tool
Task
LichtFACTOR sells lamps and lighting solutions from hundreds of manufacturers. Until now, manually maintaining price lists in the inventory management system was a significant hurdle that hindered efficient proposal preparation. Employees had to painstakingly calculate prices and discounts for each item. The challenge was clear: an intelligent data import software was needed. An import software that functions as a smart sales tool and fully automates the error-prone process.
Result
Our custom-developed data import software has revolutionized the process. The entire task, which used to take several workdays, is now limited to a few hours for consolidating dealer data into an Excel list. This enormous time savings gives the LichtFACTOR team room to focus on what matters: perfect proposal preparation and excellent customer consulting. The new import software is a stable and reliable sales tool that automatically marks outdated items, ensuring a consistently up-to-date data basis, which provides a real competitive advantage.
LichtFACTOR stands for excellent lighting systems and functional lighting solutions. The Vorarlberg company accompanies customers from the initial conversation to the optimal lighting solution that makes both private and commercial living spaces shine.
Our services
Outcomes
Synchronization with clear logic
The import software performs automatic data cleansing, using the existing Excel price lists as a reference. The process involves several steps: Existing item data is updated by calculating and overwriting selling prices based on current data.
Automatic status notifications for full transparency
The solution combines manufacturer data with real-time inventory from the ERP system. This allows the import software to automatically assign differentiated status notifications such as "not orderable" or "inactive." This creates immediate transparency for quick proposal preparation without manual intervention from employees.
Smart workflow with minimal effort
The entire process is reduced to a single preparatory step: creating the central Excel file. This step, which takes a few hours, involves a responsible employee consolidating data from various dealer lists. Once this file is uploaded, the system, functioning as a sales tool, automatically synchronizes all prices and status information.
Tech-Highlights
An insight into the technology of the import software and its benefits.
Thanks to powerful technologies like Dapper, importing entire price lists is completed in just a few seconds. The data import software is therefore extremely powerful.
The SpecterConsole highlights important information in color, ensuring an exceptionally simple and clear operation. Interaction is thus easy and extremely efficient.
Based on C# and modern open-source libraries, the solution is robust, performant, and easily extensible. A future-proof foundation for any further development.
Technologies used
The following technologies were used to realize the import software.
»With the new import software, we save valuable time and minimize sources of error. The investment has quickly paid off. Every item is always up-to-date at the push of a button, ready for proposal preparation or order.«
