Change / set customer id to begind at a high number or with a prefix?

  • Posts: 14
  • Thank you received: 0
2 years 8 months ago #339816

-- HikaShop version -- : 4.4.5
-- Joomla version -- : 3.9.25
-- Error-message(debug-mod must be tuned on) -- : No errors

Hello,
Is it possible to set the auto generated customer number in HikaShop with a prefix like 9999X: 99991, 99992, 99993 ... ?
Thank you :)

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
2 years 8 months ago #339819

Hi,

There is no "customer id" or "customer number" in HikaShop.
I suppose that you're talking about the user_id of the entry in the hikashop_user table.
You can change that for new users in the future by changing the auto_increment in the hikashop_user table via your PHPMyAdmin.
And if you're talking about the id of the Joomla user account in the users table of joomla, you also have an auto_increment on it so you can change it in PHPMyAdmin the same way.
stackoverflow.com/a/5665713

The following user(s) said Thank You: jerndorff

Please Log in or Create an account to join the conversation.

  • Posts: 14
  • Thank you received: 0
2 years 8 months ago #339826

Hi and thank you.
Changing the auto increment for the table will do the trick :)
Best regard,
Michael

Please Log in or Create an account to join the conversation.

  • Posts: 14
  • Thank you received: 0
2 years 8 months ago #339892

Hi Nicolas,

Unfortunately it does not work. When registering a new account, it now only partly register the user in the customer listing.
No Joomla user is beeing added, and it is therefore no longer possible to register at the shop-
How do we solve this?

Update: In _hikashop_user it sets user_id correctly to 99991 but user_cms_id is set to 0 and no Joomla user is being created.

Best regards,
Michael

Last edit: 2 years 8 months ago by jerndorff. Reason: Updated with db user info.

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
2 years 8 months ago #339893

Hi,

Increasing the auto_increment of the users table of Joomla cannot mess with the registration process.
It would be the case if you removed the primary key on the table or removed the auto_increment.
So I guess you need to check what you did in your PHPMyAdmin as you must have done something wrong.

If you say that the id in users is 0 when a user registers, it indicates that the auto_increment has been removed on the id column of the users table. So you need to add it back.
www.youtube.com/watch?v=vXStmizeaq8

Last edit: 2 years 8 months ago by nicolas.

Please Log in or Create an account to join the conversation.

  • Posts: 14
  • Thank you received: 0
2 years 8 months ago #339911

Hi,

Thank you, but the problem is, that a Joomla user account is no longer being created, when a user registers via HikaShop. The auto increment in the Joomla Users table is unchanged (68). A HikaShop user is generated, but it refers to "0" in user_cms_id table. The autoincrement in the HikaShop user table works as intended.

Regards,
Michael

Last edit: 2 years 8 months ago by jerndorff.

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
2 years 8 months ago #339921

Hi,

Are you talking about registration on this page ?
i.imgur.com/g2fPB12.png
Because that's the guest form, not the registration form, so it's normal that no user account is created, since that's the purpose of this form.
And what you describe in your message also indicates that you're using the guest form, not the registration form.
So I suspect that you've set the "registration" setting, under the "checkout" tab of the Hikashop configuration to "guest".
Revert it to "registration" if you want a user account to be created when the user fills that form.

Please Log in or Create an account to join the conversation.

  • Posts: 14
  • Thank you received: 0
2 years 8 months ago #339924

Unfortunately not. It's the new customer registration page located at "NY KUNDE" >> then click "Registrer dig som kunde".

PS: Your admin account is active, if you wish to take a look :)

Last edit: 2 years 8 months ago by jerndorff.

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
2 years 8 months ago #339925

Hi,

Well, that's also a guest form.
If you've activated the guest mode, then there is no HikaShop registration page, only guest form, even if it's named registration.

If you want a registration form page while you have the registration set as only guest in HikaShop you would have to use the Joomla user registration form page, not HikaShop's.

Alternatively, you can change the "Display method for registration" setting to "selector" in the HikaShop configuration and then select both the "registration" and the "guest" modes in the "registration" setting below. That will allow both guest and registration to be available on the checkout and your link will display the registration form of Hikashop.

The following user(s) said Thank You: jerndorff

Please Log in or Create an account to join the conversation.

  • Posts: 14
  • Thank you received: 0
2 years 8 months ago #339930

Thank you!!! Our problem is solved :)

I would suggest, that this setting was removed from the check out tab or at least explained in the "help" text.

Most preferable I would like to have the possibility to have two settings: one for the registration page and one for the check out page.

Best regards,
Michael

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
2 years 8 months ago #339933

Hi,

Adding a note in the help is a good idea.
I think what would make sense would be to have an option in the "hikashop user registration" type menu items to select whether to force the registration mode or let it behave based on the registration setting of the HikaShop configuration.
Thanks for your feedback.

Please Log in or Create an account to join the conversation.

Time to create page: 0.072 seconds
Powered by Kunena Forum