Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Order Process Email


pete2007

Recommended Posts

Posted

Hi,

 

How do I edit the text which is in the order process email?

 

Any help or advice would be most appreciated, thanks!

Posted
Hi,

 

How do I edit the text which is in the order process email?

 

Any help or advice would be most appreciated, thanks!

checkout_process.php in the languages/english folder may be what you need

Posted
checkout_process.php in the languages/english folder may be what you need

 

Thanks for the response.

 

I have found the section within the checkout_process.php in the languages/english folder

 

define('EMAIL_TEXT_PAYMENT_METHOD', 'Payment Method');

 

But there is no text I can edit, the text I'll looking for is:

 

 

Make Payable To: Please make payment payable to:

 

Send To:

 

Do you know where I can locate this text?

 

Thanks again for your help!

Posted
Thanks for the response.

 

I have found the section within the checkout_process.php in the languages/english folder

 

define('EMAIL_TEXT_PAYMENT_METHOD', 'Payment Method');

 

But there is no text I can edit, the text I'll looking for is:

 

 

Make Payable To: Please make payment payable to:

 

Send To:

 

Do you know where I can locate this text?

 

Thanks again for your help!

That would be in one of the payment modules under languages/english/modules/payment/

Posted
That would be in one of the payment modules under languages/english/modules/payment/

 

I editted moneyorder.php but this only seems to have changed the details on checkout_confirmation.php page, no changes are made to the confirmation email..

 

Not sure where to look next?

Posted
I editted moneyorder.php but this only seems to have changed the details on checkout_confirmation.php page, no changes are made to the confirmation email..

 

Not sure where to look next?

There are only three lines in the language file:

define('MODULE_PAYMENT_MONEYORDER_TEXT_TITLE', 'Check/Money Order');

define('MODULE_PAYMENT_MONEYORDER_TEXT_DESCRIPTION', 'Make Payable To: ' . MODULE_PAYMENT_MONEYORDER_PAYTO . '<br><br>Send To:<br>' . nl2br(STORE_NAME_ADDRESS) . '<br><br>' . 'Your order will not ship until we receive payment.');

define('MODULE_PAYMENT_MONEYORDER_TEXT_EMAIL_FOOTER', "Make Payable To: ". MODULE_PAYMENT_MONEYORDER_PAYTO . "\n\nSend To:\n" . STORE_NAME_ADDRESS . "\n\n" . 'Your order will not ship until we receive payment.');

Posted
There are only three lines in the language file:

define('MODULE_PAYMENT_MONEYORDER_TEXT_TITLE', 'Check/Money Order');

define('MODULE_PAYMENT_MONEYORDER_TEXT_DESCRIPTION', 'Make Payable To: ' . MODULE_PAYMENT_MONEYORDER_PAYTO . '<br><br>Send To:<br>' . nl2br(STORE_NAME_ADDRESS) . '<br><br>' . 'Your order will not ship until we receive payment.');

define('MODULE_PAYMENT_MONEYORDER_TEXT_EMAIL_FOOTER', "Make Payable To: ". MODULE_PAYMENT_MONEYORDER_PAYTO . "\n\nSend To:\n" . STORE_NAME_ADDRESS . "\n\n" . 'Your order will not ship until we receive payment.');

 

Correct, I have already editted this code but still no change to the confirmation email.

 

/languages/english/modules/payment/moneyorder.php

Posted
Thanks again for the quick response.

 

Do you know if its possible to add my address via coding instead of inserting the address manually within admin/mystore section?

From memory in the language file. That way it is there when you uninstall and install.

Posted
From memory in the language file. That way it is there when you uninstall and install.

 

I taken a look at the includes/languages/english.php and here's what I've found whilst search for address:

 

define('MALE_ADDRESS', 'Mr.');
define('FEMALE_ADDRESS', 'Ms.');

define('CATEGORY_ADDRESS', 'Your Address');

define('ENTRY_EMAIL_ADDRESS', 'E-Mail Address:');

define('ENTRY_EMAIL_ADDRESS_ERROR', 'Your E-Mail Address must contain a minimum of ' . ENTRY_EMAIL_ADDRESS_MIN_LENGTH . ' characters.');
define('ENTRY_EMAIL_ADDRESS_CHECK_ERROR', 'Your E-Mail Address does not appear to be valid - please make any necessary corrections.');
define('ENTRY_EMAIL_ADDRESS_ERROR_EXISTS', 'Your E-Mail Address already exists in our records - please log in with the e-mail address or create an account with a different address.');
define('ENTRY_EMAIL_ADDRESS_TEXT', '*');
define('ENTRY_STREET_ADDRESS', 'Street Address:');
define('ENTRY_STREET_ADDRESS_ERROR', 'Your Street Address must contain a minimum of ' . ENTRY_STREET_ADDRESS_MIN_LENGTH . ' characters.');
define('ENTRY_STREET_ADDRESS_TEXT', '*');

