Developer forum

Forum » Ecommerce - Standard features » Duplicated Variant Options ID error

Duplicated Variant Options ID error

Khaing May Thaw
Reply

Hi everyone,

 

Could someone help me with this issue, please?

 

I have to create a lot of variants for my products so I imported the variant data with Data Integration jobs into the EcomVariantOption table.

The data was smoothly imported.

 

But when I create the variant by manual, the system shows the 'Duplicated Key' error. Kindly check the attached image.

Because generated ID by the System and the ID coming from data integration jobs are the same.

 

Is it bug on version 9.9.2?

Kindly advise.

 

Thanks.

Best Regards,

May Thaw.

 

be.png vo.png

Replies

 
Nicolai Pedersen
Reply

Hi May

You have to go to the database, ecomnumbers table, and find the row that handles the ids for variants. And then set its seed high enough to not collide with your imported IDs. 

BR Nicolai

 

You must be logged in to post in the forum