Boomi Pricelist Sync Overview

#

Overview:

This document serves to elucidate the functionality of Boomi's stock synchronization and its associated properties. Its purpose is to provide a straightforward explanation of how the stock sync process operates, aiding all team members in understanding its mechanics and facilitating the investigation of any stock sync issues that may arise.

Within Boomi, we streamlined the procedure for synchronizing available prices of products thru bulk operations between Netsuite and Shopify. We established a property that allows us to specify each market through its corresponding fileid in Netsuite.

##

Dynamic Process Property: “fileid” and “DP\PriceID”

In addition to the these two, we configured Its token per market and Store Names that correspond with.

##

Sync\shopify\store\names – Shopify Store names

This information are set in Boomi and are vital part of this process. Boomi team has a separate document for each token Ids and being maintained and updated well.

##

Boomi Platform:

Branch 1: Retrieve the file from Netsuite and store it in the cache.

Branch 2: Retrieve necessary data from Shopify using GraphQL and commence a bulk operation to synchronize price adjustments and quantities. Prior to executing this, store the retrieved price list ID as a property, as it will be utilized in the "Subprocess: Update\prices”.

Continuation: Branch 2: "Subprocess: Update\prices”:

In this process flow, Boomi will consolidate all documents obtained from NetSuite on this branch and send 100 documents per execution. It will retrieve the `DPPriceListsID` set by Boomi from the "Sub\Process: Get\Pricelist\data\shopify\request," along with SKUs and prices obtained from NetSuite and document cache. Subsequently, it will update this information in Shopify.

Branch 3: Simply remove all cached files from Branch 1.

Good example of latest Pricelist sync between Netsuite and Shopify:

Under Shopify and its corresponding WRP: see product “Baby Beetanicals Bee Well Balm 50g – Baby 3months +”

In Netsuite:

Check for the product SKU and go to Sales / Pricing

Check and ensure that both Netsuite Value and Shopify price are synced.

This process can be found in Boomi Platform Component explorer: