[RESOLVED] Increasing maximum length of shipping tracking number field

[Rynraf]

Hi

I need to increase shipping number (tracking number) maximum characters size.

First - I changed field size in database in ps_orders to varchar 100.

Effect: I can save longer tracking number in backoffice on order details page. It saved in database in full length (longer then default 64 chars). But it displays in backoffice still with only first 64 characters. It's somewhere trim, cut to 64 characters. Where? Where can I change, increase displayed size of tracking number? I checked everything... without result Pleease help.

Edited June 20, 2022 by Rynraf
resolved info in subject (see edit history)

[Nickz]

1 hour ago, Rynraf said:

First - I changed field size in database in ps_orders to varchar 100.

change it back and refresh, empty caches.

[Rynraf]

I changed field data type in database - this time from 100 to 110 varchar - ps_orders > shipping_number.

Cleared cache from backoffice.

Still the same effect - in database full longer value but in backoffice order view it's cuted string, still to default 64 characters.

I can't find where this value is trimed still to the default 64 chars.

[Nickz]

by changing back I menat> lower than 100 as it was before.

[Rynraf]

Uhhh... I have a solution. Finally! I noticed that in Prestashop many data have two places in database. For example, also this - tracking number.

In this tables, in this columns, the same data:

• ps_orders.shipping_number
• ps_order_carrier.tracking_number

Exactly the same information in two tables. I didn't noticed this earlier. data saved in second table is more important... 😕

P.S.
In /classes/Validate.php is function isTrackingNumber.
But without defined length of string.
This function is called from /classes/order/OrderCarrier.php