Opencart how to reset product id correctly?

Question

opencart

I want to reset the product id in opencart. Now there are gaps in product IDs (for example, 145,146,148,150, etc.). How to organize all this?
Will this method work?: Change the product table through SQLYog, delete the ID field and add it again?

Answer 1

You will need to replace IDs not only in the product table, but in about 20 related tables.

Answer 2

Make an export of goods, for example, to Excel .
Number the goods as you like
. Make an import with clearing the previous data.
At the same time, keep in mind 2 points, before this operation, save the database dump, export / import, most likely it will be an additional module for the OS