How can I modify item ID and reserve some IDs

grabit
Topic Author
Offline
Platinum Member

4 years 3 months ago #77819 by grabit

How can I modify item ID and reserve some IDs was created by grabit

HI,

I have a bis item list and some items are automatically imported from a CRM, this items have a specific item ID (e.g. 32362901).

All the previous items were small numbers but after my import and a few subsequent one, my new items (not the imported one) have a ID higher than that one but still in a "reserved array" from the CRM.

Here are my questions:
Is it a way to modify the items ID that were created within this reserved array? If yes how?
Is it a way to reserve a range of IDs for the import? Maybe by starting the next IDs above the reserved array?

Thanks for your help.

An Apple a days keeps the doctor away

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

4 years 3 months ago #77822 by ggppdk

Replied by ggppdk on topic How can I modify item ID and reserve some IDs

Hello

you can run this in phpmyadmin
(example is 500 million, you can set it up to 2 billion, and still have a remaining of 100 million)

Code:

ALTER TABLE PPP_content AUTO_INCREMENT = 500000000;   // Set new auto-increment to 500 million

This way all Ids below 500 million will be "reserved" ...

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.