I would like a program that looks at two columns in an excel spreadsheet or CSV. These columns are SKU and description. The user must select the spreadsheet and then select either a path to a folder location ( must also look into subfolders) where images are located or choose a checkbox to search google images. The user then presses process. The program will then run through the excel list and compares the image in the folder to the sku and the description. After processing the files the user will then be presented with a grid where he/she can select the most appropriate picture from 5-10 of the closest options. If it cannot find an image in the folder then it must do a search and pull a few image options from the web. The user can select either plu or description or both to be entered into web search criteria
Please note that this is a matching algorithm, the picture files will not have the exact name as the sku and the description field in the Excel/CSV file. It may have a part or elements of either the plu or the description so this is why it need to match 5 of the closest and present the user these on a grid to select the appropriate pic. Once the user goes down the list selecting pics he/she clicks a button and the system renames and saves the pictures in a selected folder. The images must be renamed the same as the sku.
I would prefer this to be written in either visual studio or livecode, but as long as it works i dont really care