Relational DB Linking Question





Hey guys,

Quick question about DB Relationships & inserting data into a Referenced DB.


DB 1: Product

DB 2: Product Variants (product_id (ref to db 1) >> id)

I am currently using Shopify’s API to grab in both “Parent” product details as well as the “Variant” details to store certain needed parameters of each into my two DB’s as listed above.

Being there will be 100 variants with different “id” in this case all with the same parent “product_id” of 7514679771358, I am trying to fill DB 2 (Product Variants) but get an ERROR for Duplicate Entry Value for 7514679771358.

In the Product_Variants DB - The product_id is set as the Primary Key.

I’ve done a decent amount of research on this and not sure if I need to have some sort of Trigger (not sure how to do this) or what.

Any thoughts / help with this would be awesome as I’m sure others have similar questions that are new to the DB’s and Relations.

Cheers!![Screen Shot 2022-01-18 at 10.05.32 AM|690x415]


Community Page
Last updated: