This forum was created to help business owners just like you that sell on eBay, Amazon and through your own eCommerce Site, with the simple ethos that:
"Selling an item online is easy, so is a couple of items, but making living from a business that sells online, well that's something different entirely."
I don't pretend to have all the answers and I know that "together we're stronger" and if you consider the wealth of knowledge that we each posses, using this forum can help us all. We each have a huge amount of experience and provide our own perspectives to any questions & challenges that we may have..
Your input, no matter how small is valued
If you've not registered yet, you can do here for free and if you already have registered, sign-in here.
Get help right now
Registration is free and you can ask your question straight away.
Turbo Lister CSV Imports - Function to enable the loading large chunks of HTML Descriptions
You are here:
Multi-channel eCommerce Forums
Please consider registering
guest
Log In
5:32 PM
Howdy,
Sharing this one as it had me stumped for an hour or two.
When loading products to eBay’s Turbo Lister application, if you don’t remove the line feeds in the description, then the description cells are not loaded.
As column H is the description column, add this macro as part of your saving routine and it’ll remove the CRLF (carriage return, line feeds) and replace them with “%0d%0a” and hey presto, your descriptions will import :)
Sub GetRidofLines()
Columns(“H:H”).Select
Selection.Replace What:=Chr(10), Replacement:=”%0d%0a”, LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub
Hope that helps someone else, like I said it had me stuck for an hour or so until I worked out what it was & how to solve it.
Matt
All RSSMost Users Ever Online: 298
Currently Online:
6 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Newest Members: Marcie, Phil Morris, adil, Bethanyg24, Peter Butler, ANDI1, HannahBowden, dead phil, IQI, NWBltd, 100Olga, nuecity, EghAXWs7x4, Paul.., Irfan Elahi
Administrators: Dave Furness (69), Matthew Ogborne (186)