Solve the error occured in IF syncing
An error message is occurring in the Item fulfillment flow.
Failed to create, update/transform record because You have attempted an invalid sublist or line item operation. You are either trying to access a field on a non-existent line or you are trying to add or remove lines from a static sublist. Tip: Please make sure that all the line items that you're trying to use exist on the record.
The import mapping is shown below:
Preview of input of the import mapping is:
{
"id": "26651133",
"recordType": "itemfulfillment",
"Name": [
"35918 Warroad, Inc. : Warroad - Wholesale Orders",
"WR600 : WR600_OLYMPCBLU_L"
],
"Internal ID": "26651133",
"Warroad SO ID field": "",
"Magento/Shopify Order Number": "Manitoba Moose",
"Date": "8/14/2023",
"ShipHawk Shipping Cost": "11.35",
"Item": "WR600 : WR600_OLYMPCBLU_L",
"Quantity": "10",
"Touchstone IF Identifier": true,
"Status": "Shipped",
"Ship Via": "FedEx Ground",
"lookupfield": [
{
"id": "26651133",
"recordType": "itemfulfillment",
"Item": "WR600 : WR600_OLYMPCBLU_L",
"Internal ID": [
"970531",
"26651133"
],
"Quantity": "10",
"eTail Order Line Id": "",
"ShipHawk Shipping Cost": "11.35",
"Status": "Shipped",
"Name": "WR600 : WR600_OLYMPCBLU_L"
}
]
}
The preview of the output of the import mapping is:
{
"nlobjFieldIds": {
"celigo_nlobjTransformId": "",
"custbody_programname": "Warroad",
"memo": "Manitoba Moose",
"trandate": "8/14/2023",
"shipstatus": "Shipped",
"shipmethod": "FedEx Ground",
"custbody_3plshippingcost": "11.35",
"celigo_replaceAllLines_item": "true",
"custbody_jj_if_from_touchstone": "true",
"celigo_replaceAllLines_package": "true"
},
"nlobjSublistIds": {
"item": {
"lines": [
{
"location": "1",
"quantity": "10",
"custcol_celigo_etail_order_line_id": "",
"_keys": [
"itemname"
]
}
]
}
}
}
Comments
Hi Joe,
In place of "Items : Item (Field ID: itemname)" use itemId, then click on settings and check field "Use as a key field to find existing lines"
If this doesn't work then let us know, we can debug this further
Please sign in to leave a comment.