Customer ID in Confirmation eMail?

[MAD King]

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

[Milbo]

Sounds like stupid question, but what exactly do you mean with the customer id?

[jjk]

I was just going to type an answer, but you have been quicker...

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

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

[MAD King]

Exactly, jjk.

[Milbo]

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 .

[MAD King]

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

[jjk]

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