palmerstoneroad Posted December 17, 2014 Share Posted December 17, 2014 Hi,is there a manual way (thorugh BO) to force the change of an ID for a product?I have a list of 1 to 8 ID products, then a new added one switched to ID 23 and I would like to follow an order for the product IDs.thanks! Link to comment Share on other sites More sharing options...
parsifal Posted December 17, 2014 Share Posted December 17, 2014 (edited) AFAIK, this can't be done from the BO. You need to: 1. Delete the products with ID greater than 8 2. Change the value of the AUTO_INCREMENT property in the ps_product table of your MySQL database and set it to 9. This can be easily done with phpMyAdmin. 3. Readd your products Another way (maybe easier) is to always create your products with CSV import, setting the ID inside the CSV file and choosing the option Force all ID: http://doc.prestashop.com/display/PS16/CSV+Import+Parameters Edited December 17, 2014 by parsifal (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts