How to pack photos into folders?

Question

Photo

Hello!
I ask you for help or advice on what and how to do.
I have a price list, it contains 58,000 products, each product has a photo in one cell and an additional photo in another cell, separated by commas. prntscr.com/fjo8wb
I have a folder where all the photos of this price list are located and there are about 80,000 photos in it.
Knowing that you can not upload a lot of photos in one folder on the hosting.
How can I organize it so that I can put photos in folders and that the price list contains the correct paths to each photo and to each additional photo?
It's just that if each product is separately prescribed path and scattered across folders, then I'll grow old
Make everything scatter on the computer and propagate the paths correctly and then anger them on the server and already import the price list.
help me please

Answer 1

Files can be scattered into folders whose names are obtained from the characteristics of the product (there are different algorithms). Is the article number included in the file name? If yes, you can sort it into folders formed (named) from articles (parts of the article can be, for example, the first 2 characters) There will be 99 folders. Each has 1000 photos. This information is easy to get in a spreadsheet.