VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: man.of.earth on February 04, 2020, 23:22:09 PM

Title: Suggestion for increasing the length of a field
Post by: man.of.earth on February 04, 2020, 23:22:09 PM
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.
Title: Re: Suggestion for increasing the length of a field
Post by: pinochico on February 05, 2020, 10:12:47 AM
We updated manually on every installed version.
Title: Re: Suggestion for increasing the length of a field
Post by: Jörgen on February 11, 2020, 20:04:21 PM
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
Title: Re: Suggestion for increasing the length of a field
Post by: AH on February 12, 2020, 09:15:26 AM
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