Author Topic: Suggestion for increasing the length of a field  (Read 273 times)

arcturus

  • Jr. Member
  • **
  • Posts: 111
  • VirtueMart Version: 3.6.10 10211
Suggestion for increasing the length of a field
« 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.
Cheers,
George
https://www.proxima-mundi.ro

Now I'm using Joomla! 3.9.15 and VM 3.6.10 10211 on PHP 7.3.9

pinochico

  • 3rd party VirtueMart Developer
  • Jr. Member
  • *
  • Posts: 128
    • MiniJoomla
  • VirtueMart Version: 3
Re: Suggestion for increasing the length of a field
« Reply #1 on: February 05, 2020, 10:12:47 am »
We updated manually on every installed version.
www.minijoomla.org  - new portal for Joomla!, Virtuemart and other extensions
XML Easy Feeder - feeds from products, orders and database table
Virtuemart Email Manager - customs email templates

Jörgen

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 2526
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: Suggestion for increasing the length of a field
« Reply #2 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
Joomla 3.9.8
Virtuemart 3.4.x
Olympiantheme Hera (customized)

AH

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3047
  • VirtueMart Version: 3.6.11
Re: Suggestion for increasing the length of a field
« Reply #3 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
regards
A

Joomla 3.9.15
php 7.2