Brightpearl - add products to cache for price lists

Introduction

This flow retrieves all existing products from Brightpearl and adds them to a company cache, ready for use in subsequent price list flows. The details below are stored for each product:

• Product id

• Price List ID

• SKU

• Shopify variant id

• Shopify parent ID

Process flow snapshot

Click to view process flow snapshot

Limitations

Limitation	Summary
Timing	It is intended that this flow is run daily. To ensure that current product information is stored, it's best to run this flow as soon as possible after the product creation flow - or when you're sure that that products are up to date in both systems. This product cache is required for the Shopify > Brightpearl - sync all price lists flow.
Product matching	Product matches are determined by SKU. A product is deemed 'new' if no exact match is found between Shopify and Brightpearl SKU values.

Assumptions

No assumptions to note.

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	The default schedule for this flow is to run daily at 01:00 AM. This is the recommended run frequency but the schedule can be changed if necessary. Note that the cache updated in this flow is required for the Shopify > Brightpearl - sync all price lists process flow.
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 Search products Parameter : Filter defined to retrieve only products where the stockTracked field is set to true. If you use a different field to flag required products, this filter can be adjusted. You can also add more filters, if needed.
Script	The BP product cache - Generate SKU query script searches on SKU field values. If you do not use the SKU field for product matching, this script should be adjusted.
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 variant IDs from SKU
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 product prices

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
Append to value json value	Takes the raw value from Brightpearl and assigns it a JSON field.
BP product cache - generate SKU query	For variant ID search in Shopify.
Merge variant ID into BP products	Merges Shopify data for caching.

Cross-reference lookups in this process flow

This process flow does not use cross-reference lookups.