JohnnyDrama
New Member
- Joined
- Mar 31, 2020
- Messages
- 4
- Office Version
- 365
- Platform
- MacOS
Hi guys,
hope everyone is doing fine these days!
I've got a questions regarding creating image URLS in bulk.
I work at a small company who sell mainly to only key accounts like Amazon.
We have over 15.000 different SKU's so you can imagine how many images we have (roughly 150k).
All images are named by barcode, following up with _1 _2 for lifestyle images;
Now we host all the images on a FTP which creates a link.
I am fine with creating links, merging cells and so on but the problem is this (hopefully I explain this right).
When we have to fill out the datasheet for our customer they request all the images per SKU in 1 row in Excel.
See below;
Now I have to do this in bulk for all 15.000 images.
I can get all the file names in Excel, no problem, but then all the filenames are underneath eachother.
Each unique barcode has to be on 1 row in Excel.
So basically, how do I turn this;
Into this; (ignore the SKU code and Product, but that's how the data sheets usually look here..)
Many thanks.
Cheers.
JohnnyD.
hope everyone is doing fine these days!
I've got a questions regarding creating image URLS in bulk.
I work at a small company who sell mainly to only key accounts like Amazon.
We have over 15.000 different SKU's so you can imagine how many images we have (roughly 150k).
All images are named by barcode, following up with _1 _2 for lifestyle images;
4037571322237.jpg |
4037571322237_1.jpg |
4037571322237_2.jpg |
4037571322237_3.jpg |
4037571322237_4.jpg |
Now we host all the images on a FTP which creates a link.
I am fine with creating links, merging cells and so on but the problem is this (hopefully I explain this right).
When we have to fill out the datasheet for our customer they request all the images per SKU in 1 row in Excel.
See below;
Barcode | SKU Code | Product | Productimage | Lifestyle Image | Lifestyle Image 2 |
4037571320936 | ABCDE123 | SAMPLE PRODUCT | http://link.com/4037571320936.jpg | http://link.com/4037571320936_1.jpg | http://link.com/4037571320936_2.jpg |
4037571386215 | ABCDE124 | SAMPLE PRODUCT 2 | http://link.com/4037571386125.jpg | http://link.com/4037571386125_1.jpg | http://link.com/4037571386125_2.jpg |
Now I have to do this in bulk for all 15.000 images.
I can get all the file names in Excel, no problem, but then all the filenames are underneath eachother.
Each unique barcode has to be on 1 row in Excel.
So basically, how do I turn this;
4037571320936.jpg |
4037571320936_1.jpg |
4037571320936_2.jpg |
4037571386215.jpg |
4037571386215_1.jpg |
4037571386215_2.jpg |
4037571386215_3.jpg |
4037571322237.jpg |
4037571322237_1.jpg |
4037571322237_2.jpg |
4037571322237_3.jpg |
4037571322237_4.jpg |
Into this; (ignore the SKU code and Product, but that's how the data sheets usually look here..)
Barcode | SKU Code | Product | Productimage | Lifestyle Image | Lifestyle Image 2 | Lifestyle Image 3 |
4037571320936 | ABCDE123 | SAMPLE PRODUCT | http://link.com/4037571320936.jpg | http://link.com/4037571320936_1.jpg | http://link.com/4037571320936_2.jpg | |
4037571386215 | ABCDE124 | SAMPLE PRODUCT 2 | http://link.com/4037571386125.jpg | http://link.com/4037571386125_1.jpg | http://link.com/4037571386125_2.jpg | |
4037571322237 | ABCDE125 | SAMPLE PRODUCT | http://link.com/4037571322237.jpg | http://link.com/4037571322237_1.jpg | http://link.com/4037571322237_2.jpg | http://link.com/4037571322237_3.jpg |
Many thanks.
Cheers.
JohnnyD.