Automated Supplier Pricing

Before the solution, processing supplier files for around 5,000 products took roughly 1 hour, followed by another 1.5 hours to scan and review the products file.
With the automation in place, preparation time was reduced to around 10 minutes, and product file review took around 15 minutes, even after the product catalogue grew to approximately 9,000 products.

Previously, supplier pricing could only be matched when product identifiers were exact. The new system introduced SKU mapping, allowing supplier SKUs to be connected to internal product identifiers even when naming or formatting differed.
This increased the accuracy of applying supplier pricing to products to approximately 90%, including cases where user data entry mistakes were present.

New product setup requires only two main steps:
1. Add a row with the product identifier and description in the main sheet.
2. Map the related supplier SKUs in the mapping sheet.

Once mapped, the product can be included in the automated pricing and supplier comparison process.

The best approach is to avoid working directly with worksheet cells one by one. Instead, VBA should load the data into arrays or dictionaries, process everything in memory, and then write the results back to the worksheet in bulk.