define('IMAGE_BUTTON_ADD_ADDRESS', 'Add Address');
define('IMAGE_BUTTON_ADDRESS_BOOK', 'Address Book');
define('IMAGE_BUTTON_CHANGE_ADDRESS', 'Change Address');

 

I take it none of these are what I'm looking for?

Posted
From memory in the language file. That way it is there when you uninstall and install.

includes/languages/english/modules/payment/mailin.php

Posted
includes/languages/english/modules/payment/mailin.php

 

For some reason the mailin.php file is missing, shall I download an original and upload it?

Posted
For some reason the mailin.php file is missing, shall I download an original and upload it?

Yes, I gave you the link in post 8

Posted
Yes, I gave you the link in post 8

 

Thanks, I have uploaded the files, but in states within the instruction file that I have to run the SQL file

 

Run the SQL file however you wish. I suggest the phpmyadmin.

 

I've never done this before, how can this be achieved?

 

Thanks again for all your help.

Posted
Thanks, I have uploaded the files, but in states within the instruction file that I have to run the SQL file

 

Run the SQL file however you wish. I suggest the phpmyadmin.

 

I've never done this before, how can this be achieved?

 

Thanks again for all your help.

Scary stuff when you don't know how, but it is really very easy. Backup the database first.

 

Most webhosts have a control panel that you log into.

 

When you have logged into the control panel , you will have to find the databases section.

 

Click on the phpMyAdmin icon.

 

Select the user to configure database via phpMyAdmin and click on the Login icon.

 

A new window should open for phpMyAdmin.

 

In some cases, you may have to choose which database your OSC tables are located on. If this is the case, please choose the database from the list or the drop down box at the left.

 

To run a SQL query, click on "SQL" on the navigation bar (on the right side, click on the SQL tab at the top).

 

Then copy the code from the sql file and paste the code into the textarea on that page.

 

Click on the GO button and it is done.

 

If all goes well, your SQL query will now be succesfully entered.

Posted
Scary stuff when you don't know how, but it is really very easy. Backup the database first.

 

Most webhosts have a control panel that you log into.

 

When you have logged into the control panel , you will have to find the databases section.

 

Click on the phpMyAdmin icon.

 

Select the user to configure database via phpMyAdmin and click on the Login icon.

 

A new window should open for phpMyAdmin.

 

In some cases, you may have to choose which database your OSC tables are located on. If this is the case, please choose the database from the list or the drop down box at the left.

 

To run a SQL query, click on "SQL" on the navigation bar (on the right side, click on the SQL tab at the top).

 

Then copy the code from the sql file and paste the code into the textarea on that page.

 

Click on the GO button and it is done.

 

If all goes well, your SQL query will now be succesfully entered.

 

 

Thanks for the info.

 

I think I have 2 databases which are unused, I cannot create a new database as my host won't allow me to.

 

After I select an empty database, it then states: No tables found in database.

 

So I then click the SQL tab

 

Copy and Paste INSERT INTO orders_status VALUES (20,1,'Mailing in Payment') within the text area

 

Then click GO and then the following error appears:

 

MySQL said: Documentation

#1146 - Table 'bodybuil_dir2.orders_status' doesn't exist

 

Any thoughts on what to try next?

Posted
Thanks for the info.

 

I think I have 2 databases which are unused, I cannot create a new database as my host won't allow me to.

 

After I select an empty database, it then states: No tables found in database.

 

So I then click the SQL tab

 

Copy and Paste INSERT INTO orders_status VALUES (20,1,'Mailing in Payment') within the text area

 

Then click GO and then the following error appears:

 

MySQL said: Documentation

#1146 - Table 'bodybuil_dir2.orders_status' doesn't exist

 

Any thoughts on what to try next?

You have to select your osc database since that is what you are going to update. Other add ons that require sql to be run also need to have you select your osc database.

Posted
You have to select your osc database since that is what you are going to update. Other add ons that require sql to be run also need to have you select your osc database.

 

Good News: I've installed my first sql database! and the checkoutconfirmation.php page looks much better!

 

Bad News: When I confirmed the order, the confirmation email did not include my stores address.

 

There must be a way to insert the address manually via coding, instead of entering the address normally through admin/mystore

Posted
Good News: I've installed my first sql database! and the checkoutconfirmation.php page looks much better!

 

Bad News: When I confirmed the order, the confirmation email did not include my stores address.

 

There must be a way to insert the address manually via coding, instead of entering the address normally through admin/mystore

