PicURL Excel Spreadsheet for Variation listing issues

[rwhite2022]

I am a trading card and sports card guru and after trial and error I finally got the variation spreadsheet to upload successfully with no errors. The issue I am having now is that when I open the listing all the variation photos are the same as the main photo. In the Excel spreadsheet I have a main photo URL link on the main variation line and seperate URLs links for each variation line. I know the links work because I can manually add them to a listing on eBay.

What I have found and I am hoping that someone has a fix for this is that when I upload the Excel spreadsheet and then edit the listing and edit the variations, the option for ADD VARIATION PHOTOS is defaulted to USE DEFAULT PHOTOS. I have to manually select my variation name and then would have to manually re-enter all the photos or photo URLs.

Is there a way on the spreadsheet to change the ADD VARIATION PHOTO option so that the main variation photo and all individual variation photos upload? I really hate to do double/triple the work.

[shipscript]

Each variation line would have its own PicURL that is named for the variation.

If the name of a card in the drop list is "Blue card", then the PicURL entry would be like this:

Blue card=https://myhost.com/image0003.jpg

 If there are multiple photos for the card, the entry would look like this:

Blue card=https://myhost.com/front.jpg|https://myhost.com/back.jpg

The variation images do not need to be on the same line or same order as the variations they represent, although that helps when manually working with the file. They are managed separately and solely by the name in front of each URL.

[rwhite2022]

That was the issue. Thank you. Now for my next issue.

1. Relationship column = Variation
2. RelationshipDetails column = Card#/Name=001/203 SS Pinsar
3. PicURL column = https://den-cards.pokellector.com/325/Leafeon-VMAX.SWSH7.8.39878.thumb.png

Using the code =P7&""&R7 in a blank cell successfully combines Card#/Name=001/203 SS Pinsar to the front of the URL. Unfortunately it removes the hyperlink from it.

The question is how create a new hyperlink called:

001/203 SS Pinsar=https://den-cards.pokellector.com/325/Leafon-VMAS.SWSH7.8.39878.thumb.png in the PicURL column and the original hyperlink still work. I am sure there must be some VBA code that should do all this.

[shipscript]

@rwhite2022 

Do you have a reason to preserve a hyperlink? The URL itself is all that eBay needs. When exported as a flat CSV file, underlying codes (like links and formulas) will be stripped.

If you plan to start with the concatenated value of Card#/Name=001/203 SS Pinsar, then you will need to split that phrase to pick up only the right half to use with your PicURL. It may be simpler to have three rudimentary columns and then join them as needed.

After the formulas are rendered and exported as CSV, you can remove any construction columns prior to sending the file to eBay.

Here is how I would handle an already-concatenated phrase to split and rejoin, where the middle URL-column would be removed before uploading a CSV:

		=RIGHT(A1,LEN(A1)-SEARCH("=",A1,1))&"="&B1
A	B	C
Card#/Name=001/203 SS Pinsar	https://myhost/image.jpg	001/203 SS Pinsar=https://myhost.com/image.jpg

Otherwise start with three temporary columns and join as needed to construct the two columns that eBay needs. Then delete the three temporary columns of data.

			=A1&"="&B1	=B1&"="&C1
A	B	C	D	E
Card#/Name	001/203 SS Pinsar	https://myhost/image.jpg/>	Card#/Name=001/203 SS Pinsar	001/203 SS Pinsar=https://myhost.com/image.jpg