How to edit from Database?

[Gadget397]

I have been searching this forum for info on how to edit the About Us, Contact Us and other information on the left side...everyone says pull the files from the English folder and edit...but when I look in the database I see that info already in there to display for those files...why does it not show instead of the "Put here your Shipping & Returns information." and the other similar information links. Why would the database already have this information built in if we are not going to display it?

[mugitty]

I do not see an "About Us" entry in the Information InfoBox of the stock install

 

As to Shipping & Returns, in your catalog/includes/languages/english (or other language) folder, you will find a file named shipping.php

 

In that file, there is a line that says

define('TEXT_INFORMATION', 'Put here your Shipping & Returns information.');

You replace the red text with what you want your information to say. HTML can be used to format this area, but remember to escape (\') any apostrophes that might be within this text.

 

As to contact us, that file in the default setup is basically just a form for customers to use to send you an email. If you want to add text to that page, you would need to open catalog/contact_us.php and add a call to text information from your language file in the position that you want it to appear - something like

<tr>
 <td class="main"><?php echo TEXT_INFORMATION; ?></td>
</tr>

and then open your catalog/includes/languages/english (or other language)/contact_us.php file and add a define for that text information

define('TEXT_INFORMATION', 'Put your Contact Us information here.');

and replace the red text with what you want your information to say.

[Gadget397]

Interesting though that I do have a entry under a field called "store_docs" wherby I have entries with all the info I need for those information items. But I have also tried another brand of shopping cart before OsCommerce and I wonder if it's possible that is why I have this information that maybe others don't or do they...hmmm

[mugitty]

Interesting though that I do have a entry under a field called "store_docs"

Must be from another program or an osC contribution. There is no entry in the current osC database dump with that field name. What table does it appear in?

[Gadget397]

I am using MySQL-Front to login to my server and under "store_docs" I have the four items " About Us, Contact Us, Terms & Conditions, Privacy Policy" with each having a memo field where all the text is that we would like to have displayed. I do recall trying another shopping cart out though before this one called "Cube Cart" so perhaps it stayed in the database. I would never have thought though they both can use the same database without problems....interesting.