Can Integrator.io Update an Item Fulfillment in NetSuite?

[Aaron_Klein]

I see a flow that creates fulfillments in Netsuite, but is it possible to update a fulfillment that exists? So IF would be created in the Picked Status and then Celigo would push an update to set it to shipped? Is that possible?

What about setting the inventory details? Is there any way to map inventory details on the item fulfillment?

[davidgollom]

Yes, that's all doable. You can update just like any other record in NetSuite and you need to use the Subrecord mapping feature for the Inventory Details.

[Aaron_Klein]

Hey David, thanks for the response. That seems like what I'm looking for so I'll play around next week. Once I added the sub record type and went to mapping, now I see another step under mapping (screenshot below). Is it actually a separate step? My client has bins required so we couldn't create a fulfillment and then update inventory details after. The inventory details need to be mapped on creation of the fulfillment. Is that how it will work?

Thanks!

[Aaron_Klein]

@davidgollom We've been working with Tyler Ronan on a Shopify project and we are having issues mapping the inventory detail. The error simply says "please set inventory details." We are being told that we can't map an explicit bin which doesn't sound right. Can you please confirm that this is working in other instances where a specific bin is being set on Item Fulfillment creation?

Thanks!

[simonding]

Hi Aaron,

This error sounds like might be a pathing issue with your line items when you setup your subrecord. When you click "+Add subrecord", there should be a field to enter the path to line items. This should be the path to the array representing your items. For example, let's say your importing fulfillment data looks like this:

{
    "fulfillmentID": 123,
    "date": "2025-03-20",
    "customer": "ABC Corp",
    "status": "Shipped",
    "line_items": [
    {
        "itemID": 101,
        "itemName": "Laptop",
        "quantity": 1,
        "inventoryDetails": [
        {
            "lotNumber": "XYZ",
            "quantity": 1
        }]
    }
}

Here the path to line items should be "line_items". You may see the default entry as $ when you first open that screen which represents the root path. $.line_items should work too.

(disregard the screenshot saying Sales Order instead of Fulfillment, it should work the same).

Here's an article that goes through the process in depth. It walks through the process for sales orders, but the process should be the same for fulfillment.

https://docs.celigo.com/hc/en-us/articles/360016510891-Configure-and-map-NetSuite-subrecords#h_01J8QH29JKKMDR0TC9ATX45PV2

Hope this helps!
Simon

[davidgollom]

I agree with what Simon said below. Sounds like a data formatting issue. We usually use a script to generate and array of lots or bins as a property of the lines.

[kellyizer]

Aaron,

To format your inventory details correctly, you can leverage the transformation functionality within IO as well as using scripting as David stated.

I was working on another project where I put together a short video that walks through setting up inventory details for a Work Order import—the same approach applies to Item Fulfillments.

Please watch from 0:30 to 0:50 to see how the built-in transformation functionality is used to shape the data appropriately for the inventory details mapping.

NetSuite _Work Order Issue with Serial numbers.mp4

Thank you and please let us know if you have any additional questions.