Hello developers,
I have a suggestion: to increase the length of customer_number field, from #_virtuemart_orders, from varchar(32) to varchar(128). It is useful in case of lost/failed orders. 32 is not enough to also store the customer email address, which can be used to ask him/her to repeat the order.
We updated manually on every installed version.
I always ask for the email in the email field, why do You do this differently ? It is the best way of communicating with the customer.
It is always better to use a field for a specific task that is clear to the customer.
If You really need, You can always make notes on the statuschanges or the customer note.
Jörgen @ Kreativ Fotografi
The customer number field is set to 32 - that is enough for businesses that do not try an bend it to a purpose for which it was not intended
Storing an email address in the field is your problem
You don't need to do such a thing in the first instance - just combine the order data from the virtuemart_orders and the virtuemart_order_userinfo tables into a view in the backend