Zen Cart Logo
Forums / Templates, Stylesheets, Page Layout / Editing sitewide product data after migration

Editing sitewide product data after migration

Views: 734

Results 1 to 4 of 4
1 Feb 2012, 6:27 PM
#1
bigstore avatar

bigstore

New Zenner

Join Date:
Jan 2012
Posts:
63
Plugin Contributions:
0

Editing sitewide product data after migration

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.

1 Feb 2012, 6:37 PM
#2
rbarbour avatar

rbarbour

Totally Zenned

Join Date:
Feb 2010
Posts:
2,159
Plugin Contributions:
10

Re: Editing sitewide product data after migration

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

1 Feb 2012, 7:32 PM
#3
rstevenson avatar

rstevenson

Totally Zenned

Join Date:
Nov 2006
Location:
Dartmouth, NS Canada
Posts:
2,400
Plugin Contributions:
0

Re: Editing sitewide product data after migration

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

2 Feb 2012, 6:21 PM
#4
bigstore avatar

bigstore

New Zenner

Join Date:
Jan 2012
Posts:
63
Plugin Contributions:
0

Re: Editing sitewide product data after migration

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

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