Hello All,
I need some help! I am selling sports cards on ebay and attempting to automate a good portion of the listing process. I have a fancy pants description for each listing that uses HTML code to display my listing template.
eBay has a bulk upload process that leverages an excel file that will greatly reduce the listing time required.
So what I would like to do is to take the HTML text below and have the bold orange update based on specific cell references in an excel data table. (ie: Khris Middleton would be replaced with E3)
I've tried converting the current HTML text into a formula that references the cells but I get an error message (error with this formula). I tried just using "" and &, along with iferror but get the same error message from excel that there is an issue with the formula.
HTML CODE
<font rwr="1" size="4" style=""><div style="text-align: center; width: 100%; max-width: 1100px; margin: 0px auto; padding: 0px; border: 2px solid rgb(0, 0, 0); border-radius: 15px;"><div style="padding: 4px;"><div style="font-family: Arial; display: table; width: 100%; border-spacing: 8px;"><div style="display: table-cell; width: 60%; text-align: center; vertical-align: middle; padding: 4px; border: 1px solid #202020; border-radius: 12px;"><img src="https://pbs.twimg.com/profile_banners/1516960844701224960/1650507035/1500x500" style="width: 600px; height: 200px;"><br>
</div>
</div>
<div style="margin-right: 8px; margin-bottom: 8px; margin-left: 8px; padding: 4px; border: 1px solid rgb(32, 32, 32); border-radius: 12px;"><div style="font-family: Arial; font-size: 22px; color: rgb(255, 255, 255); font-weight: bold; letter-spacing: 2px; padding-right: 8px; padding-left: 8px; border: 1px solid rgb(0, 0, 0); border-radius: 8px; background-image: radial-gradient(rgb(80, 80, 80), rgb(16, 16, 16), rgb(80, 80, 80)); background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;"><span style="font-family: arial;">ITEM DETAILS</span></div>
<div style="color: rgb(24, 24, 24); text-align: left; padding: 8px;">
<p style="color: rgb(0, 0, 0); vertical-align: top; max-width: 100%; box-sizing: border-box; overflow-wrap: break-word; margin: 0px 0px 15px; padding: 0px; font-size: 14px; line-height: 1.5;"><span style="color: rgb(24, 24, 24); font-size: medium;"><b style="font-family: arial;">Player:</b><font face="arial"> </font><font face="Arial">Khris Middleton</font></span></p><p style="font-family: arial; color: rgb(0, 0, 0); vertical-align: top; max-width: 100%; box-sizing: border-box; overflow-wrap: break-word; margin: 0px 0px 15px; padding: 0px; font-size: 14px; line-height: 1.5;">
<span style="color: rgb(24, 24, 24); font-size: medium;"><b>Year:</b> 2021</span><br style="color: rgb(24, 24, 24); font-size: medium;">
<br style="color: rgb(24, 24, 24); font-size: medium;">
<span style="color: rgb(24, 24, 24); font-size: medium;"><b>Product:</b> Panini Contenders Game Ticket Green Ice Parallel Card</span><br style="color: rgb(24, 24, 24); font-size: medium;">
<br style="color: rgb(24, 24, 24); font-size: medium;">
<span style="color: rgb(24, 24, 24); font-size: medium;"><b>Card Number:</b> 83</span></p>
</div>
<div style="font-family: Arial; color: rgb(24, 24, 24); text-align: left; padding: 4px;"><span style="font-size:16px;"><span style="font-size: 16px; font-family: arial;">Item is being sold as is. We will do our best to note noticeable flaws below but please view the pictures to determine condition of the card(s).<br>
<br>
Please send us a message with any questions.<br>
<br>
No returns.</span></span></div>
<br>
<div style="font-family: Arial; font-size: 22px; color: rgb(255, 255, 255); text-align: center; font-weight: bold; letter-spacing: 2px; padding-right: 8px; padding-left: 8px; border: 1px solid rgb(0, 0, 0); border-radius: 8px; background: radial-gradient(rgb(80, 80, 80), rgb(16, 16, 16), rgb(80, 80, 80));"><span style="font-family: arial;">PAYMENT</span></div>
<div style="font-family: Arial; color: rgb(24, 24, 24); text-align: left; padding: 8px;">
<p style="font-family: arial; color: rgb(0, 0, 0); vertical-align: top; max-width: 100%; box-sizing: border-box; overflow-wrap: break-word; margin: 0px 0px 15px; padding: 0px; font-size: 14px; line-height: 1.5;"><span style="font-size: 16px;"><span style="background-color: rgb(255, 255, 255);">- PayPal Payments must be from a verified PayPal account.<br>
</span><br>
- "Buy It Now" listings payment is due within 7 days for single items. If purchasing more then one item please add them to your eBay cart and then combine the shipping. If you are having trouble with this simply commit to all the products and then contact us for combined shipping prior to payment.</span></p>
<p style="font-family: arial; color: rgb(0, 0, 0); vertical-align: top; max-width: 100%; box-sizing: border-box; overflow-wrap: break-word; margin: 0px 0px 15px; padding: 0px; font-size: 14px; line-height: 1.5;"><span style="font-size: 16px;">- "Auction" listings must be Paid within seven days of the closing of your first item. If you have additional items closing after seven days we will combine these items for you after they close.</span></p>
<span style="font-family: arial; font-size: 16px;"><span style="font-size: 18pt;"><span style="font-size: 16px;"><span style="width: 293px; height: 16px;">- Sales tax is charged according to eBay policy.</span></span></span></span></div>
<br>
<br>
<div style="font-family: Arial; font-size: 22px; color: rgb(255, 255, 255); text-align: center; font-weight: bold; letter-spacing: 2px; padding-right: 8px; padding-left: 8px; border: 1px solid rgb(0, 0, 0); border-radius: 8px; background: radial-gradient(rgb(80, 80, 80), rgb(16, 16, 16), rgb(80, 80, 80));"><span style="font-family: arial;">SHIPPING</span></div>
<div style="font-family: Arial; color: rgb(24, 24, 24); text-align: left; padding: 8px;"><span style="font-family: arial;"><span style="font-size: 12pt; text-align: center;">- Single cards sold under $20 USD ship in a Plain White Envelope with </span><span style="font-size: 12pt; text-align: center;">eBay standard envelope. Please be patient with the tracking as it is not always updated/scanned by UPS.<br>
<br>
</span></span><span style="font-family: arial; font-size: 16px;"><span style="font-size: 12pt; text-align: center;">- </span><span style="text-align: center; width: 639px; height: 17px;">Single cards sold $20 or more and card lots shipped well protected in a team bag and bubble mailer.<br>
<br>
- Ungraded cards will be sleeved in a toploader/card saver and taped with painter's tape to keep the card from falling out in transit.<br>
<br>
- We will typically ship cards within 2-3 business days of completed payment.</span></span></div>
<br>
<div style="font-family: Arial; font-size: 22px; color: rgb(255, 255, 255); font-weight: bold; letter-spacing: 2px; padding-right: 8px; padding-left: 8px; border: 1px solid rgb(0, 0, 0); border-radius: 8px; background-image: radial-gradient(rgb(80, 80, 80), rgb(16, 16, 16), rgb(80, 80, 80)); background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;"><span style="font-family: arial;">ABOUT US</span></div>
<div style="font-family: Arial; color: rgb(24, 24, 24); text-align: left; padding: 8px;"><span style="font-family: arial;">C4 Cards was established in 2022. Just a dad and his 3 kids having a blast buying, selling, and collecting cards. We primarily focus on basketball, football and Pokemon cards but will occasionally have other sports/collectibles as well. We appreciate you checking us out and would love to earn your positive feedback! Please message us with any questions/comments/suggestions.</span></div>
</div></div>
<div style="font-family: Arial; height: 30px; text-align: center; border-top: 1px solid rgb(0, 0, 0); border-bottom-right-radius: 12px; border-bottom-left-radius: 12px; background: radial-gradient(rgb(216, 216, 216), rgb(40, 40, 40));"></div>
</div><br></font>
I need some help! I am selling sports cards on ebay and attempting to automate a good portion of the listing process. I have a fancy pants description for each listing that uses HTML code to display my listing template.
eBay has a bulk upload process that leverages an excel file that will greatly reduce the listing time required.
So what I would like to do is to take the HTML text below and have the bold orange update based on specific cell references in an excel data table. (ie: Khris Middleton would be replaced with E3)
I've tried converting the current HTML text into a formula that references the cells but I get an error message (error with this formula). I tried just using "" and &, along with iferror but get the same error message from excel that there is an issue with the formula.
HTML CODE
<font rwr="1" size="4" style=""><div style="text-align: center; width: 100%; max-width: 1100px; margin: 0px auto; padding: 0px; border: 2px solid rgb(0, 0, 0); border-radius: 15px;"><div style="padding: 4px;"><div style="font-family: Arial; display: table; width: 100%; border-spacing: 8px;"><div style="display: table-cell; width: 60%; text-align: center; vertical-align: middle; padding: 4px; border: 1px solid #202020; border-radius: 12px;"><img src="https://pbs.twimg.com/profile_banners/1516960844701224960/1650507035/1500x500" style="width: 600px; height: 200px;"><br>
</div>
</div>
<div style="margin-right: 8px; margin-bottom: 8px; margin-left: 8px; padding: 4px; border: 1px solid rgb(32, 32, 32); border-radius: 12px;"><div style="font-family: Arial; font-size: 22px; color: rgb(255, 255, 255); font-weight: bold; letter-spacing: 2px; padding-right: 8px; padding-left: 8px; border: 1px solid rgb(0, 0, 0); border-radius: 8px; background-image: radial-gradient(rgb(80, 80, 80), rgb(16, 16, 16), rgb(80, 80, 80)); background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;"><span style="font-family: arial;">ITEM DETAILS</span></div>
<div style="color: rgb(24, 24, 24); text-align: left; padding: 8px;">
<p style="color: rgb(0, 0, 0); vertical-align: top; max-width: 100%; box-sizing: border-box; overflow-wrap: break-word; margin: 0px 0px 15px; padding: 0px; font-size: 14px; line-height: 1.5;"><span style="color: rgb(24, 24, 24); font-size: medium;"><b style="font-family: arial;">Player:</b><font face="arial"> </font><font face="Arial">Khris Middleton</font></span></p><p style="font-family: arial; color: rgb(0, 0, 0); vertical-align: top; max-width: 100%; box-sizing: border-box; overflow-wrap: break-word; margin: 0px 0px 15px; padding: 0px; font-size: 14px; line-height: 1.5;">
<span style="color: rgb(24, 24, 24); font-size: medium;"><b>Year:</b> 2021</span><br style="color: rgb(24, 24, 24); font-size: medium;">
<br style="color: rgb(24, 24, 24); font-size: medium;">
<span style="color: rgb(24, 24, 24); font-size: medium;"><b>Product:</b> Panini Contenders Game Ticket Green Ice Parallel Card</span><br style="color: rgb(24, 24, 24); font-size: medium;">
<br style="color: rgb(24, 24, 24); font-size: medium;">
<span style="color: rgb(24, 24, 24); font-size: medium;"><b>Card Number:</b> 83</span></p>
</div>
<div style="font-family: Arial; color: rgb(24, 24, 24); text-align: left; padding: 4px;"><span style="font-size:16px;"><span style="font-size: 16px; font-family: arial;">Item is being sold as is. We will do our best to note noticeable flaws below but please view the pictures to determine condition of the card(s).<br>
<br>
Please send us a message with any questions.<br>
<br>
No returns.</span></span></div>
<br>
<div style="font-family: Arial; font-size: 22px; color: rgb(255, 255, 255); text-align: center; font-weight: bold; letter-spacing: 2px; padding-right: 8px; padding-left: 8px; border: 1px solid rgb(0, 0, 0); border-radius: 8px; background: radial-gradient(rgb(80, 80, 80), rgb(16, 16, 16), rgb(80, 80, 80));"><span style="font-family: arial;">PAYMENT</span></div>
<div style="font-family: Arial; color: rgb(24, 24, 24); text-align: left; padding: 8px;">
<p style="font-family: arial; color: rgb(0, 0, 0); vertical-align: top; max-width: 100%; box-sizing: border-box; overflow-wrap: break-word; margin: 0px 0px 15px; padding: 0px; font-size: 14px; line-height: 1.5;"><span style="font-size: 16px;"><span style="background-color: rgb(255, 255, 255);">- PayPal Payments must be from a verified PayPal account.<br>
</span><br>
- "Buy It Now" listings payment is due within 7 days for single items. If purchasing more then one item please add them to your eBay cart and then combine the shipping. If you are having trouble with this simply commit to all the products and then contact us for combined shipping prior to payment.</span></p>
<p style="font-family: arial; color: rgb(0, 0, 0); vertical-align: top; max-width: 100%; box-sizing: border-box; overflow-wrap: break-word; margin: 0px 0px 15px; padding: 0px; font-size: 14px; line-height: 1.5;"><span style="font-size: 16px;">- "Auction" listings must be Paid within seven days of the closing of your first item. If you have additional items closing after seven days we will combine these items for you after they close.</span></p>
<span style="font-family: arial; font-size: 16px;"><span style="font-size: 18pt;"><span style="font-size: 16px;"><span style="width: 293px; height: 16px;">- Sales tax is charged according to eBay policy.</span></span></span></span></div>
<br>
<br>
<div style="font-family: Arial; font-size: 22px; color: rgb(255, 255, 255); text-align: center; font-weight: bold; letter-spacing: 2px; padding-right: 8px; padding-left: 8px; border: 1px solid rgb(0, 0, 0); border-radius: 8px; background: radial-gradient(rgb(80, 80, 80), rgb(16, 16, 16), rgb(80, 80, 80));"><span style="font-family: arial;">SHIPPING</span></div>
<div style="font-family: Arial; color: rgb(24, 24, 24); text-align: left; padding: 8px;"><span style="font-family: arial;"><span style="font-size: 12pt; text-align: center;">- Single cards sold under $20 USD ship in a Plain White Envelope with </span><span style="font-size: 12pt; text-align: center;">eBay standard envelope. Please be patient with the tracking as it is not always updated/scanned by UPS.<br>
<br>
</span></span><span style="font-family: arial; font-size: 16px;"><span style="font-size: 12pt; text-align: center;">- </span><span style="text-align: center; width: 639px; height: 17px;">Single cards sold $20 or more and card lots shipped well protected in a team bag and bubble mailer.<br>
<br>
- Ungraded cards will be sleeved in a toploader/card saver and taped with painter's tape to keep the card from falling out in transit.<br>
<br>
- We will typically ship cards within 2-3 business days of completed payment.</span></span></div>
<br>
<div style="font-family: Arial; font-size: 22px; color: rgb(255, 255, 255); font-weight: bold; letter-spacing: 2px; padding-right: 8px; padding-left: 8px; border: 1px solid rgb(0, 0, 0); border-radius: 8px; background-image: radial-gradient(rgb(80, 80, 80), rgb(16, 16, 16), rgb(80, 80, 80)); background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;"><span style="font-family: arial;">ABOUT US</span></div>
<div style="font-family: Arial; color: rgb(24, 24, 24); text-align: left; padding: 8px;"><span style="font-family: arial;">C4 Cards was established in 2022. Just a dad and his 3 kids having a blast buying, selling, and collecting cards. We primarily focus on basketball, football and Pokemon cards but will occasionally have other sports/collectibles as well. We appreciate you checking us out and would love to earn your positive feedback! Please message us with any questions/comments/suggestions.</span></div>
</div></div>
<div style="font-family: Arial; height: 30px; text-align: center; border-top: 1px solid rgb(0, 0, 0); border-bottom-right-radius: 12px; border-bottom-left-radius: 12px; background: radial-gradient(rgb(216, 216, 216), rgb(40, 40, 40));"></div>
</div><br></font>
