NetSuite > Shopify - order 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 NetSuite query retrieves orders that have been fulfilled in the last day, with sales order number, PO number, shipping details, tracking numbers, and status (sorted by most recent first). Next, anything that is not in a shipped state is removed before data is cached.

We then retrieve and cache required details from Shopify, and the final cache is pushed to Shopify (sending fulfilment IDs and tracking numbers).

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.
Fulfillment cancellations in Shopify	This flow will fail if an order has been fulfilled and then the fulfillment is subsequently cancelled in Shopify.

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

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 SuiteQL query on the NetSuite connector retrieves fulfillment (shipment) records, together with related sales order and shipping details, for the past day. As such, we recommend running this on a daily schedule, or manually.
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 (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 order by ID by name via graphql` `Variables` : Leave the `Order Name` variable as it defaults.
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 order for fulfillment via graphql` `Variables` : Leave the `Order ID` variable as it defaults.
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 Fulfill orders via graphql` `Variables` : Leave the `Fulfilment Order ID` and `Tracking Number` variables as the defaults.

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

This process flow does not use scripts.

Cross-reference lookups in this process flow

This process flow does not use cross-reference lookups.