HTML to embed image in listing please?

[DoubleHappinessRecords]

Hi all
I want to 'embed' my current postal rates chart http://i.imgur.com/W4roy9g.jpg in all my listings, i.e. I want it to be displayed in the lower half of each item page.

Unfortunately Excel didn't like the code I got from the ebid 'sell an item' form, this is what I was trying:

<p><br />
<img alt="" src="http://i.imgur.com/W4roy9g.jpg" style="width: 505px; height: 475px;" /></p>

I'm pretty sure the equal signs and quote marks were producing errors in Excel because it was trying to treat them as part of a formula, so I couldn't use this code in my upload.

Any suggestions please? Sample listing:- http://www.ebid.net/uk/for-sale/040-...-147679306.htm

[cheaver]

Hi all
I want to 'embed' my current postal rates chart http://i.imgur.com/W4roy9g.jpg in all my listings, i.e. I want it to be displayed in the lower half of each item page.

Unfortunately Excel didn't like the code I got from the ebid 'sell an item' form, this is what I was trying:

<p><br />
<img alt="" src="http://i.imgur.com/W4roy9g.jpg" style="width: 505px; height: 475px;" /></p>

I'm pretty sure the equal signs and quote marks were producing errors in Excel because it was trying to treat them as part of a formula, so I couldn't use this code in my upload.

Any suggestions please? Sample listing:- http://www.ebid.net/uk/for-sale/040-...-147679306.htm

? Include the URL in your listing as in using the image icon ?

[DoubleHappinessRecords]

Perhaps I'm not being clear...

I don't have time to enter the international shipping rates for each item right now, because there are thousands of them all at different weights. So as a 'stop gap' I want to include a full size chart so that overseas buyers can work out what the shipping cost will be. Also, this will help for multiple item orders.

So I want buyers to see this chart - http://i.imgur.com/W4roy9g.jpg - full size, on each and every listing.

I tried using the 'add item' form, adding the image url into the listing, and then copying and pasting the resulting HTML code. That's the code that I posted above.

Unfortunately, Excel did not 'like' it, because it tried to interpret the HTML as a formula, so it kept throwing errors and would not let me save without deleting the offending code.

So I'm looking for a workaround. I guess a clickable link would be better than nothing, but I would really like the image displayed full-size at the bottom of each listing.

I hope that's clearer, thanks.

Edit: I guess I could use 'My Bulk Edit' to find and replace the image url with the code I posted above. It's a funny way of doing it though, I would rather upload with functional HTML in the listings, if possible.

[sherlock07]

Just a thought, have you tried formatting the cell that contains the code as text, that should stop it trying to use it as a formula.

[JanetB]

Perhaps I'm not being clear...

I don't have time to enter the international shipping rates for each item right now, because there are thousands of them all at different weights. So as a 'stop gap' I want to include a full size chart so that overseas buyers can work out what the shipping cost will be. Also, this will help for multiple item orders.

So I want buyers to see this chart - http://i.imgur.com/W4roy9g.jpg - full size, on each and every listing.

I tried using the 'add item' form, adding the image url into the listing, and then copying and pasting the resulting HTML code. That's the code that I posted above.

Unfortunately, Excel did not 'like' it, because it tried to interpret the HTML as a formula, so it kept throwing errors and would not let me save without deleting the offending code.

So I'm looking for a workaround. I guess a clickable link would be better than nothing, but I would really like the image displayed full-size at the bottom of each listing.

I hope that's clearer, thanks.

Edit: I guess I could use 'My Bulk Edit' to find and replace the image url with the code I posted above. It's a funny way of doing it though, I would rather upload with functional HTML in the listings, if possible.

<div align="center"><img src="http://i.imgur.com/W4roy9g.jpg" style="width: 505px; height: 475px; alt="shipping costs"></div>

[DoubleHappinessRecords]

Just a thought, have you tried formatting the cell that contains the code as text, that should stop it trying to use it as a formula.

Yes I did, but it doesn't work, as I need to use the =CONCATENATE formula in Excel to build my descriptions out of my original data columns (artist, title, label, cat# and so on). Thanks anyway.

<div align="center"><img src="http://i.imgur.com/W4roy9g.jpg" style="width: 505px; height: 475px; alt="shipping costs"></div>

I had such high hopes for that, but sadly not. It just come up 'the formula you typed contains an error. Again, it's because of the =CONCATENATE formula. Excel doesn't like quotes within quotes, it 'thinks' there should be a comma there to demarcate text from code. This is the whole string I am trying (for row 15864):

=CONCATENATE(AB15684,": ",AC15684,"<BR><BR>",AF15684,"<BR><BR>",AD1568 4," - ",AE15684,"<BR><BR>Grading item/sleeve: ",AS15684," / ",AT15684,". ",AU15684,"<div align="center"><img src="http://i.imgur.com/W4roy9g.jpg" style="width: 505px; height: 475px; alt="shipping costs"></div>")

...but the computer says no. Even reducing it down to...

=CONCATENATE(AB15684,": ",AC15684,"<BR><BR>",AF15684,"<BR><BR>",AD1568 4," - ",AE15684,"<BR><BR>Grading item/sleeve: ",AS15684," / ",AT15684,". ",AU15684,"<img src="http://i.imgur.com/W4roy9g.jpg" style="width: 505px; height: 475px</div>")

...still doesn't work because of the quotes within quotes. Thanks for the suggestion, anyway. I guess I might try the bulk find and replace instead, but I'm unsure if HTML inserted that way would be functional or not?

[astral276]

Have you tried replacing the double quotes (") with single quotes (')?

From:

"<div  align="center"><img src="http://i.imgur.com/W4roy9g.jpg"  style="width: 505px; height: 475px; alt="shipping  costs"></div>"

To:

"<div  align='center'><img src='http://i.imgur.com/W4roy9g.jpg'  style='width: 505px; height: 475px;' alt='shipping  costs'></div>"

Note: In the second code I have added the closing quote to the style= definition which was omitted in the code you posted.

[Gill]

If you upload the pic to your gallery you can use the link given next to it to embed the pic into your listings via bulk edit (I think).

Sorry, I'm not an html person this is just another idea. Maybe Jan or Mel could say if this idea would work.