I am trying to perform an initial full replication of my BigCommerce data to mySQL. I have been mostly successful (!) except in an area I can't ignore, the PriceListRecords table. The error I get is that the VariantID is a duplicate.
error is: Duplicate entry '111' for key 'PRIMARY'
in the MySQL PriceListRecords table, Replication is using the VariantId field as a Primary key for an index. It seems to me this is incorrect.
in BC's API V3, one Variant is created for each product even if you aren't using variant (I'm not). But I have 4 price lists, so I will have 4 prices for each product and therefore 4 prices for each VariantId. Which is why I am getting the error. What should I do?