Change a product ID

Hi,

I'd like to change a product ID from 17508 to 22.

I've searched in phpMyAdmin to check if there is any other products with the ID 22 and there is not.

I tried editing the ID from 17508 to 22, but this simply makes the product disappear from the hikashop interface.

Is this the incorrect way of doing this?

Thanks,

Phil

Hi,

You can do it in PHPMyAdmin. However, that product id is also used in other tables like jos_hikashop_product_category, jos_hikashop_price, etc. If you change the id only in the jos_hikashop_product table, you won't have that in all the other tables and that's why you don't see it anymore. The table jos_hikashop_product_category is making the link between products and categories, so if you don't update the product id there, it will mean that your product won't be linked to a category, and it won't display anywhere.