Product Combinations Issue

[KD]

Hi,

We ran the TB cleaner to clean-up all the test data and start fresh.

When we add the new product and try to add the combinations for any products it gives " duplicate entry for key 'primary' " and it does not update the combinations on the product page. If we go back and edit the same Combination, remove Null value and re-add the value it save and update successfully.

Has anyone experience the above issue and if there is any solution to fix the issue?

 

Thanks

KD

[Smile]

I might have seen it before in PS, but normally I just delete the product and add it again. Then it is mostly sloved.

[Wartin]

On 7/14/2020 at 1:32 AM, KD said:

Hi,

We ran the TB cleaner to clean-up all the test data and start fresh.

When we add the new product and try to add the combinations for any products it gives " duplicate entry for key 'primary' " and it does not update the combinations on the product page. If we go back and edit the same Combination, remove Null value and re-add the value it save and update successfully.

Has anyone experience the above issue and if there is any solution to fix the issue?

 

Thanks

KD

Did you import those using CSV?
When working with combinations, there is a REF number that is not products', but the combination reference number. In order to make it work, you have to chose a different number for EACH combination, like TSHIRTWHITE and TSHIRTBLACK.

 

[KD]

To fix the issue, we restore the DB and cleaned it manually.

 

Thanks

KD