Product numbers change from /0 to _0 when create

Using my Dolibarr PM modules
1

Hi there! Thank you for this great product!

We have a product numbering system that is made of 6 digits part number plus a packaging or color variant designated with /0 , /1, /0V, /100, etc.

When I imported all the products from csv, everything was fine.

But when I add now a new product, the system is changing the name when I create e.g. from 201063/0 to 201063_0.

Dolibarr is 15.0.1, php 7.4, Linux Litespeed, MariaDB.

I suspect it may be from the encoding?
Storage latin1
Sorting latin1_swedish_ci

2

Hi,

I just did a quick check, it’s the same thing here (15.0.1) as well. If you manually enter a product ref with / they get converted to _.

My guess is that this happens by design. Probably to be able to use a ref also as a (part of a) file name, which is not possible with the / character.

There might possibly be some config to change this - but currently I am not aware of this. Maybe someone else can chime in with additional infos.

How about using an extrafield and storing the original number there in addition to using it in the ref?

3

/ is not allowed for compatibility reasons.
If Import allows it, it’s a bug

4

I tested Dolibar for Months now, “/” has no negative impact in Reference. I think it should be removed from the incompatibility list for Product Numbers. In DB, ref is varchar so it doesn’t matter.

I noticed that in Elephant it has a cleanup function (line 219), but ‘/’ is not included in forbidden character, which is correct. Also, getExample returns values with /.

But somewhere else it is removed and replaced. Can you point me to it?