Change mapping from default customer to conditional mapping

Hello! We currently are setup to map all transactions from Shopify to one default Netsuite customer because we only had one platform using Shopify, our personal website. Now we have multiple platforms using Shopify (TikTok and our website).

I need to reconfigure our order import flow to map transactions for the TikTok channel in Shopify to a specific netsuite TikTok customer (call it internal id 12345) and then have all other channels map to the existing default custoemr (call it internal id 67890).

We had a third party originally setup the integration app so I am not sure what needs updated. I know we have “sync all orders against the default netsuite customer” box checked, I assume this needs unchecked. After that, where do I add the conditional mapping to go to one of two customers based on the above? Is that in the order flow mapping? Can someone help me with the fields/logic?

Thank you!

1 Like

Hi Kelly,

You’re right — if you want Shopify orders to route to different NetSuite customers depending on the sales channel, the first step is to uncheck “Sync all orders against the default NetSuite customer.”

From there, you’ll need to adjust the Shopify Order → NetSuite Sales Order Import flow:

  • If Customer Deposit is enabled in your integration, this will need to be configured on the Customer Lookup criteria so that the right customer record is selected for each channel.

  • If Customer Deposit is not enabled, then we can update your existing Import Mapping for the Entity (Customer) field to include conditional logic, for example:

    • If source_name = TikTok → map to NetSuite customer internal ID 12345

    • Else → map to NetSuite customer internal ID 67890

If you’re not sure which field carries the channel info, you can confirm by checking a TikTok order JSON in Shopify.

Please note — if we need to update your current mapping on our side, a support ticket will be required since we’ll also need your API token to proceed with the update. I recommend opening a ticket so we can guide you through the setup or apply the mapping directly for you.

Best regards,
Francis

1 Like