The business receives optical scan files from suppliers.
Some suppliers provide them ready to import. Others don’t.
The practice system identifies products using a UPC code, but certain suppliers name the files using their own model names instead.
Because of this mismatch, the files could not be uploaded directly.
Staff had to manually:
• Check the catalogue spreadsheet
• Match each item to the correct product
• Rename every scan file
• Then run another tool to convert the files into the required upload format
This process was slow and mistakes caused failed imports.
A custom tool was created that:
The files are now ready for conversion without manual checking.
Manual matching and renaming of supplier files
Files prepared correctly in one run
