Skip to main content
SCS IT / Linard

Automated supplier data integration for IT hardware

For SCS IT / Linard, CONSENSO TECH developed an application to automate daily supplier data. Product catalogues, prices and stock levels from various supplier files are processed, transformed and made available for ERP and eCommerce processes.

At a glance

Starting point

  • Daily product and stock data from several IT hardware suppliers
  • Differing file formats, currencies and data structures
  • Manual preparation for ERP and eCommerce
  • A need for dynamic pricing logic and promotion capability
  • Updating existing products and capturing new items
  • Handling product conditions such as NEW, REF, USED, RENEW or OEM-compatible
  • Duplicate and deletion logic per supplier

Solution

  • Development of an application for supplier data import and export
  • Processing of multiple supplier files
  • Combination with ERP product data from OPACC
  • Support for CHF, EUR and GBP including exchange rate logic
  • Mapping onto defined export structures
  • Rules for price mark-ups, minimum prices and product conditions
  • Data validation, editing and deletion logic
  • User interfaces for import, validation, configuration and export
  • Preparation of export files for the ERP and eCommerce platform

Result

  • A significant reduction in manual data preparation
  • Up-to-date product prices and stock levels
  • Faster onboarding of new products
  • Better control of pricing logic and promotions
  • Higher data quality through validation and mapping
  • A foundation for further automation, for example FTP processing or additional product data sources

SCS IT is a B2B IT reseller whose business model depends heavily on up-to-date product, price and stock data from various suppliers. Until now, supplier files arriving daily were converted manually in order to update existing products, prepare new items and make the data available for ERP and eCommerce processes.

CONSENSO TECH developed an application to automate this process. The solution processes supplier files in different formats and currencies, combines them with existing ERP product data and generates structured export files for further processing. Existing products can be updated with current prices and stock levels; new products are prepared as new records for import.

Rules for price mark-ups, minimum prices, product conditions, supplier logic, duplicates and deletion or exception cases were also taken into account. Through the user interfaces, files can be imported, data validated, configurations adjusted and exports triggered.