# NetSuite/ShipHero Integration Issues

**URL:** <https://community.shiphero.com/t/netsuite-shiphero-integration-issues/405>\
**Category:** Getting Started\
**Created:** [March 20, 2020, 6:12pm UTC](https://community.shiphero.com/t/netsuite-shiphero-integration-issues/405 "2020-03-20T18:12:40Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![shanegothman](https://avatars.discourse-cdn.com/v4/letter/s/71e660/32.png) [@shanegothman](https://community.shiphero.com/u/shanegothman)\
**Post date:** [March 20, 2020, 6:12pm UTC](https://community.shiphero.com/t/netsuite-shiphero-integration-issues/405/1 "2020-03-20T18:12:40Z")

</div>

The main issue I’m currently noticing is that the sales orders in Netsuite are ending up with different quantities or even canceled items once they push through to ShipHero.

FarApp, our integrator, seems to be sending the correct information to ShipHero, but some how ShipHero is interpreting this information incorrectly.

In an example order, NetSuite & FarApp correctly sent 1 unit of a SKU to ShipHero, but ShipHero is showing 2 units of that SKU in the order.

From FarApp:  
"I see we sent only 1 of quantity for SKU: 070-127-008-GRT-M-34  
I see:  
“custom\_options”: “{‘custcol1’: ‘070-127-008-GRT-M-34’, ‘ItemName’: ‘070-127-008 : 070-127-008-GRT-M-34’, ‘Location’: ‘’, ‘custcol4’: ‘Jamaican Me Drink Shorts’}”,  
“eligible\_for\_return”: “false”,  
“partner\_line\_item\_id”: “6159”,  
“price”: “45.00”,  
“product\_name”: “Jamaican Me Drink Shorts”,  
“quantity”: 1,  
“quantity\_pending\_fulfillment”: 1,  
“sku”: “070-127-008-GRT-M-34” },

So I’m not sure how it’s appearing with 2 units in ShipHero. NS, shows 1 so I don’t think there’s an issue there, FarApp sent 1 so I don’t think there’s an issue there. ShipHero shows 2 but I can’t determine why.

Can anyone help me figure this issue out?

Thank you!!  
Shane

---

<div class="post-metadata">

**Author:** ![tomasw](https://sea2.discourse-cdn.com/flex020/user_avatar/community.shiphero.com/tomasw/32/248_2.png) [@tomasw](https://community.shiphero.com/u/tomasw)\
**Post date:** [March 23, 2020, 1:29pm UTC](https://community.shiphero.com/t/netsuite-shiphero-integration-issues/405/2 "2020-03-23T13:29:53Z")

</div>

Hi @shanegothman!  
Do you have the order number or even better, the legacy\_id of the order you are referring to?  
I’ll be happy to investigate further to see what I can find.  
Thanks!  
Tom

---

<div class="post-metadata">

**Author:** ![shanegothman](https://avatars.discourse-cdn.com/v4/letter/s/71e660/32.png) [@shanegothman](https://community.shiphero.com/u/shanegothman)\
**Post date:** [March 23, 2020, 1:42pm UTC](https://community.shiphero.com/t/netsuite-shiphero-integration-issues/405/3 "2020-03-23T13:42:20Z")

</div>

Hi @tomasw!

Thank you for your help.

Take for example, order # WMG-94805.

Thanks!

Shane

---

<div class="post-metadata">

**Author:** ![tomasw](https://sea2.discourse-cdn.com/flex020/user_avatar/community.shiphero.com/tomasw/32/248_2.png) [@tomasw](https://community.shiphero.com/u/tomasw)\
**Post date:** [March 23, 2020, 2:45pm UTC](https://community.shiphero.com/t/netsuite-shiphero-integration-issues/405/4 "2020-03-23T14:45:33Z")

</div>

Hi @shanegothman!  
Thanks for that info. For that order number, I was able to find two orders:

[First-order:](https://app.shiphero.com/dashboard/orders/details/119715893) Created through Shopify  
[Second-Order:](https://app.shiphero.com/dashboard/orders/details/119718672) Via public-API

I’m assuming you are referring to the second-order which has no line items, and that might be because the partner\_line\_item\_id might bot be a unique identifier, but I might be confused.  
In case you are referring to the Second-order is there any chance you can provide the request\_id got in return or the exact mutation you were using to create de order?

Thanks again!  
Tom

---

<div class="post-metadata">

**Author:** ![shanegothman](https://avatars.discourse-cdn.com/v4/letter/s/71e660/32.png) [@shanegothman](https://community.shiphero.com/u/shanegothman)\
**Post date:** [March 23, 2020, 3:10pm UTC](https://community.shiphero.com/t/netsuite-shiphero-integration-issues/405/5 "2020-03-23T15:10:28Z")

</div>

Hi @tomasw

Yes, I am referring to the second order. The first was created directly from Shopify and the second was created via our integration with NetSuite. Once our NetSuite integration is working properly, we are going to disconnect our Shopify to ShipHero integration.

I am not quite sure where to find the partner\_line\_item\_id ro request\_id but below is the customer and order output mapping given from FarApp, our integrator. Please let me know if this helps at all:

**Customer Output:**  
**record:** Record Type = “Customer”  
**isPerson:** true  
**firstName:** Jon  
**lastName:** Garchow  
**phone:** 6029194810  
**email:** [j.garchow@yahoo.com](mailto:j.garchow@yahoo.com)  
**taxable:** true  
**addressbookList:**  
**addressbook:**  
**addressbookAddress:**  
**addressee:** Jon Garchow  
**addr1:** 900 West Grove Parkway #1114  
**city:** Tempe  
**zip:** 85283  
**addrPhone:** 6029194810  
**state:** AZ  
**country:** \_unitedStates  
**defaultShipping:** false  
**defaultBilling:** true  
**isResidential:** true  
**addressbook:**  
**addressbookAddress:**  
**addressee:** Jon Garchow  
**addr1:** 3897 E Melrose St  
**city:** Gilbert  
**zip:** 85297-3548  
**addrPhone:** 6029194810  
**state:** AZ  
**country:** \_unitedStates  
**defaultShipping:** true  
**defaultBilling:** false  
**isResidential:** true  
**subsidiary:** Internal ID = “1”

---

<div class="post-metadata">

**Author:** ![tomasw](https://sea2.discourse-cdn.com/flex020/user_avatar/community.shiphero.com/tomasw/32/248_2.png) [@tomasw](https://community.shiphero.com/u/tomasw)\
**Post date:** [March 23, 2020, 5:33pm UTC](https://community.shiphero.com/t/netsuite-shiphero-integration-issues/405/6 "2020-03-23T17:33:50Z")

</div>

Thanks again for providing that information @shanegothman!

I could find the request and the mutation you are making, and it looks good, I was able to create an order on my account successfully by using that exact mutation.

The only advice on why this may be failing is because of the “partner\_line\_item\_id”: “6159” because they need to be unique across all the order’s line items, and is also recommended to be unique across the entire store.

Make sure those are unique identifiers. Otherwise, they will not be appropriately added to the order, leaving the order empty or with missing line items.

---

<div class="post-metadata">

**Author:** ![shanegothman](https://avatars.discourse-cdn.com/v4/letter/s/71e660/32.png) [@shanegothman](https://community.shiphero.com/u/shanegothman)\
**Post date:** [March 23, 2020, 5:58pm UTC](https://community.shiphero.com/t/netsuite-shiphero-integration-issues/405/7 "2020-03-23T17:58:45Z")

</div>

Hmm I guess that makes sense. But we are seeing the same issue with orders that were only created in NetSuite and then brought over to ShipHero (i.e. were not input into Shopify at all, so there is no duplicate order in ShipHero).

For example, order # SO1032 was created only in NetSuite, so there should be no duplicate partner line item id in ShipHero. However, this order in ShipHero is missing many of the items from the order.

Could you kindly see if this order has the same issue?

Thank you!!

---

<div class="post-metadata">

**Author:** ![shanegothman](https://avatars.discourse-cdn.com/v4/letter/s/71e660/32.png) [@shanegothman](https://community.shiphero.com/u/shanegothman)\
**Post date:** [March 26, 2020, 11:12pm UTC](https://community.shiphero.com/t/netsuite-shiphero-integration-issues/405/8 "2020-03-26T23:12:20Z")

</div>

Hi @tomasw

I just wanted to follow up and see if you were able to find out anything further about this issue.

Thank you very much!  
Shane

---

<div class="post-metadata">

**Author:** ![tomasw](https://sea2.discourse-cdn.com/flex020/user_avatar/community.shiphero.com/tomasw/32/248_2.png) [@tomasw](https://community.shiphero.com/u/tomasw)\
**Post date:** [March 28, 2020, 12:40pm UTC](https://community.shiphero.com/t/netsuite-shiphero-integration-issues/405/9 "2020-03-28T12:40:42Z")

</div>

Hi @shanegothman  
Unfortunately, I don’t have an update about this, but we already have an open ticket for handling better duplicated partner\_line\_item\_id.  
I will raise the priority for this and will let you know as soon as I there is any update.  
I appreciate your patience in this.  
Thanks! Tom

---

<div class="post-metadata">

**Author:** ![shanegothman](https://avatars.discourse-cdn.com/v4/letter/s/71e660/32.png) [@shanegothman](https://community.shiphero.com/u/shanegothman)\
**Post date:** [March 30, 2020, 6:33pm UTC](https://community.shiphero.com/t/netsuite-shiphero-integration-issues/405/10 "2020-03-30T18:33:32Z")

</div>

Hi Tom,

Thank you! It is definitely a high priority for us so we appreciate you escalating it.

Best,

Shane

---

<div class="post-metadata">

**Author:** ![andrewmazzotta](https://avatars.discourse-cdn.com/v4/letter/a/4491bb/32.png) [@andrewmazzotta](https://community.shiphero.com/u/andrewmazzotta)\
**Post date:** [May 22, 2020, 1:48pm UTC](https://community.shiphero.com/t/netsuite-shiphero-integration-issues/405/11 "2020-05-22T13:48:58Z")

</div>

Morning @shanegothman @tomasw,

We are also are using ShipHero, NetSuite, Shopify, and FarApp. Is there a company name you could share who knows how to integrate ShipHero and NetSuite inventory management. We have Shopify sales going through FarApp to NetSuite and just added a new warehouse that uses ShipHero. (So we are in need of having ShipHero and NetSuite understanding quantity of product on hand among each other.)

Looking forward to feedback and following up with improvements we come across for everyone’s future benefit.

Thanks!

Andrew

---

<div class="post-metadata">

**Author:** ![shanegothman](https://avatars.discourse-cdn.com/v4/letter/s/71e660/32.png) [@shanegothman](https://community.shiphero.com/u/shanegothman)\
**Post date:** [May 22, 2020, 2:07pm UTC](https://community.shiphero.com/t/netsuite-shiphero-integration-issues/405/12 "2020-05-22T14:07:08Z")

</div>

Hi Andrew,

I handled the integration on the accounting & operational side for my company, William Murray Golf. I can help answer any questions you may have, if you would like to set up a quick call or shoot me an email with questions.

Just let me know how I can help!

Shane

---

<div class="post-metadata">

**Author:** ![andrewmazzotta](https://avatars.discourse-cdn.com/v4/letter/a/4491bb/32.png) [@andrewmazzotta](https://community.shiphero.com/u/andrewmazzotta)\
**Post date:** [May 22, 2020, 3:12pm UTC](https://community.shiphero.com/t/netsuite-shiphero-integration-issues/405/13 "2020-05-22T15:12:34Z")

</div>

Hi Shane,

Appreciate the reply! If I send an email to [help@williammurraygolf.com](mailto:help@williammurraygolf.com) will I get you by chance?

Thanks!

Andrew

---

<div class="post-metadata">

**Author:** ![shanegothman](https://avatars.discourse-cdn.com/v4/letter/s/71e660/32.png) [@shanegothman](https://community.shiphero.com/u/shanegothman)\
**Post date:** [May 22, 2020, 3:48pm UTC](https://community.shiphero.com/t/netsuite-shiphero-integration-issues/405/14 "2020-05-22T15:48:40Z")

</div>

Hi Andrew,

Nope, do you mind sending it to [accounting@williammurraygolf.com](mailto:accounting@williammurraygolf.com)?

Thanks!  
Shane
