Jump to content

MySQL Editting :(


Recommended Posts

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”
“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.

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...