razvy Posted April 13, 2015 Share Posted April 13, 2015 Hi, I want to use the EAN code number as product ID, but Prestashop won't let me, it says that the product can not be saved. I'm guessing it's because the ID is too long. If I shorten it to 9 digits, it works. How can I make Prestashop accept 13 digits IDs? It's very important, I have more that 50.000 products and using the EAN code would dimplify my work. Thanks! Link to comment Share on other sites More sharing options...
prestatent Posted April 13, 2015 Share Posted April 13, 2015 Hi Ean code field is available as a separate field in prestashop on the PRODUCT and COMBINATIONS so you can have the ean code against your products but not as the product-id. The field size may be the issue, but if you wanted to increase the size of the field you would have to do this on all product related tables where the id is located. I think this would be a waste of your time, as well as potentially causing problems with the code. Link to comment Share on other sites More sharing options...
tuk66 Posted April 13, 2015 Share Posted April 13, 2015 id_product field is unsigned integer (auto increment) so maximum value is 4294967295 (10 digits). This field is used in many tables and I wouldn't touch it in any case. Link to comment Share on other sites More sharing options...
razvy Posted April 13, 2015 Author Share Posted April 13, 2015 Ok, thanks. It would have easen up my work if it was just a modification in one table, but I understand it is much more complicated than that. Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
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