Shopify > Brightpearl - sync all price lists

Introduction

The process flow retrieves all prices lists from Shopify, compares them Brightpearl, and makes required updates.

This blueprint includes two process flows to handle the sync of price lists between Shopify and Brightpearl: Shopify > Brightpearl (detailed here) and Brightpearl > Shopify. 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
Price list creation in Brightpearl	There is no dedicated API to create price lists in Brightpearl, so they must be created manually. This flow updates existing price lists, it does not create new ones.

Assumptions

Assumption	Summary
Sync direction	Running this flow assumes that you want to sync prices in this direction (i.e. from Shopify to Brightpearl). If required, a flow for the reverse direction is available (Brightpearl > Shopify push catalog & pricing). You should run one or the other.
Price list creation in Brightpearl	This flow assumes that required price lists have been created in Brightpearl.
Product cache	This flow assumes that the Brightpearl products cache is up to date.

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.

Shape settings determine the outcome of process flows. Do not change shape settings unless they are listed below.

Shape	Notes
Trigger	No default schedule is set. This flow is designed to be run manually, as required.
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 price lists and prices
Connector (Brightpearl)	If you did not add or select a Brightpearl instance during the blueprint installation process, the following settings must be configured: Source instance : Set to your required Brightpearl instance Source endpoint : Set to GET Get product prices Id : Set to [[payload.pid]].
Connector (Brightpearl)	If you did not add or select a Brightpearl instance during the blueprint installation process, the following settings must be configured: Source instance : Set to your required Brightpearl instance Source endpoint : Set to GET Get all price lists
Connector (Brightpearl)	If you did not add or select a Brightpearl instance during the blueprint installation process, the following settings must be configured: Source instance : Set to your required Brightpearl instance Source endpoint : Set to PUT Upate product price quantity 1 break Id : Set to [[meta.pid]].

Reference

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

• Scripts used in this process flow

• Cross-reference lookups used in this process flow

Scripts in this process flow

Script	Summary
Dedupe SKUs	De-dupes data retrieved from multiple price lists (based on SKUs) for optimal searching in Brightpearl.
Remove price lists not found in BP	Since Brightpearl does not support the creation of price lists, this script removes any prices lists retrieved from Shopify, if they do not exist in Brightpearl.

Cross-reference lookups in this process flow

This process flow does not use cross-reference lookups.