melriks Posted May 20, 2012 Share Posted May 20, 2012 In Magento the Product ID can be any combination of letters and numbers as long as it is unique. In Prestashop, the Product ID is a number. Does anyone know is it possible to change the product id to varchar? I have a database of products all with a unique sku. Some skus are letter/number combinations. I want to do pricing updates but to do that I need to use the product id. Pulling that id out of the shop and merging it with the database is difficult due to number of skus. Wondered if anyone has tried changing the product id to something other than a number? Link to comment Share on other sites More sharing options...
Andrei_BelVG Posted May 22, 2012 Share Posted May 22, 2012 We would suggest you to write the ‘SKU’ field in ‘EAN13 or JAN’ (it’s the same as ‘ean13’ in the ‘Product’ table) and compare products according to that field. 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