editing multiple pages

[Trees2wood]

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.

[kobra]

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

[Trees2wood]

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 ?

[Donal]

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

The built in developers toolkit, very handy

[haredo]

@ 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..

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

[Trees2wood]

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

Thanks for pointing me in the right direction

[Trees2wood]

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

[haredo]

This thread will get you on the right track..

http://www.zen-cart.com/forum/showthread.php?t=124425

[Trees2wood]

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" ??

[kobra]

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