BigCommerce Replicate to mySQL errors

  • 13Views
  • Last Post 3 weeks ago
  • Topic Is Solved
0
votes
Suda Miller posted this 4 weeks ago

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? 

Attached Files

0
votes
Mariia Zaharova posted this 3 weeks ago

Hello Suda,

 

Thank you for contacting our Skyvia Support.

 

 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. 

 

Skyvia works with BigCommerce via its API. In this case, API Ver3. Target tables are created in accordance with the source table. The PriceListRecords table does not have its own Id column and, thus, the VariantId is used for that case. Unfortunately, we cannot avoid this due to the BigCommerce API limitations.  

You can try manually remove the unique constraint from the target database table.

 

If we have any news regarding this case or any other suggestions, we will definitely post them here.

 

Best regards,

Mariia

Close