I would like to be able to map the notify customer on a fulfilment to T/F based on some logic, rather than a simple hardcoded Yes/No such that Fulfilment Orders that require shipping have notify = True; and those that “do not require shipping” have notify = False.
Without this the customer gets 2 shipping notifications, first for the items that are truly shipped; then a second for the items on the order (eg service type items) that have been fulfilled but not physically shipped. This is confusing and not great customer experience.
I think the relevant data on the Shopify Fulfilment is the “Shipping Method” (delivery_method). On test orders this shows as “Shipping not required” for such items. I’ve tried to write a handlebar expressions but don’t think the data is being exposed in the flow?
Currently, in the standard Shopify–NetSuite integration app, the NetSuite Fulfillment → Shopify Fulfillment (Add) mapping only allows the notifyCustomer field to be set as a static True/False value. However, you can achieve the desired behavior by creating a saved search formula in NetSuite to determine which customers should be notified and which should not.
The issue is that there is more than one fulfilment created in Shopify (from one fulfilment in NetSuite) and Shopify creates separate fulfilment orders for the items that do not require shipping. I want to notify the customers about fulfilments UNLESS they are for Order Fulfilmetn sections that are classified by Shopify as “Does not require Shipping”.
I wish to avoid sending a notification that non-shipping items have been shipped Although I do need to marl them as fulfilled to close the order in Shopify.
Ideally I would add handlebar expression on the Notify setting in the flow but I cannot seem to access the field delivery_method
The NetSuite Fulfillment - Shopify Fulfillment (Add) flow reads data from the saved search, and it does not have access to the Shopify fulfillment JSON. This is why the delivery_method field cannot be accessed in the mapping. Because of this, any conditional logic for the Notify Customer value needs to be handled within the saved search.
One possible approach is to create a custom field on the Item Fulfillment form (for example, a checkbox or text field) that indicates whether the customer should be notified. If the custom field is checked or contains a value indicating that the order requires shipping, the saved search should return True for Notify Customer. If the field is unchecked or indicates that shipping is not required, the saved search should return False.
This way, when the flow retrieves the data from the saved search, it will follow the value returned by the formula and prevent sending a notification to the customer when it is set to False.
Sample saved search formula:
CASE WHEN {custbody_notify_customer} = 'T' THEN 'true' ELSE 'false' END
or
CASE WHEN {custbody_shipping_type} = 'Shipping not required' THEN 'false' ELSE 'true' END
Although I do need to marl them as fulfilled to close the order in Shopify.