Gift Card not added on Shopify to NetSuite Request

Integration Apps
, ,
1

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

Any idea on what is missing?

Thanks.

2

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

3

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).