Product ID generation

[unclesam2010]

Hello guys! trying to understand how this Product ID  generator works and how to change the value.   
After manual importation I can't add new product in admin, I have couple thousands of products in my cart and all works good, except I can't add anything new from the admin panel. Sure, I can do it manually, but would like to solve this issue,  so lets say when I add new product it starts from 10001 and so on

couldn't find it anywhere in database., so please help me out!

Thank you

[abantecart]

When you say you can not add, what exactly do you mean? Do you get an error? What is the error? What do you see in the log after you try to add?

[Basara]

Hi.
What is your hosting operating system (Windows or Linux hosting)?

[unclesam2010]

System: Linux

if you try to add through panel,  you seen just processing status all the time and it doesn't add the product, nothing was registered in error log.

the work around was to you import 1 line through admin panel and put product id lets say 5000, so after that you can start adding product normally through admin panel. the next id product will be 5001

but still I would like to find out where the product id generator takes it's value... anyone ?

thanks

[Basara]

Hi.
Product id generated automatically in mysql database. So problem in mysql database in my opinion.  Try to fix it in phpmyadmin.
    Log in to cPanel. and backup database!...
    In the Databases section of the cPanel home screen, click phpMyAdmin. ...
    In the left pane, click the name of the database that you want to work on. ...
    In the right pane, select the check boxes for the all tables in the database that you want to optimize and repair.
https://www.a2hosting.com/kb/cpanel/cpanel-database-features/optimizing-and-repairing-mysql-databases-with-phpmyadmin

[unclesam2010]

will try and post the result. thank you

[unclesam2010]

Repairing Database tables helped. Thank you for your support!!!