Shopify > NetSuite - sync locations

Introduction

The Shopify > NetSuite - sync locations flow retrieves all locations from Shopify, then runs a script to check if they exist in NetSuite. New locations are created (via the first branch), address details for existing locations are updated (via the second branch), and locations with missing information are processed by the third branch.

This blueprint includes two process flows to handle the sync of locations between Shopify and NetSuite - you only need to run ONE, depending on which way you want the sync to work:

Process flow snapshot

Click to view process flow snapshot

Limitations

Limitation
Summary

Shopify GraphQL error handling

There is a known limitation with error handling for Shopify GraphQL. Please refer to the Error handling for Shopify GraphQL section for more information and a suggested approach that you may wish to adopt in your flows.

Assumptions

The following cross-reference lookup tables must be updated before running this flow:

Please ensure that you have completed the necessary setup before proceeding.

Customisation

To ensure that this process flow runs as required, some customisation options are available. These are documented in the following sections:

Flow variables

This process flow does not use flow variables.

Process flow shapes

This process flow includes some shapes that can be configured with your own settings. Please see guidelines in the table below.

Shape
Notes

Trigger

No default schedule is defined. If you decide that you want to sync locations in this direction (rather than from NetSuite to Shopify), you may decide to add a schedule.

Notify

This flow is designed in a try/catch structure, so notifications are generated if any part of the flow fails. To achieve this, the catch route includes a notify shape, which must be configured for your own notification preferences. Alert level: Defaults to error but can be changed if needed Channel: Defaults to email + log but can be changed if needed Email Limit: Defaults to 5 but can be changed if needed Notification Group: Replace the notify placeholder which your required notification group. Message: If required, you can change the placeholder message. For more information, please refer to our Notify shape and Notification groups pages.

Connector (NetSuite) Branch: First

If you did not add or select a NetSuite instance during the blueprint installation process, the following settings must be configured: Source instance : Set to your required NetSuite instance. Source endpoint : Set to POST suiteQL

Query: Leave as the default

Connector (NetSuite) Branch: Second

If you did not add or select a Shopify instance during the blueprint installation process, the following settings must be configured: Source instance : Set to your required Shopify instance. Source endpoint : Set to POST Get all locations via graphql

Notify Branch: Missing information

Configure the notify shape for your own notification preferences in the event that locations have missing information. Alert level: Defaults to error but can be changed if needed Channel: Defaults to email + log but can be changed if needed Email Limit: Defaults to 5 but can be changed if needed Notification Group: Replace the notify placeholder which your required notification group.

Message: If required, you can change the placeholder message. For more information please refer to our Notify shape and Notification groups pages.

Reference

Reference information for this process flow is documented in the following sections:

Scripts in this process flow

Script
Summary

Shopify to NS - Determine new and updated locations

Compares shopify and netsuite locations and outputs those that are new those that to be updated.

Cross-reference lookups in this process flow

Cross-reference lookup
Summary

Shopify location > NetSuite location ID

Maps Shopify location names to NetSuite location IDs. You must update this cross-reference lookup table before running this flow. Please see our Installation & setup guide ➤ Stage 1: Patchworks setup.

Inventory true/false

Used for location creation in NetSuite. This cross-reference lookup is set as required and does not need to be changed.

Last updated

Was this helpful?