Go to previous topic
Go to next topic
Last Post 09 Dec 2019 10:09 PM by  Steve L
orphan records
 1 Replies
Author Messages


Basic Member


Posts:281
Basic Member


--
09 Dec 2019 02:11 PM

    Hi Stephen,

    I have found some orphan records in the prductvariant and productvariantgroup tables.
    Is it ok to delete thes records direct in sql or is it better to to this with the "d" options in import upload.

    Regards, Ton

    0


    Veteran Member


    Posts:2956
    Veteran Member


    --
    09 Dec 2019 10:09 PM

    I suggest you just delete using the Import action. You should not have any orphan variants since there is a foreign key tied to a product (unbreakable).

    0


    ---