butte wrote:No missing function. Use the tool to draw down an Export of what you have, so the example is there to follow.
Not so minor point of lingo. If ALL are simply in /image/cache/data, then that can be added to fronts of all images. If they're in subdirectories, that will complicate the task below. You upload originals into /image/data/ but the spreadsheet and OC are looking instead at thumbnails generated into /image/cache/data. Notice that in the example Export drawn down before you start, and follow it.
Each image will have its address path (which if you're lucky in prepending them will end with the data/ part), and if there are spaces in the names you'll wish there weren't but you can cure that by editing a command line directory list shunted into a text file (change all " " to "_"). You can Sort another column in the spreadsheet (such as product name) for the numbering sequence, separately sort the image list, then draw latter into former in the correct column. You must set up the numbered images to match the spreadsheet. With paths on their fronts, they wont Sort by number without some macro gymnastics (ignore nose, sort other end). You can try adding paths after the images' column has them in sequence, since you can follow between tree and blocks of common products, then tell Excel to add each path.
So say I have product numbers
The image location is
I could make columns with
Add them together via a formula to get data/image.jpg
Copy that into my product numbers
Copy that onto a new spreadsheet, delete the formulas and then add the product numbers which should be surrounded by data/image.jpg and then upload that.
Do I need to have the images located on my image directory, prior to import upload. I did what I described earlier and attempted to upload, without the pictures on my image directory and got an error.
I tried the next day without the images process I described earlier and it uploaded fine.