MySQL Editting :(

[chino259]

Hi there, I had imported about 4000+ Items to my prestashop, and have gotten rid of all the products.
Now i seem to add a new product 1 by 1, and it adds an ID Number of 4226+

I would really like to get the Product ID Numbers to start from 1. If anyone can please tell me what table(s)
to edit in my PHPMyAdmin in order to accomplish this.

I tried “ALTER TABLE ps_product AUTO_INCREMENT = 1”
and
“ALTER TABLE ps_product_lang AUTO_INCREMENT = 1”

and nothing changed, added new product and it added 4228+

Hope to get some help from the community here.