Possible to use ?skipped? ID with new products?

  • Resolved Alexanne

    (@alexannee)


    5 years ago

    Hello,

    I have a big big Woocommerce store, and I did my products import quite a few times before I got it right. Now everything is fine, but my IDs are in the 100 000’s. Phew!

    Because I deleted and re-uploaded my products many times, IDs kept adding up even if I deleted the old ones.

    Maybe it is more a general WordPress question, but is it possible for my next import to use lower, unused ID?

    Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support AW a11n

    (@slash1andy)

    Automattic Happiness Engineer

    Hey there!

    >Now everything is fine, but my IDs are in the 100 000’s.

    So the main issue here is that your DB server is on the 100,000 level.

    It maintains an auto-increment number for what to assign as the next ID. There’s not a way for it to use *only* the deleted post ids, as you can basically just set it to restart counting up from 100 (for instance). Once you get back up to where you have content with an id, and it duplicates it, your site will not work properly, and the amount of work to fix that issue will be substantial.

    If you are worried about sequential order numbers (having product ids that high is not really something to worry about), you can use a plugin like this one: https://www.ads-software.com/plugins/woocommerce-sequential-order-numbers/

    Hopefully that helps! Have a great one!

    Thread Starter Alexanne

    (@alexannee)

    Hello,

    That was what I thought. Thanks for confirming it, I’ll keep my high IDs.

    Have a nice day!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Possible to use ?skipped? ID with new products?’ is closed to new replies.