editing multiple pages

This has had to have been discussed here before but I cant find anything searching .... Is there a way to edit all (several hundred) pages at one time ? The way I have shipping set up people that want just one thing pay to much, I thought it would make people buy more but I now think it is costing me sales. On every page I tell them
" Shipping to the USA will be a flat 6.00 for orders under 100.00 FREE SHIPPING to the USA if your order is over 100.00. Shipping to Canada is 12.00 no matter how many sets you buy. International shipping is 16.00 , all custom fees, duties, taxes etc.. are the responsibility of the buyer."

But I want to change it to something like" Free shipping to the USA, Canada shipping is 6.00 and international shipping is 12.00 no matter how many sets you buy. All international custom fees,duties,taxes etc... are the responsibility of the buyer "

Can this be done easily or do I just need to start at the top of the list and change them one at a time.

On every page I tell them

But I want to change it to something like"

do I just need to start at the top of the list and change them one at a time
What pages are you talking about??

Because ZenCart is php pages are constructed from pieces and all you should have to do is change that piece

Hey Kobra. By pages I mean I have that paragraph in the description for every product. About 200 products/pages to change.

"ZenCart is php pages are constructed from pieces and all you should have to do is change that piece " you make that sound so simple lol

is this a simple thing to explain ? I tried searching for things like - edit multiple pages and change page descriptions and a couple more terms like that and couldnt find anything. Am I searching using the wrong search terms ?

This should help
https://www.zen-cart.com/tutorials/index.php?article=38

The built in developers toolkit, very handy:smile:

@ Trees..
You host should have a cpanel with your site...
Within this panel you will find phpMyAdmin
Here you will select the database you are using with your site
You will notice all the tables here..
Find: product_description
Do a search on a sql query on how to find and replace wording..:smile:

Back up, yes BACK UP your database before you play...

THANKS EVERYBODY !! I am going to learn this or die trying.

Thanks for pointing me in the right direction

and I used to think trying to learn the banjo was hard...geezzz
But I guess I can look at this the same way , practice and sooner or later I will know how to do it

This thread will get you on the right track.. > http://www.zen-cart.com/forum/showthread.php?t=124425

I have had a question in my head for a few weeks now about backups , guess this is a good time to get clarification. When I do backups using phpMyAdmin I follow the directions found in the documentation here. The next time I go to do a backup of the DB most everything is checked the same as when I did my last backup with the exception of "add drop table" instead the box "add if not exists" is checked.
In the past I check the box " add drop table " anyway because thats what the directions say.
So my question is do I need to check the "add drop table" everytime or will it be ok leaving it checked at "add if not exists" ??

So my question is do I need to check the "add drop table" everytime or will it be ok leaving it checked at "add if not exists" ??
Basically, NO....

There are instances where one might select a different set but they must really understand what they are doing

The DB while robust is fragile to being structured correctly....

If all you want to alter is the product description....

First make a backup, place your site down for maintenance,

Tehn make a backup/export of ONLY the product description table.

Preserve a unaltered copy of this table, open another copy in a code editor like notepad++

Do a replace and enter the current text exactly in the for box

Enter the exact text you want displayed in the with box and select replace all

Save and import this table to your DB

Take off maint and check that you have not broken things

If you have....import the unaltered back of that table and you should be back to where you were

All else fails, import the full DB backup you made before starting

I got an error message that said #1062 - Duplicate entry '23-1' for key 'PRIMARY'
I scratched my head for a while and thought it was because some of the words was in both what I had to start with and the new description I changed to. ?? So I figured I would try and change the text I didnt want anymore with the word pizza , then I could do it again and change pizza to my new description but get the same error message ?? #1062 - Duplicate entry '23-1' for key 'PRIMARY'

Looking at the database after I changed it , it looks like I want it but something is not in the right place for the import ? any ideas ? Thanks

Scratching my head some more....
Should I drop the products_description table first, then import the new one ? is that where the " duplicate is coming from ?

Trees2wood:

Should I drop the products_description table first, then import the new one ? is that where the " duplicate is coming from ?

That did it. :clap::clap: Thanks for the help everybody. I just changed 768 pages ( I forgot I had over 500 other pages 90% filled out thanks to the copy function )

Perfect glad you problem is solved... :smile:
That saved you a little time...

I got an error message that said #1062 - Duplicate entry '23-1' for key 'PRIMARY'
Yes as you found out when making the single table backup for editing one should use the same settings in phpmyadmin as those for a full DB backup....insuring that "CHECKED: Add DROP TABLE" is added

https://www.zen-cart.com/tutorials/index.php?article=103

I couldnt have done it without you guys help. Thank all of you for your time.

Mark , reading the thread you directed me to I saw you said the same thing to the people that helped you.... I hope I will also be able to return the favors for years to come. Once I learn what the right answers are :book: