Sync item fulfillments from NetSuite to Shopify

Items fulfilled in NetSuite are exported to Shopify in batch flows and can be configured to transfer data in scheduled intervals. The flow also syncs the item fulfillment that includes digital items in an order. The NetSuite fulfillment to Shopify fulfillment (add) flow can run from every 15 minutes to once every week. You can check the status of the export in the integrator.io dashboard. 

NetSuite Saved Search to sync item fulfillments: Select the desired 'saved search' from the list. Click 'Refresh' to fetch the latest records from NetSuite.

To sync multiple tracking numbers with Shopify, enable the GraphQL flow.

Example: A single Shopify order may contain three separate fulfillments. After the order is synced to NetSuite, you’ll need to assign tracking numbers to each fulfillment. These tracking numbers from the corresponding NetSuite shipments can then be synced back to their respective fulfillment records in Shopify.

GraphQL flow

Understand the flow

In the NetSuite fulfillment to Shopify fulfillment (add) flow, the Get order fulfillment from NetSuite export retrieves new item fulfillments created in NetSuite since the last flow run. The Get fulfillment order info from Shopify lookup fetches corresponding fulfillment order details from Shopify based on the order data received from NetSuite.

The Update fulfillment order location import step ensures the correct location is set for the Shopify fulfillment order, aligning it with any changes in the fulfillment location in NetSuite. The Get updated fulfillment order info from Shopify lookup then revalidates the updated fulfillment order to ensure it’s ready for fulfillment.

Finally, the Post order fulfillment to Shopify import, posts the fulfillment details to Shopify. The flow tracks the total number of fulfillments processed and displays this count on the integrator.io Dashboard.

The flow exports only the data that has not been previously exported. If the flow encounters any issues while creating the fulfillment in Shopify, an error message is displayed on the integrator.io Dashboard to help identify and resolve the issue.

Key benefits

To take full advantage of Shopify’s latest and upcoming features, we recommend migrating to the new GraphQL flow as early as possible. This will ensure compatibility with future enhancements and provide a more reliable and flexible fulfillment process.

Limitation: The flow supports up to 250 fulfillment orders per Shopify order. However, it does not support scenarios where a single line item is included in multiple fulfillment orders, as this typically results from manual splitting in Shopify and is not considered a valid business use case.

Support Split Shipping (Cart)

Shopify has introduced a Split Cart feature that allows buyers to choose different delivery methods for different items in the same order. This results in multiple fulfillment orders being generated, even if all items are fulfilled from the same location. The Shopify-NetSuite integration app supports this capability using the new GraphQLNetSuite fulfillment to Shopify fulfillment (add) flow.

Understand Split Cart

Split Cart allows Shopify merchants to:

For example, a customer may select Expedited Shipping for one item and Standard Shipping for another, creating separate fulfillment orders in Shopify.

Understand how GraphQL flow supports Split Cart

The GraphQL-based NetSuite fulfillment to Shopify fulfillment (add) flow now automatically handles:

The flow ensures that each line item is correctly fulfilled in NetSuite and updated back to Shopify, avoiding partial fulfillments and manual intervention.

Prerequisites

To take advantage of Split Cart support:

If you're already using the GraphQL flow, no additional setup is required. Fulfillment records from NetSuite will be matched to the appropriate Shopify fulfillment order based on the selected delivery method and shipping profile.

REST flow

Understand the flow

In the [Deprecated] NetSuite fulfillment to Shopify fulfillment (add) flow, the Get order fulfillment from NetSuite export retrieves new item fulfillments created in NetSuite since the last successful flow run. The flow then uses the Get order fulfillment order info from Shopify lookup to fetch the corresponding fulfillment order details from Shopify, using identifiers such as the Shopify order ID.

Next, the Update fulfillment order location import updates the location on the Shopify fulfillment order to match the fulfillment location used in NetSuite. This ensures the fulfillment order in Shopify is correctly aligned with NetSuite’s data and ready for processing.

Finally, the Post order fulfillment to Shopify import sends the fulfillment details to Shopify, marking the order as fulfilled. The flow displays the number of processed fulfillments on the integrator.io Dashboard. 

The flow exports only the data that has not been previously exported, and if the flow fails to post a fulfillment to Shopify, an error message will appear on the integrator.io Dashboard to assist with troubleshooting.

Run the flow

You can see the flow status in the integrator.io Dashboard. On a successful sync, for every record, the success count of the flow, including the import and export, is shown as 1.