Forum
Welcome, Guest
Username: Password: Remember me

TOPIC: How to reset product ID#s

How to reset product ID#s 9 years 3 days ago #26282

I uploaded a test CSV with 60 items, deleted it. Then uploaded another one with actual content. But my product numbers started at 61 not 1. How do I get my product IDs back to 0 after removing the content?
The administrator has disabled public write access.

How to reset product ID#s 9 years 3 days ago #26283

  • Support
  • Support's Avatar
  • OFFLINE
  • Moderator
  • Posts: 10443
  • Thank you received: 633
Dear Clifford,

Please note that this is controlled by MySQL functions, whether or not the entries are deleted, it saves the last ID of the data. You will need to change some parameters from PHPMyAdmin of your website. Here's a Stackoverflow link, that can help you with that: stackoverflow.com/questions/8923114/how-...o-increment-in-mysql

Thank you.
Best regards
Web-Dorado team

Joomla extensions,
Wordpress plugins,
Drupal modules
Clear the cache before asking questions. :)
The administrator has disabled public write access.
Time to create page: 0.143 seconds
Powered by Kunena Forum