What this contrib does:
=========================
This contrib allows customers to add comments to their own orders, even after the order has been finalized.
There are many reasons why you may need to email your customers and await feedback from them. There are other reasons why your customers may contact you directly. The purpose of this contrib is to allow that communication to happen directly in osCommerce; thereby removing the need to copy-n-paste communications into the osCommerce admin tool.
***IMPORTANT***: This contribution is very simple to install, but requires you to do a little thinking. When the customer submits an update, this code will change the order status. You can either have it change to an existing order status, or make up a completely new status (mine is named Customer Update). You can have the code update the order status to whatever you want, but you have to decide, and then edit the line below, as I've marked it. It is currently hardcoded to 13.
To find the numerical value of your order status in the osCommerce administration tool, do the following:
1- Admin > Localization > Orders Status.
2- Click on the order status you'll be using for this contrib
3- Note the URL in your browser. It will be http://YourDomainName/admin/orders_status....age=1&oID=XXXXX, where XXXXX is the order status number. Again, the code is hardcoded to use 13.
What this contrib does NOT:
===========================
This contrib does not allow the customer to modify their order in any way other than add comments. It does not allow them to select the new order status. It will set the order status to the same "Customer Update" (as described above) every time. It does not allow them to add/remove products from their order. Again, they can add comments. That's all.
Additional uses:
===========================
I find it useful to link to the account_historY_info.php page (which requires a login) on the contact_us.php page. This has really cut down on email that asks what the order status is, or if they can have it shipped via SlowBoat rather than Next Day. Allowing customers to put these questions directly into their order means that I don't have to read as much email.
Disclaimer:
===========================
This contrib has been designed for and tested with osCommerce 2.2 MS2. While it should easily work, perhaps with minor modifications, with other versions of osCommerce, it has not been tested as such.
If you find this contribution useful, please support the osCommerce project by becoming an osCommerce Community Sponsor. At the time of this writing, details of Community Sponsorship can be found at http://www.oscommerce.com/about/news,111.
Legend: 
Download
Report
When a customer updates their order an email gets sent to the store owner.
Both the To: and From: fields are the store owner.
This small change makes the from field to the customers name and email.
Makes easier if you just want to reply to the emal.
Sorry, but I found some errors on the previus upload, there is the correct one.
screenshot
first, uplaod the gif icon to your catalog/images folder
next:
on catalog contact_us.php
find:
<?php
} else {
?>
<tr>
<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
<tr class="infoBoxContents">
<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
after that,
add:
<tr>
<td <p align="right"><?php echo tep_image(DIR_WS_IMAGES . 'flecha_contact_us.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></p></td>
<td class="main"><?php echo '<a href="' . tep_href_link(FILENAME_ACCOUNT_HISTORY, '', 'SSL') . '"><u>' . ADD_COMMENT_ORDER . '</u></a>'; ?></td>
</tr>
---------------
Finally:
on catalog/ includes/languages/espanol/contact_us.php
add before the last ?>
define('ADD_COMMENT_ORDER', '(Click) Metodo rapido para Contactarnos acerca de su orden');
and
on catalog/ includes/languages/english/contact_us.php
add before the last ?>
define('ADD_COMMENT_ORDER', '(Click) Quick way to Contact us about your order ');
---------------
ciao
Quick way to Contact us about the order. here are the instructions to connect contact_us with costumer comments
Hi,
<br /><br />
I just decided to fix the bug reported by Zaitsev, really quick and easy, it appears to work fine for me.
<br /><br />
Steps:
1 new SQL query needs to be executed that stores the order status apposed to there being a default order status in the HTML
<br /><br />
2. Remove the $status from the first section of the code in account_history_info.php, replacing with the variable now stored in the database
<br /><br />
3. Remove the &status=13 from the <a> from the second bit of code in the account_history_info.php
<br /><br />
4. Add a new function into the admin/includes/functions/general.php. NOTE: this function has been taken from the
"restore order for customer change" contribution. If you already have this mod installed skip this step.
<br /><br />
full details are in the zip file attached.
<br /><br />
enjoy!
There is security bug in contribution - DO NOT SETUP THIS contribution (all versions affected)
1.2 - added ability to email adminstrator when customer updates order
- other changes to Step 1 for security purposes (Thanks, Nimmit!)
- need to add admin ability (Admin >> Configuration >> Customer Comments) to turn on/off administrator notification when customer updates order
- add more code comments to make modifications easier
- changed one field in Section 2 to be language-defined for ease of use in non-english installations
Changelog:
1.1a - fixed typo in Step 2 (Thanks, Alan! Post this in the support thread next time so it doesn't take weeks for me to see it!)
I couldn't find the step 2 code but the code shown below could be found in account_history_info.php -
===========================
STEP 2
===========================
In catalog/account_history_info.php, find the following code:
<?php
if (DOWNLOAD_ENABLED == 'true') include(DIR_WS_MODULES . 'downloads.php');
?>
<tr>
<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
</tr>
<tr>
changes in 1.1
- added proper language string definitions to catalog/includes/languages/english.php
- message stack now works. IOW, when the customer updates their order successfully, they get the little green bar telling them that their order was successfully updated.
- properly closed a previously open-ended comment (Thanks, Thomas!)
I was wondering why this made everything look all screwed up in the page... the second comment line after the order status definition is not closed!
Included is the file with the fix, nothing major, to err is human, great contrib by the way!!!
What this contrib does:
=========================
This contrib allows customers to add comments to their own orders, even after the order has been finalized.
There are many reasons why you may need to email your customers and await feedback from them. There are other reasons why your customers may contact you directly. The purpose of this contrib is to allow that communication to happen directly in osCommerce; thereby removing the need to copy-n-paste communications into the osCommerce admin tool.
***IMPORTANT***: This contribution is very simple to install, but requires you to do a little thinking. When the customer submits an update, this code will change the order status. You can either have it change to an existing order status, or make up a completely new status (mine is named Customer Update). You can have the code update the order status to whatever you want, but you have to decide, and then edit the line below, as I've marked it. It is currently hardcoded to 13.
To find the numerical value of your order status in the osCommerce administration tool, do the following:
1- Admin > Localization > Orders Status.
2- Click on the order status you'll be using for this contrib
3- Note the URL in your browser. It will be http://YourDomainName/admin/orders_status....age=1&oID=XXXXX, where XXXXX is the order status number. Again, the code is hardcoded to use 13.
What this contrib does NOT:
===========================
This contrib does not allow the customer to modify their order in any way other than add comments. It does not allow them to select the new order status. It will set the order status to the same "Customer Update" (as described above) every time. It does not allow them to add/remove products from their order. Again, they can add comments. That's all.
Additional uses:
===========================
I find it useful to link to the account_historY_info.php page (which requires a login) on the contact_us.php page. This has really cut down on email that asks what the order status is, or if they can have it shipped via SlowBoat rather than Next Day. Allowing customers to put these questions directly into their order means that I don't have to read as much email.
Disclaimer:
===========================
This contrib has been designed for and tested with osCommerce 2.2 MS2. While it should easily work, perhaps with minor modifications, with other versions of osCommerce, it has not been tested as such.
If you find this contribution useful, please support the osCommerce project by becoming an osCommerce Community Sponsor. At the time of this writing, details of Community Sponsorship can be found at http://www.oscommerce.com/about/news,111.
Add file to this package