Shopify > NetSuite - fulfillments – Patchworks Support Portal

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

Introduction

This flow was designed on the basis that orders are typically fulfilled in NetSuite.

A Shopify GraphQL query retrieves fulfilled/partially fulfilled orders created after a given date, with a financial status of authorized, paid or pending. The lookback date is calculated by referencing a datefrom flow variable in the created_at section of the GraphQL query.

This data is then compared with NetSuite. If the order is not in a fulfilled state, the item fulfillment is pushed with a shipped status. Partial fulfillments are supported.

Limitations

Limitation	Summary
Carrier information in NetSuite.	Out of the box, NetSuite does not include a 'carrier' field in the `package` section of item fulfillments.

Assumptions

No assumptions noted for this flow.

Customisation

To ensure that this process flow runs as required, some customisation options are available. These are documented in the following sections:

Flow variables

The table below summarises flow variables defined for this process flow.

Flow variable	Summary	Default value
`datefrom`	Set the relative time period to look back for new fulfillments in Shopify. Update the default value as required.	-10 days

For information on working with flow variables, please refer to our flow variables documentation.

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 GraphQL query on the Shopify connector retrieves fulfillments/partial fulfillments that have been created since your given lookback period (based on the value of the `datefrom` flow variable). You should ensure that the trigger schedule aligns with your lookback period, or run this flow manually.
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 fulfilled orders via graphql` `Variables` : Leave the `Filter` 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`: Leave as the default
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 Createe fulfillment from SO` `Variables`: Leave `NetSuite Order ID` as the default

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
Determine what needs fulfilling	Checks the SKUs from Shopify to match the fulfillment lines needed for Netsuite.

Cross-reference lookups in this process flow

This process flow does not use cross-reference lookups.