Customer number

Customer number

Is it possible to get a customer number be automatically assigned to registered users? And these are then also printed on the invoice or the delivery note? And also in the confirmation email?

Aw: Customer number

if possible will be make a plugin
or
you need to change the core of the store

Aw: Customer number

i´ll take both. What do I have to do?

Aw: Customer number

does the user id in the backend mean the customer number? if i change the last user id in the database to 10000 does it count up? 10001, 10002, etc

Then I could use this number as customer number. And this would then have to be inserted in the invoice, delivery note and mail. In Backend i´ve found "Kundennummer in Rechnung einfügen" I think this is what i need!?

---

Aw: Customer number

Yes.

Yes.

---

Aw: Customer number

Ok. Costomer number in Invoice works!

But if i change --- User-ID and Number --- from the last registred user 1617 to 11617 in Database (jshopping_users) can´t find the user after save in Joomshopping Userlist.

I see that the users in the Joomla user database also have the same ID (1617) and maybe that's why after changing the numbers in Joomshopping (to 11617) they are not found anymore?

Must Change ID in Joomla User Db AND Joomshopping User Db, or what did I do wrong?

---

Aw: Customer number

Need change in:
table #_users
and
table #_jshopping_users

Aw: Customer number

Ok works, thank you! the fact that the customer number is now printed on the invoice is enough for me for now. Thanks again

Aw: Customer number

Hey,
I have changed the user id in joomla, but in table joomshopping_users it ist not possible.
See screenshot attached.

Thanks and regards

---

Aw: Customer number

New user -> created
in table _user
-> id copy to ->
in table __jshopping_user

---

Aw: Customer number

Thanks, it works.
But since the update the user id and the number where the same (see pdf attached).
Now these numbers are different. How can I change bzw. where can I change, that the numbers were the same again?
Thanks and regards
user_id_vs_number.pdf

Aw: Customer number

in Database
Use phpmyadmin for chage value
---------
or ??

Aw: Customer number

in which table? I only can change the numbers in users, nothing in table joomshopping_users

Aw: Customer number

field: number

Aw: Customer number

I am sorry but I don't understand. Last time I had to change it under operations, but now there ist no field like numbers.
See screeshot attached.

---

Aw: Customer number

You just need to change the field values.

Admin / JoomShopping / Client / Edit

set Number


Or use phpMyadmin chenage value for filed number

---

Aw: Customer number

Dear Admin, thanks for help so far.
What we expect, as it used to be, is, that an new customer will get number = user_id. How can we do this?
For sure we can change the numer with phpmyadmin and the admininterface in joomshopping, but as we hope to have many new customers, this is not the way we can work.
thanks für further advice.

Aw: Customer number

1. update all old user

update `..._jshopping_users` set `number`=user_id

-----------------------------------------------------

BY default in JoomShopping
number = user_id

-------------------------------------------------------------------------------------------

Or proble after your changes



_jshopping_users not have autoincrement