Shopify <> NetSuite IA - Data Available for Customer Lookup Criteria

Integration Apps
,
1

Hi,

We have a client implementing shopify markets and they have two NetSuite subsidiaries.

Currently, most of their customers are only valid in either their USA sub or their Canada sub.

I would like to be able to lookup the correct customer by utilizing the Shopify Order’s presentment currency field. This is how the Subsidiary will be determined for the order. However, as far as I know, the lookup is can only use the Customer object data, not order data.
Is there a way to work around this in the Order or Customer flows?

I realize the other option will be to make each customer able to order in both subsidiaries.
Thank you,

Dave G

2

Hi David,

At this time, the built-in Customer lookup criteria are limited to Customer object data, but a common and supported workaround is to use handlebar expressions directly within the Order to NetSuite mapping.

This approach allows you to reference order-level fields (like presentment currency) and map the subsidiary dynamically based on order data, rather than customer data like using handlebar logic to change subsidiary or customer mappings based on order-level conditions such as country code or source

Thank you,