Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Product Id in databse


zeeshop

Recommended Posts

Hi,

 

 

On our shop when I first added products all was in right sequence, but then I had to delete whole category and add products again.

 

Instead of start from product id "0" ids are starting from 400 or so on means products we already deleted is still occupying place in database.

 

Can some one please advise me how I can totally remove or set so new product id start from number in previously deleted numbers. or if I want to totally clean products and add products again in category how I can set new product start from id 1 and so on.

 

 

 

Thanks.

 

Regard

Link to comment
Share on other sites

The products are not occupying anywhere, they have been deleted.

 

To start the numbers from 1 you need to drop the table and recreate it.

 

This article talks about starting from a higher no for another table.

 

http://www.oscommerce.info/kb/osCommerce/G...s_and_Tricks/31

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...