Shopify-Netsuite release notes v1.31.0, February 2020

What’s new

Sync Shopify edited order data to NetSuite sales order

You can now sync the Shopify edited order data to the NetSuite sales order. In Shopify for an order, you can add items, remove items, and adjust the item quantities. These Shopify edited orders can now be synced to NetSuite using the scheduled order flow (Shopify Order to NetSuite Order/CashSale Add) or using the on-demand functionality. Only the data of an order or a line item that is unfulfilled can be synced to the NetSuite sales order. 
To understand more about this feature, refer to Sync edited order data to NetSuite sales order.

Ability to support automatic discounts

The order import flows now allow you to sync the automatic discount (cart level or line level) from Shopify to NetSuite. The integration app can sync data related to the following Shopify automatic discounts:

• Percentage
• Fixed amount
• Buy X and get Y

To understand more about the automatic discount scenarios, refer here.

To understand more about the automatic discount feature on the Shopify side, refer here.

What’s enhanced

Add external ID for old customer accounts

The “external ID” is now added for all the old customer account flows, exports, and imports. The “external ID” helps to easily identify a particular resource and is useful to lock the mappings.

Purchase order mapping changes

For the “Shopify Order to NetSuite Order Add” flow, the “Export Field” value of the PO# mapping is changed from “order_number” to “name.”  The “order_number” mapping consists of just the order number. The “name” mapping consists of the “prefix + order number + suffix”. The prefix or suffix is added by the store admin. The mapping changes are useful for better order search in NetSuite.

Ability to create partial refunds for customer deposit

The “Shopify Refund to NetSuite Refund Add” flow now supports to create partial refunds. The customer refund records can now be created for a partially refunded amount. 

Create customer refund using the original payment method

You can now create customer refunds using the original payment method. To create a customer refund, there should be an associated customer deposit. If a refund is initiated in Shopify and if the corresponding sales order has a customer deposit associated with it, a customer refund is created against the customer deposit. 

Ensure to have the following mappings for the “Shopify Transaction to NetSuite Customer Deposit Add” flow to create customer refund using the original payment method:

Uninstall the integration app if the NetSuite connection is offline

You can now uninstall the Shopify Integration App even if the NetSuite sandbox connection is offline. The online connection check for the NetSuite sandbox connection is deleted.

What’s fixed

”Celigo Shopify Item Id Map” to be available for the matrix sub-items only for the selected Shopify stores

If you unselect a store on the matrix sub-item and try to update the matrix item, the ”Celigo Shopify Item Id Map” field should not be available for the deselected Shopify store. 

Example: If you create a matrix item with four matrix sub-items (S1, S2, S3, and S4) and select three stores. In this scenario, 12 records are created below the ”Celigo Shopify Item Id Map” for 4 matrix sub-items and one for each store. If you deselect a store for S1 and try to update the matrix item, below the ”Celigo Shopify Item Id Map” tab, for the S1 sub-item, only two lines should be available as the third store is deselected.

“ETAIL Order Item Type ID” field in NetSuite to display the correct value

If you try to import order (from Shopify to NetSuite):

• With an item having no SKU,
• A line-level discount applied, and
• An SKU value exists in the “NetSuite item to track order lines when no matching SKU is found in NetSuite” field,

the “ETAIL Order Item Type ID” field in NetSuite now displays only the correct value “Celigo_Discount_Line_<Etail Order Line ID>” in the sales order and refund records. 

Example: Celigo_Discount_Line_lineitemid. Here “lineitemid” is the <Etail Order Line ID>.

“NetSuite Refund Method” value to be saved in only the selected store

When you try to change the value in the “NetSuite Refund Method” setting in the Refund > Advanced Settings > Shopify to NetSuite tab, the updated value is now saved only in the current Integration App store instead of all the available stores added in the Integration App.

Order flow to consider the SKU value in the setting

When you run the “Shopify Order to NetSuite Order Add” flow and Shopify item does not have any SKU value, the flow now considers the value selected in the “NetSuite item to track Shopify order lines with no SKU value” setting.

Mapping changes for the “Payments are captured in” setting

To capture payments in NetSuite and mark the order as paid, the mappings are changed. In the Integrations Flows > Billing > Advanced Settings section, in the “Payments are captured in” setting, for the Netsuite after the order fulfillment value, the mappings are changed as below:

Import orders without variances for multiple base currency setup

When your setup has multiple base currencies, you can now import orders to NetSuite without any eTail order or eTail tax variances.