# Gift Card not added on Shopify to NetSuite Request

**URL:** <https://connective.celigo.com/t/gift-card-not-added-on-shopify-to-netsuite-request/665>\
**Category:** Integration Apps\
**Tags:** error-handling, shopify, netsuite\
**Created:** [September 2, 2022, 2:43pm UTC](https://connective.celigo.com/t/gift-card-not-added-on-shopify-to-netsuite-request/665 "2022-09-02T14:43:48Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![carolinaoxoby](https://avatars.discourse-cdn.com/v4/letter/c/ac91a4/32.png) [@carolinaoxoby](https://connective.celigo.com/u/carolinaoxoby)\
**Post date:** [September 2, 2022, 2:43pm UTC](https://connective.celigo.com/t/gift-card-not-added-on-shopify-to-netsuite-request/665/1 "2022-09-02T14:43:48Z")

</div>

I am testing in Shopify Sandbox the NetSuite - Shopify Order Sync with Gift Card but is showing an error "Unable to create the order in NetSuite for the Shopify order #4656836739135 Failed to save record because Please choose an item to add"

Reviewing the NetSuite request the Gift Card Item is not added, see below:

r.selectNewLineItem("item");  
r.setCurrentLineItemValue("item", "custcol\_replay\_bin\_number", null);  
r.setCurrentLineItemValue("item", "custcol\_replay\_item", null);  
r.setCurrentLineItemValue("item", "quantity", 1);  
r.setCurrentLineItemValue("item", "price", -1);  
r.setCurrentLineItemValue("item", "rate", 0);  
r.setCurrentLineItemValue("item", "custcol\_celigo\_etail\_itemtype\_id", "Celigo\_GiftCardItem");  
r.setCurrentLineItemText("item", "taxcode", "Shopify Avatax");  
r.setCurrentLineItemValue("item", "taxrate1", "0.0%");  
r.setCurrentLineItemValue("item", "description", null);  
r.setCurrentLineItemValue("item", "custcol\_replay\_item\_sku", null);  
r.commitLineItem("item");

The Gift Card is set under Setting-\> Order -\> Order

![5301043caa20740200000001-563552c3c0d1403ca6bd2de2092a5ada.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/optimized/2X/7/7bd370cca7fadf2c36fd0a8cfb00b2f070baa0d2_2_690x67.png)

Any idea on what is missing?

Thanks.

---

<div class="post-metadata">

**Author:** ![anithaabraham](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/anithaabraham/32/6964_2.png) [@anithaabraham](https://connective.celigo.com/u/anithaabraham)\
**Post date:** [September 9, 2022, 1:05pm UTC](https://connective.celigo.com/t/gift-card-not-added-on-shopify-to-netsuite-request/665/2 "2022-09-09T13:05:28Z")

</div>

@carolinaoxoby I've moved your post to the Shopify - NetSuite Integration App forum for better visibility.

---

<div class="post-metadata">

**Author:** ![jasoncraveiro](https://avatars.discourse-cdn.com/v4/letter/j/cab0a1/32.png) [@jasoncraveiro](https://connective.celigo.com/u/jasoncraveiro)\
**Post date:** [September 17, 2022, 12:14am UTC](https://connective.celigo.com/t/gift-card-not-added-on-shopify-to-netsuite-request/665/3 "2022-09-17T00:14:03Z")

</div>

That setting option you have populated with "Shopify Gift Card" is what's used to track the redemption of a gift certificate on an order, not the original sale of the gift certificate.

Don't have any experience using native Shopify Gift Certificates (we use Rise.ai), but you need to create the Gift Certificate Item in NetSuite that matches the item in Shopify (SKU, Variant ID, Product ID). Or alter your settings to give a generic NetSuite SKU for Celigo to post to when the item in Shopify isn't found in NetSuite ("Shopify Unknown Item" for example).