[Solved] Can the User ID numbers be reset to begin at different value?

mdneer

Here is my situation:  my old site is no longer functioning, so I had to rebuild into a new site.  However, I had a database of 479 customers that I want to import as a table.  The problem is, with each new customer there is a duplication of user IDs, so a customer with the same number can download all the products that his doppelganger has purchased.  I would like to reset the values to start again at 500.  Is this possible within Checkout?

Thanks.

Tribulant

@mdneer

You can just set the auto increment index on the "wp_wpcoorders" database table used by the WordPress Shopping Cart plugin.

See this documentation: http://tribulant.com/docs/wordpress-shopping-cart-plugin/3475

Tribulant

@mdneer

Did you find a solution to this?

Best is to set the index on the database table in a tool such as phpMyAdmin.

What are you importing from though? Do you have a SQL file?

mdneer

I was using phpMyAdmin through 1&1, but was never able to find a solution.  I have the SQL files.