News:

Support the VirtueMart project and become a member

Main Menu

Suggestion for increasing the length of a field

Started by man.of.earth, February 04, 2020, 23:22:09 PM

Previous topic - Next topic

man.of.earth

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.

pinochico

We updated manually on every installed version.
www.minijoomla.org  - new portal for Joomla!, Virtuemart and other extensions
XML Easy Feeder - feeds for FB, GMC,.. from products, categories, orders, users, articles, acymailing subscribers and database table
Virtuemart Email Manager - customs email templates
Import products for Virtuemart - from CSV and XML
Rich Snippets - Google Structured Data
VirtueMart Products Extended - Slider with products, show Others bought, Products by CF ID and others filtering products

Jörgen

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.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

AH

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.10.11
php 8.0