No customer number?

  • Posts: 98
  • Thank you received: 7
  • Hikashop Business
3 weeks 8 hours ago #368617

-- HikaShop version -- : 6.1
-- Joomla version -- : 5.3.x
-- PHP version -- : 8.4.x

Hi!

Currently I set up a new shop with Hikashop and want to configure some things. But now I face a problem. I can configure an order number and an invoice number - but there is no customer number!? I guess you forget this important number ... if I do not overlooked it, please add it as soon as possible!

Cheers

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

  • Posts: 84498
  • Thank you received: 13740
  • MODERATOR
3 weeks 4 hours ago #368620

Hi,

Well, HikaShop has a customer ID which you can use as number.
And if you need something different, you can create a custom field of the table "user" and of the type "text" so that you can have a field for the customer number.
Why would you need a customer number different from the customer ID ?

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

  • Posts: 98
  • Thank you received: 7
  • Hikashop Business
1 week 4 days ago #368745

nicolas wrote: Well, HikaShop has a customer ID which you can use as number.
And if you need something different, you can create a custom field of the table "user" and of the type "text" so that you can have a field for the customer number.
Why would you need a customer number different from the customer ID ?


The idea of a custom field would not work as needed. As far as I know this would create a text field for manual input. But what we need - and what nearly every other shop software does as default - is to create an automatic customer number.

The format should be configurable in the same way like the other numbers (order number, invoice number) with prefix and number count.

Why to use? Think of internal organisation or customers from different funnels, these and other needs are important for my clients. The simple ID is ... an ID not more, not configurable. Some shop owners are willing to switch to HikaShop as shopping solution but have to use the same (or similar) number systems for internal operation.

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

  • Posts: 84498
  • Thank you received: 13740
  • MODERATOR
1 week 4 days ago #368748

Hi,

You could combine a custom field of the table "user" with a mass action configured like this:
- a trigger "when a user is created"
- an action "update the values" on the column of the custom user field, with the mode "operation" and a value like this:

concat('xxx-',user.user_id)
This would create a user number with the format xxx-yyy
where xxx is the prefix you entered in the mass action, and yyy the id of the user_id.
The format can be tweaked as needed in the value of the action in the mass action.

While this requires a bit of setup, it seems simple enough for something that looks niche enough that you're the first one talking about it in 15 years on this forum as far as I know. So I don't think it warrants the development of that capability by default with yet another option by default in HikaShop.

The following user(s) said Thank You: Rusty

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

  • Posts: 98
  • Thank you received: 7
  • Hikashop Business
1 week 3 days ago #368786

nicolas wrote: You could combine a custom field of the table "user" with a mass action configured like this:
- a trigger "when a user is created"
- an action "update the values" on the column of the custom user field, with the mode "operation" and a value like this:

concat('xxx-',user.user_id)
This would create a user number with the format xxx-yyy
where xxx is the prefix you entered in the mass action, and yyy the id of the user_id.
The format can be tweaked as needed in the value of the action in the mass action.


Thank you for this workaround. What exactly means or does "concat"?

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

  • Posts: 84498
  • Thank you received: 13740
  • MODERATOR
1 week 2 days ago #368787

"concat" is a function of MySQL used to concatenate several strings into one:
www.w3schools.com/sql/func_mysql_concat.asp

The following user(s) said Thank You: Rusty

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

Time to create page: 0.060 seconds
Powered by Kunena Forum