VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: MAD King on May 14, 2011, 01:25:57 AM

Title: Customer ID in Confirmation eMail?
Post by: MAD King on May 14, 2011, 01:25:57 AM
Will there the Customer ID in the Confirmation eMail and in the List Order in the Backend? Since 1.1 is missing this.

Thank you
Title: Re: Customer ID in Confirmation eMail?
Post by: Milbo on May 14, 2011, 09:52:39 AM
Sounds like stupid question, but what exactly do you mean with the customer id?
Title: Re: Customer ID in Confirmation eMail?
Post by: jjk on May 14, 2011, 11:24:02 AM
I was just going to type an answer, but you have been quicker... :D

He is asking for a field which would translate into "Kundennummer" in German. Many businesses use this to reference customers in different applications, i.e. order management, accounting, etc. (This might also be on the wishlist of the forum member who is working on an update for his SOA application for VM)

See this article and example in the german Wikipedia:
http://de.wikipedia.org/wiki/Normalisierung_%28Datenbank%29#Ziel:_Konsistenzerh.C3.B6hung_durch_Redundanzvermeidung (http://de.wikipedia.org/wiki/Normalisierung_%28Datenbank%29#Ziel:_Konsistenzerh.C3.B6hung_durch_Redundanzvermeidung)

Currently the confirmation email only lists an order-id. I've seen a customer_number field in jos_vm_users, but is it used?

Title: Re: Customer ID in Confirmation eMail?
Post by: MAD King on May 14, 2011, 15:39:01 PM
Exactly, jjk.
Title: Re: Customer ID in Confirmation eMail?
Post by: Milbo on May 14, 2011, 19:49:28 PM
Hahha, of course I know what that is.

But there exist already several numbers. The question is if we want to add an additional number, which can be filled by a plugin. Everyone wants another pattern. But this is an extra feature in my eyes. But it makes to sense to add a db field for that already.
and there it is #__virtuemart_vmusers.customer_number. But there is afaik not a nice tool written to fill it, yet .
Title: Re: Customer ID in Confirmation eMail?
Post by: MAD King on May 14, 2011, 21:09:10 PM
I think it doesen't really matter if there would be a extra plugin for this or if the already existing customer ID can be used, as long anything is showing up. lol
Title: Re: Customer ID in Confirmation eMail?
Post by: jjk on May 15, 2011, 08:19:35 AM
Perhaps VM2 could initially use the simple stupid approach and just use the MySQL auto_increment and auto_increment_offset attribute to produce unique customer_ids which show in the customer administration and (optionally) on the invoices ...until somebody codes a more intelligent solution  ;)