When exporting the products file as a CSV, I cannot figure out a way in Excel or other to take the multiple products image URLs on multiple lines, and put them all in one cell, separated by commas. I have them sorted by position.
Excel gurus out there? My sheet only has SKUs, Image Src and Image Position columns.
Thanks in advance.
Hey, @monero
The concatenate function in excel should help you accomplish this. I found a youtube video that will show you how to accomplish this. Right around the 2:10 second mark it’s discussed.
If there is anything else I can help you with, please let me know.
Thank you so much. Didn’t know about textjoin and how it can skip over empty cells.
Actually, it has one flaw unless I am doing something wrong. The formula will begin producing erroneous data unless all products have the same number of images.
What I ended up doing is get the data from an app that does eBay listing feeds, load into excel via get external data from the web (so I can keep it updated), manipulate the data in power query, then load into another sheet to get exactly one cell with values separated by commas.
Great workaround! Glad you were able to get it worked out for your specific needs.
If there is anything else I can help you with, please let me know.
I have created a sheet with semicolon separated image src column, with each url separated. It will only upload 1 image per sku still. What am I doing wrong?