natebc Posted December 11, 2015 Share Posted December 11, 2015 (edited) Hello, Can you Change the UPC length? I got an error my UPC is 20 in length. It looks like the limit is 12. Nate Edited December 11, 2015 by natebc (see edit history) Link to comment Share on other sites More sharing options...
natebc Posted December 11, 2015 Author Share Posted December 11, 2015 (edited) One site is 1.6.1.3 and the other 1.6.0.9. Nate Edited December 11, 2015 by El Patron (see edit history) Link to comment Share on other sites More sharing options...
Bill Dalton Posted December 11, 2015 Share Posted December 11, 2015 Nate, the standard length for a real UPC code is 12. To make the field longer you will need to open the MySQL table and modify the field length. The correct table depends on which type of in Preferences > Products Enable stock management and/or Enable advanced-stock management Some of the tables are ps_product_attribute and ps_stock - There may be more. 1 Link to comment Share on other sites More sharing options...
natebc Posted December 12, 2015 Author Share Posted December 12, 2015 Nate, the standard length for a real UPC code is 12. To make the field longer you will need to open the MySQL table and modify the field length. The correct table depends on which type of in Preferences > Products Enable stock management and/or Enable advanced-stock management Some of the tables are ps_product_attribute and ps_stock - There may be more. Hi Bill Dalton I don't know why this suppler has UPC codes longer thing 12 numbers. I was Enable stock management and Enable advanced-stock management. Where can I find how to open the MySQL table and open ps_product_attribute and ps_stock? Thanks Nat Link to comment Share on other sites More sharing options...
Bill Dalton Posted December 12, 2015 Share Posted December 12, 2015 You will need to check with your host. They should have a program available for you to edit your MySQL table. Can you not use the Reference field, or create a new field in Features? Link to comment Share on other sites More sharing options...
natebc Posted December 12, 2015 Author Share Posted December 12, 2015 You will need to check with your host. They should have a program available for you to edit your MySQL table. Can you not use the Reference field, or create a new field in Features? Hi Bill, Yes the program is called phpMyAdmin. but do you know how I would be able to edit it from there. I can create a new field in Features if needed. Natebc Link to comment Share on other sites More sharing options...
Bill Dalton Posted December 12, 2015 Share Posted December 12, 2015 Natebc, using an existing field or creating a new field in Catalog > Products > Edit > Features would be best if you do not know how to edit your database. Link to comment Share on other sites More sharing options...
natebc Posted December 12, 2015 Author Share Posted December 12, 2015 Natebc, using an existing field or creating a new field in Catalog > Products > Edit > Features would be best if you do not know how to edit your database. Yes I'm going to use the Features to create UPC. Thanks for your help Natebc 1 Link to comment Share on other sites More sharing options...
Recommended Posts