Skyvia error on BigCommerce import with unmodified BC export csv

  • 20Views
  • Last Post 27 August 2019
0
votes
Mikael Enroos posted this 27 August 2019

Hi,

When I try to import a csv from sftp to BigCommerce I get errors. The log says "The value of the column CustomFields has incorrect JSON format". The csv has the same structure as the exported csv from BC and the only thing changed is the price and amount.

I've attached a screen dump of the log file.

Attached Files

0
votes
Mariia Zaharova posted this 27 August 2019

Hello Mikael!

 

The issue is related to the fact that this field uses complex JSON format. You can try sending values to CustomFields field in this JSON format :

[{ "name": "Release Year", "value": "2019" }]

 

 

 

JIC: you can also import data to the ProductCustomFields table.

 

Best regards,

Mariia

Close