product description html to text edit?

[punkstop`]

Hey guys, I'm new at this and am not completely familiar with the system, but let me give this a go...

We are tranferring our old online store to a new one by zen cart. we tranferred over close to 10,000 products, and right now we need to modify EVERY product desrciption and insert <br> (break) tags everywhere we had a return (new line|). That's about 10 breaks per 10,000 items, and I'm looking for a mod.

I need to know if I can change the product description text box so that a return will equal a break by default, for this field only. There has to be a way.

Thanks for the help guys!
Sean
www.punkstop.com

[jake74]

That sort of change you want to do in mySQL. Once you import your products into the database (with existing descriptions), run a SQL command with the replace function:

update tablename set field = replace(field,'search_for_this','replace_with_this');

Good luck!
Jake

[punkstop`]

Forgive me for being a pain, but could you elaborate on how that's done? Like I said, I'm VERY new to this system, and am still fairly unfamiliar with the different places.

[gjh42]

That is actually not a Zen Cart function at all, but a mySQL database function.

You would run that command in phpMyAdmin, to modify the information once it is stored in your database.
The way to access phpMyAdmin would depend on your server control panel; if you have cPanel, there is a tiny link at the bottom of the MySQL Database page.