Hey everyone, I tried getting our Froogle feed working a year ago but ran into problems. I have some time to tinker again so hopefully someone here can help me out. When we tried to upload to Froogle before we were told they couldn't accept our file because it contained HTML. Basically, our product descriptions contain HTML. So I tried using our short product descriptions (used on the category pages to give users a brief idea of what the product was about) and Google said "Nope, it needs to be the same description as on your website." So my question is... what can we do? Is there some program out there that can remove HTML from a txt file or csv file? Is there some module we can add to Excel? Everything is good to go for our uploads except that HTML in our file.
If you have a PHP enabled server you can take the description from the database and then perform striptags() on them to get rid of all html tags. Then use the output in your Froogle feed. If you do it manually then just copy and 'paste unformatted' in you excel or however you do it. If you need more detailed help then let us know your server setup, e-commerce software, how you generate your feeds etc.
My server is PHP enabled... but the outputing is done via ASP. My server is Windows 2003, ecommerce is Volusion, feeds are generated by Volusion (I can choose MDB, CSV, TAB, or PIPE as my output method). I know this isn't a popular setup and probably no one here is even running Volusion... so I'm not sure if I can get any help on the ASP side of things. That's why i was asking about what I could do with the file after my store has populated it.
Here's the actual query we run to get the file we can upload to froogle: Can this be modified to remove all HTML characters?