A team of Data Maintenance Officers manage inventory data for a master database and for other businesses ERP systems.
The data being maintained consists of: Suppliers details, products, descriptions, pricing, special quantity pricing, barcodes, promotions.
The supplier would supply the Data Maintenance team with a price list in Excel format containing all of their products and pricing that will be coming into effect.
The data team would:
After understanding each step of the process, we were able to automate and streamline over 80% of the process in Access and Excel using VBA. After implementing the automated process, the data team would:
Further Excel macros were designed to split the data out of the main working file into separate files and reports after it has been checked, ready for distribution to each of the clients.
Further Excel macros were designed to prepare each of the clients files in a format ready to import into their ERP systems to update the pricing and product data.
(After some years, this was then developed into a web application to incorporate multiple ERP systems, various data sources and the ability to scale – see our post called WebApp: Inventory Data Management v2.0)
We take the stress out of websites for you and offer quick, easy web design so you can get your business online as quick as possible. Start growing and get exposure now!
Below is what you get when you sign up to our site:
*Content and images need to be supplied