I'm exporting products data from our enterprise Erp to a Prestashop installation.

Our ERP products code are alphanumerics like A001, A002, etc. I would like to use this code into Prestashop, but if I'm not wrong, Prestashop Id is numerical.

So, does a field like "External Product Code" exist that I can use in the Products table in Prestashop?


While Prestashop does use a unique numerical autonumber to identify products (ps_product.id_product), there are also three fields into which you could provide external references - Reference Code, EAN-13 or JAN Barcode, and UPC Barcode, though it is apparent the Reference Code field (ps_product.reference) would be the most appropriate and does not have any validation other than to limit the acceptable characters to alphanumerics and special characters .-_#\.

Since this question was asked some time ago I'm not sure which version of Prestahop @stighy would have had installed and be referring to, however having checked I can confirm that this reference field was present in v1.4.11.0 and is still present in v1.6.0.14.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for?Browse other questions tagged or ask your own question.