frustrated Posted July 28, 2013 Share Posted July 28, 2013 Hello, For days ive been experimenting with the CSV product uploader, im now ready to import my redone and final csv of all my products but id number is at over 3000 can i reset that back to 1 again? is all this unwanted data from product id numbers 1-3000 stored somewhere that i can remove? many thanks x Link to comment Share on other sites More sharing options...
vekia Posted July 28, 2013 Share Posted July 28, 2013 in this case just truncate products tables, then auto icrenement will be reset to 0 Link to comment Share on other sites More sharing options...
frustrated Posted July 28, 2013 Author Share Posted July 28, 2013 sorry what do you mean by truncate product tables? sorry if im being silly Link to comment Share on other sites More sharing options...
vekia Posted July 28, 2013 Share Posted July 28, 2013 hello here is the clarification conntect your database, for example via phpmyadmin then from databases list on the left hand side select your prestashop database search for tables related to the product (ps_product) and also (ps_category_product) and check the checkbox near them scroll page down and from dropdown select "EMPTY / TRUNCATE" Link to comment Share on other sites More sharing options...
frustrated Posted July 28, 2013 Author Share Posted July 28, 2013 is this possible to do this in plesk or via ftp? Will it have any effect if i just leave it as it is? ie will my prestashop admin panel be really slow when amending product info if I just leave it? Im trying to manually do the sizes/colours but its taking a while to load the admin product page in prestashop admin Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted July 28, 2013 Share Posted July 28, 2013 you will need access to phpmyamdin on your hosting account in order to follow veikas procedure. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now