Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

how to reset auto_increment back at 1


lucilue2003

Recommended Posts

I was wondering, i've been creating and deleting products and testing and stuff and i have noticed that after i delete all my products, my product id count doesn't start at 1, rather it is currently on 8. So i were to add a product, its product id would be 9 instead of 1.

 

Any clues on how i can get the counting back at 1 ?

 

 

thanks.

Link to comment
Share on other sites

It doesn't matter what the product_id is... just as long as it has one, which it will because it's been added automatically.

 

Throughout the life of your store and database, you will add and delete many products... so it will get out of whack then anyway.

 

Tony

"The price of success is perseverance. The price of failure comes much cheaper."

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...