# Can Integrator.io Update an Item Fulfillment in NetSuite?

**URL:** https://connective.celigo.com/t/can-integrator-io-update-an-item-fulfillment-in-netsuite/3596
**Category:** Integrator.io
**Tags:** netsuite, shopify
**Created:** [February 28, 2025, 7:01pm UTC](https://connective.celigo.com/t/can-integrator-io-update-an-item-fulfillment-in-netsuite/3596 "2025-02-28T19:01:55Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![Aaron\_Klein](https://avatars.discourse-cdn.com/v4/letter/a/e68b1a/32.png) [@Aaron\_Klein](https://connective.celigo.com/u/Aaron_Klein)
#### Post date: [February 28, 2025, 7:01pm UTC](https://connective.celigo.com/t/can-integrator-io-update-an-item-fulfillment-in-netsuite/3596/1 "2025-02-28T19:01:55Z")

</div>

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?

---

<div class="post-metadata">

### Author: ![davidgollom](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/davidgollom/32/6605_2.png) [@davidgollom](https://connective.celigo.com/u/davidgollom)
#### Post date: [February 28, 2025, 11:40pm UTC](https://connective.celigo.com/t/can-integrator-io-update-an-item-fulfillment-in-netsuite/3596/2 "2025-02-28T23:40:46Z")

</div>

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.

 ![A form interface with options for importing records, showing "Item Fulfillment" as the record type and an option to "Add subrecord," indicated by a red arrow. (Captioned by AI)](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/0/06a9b0595ca17f2cb1d8878608d066e00177b485.png)

---

<div class="post-metadata">

### Author: ![Aaron\_Klein](https://avatars.discourse-cdn.com/v4/letter/a/e68b1a/32.png) [@Aaron\_Klein](https://connective.celigo.com/u/Aaron_Klein)
#### Post date: [March 1, 2025, 12:51am UTC](https://connective.celigo.com/t/can-integrator-io-update-an-item-fulfillment-in-netsuite/3596/3 "2025-03-01T00:51:06Z")

</div>

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!

 ![image](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/7/7a2d325c280c958334a3b407609ade4fef6314d1.png)

---

<div class="post-metadata">

### Author: ![Aaron\_Klein](https://avatars.discourse-cdn.com/v4/letter/a/e68b1a/32.png) [@Aaron\_Klein](https://connective.celigo.com/u/Aaron_Klein)
#### Post date: [March 19, 2025, 8:09pm UTC](https://connective.celigo.com/t/can-integrator-io-update-an-item-fulfillment-in-netsuite/3596/4 "2025-03-19T20:09:59Z")

</div>

@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!

---

<div class="post-metadata">

### Author: ![simonding](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/simonding/32/6863_2.png) [@simonding](https://connective.celigo.com/u/simonding)
#### Post date: [March 20, 2025, 7:54pm UTC](https://connective.celigo.com/t/can-integrator-io-update-an-item-fulfillment-in-netsuite/3596/5 "2025-03-20T19:54:20Z")

</div>

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:

```auto
{
    "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).

 ![image](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/5/599c5bf385af1612e2176fd3a6b0c7f9fdf18092.png)

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](https://docs.celigo.com/hc/en-us/articles/360016510891-Configure-and-map-NetSuite-subrecords#h_01J8QH29JKKMDR0TC9ATX45PV2)

Hope this helps!  
Simon

---

<div class="post-metadata">

### Author: ![davidgollom](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/davidgollom/32/6605_2.png) [@davidgollom](https://connective.celigo.com/u/davidgollom)
#### Post date: [March 20, 2025, 10:41pm UTC](https://connective.celigo.com/t/can-integrator-io-update-an-item-fulfillment-in-netsuite/3596/6 "2025-03-20T22:41:19Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![kellyizer](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/kellyizer/32/4369_2.png) [@kellyizer](https://connective.celigo.com/u/kellyizer)
#### Post date: [March 21, 2025, 10:18pm UTC](https://connective.celigo.com/t/can-integrator-io-update-an-item-fulfillment-in-netsuite/3596/7 "2025-03-21T22:18:55Z")

</div>

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](https://drive.google.com/file/d/13h-jMUOxGTYC4CndFaSnNGSVK96bAISg/view?usp=drive_link)**
>
> Google Drive file.

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