Jump to content



Latest News: (loading..)

- - - - -

How to Get your product id number back to 0


This topic has been archived. This means that you cannot reply to this topic.
No replies to this topic

#1   matrix2223

matrix2223
  • Members
  • 861 posts

Posted 26 May 2010 - 11:19 PM

Heres a short easy tip to get your products and categories counts set back to 0 after you have successfully installed osCommerce.

Like always its probably been answered and I couldn't find it.

1)Login in to you admin section
2)Go to you catalogs first page where all the main category folders are listed and delete them and the products in them
3)Go to your favorite sql program such as phpMyAdmin and run this sql statement.
TRUNCATE TABLE products; TRUNCATE TABLE categories;
Thats All!!
The first category and the first product you add will be #1

Cheers
Eric

Keep up on osCommerce changes and updates at Github | Understand osCommerce a little further at OsCommerce Documentation | Copy and paste your error message in Google add "in osCommerce" at the end to get relevant answers to most issues.