Thought it did, but you can copy the information in the language file

 

define('MODULE_PAYMENT_MAILIN_TEXT_DESCRIPTION', '

which is where I have my store address

 

into

 

define('MODULE_PAYMENT_MAILIN_TEXT_EMAIL_FOOTER', '

 

so the info goes into the footer

something like

 

Please make your Cheque or Money Order payable to: <b> xxxxxx </b>

<BR>

<br>

Mail Payment to:

<br>

<br>

<p align="left"> <b> mail adress name,</b>

<br>

street address,

<br>

suburb,

<br>

state and post code.

<br>

country</b></p>

<br>

<br>

If you have any questions, you may call us at <b> tel no </b>, between the hours of 10am and 6pm Monday to Saturday, or e-mail us at email address at any time.

<br>

<br>

ALL CHEQUES REQUIRE SIX BUSINESS DAYS TO ENSURE THAT THE CHEQUE CLEARS YOUR BANK.

<br>

Money Order Payments will be considered Cash Payments and will not delay your order.

<br>

<b>There will be a $1,000.000.000.00 Service Charge for all dishonoured cheques ! </b>

<br>

 

so you put your info into the obvious places.

Posted
Thought it did, but you can copy the information in the language file

 

define('MODULE_PAYMENT_MAILIN_TEXT_DESCRIPTION', '

which is where I have my store address

 

into

 

define('MODULE_PAYMENT_MAILIN_TEXT_EMAIL_FOOTER', '

 

so the info goes into the footer

something like

 

Please make your Cheque or Money Order payable to: <b> xxxxxx </b>

<BR>

<br>

Mail Payment to:

<br>

<br>

<p align="left"> <b> mail adress name,</b>

<br>

street address,

<br>

suburb,

<br>

state and post code.

<br>

country</b></p>

<br>

<br>

If you have any questions, you may call us at <b> tel no </b>, between the hours of 10am and 6pm Monday to Saturday, or e-mail us at email address at any time.

<br>

<br>

ALL CHEQUES REQUIRE SIX BUSINESS DAYS TO ENSURE THAT THE CHEQUE CLEARS YOUR BANK.

<br>

Money Order Payments will be considered Cash Payments and will not delay your order.

<br>

<b>There will be a $1,000.000.000.00 Service Charge for all dishonoured cheques ! </b>

<br>

 

so you put your info into the obvious places.

 

I have already editted mailin.php file by adding my address, phone no etc...

 

The next bit I don't quite understand:

 

Do you want me to find the following code within english.php

 

define('MODULE_PAYMENT_MAILIN_TEXT_DESCRIPTION', '

which is where I have my store address

 

and replace with?

 

define('MODULE_PAYMENT_MAILIN_TEXT_EMAIL_FOOTER', '

Posted
I have already editted mailin.php file by adding my address, phone no etc...

 

The next bit I don't quite understand:

 

Do you want me to find the following code within english.php

 

define('MODULE_PAYMENT_MAILIN_TEXT_DESCRIPTION', '

which is where I have my store address

 

and replace with?

 

define('MODULE_PAYMENT_MAILIN_TEXT_EMAIL_FOOTER', '

No, if the text does not appear in the email when the db is updated, you could add what I suugested to the includes/laguanges/english/modules/payment/mailin.php ie the language file (for that contribution).

 

I did not say replace, I said to add.

 

So you add your store address to the define

define('MODULE_PAYMENT_MAILIN_TEXT_EMAIL_FOOTER'

 

Do not remove the formatting of the define.

Posted
No, if the text does not appear in the email when the db is updated, you could add what I suugested to the includes/laguanges/english/modules/payment/mailin.php ie the language file (for that contribution).

 

I did not say replace, I said to add.

 

So you add your store address to the define

define('MODULE_PAYMENT_MAILIN_TEXT_EMAIL_FOOTER'

 

Do not remove the formatting of the define.

 

I've just taken a look within the mailin.php and the following code is already inserted within the bottom of the text:

 

');

 define('MODULE_PAYMENT_MAILIN_TEXT_EMAIL_FOOTER', '
<br>
');
?>

Posted
I've just taken a look within the mailin.php and the following code is already inserted within the bottom of the text:

 

');

 define('MODULE_PAYMENT_MAILIN_TEXT_EMAIL_FOOTER', '
<br>
');
?>

Exactly, you have to add information there. I am sure you will work it out.

Posted
Exactly, you have to add information there. I am sure you will work it out.

 

Sorry I am not good at this coding stuff..

 

Do I insert my address here:

 

');

 

define('MODULE_PAYMENT_MAILIN_TEXT_EMAIL_FOOTER', '

<br>

~ Insert My address Here ~

');

?>

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...