Editing sitewide product data after migration

[bigstore]

Migrated all my product data over from an older version of ZC. The designer before me built all of the additional product info within tables with the TonyMCE editor. So what I'm trying to do is search my site using dreamweaver's find and replace tool to find all of the <table width="45%" and change it to 100%.

It's really just a work around until I install Additional Product fields plugin.

So I guess I just need to know where ZC stores the product data (inside the db?) so I can find all the table widths and change them up.

Pretty much I'm thinking the HTML is located inside the db.

Hope this makes sense.

[rbarbour]

We really need to see the site live to be able to advise correctly.

If I was to guess I would say look in:
/includes/templates/YOUR_TEMPLATE/templates/tpl_product_info_display.php

[rstevenson]

rbarbour's advice may be correct, if the width is being set in ZC's PHP code. But if I'm reading your question right, the 45% width was actually manually inserted into every product description. To check if that's so, go into admin/Catalog/Categories / Products and select a product to Edit. If you see that 45% width code in the description field, then yes, it's all stored in the database. In which case you will need to write a SQL command to change it all to 100%. And at that point I run for the hills. Someone else who is handy with SQL will have to advise further.

Rob

[bigstore]

rbarbour's advice may be correct, if the width is being set in ZC's PHP code. But if I'm reading your question right, the 45% width was actually manually inserted into every product description. To check if that's so, go into admin/Catalog/Categories / Products and select a product to Edit. If you see that 45% width code in the description field, then yes, it's all stored in the database. In which case you will need to write a SQL command to change it all to 100%. And at that point I run for the hills. Someone else who is handy with SQL will have to advise further.

Rob

that's exactly what I was thinking. I guess I'll have to buy that MySQL book...