Change User Id

Store Builder Questions
1

Hello friends,

Is there any way to change user ID?

I need to change user ID according to our ERP program.

Which tables to edit and is there any simple way?

Thank you in advance

Frank

2

I am afraid, it can cause many issues. But the main tables are:

cscart_users

cscart_usergroup_links

cscart_user_profiles

cscart_user_data

If you want to keep orders for these customers, also check tables starting with cscart_order

3

Hi eComLabs,

I was afraid that it will not be so easy.

Can you point me to any other solution to assign existing customer ID from my ERP.

thank you in advance.

4

Hi eComLabs,

I was afraid that it will not be so easy.

Can you point me to any other solution to assign existing customer ID from my ERP.

thank you in advance.

Unfortunately there is no easy way to do it. Each user ID is unique with auto increment feature. I suggest you to add new field for each user - External ID and sync data by the value of this field

5

Hi eComLabs,

thank you.

Should I add this field in database?

Frank

6

Yes, add this field to database and make it editable from the admin panel

7

Yes, add this field to database and make it editable from the admin panel

Hi master,

how to make it editable in admin?

Thanx for you help again.

Frank

8

Use hooks in the My changes module to do it. As example, you can use on of the default modules, e.g. Age Verification

http://prntscr.com/cw51uz

9

sorry, I'm too stupid to use hoohs, I'm over 60 :-(

I don't use field fax, can I use this field?

Can I rename fax field to ExternalID in db?

Thank you anyway friend

Frank

10

sorry, I'm too stupid to use hoohs, I'm over 60 :-(

I don't use field fax, can I use this field?

Can I rename fax field to ExternalID in db?

But this field will be displayed in the store-front as well. Feel free to contact us to get a free quote