Guest Posted July 29, 2015 Share Posted July 29, 2015 Just tried to enter a new product and the reference code is 33 characters long. received an error response saying the max field length is only 32 characters - Arrgg Because of our new product coding system we wil be having longer codes. So, the questions if I go to table PS_product I can see the refernce field is set as varchar(32) Can I just change the 32 to be larger? Could there be any implications in the rest of the database? Store front / backoffice? Most importantly, what would happen if a future prestashop upgrade "reset" that field length to 32? Link to comment Share on other sites More sharing options...
Guest Posted July 29, 2015 Share Posted July 29, 2015 Any guidance about this? Link to comment Share on other sites More sharing options...
Guest Posted July 30, 2015 Share Posted July 30, 2015 perhaps all our gurus are on holiday Link to comment Share on other sites More sharing options...
Guest Posted August 2, 2015 Share Posted August 2, 2015 Any thoughts from our weekend gurus? Link to comment Share on other sites More sharing options...
Guest Posted August 5, 2015 Share Posted August 5, 2015 Any guidance from anyone? Link to comment Share on other sites More sharing options...
Guest Posted August 7, 2015 Share Posted August 7, 2015 ? Link to comment Share on other sites More sharing options...
Paulito Posted August 8, 2015 Share Posted August 8, 2015 Hello Ron Have you had a look at this topic https://www.prestashop.com/forums/topic/343553-increase-characters-allowed-for-supplier-reference/ Paul Link to comment Share on other sites More sharing options...
Guest Posted August 8, 2015 Share Posted August 8, 2015 Hi Paul yes, that allows you to enter more characters without getting the error message - BUT still only 32 characters are stored in the table So the question remains if I go to table PS_product I can see the refernce field is set as varchar(32) Can I just change the 32 to be larger? Could there be any implications in the rest of the database? Store front / backoffice? Most importantly, what would happen if a future prestashop upgrade "reset" that field length to 32? Link to comment Share on other sites More sharing options...
123Kirill312 Posted August 9, 2015 Share Posted August 9, 2015 (edited) Hi, I did the same for UPC Length. Edit length of this field in Data Base, somewhere in controller of this field and in validation file, Make back ups! Something like this https://www.prestashop.com/forums/topic/441759-changing-the-length-of-the-upc-field-in-products/ After upgrade of the Prestashop you will lose your changes. Regards, Kirill Edited August 9, 2015 by 123Kirill312 (see edit history) Link to comment Share on other sites More sharing options...
Guest Posted August 9, 2015 Share Posted August 9, 2015 Thanks Kirill Link to comment Share on other sites More sharing options...
123Kirill312 Posted August 9, 2015 Share Posted August 9, 2015 Thanks to Pascal, he wrote a manual how to edit it. I just rembered that it is necessary to edit DB and two files. Regards, Kirill 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