I want to add a new field "Transaction Date" to manually input a date when the CC was charged (we use manual processing). This will be done by our sales team using order history page (admin) - it is not seen by the customer during the order.
I successfully added a new field to the xcart_orders table as "date_transaction".
I edited the history_order.tpl page to include the new field - closely copying the existing customer notes field.
{if $usertype ne "C"}
<p />
Transaction Date (MM/DD/YY):<br />
<input name="date_transaction" type="text" style="width: 100px;" value="{$date_transaction|escape:quotes}" size="11" maxlength="11" />
{/if}
Now what func file do I edit to input this date into the database so its saved?