[Skip to main content](#vessel-content) # Change / set customer id to begind at a high number or with a prefix? ## - **[jerndorff](/forum/user/25289-jerndorff "View jerndorff's Profile")** - [![jerndorff's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/25289-jerndorff "View jerndorff's Profile") Topic Author - [ Offline](/forum/user/25289-jerndorff) Less More - Posts: 14 - Thank you received: 0 - 4 years 7 months ago [\#339816](#339816) by [jerndorff](/forum/user/25289-jerndorff "View jerndorff's Profile") *[Change / set customer id to begind at a high number or with a prefix?](/forum/25-install-update/904052-change-set-customer-id-to-begind-at-a-high-number-or-with-a-prefix#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 :)")* was created by *[jerndorff](/forum/user/25289-jerndorff "View jerndorff's Profile")* -- 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 ![:)](/media/kunena/emoticons/8.png ":)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNDA1Mi1jaGFuZ2Utc2V0LWN1c3RvbWVyLWlkLXRvLWJlZ2luZC1hdC1hLWhpZ2gtbnVtYmVyLW9yLXdpdGgtYS1wcmVmaXg/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86315 - Thank you received: 14276 - - 4 years 7 months ago [\#339819](#339819) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Change / set customer id to begind at a high number or with a prefix?](/forum/25-install-update/904052-change-set-customer-id-to-begind-at-a-high-number-or-with-a-prefix#339819 "-- 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 :)")* 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](https://stackoverflow.com/a/5665713) The following user(s) said Thank You: [jerndorff](/forum/user/25289-jerndorff "View jerndorff's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNDA1Mi1jaGFuZ2Utc2V0LWN1c3RvbWVyLWlkLXRvLWJlZ2luZC1hdC1hLWhpZ2gtbnVtYmVyLW9yLXdpdGgtYS1wcmVmaXg/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[jerndorff](/forum/user/25289-jerndorff "View jerndorff's Profile")** - [![jerndorff's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/25289-jerndorff "View jerndorff's Profile") Topic Author - [ Offline](/forum/user/25289-jerndorff) Less More - Posts: 14 - Thank you received: 0 - 4 years 7 months ago [\#339826](#339826) by [jerndorff](/forum/user/25289-jerndorff "View jerndorff's Profile") Replied by *[jerndorff](/forum/user/25289-jerndorff "View jerndorff's Profile")* on topic *[Change / set customer id to begind at a high number or with a prefix?](/forum/25-install-update/904052-change-set-customer-id-to-begind-at-a-high-number-or-with-a-prefix#339826 "-- 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 :)")* Hi and thank you. Changing the auto increment for the table will do the trick ![:)](/media/kunena/emoticons/8.png ":)") Best regard, Michael Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNDA1Mi1jaGFuZ2Utc2V0LWN1c3RvbWVyLWlkLXRvLWJlZ2luZC1hdC1hLWhpZ2gtbnVtYmVyLW9yLXdpdGgtYS1wcmVmaXg/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[jerndorff](/forum/user/25289-jerndorff "View jerndorff's Profile")** - [![jerndorff's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/25289-jerndorff "View jerndorff's Profile") Topic Author - [ Offline](/forum/user/25289-jerndorff) Less More - Posts: 14 - Thank you received: 0 - 4 years 7 months ago - 4 years 7 months ago [\#339892](#339892) by [jerndorff](/forum/user/25289-jerndorff "View jerndorff's Profile") Replied by *[jerndorff](/forum/user/25289-jerndorff "View jerndorff's Profile")* on topic *[Change / set customer id to begind at a high number or with a prefix?](/forum/25-install-update/904052-change-set-customer-id-to-begind-at-a-high-number-or-with-a-prefix#339892 "-- 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 :)")* 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: 4 years 7 months ago by [jerndorff](/forum/user/25289-jerndorff "View jerndorff's Profile"). Reason: Updated with db user info. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNDA1Mi1jaGFuZ2Utc2V0LWN1c3RvbWVyLWlkLXRvLWJlZ2luZC1hdC1hLWhpZ2gtbnVtYmVyLW9yLXdpdGgtYS1wcmVmaXg/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86315 - Thank you received: 14276 - - 4 years 7 months ago - 4 years 7 months ago [\#339893](#339893) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Change / set customer id to begind at a high number or with a prefix?](/forum/25-install-update/904052-change-set-customer-id-to-begind-at-a-high-number-or-with-a-prefix#339893 "-- 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 :)")* 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](https://www.youtube.com/watch?v=vXStmizeaq8) Last edit: 4 years 7 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNDA1Mi1jaGFuZ2Utc2V0LWN1c3RvbWVyLWlkLXRvLWJlZ2luZC1hdC1hLWhpZ2gtbnVtYmVyLW9yLXdpdGgtYS1wcmVmaXg/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[jerndorff](/forum/user/25289-jerndorff "View jerndorff's Profile")** - [![jerndorff's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/25289-jerndorff "View jerndorff's Profile") Topic Author - [ Offline](/forum/user/25289-jerndorff) Less More - Posts: 14 - Thank you received: 0 - 4 years 7 months ago - 4 years 7 months ago [\#339911](#339911) by [jerndorff](/forum/user/25289-jerndorff "View jerndorff's Profile") Replied by *[jerndorff](/forum/user/25289-jerndorff "View jerndorff's Profile")* on topic *[Change / set customer id to begind at a high number or with a prefix?](/forum/25-install-update/904052-change-set-customer-id-to-begind-at-a-high-number-or-with-a-prefix#339911 "-- 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 :)")* 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: 4 years 7 months ago by [jerndorff](/forum/user/25289-jerndorff "View jerndorff's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNDA1Mi1jaGFuZ2Utc2V0LWN1c3RvbWVyLWlkLXRvLWJlZ2luZC1hdC1hLWhpZ2gtbnVtYmVyLW9yLXdpdGgtYS1wcmVmaXg/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86315 - Thank you received: 14276 - - 4 years 7 months ago [\#339921](#339921) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Change / set customer id to begind at a high number or with a prefix?](/forum/25-install-update/904052-change-set-customer-id-to-begind-at-a-high-number-or-with-a-prefix#339921 "-- 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 :)")* Hi, Are you talking about registration on this page ? [ i.imgur.com/g2fPB12.png](https://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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNDA1Mi1jaGFuZ2Utc2V0LWN1c3RvbWVyLWlkLXRvLWJlZ2luZC1hdC1hLWhpZ2gtbnVtYmVyLW9yLXdpdGgtYS1wcmVmaXg/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[jerndorff](/forum/user/25289-jerndorff "View jerndorff's Profile")** - [![jerndorff's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/25289-jerndorff "View jerndorff's Profile") Topic Author - [ Offline](/forum/user/25289-jerndorff) Less More - Posts: 14 - Thank you received: 0 - 4 years 7 months ago - 4 years 7 months ago [\#339924](#339924) by [jerndorff](/forum/user/25289-jerndorff "View jerndorff's Profile") Replied by *[jerndorff](/forum/user/25289-jerndorff "View jerndorff's Profile")* on topic *[Change / set customer id to begind at a high number or with a prefix?](/forum/25-install-update/904052-change-set-customer-id-to-begind-at-a-high-number-or-with-a-prefix#339924 "-- 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 :)")* 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 ![:)](/media/kunena/emoticons/8.png ":)") Last edit: 4 years 7 months ago by [jerndorff](/forum/user/25289-jerndorff "View jerndorff's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNDA1Mi1jaGFuZ2Utc2V0LWN1c3RvbWVyLWlkLXRvLWJlZ2luZC1hdC1hLWhpZ2gtbnVtYmVyLW9yLXdpdGgtYS1wcmVmaXg/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86315 - Thank you received: 14276 - - 4 years 7 months ago [\#339925](#339925) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Change / set customer id to begind at a high number or with a prefix?](/forum/25-install-update/904052-change-set-customer-id-to-begind-at-a-high-number-or-with-a-prefix#339925 "-- 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 :)")* 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](/forum/user/25289-jerndorff "View jerndorff's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNDA1Mi1jaGFuZ2Utc2V0LWN1c3RvbWVyLWlkLXRvLWJlZ2luZC1hdC1hLWhpZ2gtbnVtYmVyLW9yLXdpdGgtYS1wcmVmaXg/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[jerndorff](/forum/user/25289-jerndorff "View jerndorff's Profile")** - [![jerndorff's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/25289-jerndorff "View jerndorff's Profile") Topic Author - [ Offline](/forum/user/25289-jerndorff) Less More - Posts: 14 - Thank you received: 0 - 4 years 7 months ago [\#339930](#339930) by [jerndorff](/forum/user/25289-jerndorff "View jerndorff's Profile") Replied by *[jerndorff](/forum/user/25289-jerndorff "View jerndorff's Profile")* on topic *[Change / set customer id to begind at a high number or with a prefix?](/forum/25-install-update/904052-change-set-customer-id-to-begind-at-a-high-number-or-with-a-prefix#339930 "-- 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 :)")* Thank you!!! Our problem is solved ![:)](/media/kunena/emoticons/8.png ":)") 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNDA1Mi1jaGFuZ2Utc2V0LWN1c3RvbWVyLWlkLXRvLWJlZ2luZC1hdC1hLWhpZ2gtbnVtYmVyLW9yLXdpdGgtYS1wcmVmaXg/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86315 - Thank you received: 14276 - - 4 years 7 months ago [\#339933](#339933) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Change / set customer id to begind at a high number or with a prefix?](/forum/25-install-update/904052-change-set-customer-id-to-begind-at-a-high-number-or-with-a-prefix#339933 "-- 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 :)")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNDA1Mi1jaGFuZ2Utc2V0LWN1c3RvbWVyLWlkLXRvLWJlZ2luZC1hdC1hLWhpZ2gtbnVtYmVyLW9yLXdpdGgtYS1wcmVmaXg/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.214 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)