Hi Ray. Ok my questions to your reply;
(1) when you said 'save the image into a folder with the SKU...what did you mean? Because if you mean the actual folder named as the SKU, then that would mean lots of folders so would take even longer to search through!
(2) taken from above I could create folder names as brands, and then the SKUs within the brand folder...that could be a better way of reducing.
(3) the main reason I put this forum post forward for feedback is because the client wants to provide me with an excel spreadsheet of products, now if I were to store image filenames in an image table on the database, then that would mean the client would need to know the ID column from the products table to then input into a second spreadsheet for the image table....that will get very messy since the client only has basic computer skills...that's why I thought to just allow them to upload the images directly as I can use a multi image upload script file where they can drag and drop images on the webpage and they get uploaded automatically, and as long as the image name has the correct SKU then it would automatically be associated with the product in the database.