Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Reset Option Values ID numbers


Recommended Posts

This isn't that important, but wondering if there was a way to do this?


So, in the Product Attributes section I had 402 Option Values which I have now got down to just 20! And just for the sake of being orderly I thought it would be nice to have the option ID's using 1-20 (NOTE: IDs 1-20 are now free).


But when I go to re-enter the Option Values the next ID it's allowing me to use is 403 - is there any way to allow me to reset this to use 1 and so on?



Link to comment
Share on other sites

Its the AUTO_INCREMENT value for the table, you can change it in the operations tab in phpMyAdmin after selecting the table.


Or a perhaps easier method, backup the database with the reseted key values using Database Backup Manager or Auto Backup Database then with Database Backup Manager restore that one table, after the restore the AUTO_INCREMENT value will be one higher than the highest key value



Remember, What you think I ment may not be what I thought I ment when I said it.




Auto Backup your Database, Easy way


Multi Images with Fancy Pop-ups, Easy way


Products in columns with multi buy etc etc


Disable any Category or Product, Easy way


Secure & Improve your account pages et al.

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...