Shopify > NetSuite - sync locations

To view this content in our official product documentation, click here.

Introduction

Locations must be synced between Shopify and NetSuite (otherwise the Shopify > NetSuite - sales order creation flow will fail).

This blueprint includes two process flows to handle this - you only need to run ONE, depending on which way you want the sync to work:

• Shopify > NetSuite - sync locations (this flow)
• NetSuite > Shopify - sync locations

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.

Limitations

No limitations to note.

Assumptions

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

• Shopify location > NetSuite location ID

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
• Process shape shapes

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.

{% hint style="warning" %} Shape settings determine the outcome of process flows. Do not change shape settings unless they are listed below. {% endhint %}

Shape	Notes
Trigger	The default setting is to run hourly, which is recommended. You can change the schedule if required.
Connector (NetSuite)	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 (Shopify)	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

Reference

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

• Operations count
• Scripts used in this process flow
• Cross-reference lookups used in this process flow

Operations count

The operations count for this process flow is: x per order.

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.