This solution has been successfully working since 2010 in trade organizations selling spare parts for cars, as well as household goods.
In organizations that sell spare parts, the solution works with very large price lists. Sometimes up to a million lines. Before the implementation of this solution, loading price lists was handled by a separate person, who spent up to 2/3 of his working day on this. After implementation, the time was reduced to several hours a week (checking whether the price list formats of suppliers who like to do this have changed).
Where household appliances are sold, the program can process price lists from hundreds of suppliers.
Today the program is implemented using conventional forms (USP, UT). Implementation on managed forms is possible. Change does not require much time.
All the various information about prices and supplier balances, first of all, is reduced to a single data structure and loaded into a special register of information. In the next step, this information register is processed, where it matches the supplier’s data with our nomenclature directory. The main parameters for the docking: this is the article number of the product and the manufacturer of the company. But even if they differ, it is possible to customize all.
If the supplier’s price list contains information on several warehouses, it can also be processed and saved. Depending on the need, we can process either one specific warehouse or several warehouses or all.
In addition to the price, which can also be saved either as Procurement or as Sales (processed according to a specific formula for each product group) information on balances is also saved. Even in the format: 10+, more than 10 etc.
This information can be very easily added either in the form of selection of goods or in the workplace of the manager.
To properly configure, you need to allocate time to the initial setting. In the future, it remains only to periodically check whether there is something new for suppliers, and whether they have changed the parameters of the file being sent (for price lists that we receive by mail).
Fig.2. Choosing a supplier for downloading prices and balances, adjusting data loading settings.
The following form sets the data: