Resetting Product ID

  • Resolved mjaitly123

    (@mjaitly123)


    2 years, 1 month ago

    I deleted all the products in WooCom through a SQL query in phpadmin. However, when I add new products, the product id (ID) does not start from 1. If I delete 600 products then the id for the new product (which I insert into the blank table after having deleted all records earlier) starts from 601. How can I make it start from 1…in other words totally afresh? Basically, I want to reset the ID back to 1 as it was when the table was first created.

Viewing 3 replies - 1 through 3 (of 3 total)

  • You can’t. If you use the SKU field as a product ID, you can make it what you want.

    I think you’d have to nuke _all_ your posts/pages/menu items… literally everything in your DB. product ID is the wp_posts.ID which is shared will all content types.

    Plugin Support Gabriel – a11n

    (@gabrielfuentes)

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if and/or when you are ready to continue.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Resetting Product ID’ is closed to new replies.