Is there a way to reset the auto increment IDs for any tables? I have deleted products which rely on my own foreign key, but when I re import them it creates its own IDs. I would like the ability to truncate the product table and reset AUTO_INCREMENT ids. I am in testing phase right now, but cannot do anything until our foreign keys are the same in both my system and infusionsoft.
I can no longer retrieve the correct product to sync up with my own system.
I am using Laravel 7 and the Oauth PHP 7.2