Hide admin order comments from customer

Hi,

I often use the order comments box to keep notes for my own personal use about a particular order.

I recently found out from another thread that all these comments can be viewed by the customer if they view their order history :shocking:

If there any way these comments can be hidden unless the 'notify customer' field is ticked?

Thanks :smile:

This is not a feature of Zen Cart at this time, but you could build this into the comments and customize the catalog to not show these marked comments to the customer ...

Thanks for the quick reply Linda. :smartass:

Can you be a bit more specific how this can be achieved?

You would need to edit the file:
/includes/modules/pages/account_history_info/header_php.php

And change the select statement to not include those that were not sent to the customer ...

This select is grabbing all of the history ...

$statuses_query = "SELECT os.orders_status_name, osh.date_added, osh.comments
                   FROM   " . TABLE_ORDERS_STATUS . " os, " . TABLE_ORDERS_STATUS_HISTORY . " osh
                   WHERE      osh.orders_id = :ordersID
                   AND        osh.orders_status_id = os.orders_status_id
                   AND        os.language_id = :languagesID
                   ORDER BY   osh.date_added";

Thanks, i'll give that a try :yes:

Thanks Linda for providing the file and the PHP code that needed to be edited.

$statuses_query = "SELECT os.orders_status_name, osh.date_added, osh.comments
FROM " . TABLE_ORDERS_STATUS . " os, " . TABLE_ORDERS_STATUS_HISTORY . " osh
WHERE osh.orders_id = :ordersID
AND osh.orders_status_id = os.orders_status_id
AND os.language_id = :languagesID
ORDER BY osh.date_added";

Added (AND osh.customer_notified ='1' ) to the file above. And now if I do not tic the notifiy customer box it does not show in the customers account under "Status History & Comments".

$statuses_query = "SELECT os.orders_status_name, osh.date_added, osh.comments
FROM " . TABLE_ORDERS_STATUS . " os, " . TABLE_ORDERS_STATUS_HISTORY . " osh
WHERE osh.orders_id = :ordersID
AND osh.customer_notified ='1'
AND osh.orders_status_id = os.orders_status_id
AND os.language_id = :languagesID
ORDER BY osh.date_added";

Linda,

Just sent you a pot of coffee.

Thanks again

Thanks very much for the support ... we really appreciate it ...

That helps us so much and I am very glad that this could help you in adding this feature ... :smile:

-edited- do you know how soon this might be a regular feature of ZC?

It is on the list of things to do ... but it is not a pressing feature ...

You might be best having this customized for your site ... there are many ways to approach this and you can do a simple limitation of all but customer is seen by customer vs a more useful change where you can control what the customer sees and does not see ...

If you get stuck, you can drop me a PM if need be ...

Thank you. What would it take to make this a pressing feature? (just curious) Also, I sent you a PM, I'll take you up on the customization aspect.

For clarity, to fix this in 1.37

goto /includes/modules/pages/account_history_info
edit file header_php.php

1ST: CREATE A BACKUP OF FILE header_php.php

FIND:

$statuses_query = "SELECT os.orders_status_name, osh.date_added, osh.comments
FROM " . TABLE_ORDERS_STATUS . " os, " . TABLE_ORDERS_STATUS_HISTORY . " osh
WHERE osh.orders_id = :ordersID
AND osh.orders_status_id = os.orders_status_id
AND os.language_id = :languagesID
ORDER BY osh.date_added";

CHANGE TO:

$statuses_query = "SELECT os.orders_status_name, osh.date_added, osh.comments
FROM " . TABLE_ORDERS_STATUS . " os, " . TABLE_ORDERS_STATUS_HISTORY . " osh
WHERE osh.orders_id = :ordersID
AND osh.customer_notified ='1'
AND osh.orders_status_id = os.orders_status_id
AND os.language_id = :languagesID
ORDER BY osh.date_added";

kwizshow ... we appreciate your enthusiasm but how does this differ from philc's post #6 ... :unsure:

Well....if I must explain...

her post does not say what to edit. The previous posts mention this:
/includes/pages/account_history_info/header_php.php and that is INCORRECT. I would think the forum would want correct information....

I mention where to edit and what in one post...

is that acceptable?

ps if i am ever wrong (almost thru 2007 without...) I will gladly take a tomatoe in the face. Until then, I think you will find my posts are usually right on. I am not new to osc, php, sql or server. thanks, look forward to contributing without explanations.

Yes, actually, an explanation does help so that I can correct a typo ...

I so hate it when out of 33,000+ posts I put in a typo ... bless you for being part of our forum ... :smile:

lol, i made a mistake in another forum on the same topic...

i get pissy when programming for 15 hours...i need coffee...lol

hope to be productive here for everyone, regards,

d
:laugh:

Thanks again for the catch, kwizshow ... I do hate missing those directories ... :cool:

THANKS!!

This worked perfectly for me! And is going to be a huge time saver to be able to have order information all in one, especially when a customer calls with a problem with the order or something!

Muchas Gracias!!:clap:

Great help...For me this is a very important improvement. Thanks all!:clap:

there is also a module inthe Downlloads section that has 2 seperate areas for notes,
1 is visible to clients the other is visible to admin ONLY