Shopify > NetSuite - sync all price lists – Patchworks Support Portal

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

Introduction

This flow pulls price lists and associated prices from Shopify, and removes duplicate items. We then retrieve items from NetSuite (using UPC codes).

Next, a script matches Shopify SKUs to NetSuite items, and inventory item price lists are updated.

{% hint style="warning" %} Catalog syncing is highly custom - every business has different product data structures, matching rules, and business logic. For example, Some businesses match on SKU, others on UPC code, or custom fields. This flow provides base functionality however, updates may be required to meet your own business needs. {% endhint %}

{% hint style="warning" %} This flow updates all prices for a product, so if a catalog is associated with multiple products, all of those product prices will be changed in NetSuite. {% endhint %}

Limitations

Limitation Summary

Shopify GraphQL for price lists

Shopify GraphQL for price lists does not have an updated at timestamp, therefore this flow needs to run manually, or on a daily schedule.

Catalogues

The general limitation of catalogs in NetSuite means that if a product price is updated in Shopify, that

same price level might be used by multiple catalogs in NetSuite. As such, NetSuite updates all products using that price level as 'changed'.

Price levels Currency page price level and quantity are hard coded and will need to be updated or developed further to handle multiple currencies.

Assumptions

This flow assumes that SKUs are stored in NetSuite's upccode field. If you use a different field to store this value, any connector queries, mappings and scripts referencing the upccode field must be updated. Please see the Customisation ➤ process flow shapes section for details.

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.

{% 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	This flow is designed to be run manually, or on a daily schedule.
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`
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 prices from price list` `Variables` : Leave the `Price List` variable as it defaults.
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`: SuiteQL compares SKUs to a value in NetSuite. This NetSuite connector is configured with a query that expects the comparison value in `upccode`. If you use a different field, please update the query accordingly.
Script	The `Match upc for price update` script expects NetSuite comparison values in `upccode`. Updates will be required if your system is configured differently.

Reference

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

Operations count

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

Scripts in this process flow

Script	Summary
Dedupe items	Extracts SKUs from items, removes duplicates. Returns a payload with SKUs in a formatted SQL parameter, to be consumed by the subsequent NetSuite query.
Match upc for price update	Matches Shopify product prices with NetSuite items (via `upccode`) and prepares a de-duplicated list for price updates.

Cross-reference lookups in this process flow

There are no cross-reference lookups to note for this flow.