Rynraf Posted June 17, 2022 Share Posted June 17, 2022 (edited) 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) Link to comment Share on other sites More sharing options...
Nickz Posted June 17, 2022 Share Posted June 17, 2022 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. Link to comment Share on other sites More sharing options...
Rynraf Posted June 19, 2022 Author Share Posted June 19, 2022 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. Link to comment Share on other sites More sharing options...
Nickz Posted June 19, 2022 Share Posted June 19, 2022 by changing back I menat> lower than 100 as it was before. Link to comment Share on other sites More sharing options...
Rynraf Posted June 19, 2022 Author Share Posted June 19, 2022 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now