Bulk Import/Update Data With Collections

Importing or updating data using the bulk tools is generally straightforward. Each row in the CSV file represents a single item, and each column corresponds to a specific value for that item.

However, in some cases, a column may represent a collection of values. For example, when importing Product Listings, you need to specify one or more associated Products. Collection values should be provided in JSON format (e.g., as an array). These values are optional during an update - if left blank, the existing values will be retained.

Here’s an example of how to format collection values:

Products

• FieldValues - e.g. [{"fieldId": 1, "value": "Small"}]

ProductFields

• Options - e.g. [{"value": "Small", "dependsOnName": null, "dependsOnValue": null, "isSelected": false, "personalisationPrice": null, "image": null}, {"value": "Medium", "dependsOnName": null, "dependsOnValue": null, "isSelected": false, "personalisationPrice": null, "image": null}, {"value": "Large", "dependsOnName": null, "dependsOnValue": null, "isSelected": false, "personalisationPrice": null, "image": null}]
• ProductTypes - e.g. [1]

ProductListings

• Images - e.g. ["Image1.jpg", "Image2.jpg"]
• Products - e.g. [{"id": 1, "isSelected": false}]
• BundleProducts - e.g. [{"name": "Group 1", "description": null, "listType": "DropDown", "isRequired": false, "products": [{"id": 1, "overridePrice": null, "quantity": 2, "isSelected": true}, {"id": 2, "overridePrice": "10", "quantity": 1, "isSelected": false}]}, {"name": "Group 2", "description": null, "listType": "RadioButton", "isRequired": false, "products": [{"id": 1, "overridePrice": null, "quantity": 1, "isSelected": false}]}]

ProducteBayListings

• Images - e.g. ["Image1.jpg", "Image2.jpg"]
• Products - e.g. [{"id": 1, "overridePrice": "10", "overrideMaxQuantity": null}]
• BundleProducts - e.g. [{"id":1, "overridePrice": null, "quantity": 2}, {"id": 2, "overridePrice": "10", "quantity": 1}]