Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Reset Option Values ID numbers


Fifecycles

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?

 

Thanks.

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

Sam

 

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

 

Contributions:

 

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

Archived

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

×
×
  • Create New...