pete2007 Posted February 12, 2009 Posted February 12, 2009 Hi, How do I edit the text which is in the order process email? Any help or advice would be most appreciated, thanks!
Guest Posted February 12, 2009 Posted February 12, 2009 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
pete2007 Posted February 12, 2009 Author Posted February 12, 2009 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!
Guest Posted February 12, 2009 Posted February 12, 2009 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/
pete2007 Posted February 12, 2009 Author Posted February 12, 2009 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?
Guest Posted February 13, 2009 Posted February 13, 2009 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.');
pete2007 Posted February 13, 2009 Author Posted February 13, 2009 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
Guest Posted February 13, 2009 Posted February 13, 2009 Correct, I have already editted this code but still no change to the confirmation email. /languages/english/modules/payment/moneyorder.php Mail in Check or Money Order Payment Module V 1.0 may better suit you.
pete2007 Posted February 13, 2009 Author Posted February 13, 2009 Mail in Check or Money Order Payment Module V 1.0 may better suit you. 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?
Guest Posted February 13, 2009 Posted February 13, 2009 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.
pete2007 Posted February 13, 2009 Author Posted February 13, 2009 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?
Guest Posted February 14, 2009 Posted February 14, 2009 From memory in the language file. That way it is there when you uninstall and install. includes/languages/english/modules/payment/mailin.php
pete2007 Posted February 14, 2009 Author Posted February 14, 2009 includes/languages/english/modules/payment/mailin.php For some reason the mailin.php file is missing, shall I download an original and upload it?
Guest Posted February 14, 2009 Posted February 14, 2009 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
pete2007 Posted February 14, 2009 Author Posted February 14, 2009 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.
Guest Posted February 14, 2009 Posted February 14, 2009 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.
pete2007 Posted February 14, 2009 Author Posted February 14, 2009 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?
Guest Posted February 14, 2009 Posted February 14, 2009 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.
pete2007 Posted February 14, 2009 Author Posted February 14, 2009 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
Guest Posted February 14, 2009 Posted February 14, 2009 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.
pete2007 Posted February 14, 2009 Author Posted February 14, 2009 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', '
Guest Posted February 14, 2009 Posted February 14, 2009 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.
pete2007 Posted February 15, 2009 Author Posted February 15, 2009 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> '); ?>
Guest Posted February 15, 2009 Posted February 15, 2009 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.
pete2007 Posted February 15, 2009 Author Posted February 15, 2009 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 ~ '); ?>
Recommended Posts
Archived
This topic is now archived and is closed to further replies.