Configure and run the flows in Shopify – NetSuite quickstart integration template

Shopify fulfillments to NetSuite item shipments

This flow syncs Shopify fulfillments as NetSuite item shipments on a scheduled basis. When orders are added in Shopify with shipped status, this integration flow exports these orders from Shopify to NetSuite item shipments.

Flow details

• Export source: Shopify
• Built-in export: Get Shopify fulfillments - get all shipped status orders from Shopify that have been modified since this flow last ran.
• Import destination: NetSuite
• Built-in import: Import NetSuite item shipments - add/ignore item shipments into NetSuite with Ref.No as the lookup identifier.

Before you begin

• The Shopify orders should also be present as NetSuite sales orders with pending fulfillment status.

Setup instructions

1. Configure the following mapping according to your business requirements in Import NetSuite item shipments, before running the flow.
   
2. Configure the following dynamic mapping according to your business requirements in Import NetSuite item shipments, before running the flow.
   

Shopify manual fulfillments to NetSuite item shipments

This flow syncs Shopify fulfillments as NetSuite item shipments on a real-time basis. When fulfillments (fulfilled service as manual) are added in Shopify, this integration flow exports these fulfillments from Shopify to NetSuite item shipments.

Flow details

• Export source: Shopify
• Built-in listener: Get Shopify manual fulfillments - get all order fulfillments with fulfilled service as manual from Shopify.
• Import destination: NetSuite
• Built-in import: Import NetSuite item shipments - add/ignore item shipments into NetSuite with Ref.No as the lookup identifier.

Before you begin

• The Shopify orders and NetSuite sales orders must be in sync.
• The items present in Shopify should also be present in NetSuite.
• The Shopify products SKU and NetSuite inventory items name/number should be the same. 

Setup instructions

1. Create a webhook on Shopify fulfillment creation.
2. Configure the following mapping according to your business requirements in Import NetSuite item shipments, before running the flow.
   
3. Configure the following dynamic mapping according to your business requirements in Import NetSuite item shipments, before running the flow.
   
   Create a webhook in Shopify for fulfillment creation

   1. Log in to your Shopify admin account.
   2. Navigate to Settings > Notifications > Webhooks.
   3. Click Create webhook. The Add webhook window appears.
   4. From the Event dropdown list, select Fulfillment creation.
   5. From the Format dropdown list, select JSON. 
   6. In the URL field, add the Public URL.
   7. From the Webhook API version dropdown list, select the required version.
   8. Click Save.

   Shopify refunds to NetSuite cash refunds or credit memos

   This flow syncs Shopify refunds as NetSuite cash refund or credit memo on a scheduled basis. When refunded orders or partially refunded orders are added/modified in Shopify, this integration flow exports refunded and partially refunded orders from Shopify to NetSuite cash refunds or credit memos 

   Flow details

   • Export source: Shopify
   • Built-in export: Get Shopify refunds - get all refunded and partially refunded status orders from Shopify that have been created since this flow last ran.
   • Import destination: NetSuite
   • Built-in import: Import NetSuite customers - add/ignore customers into NetSuite with email as the lookup identifier.
   • Built-in import: Import NetSuite cash refunds - add/ignore cash refunds into NetSuite.
   • Built-in import: Import NetSuite credit memos - add/ignore credit memos into NetSuite.

   Before you begin

   • The Shopify items name and NetSuite item display name should be the same.

   Setup instructions

   1. Add subsidiary mapping according to your business requirements in Import NetSuite customers, before running the flow.
   2. Configure the following mapping according to your business requirements in Import NetSuite customers, before running the flow.
      
   3. Configure the following mapping according to your business requirements in Import NetSuite cash refunds, before running the flow.
      

   Shopify abandoned checkouts to NetSuite quotes

   This flow syncs Shopify abandoned checkouts as NetSuite quotes on a real-time basis. When abandoned checkouts are created in Shopify, this integration flow exports abandoned checkouts from Shopify to NetSuite quotes.

   Flow details

   • Export source: Shopify
   • Built-in listener: Get Shopify abandoned checkouts - get all abandoned checkouts from Shopify.
   • Import destination: NetSuite
   • Built-in import: Import NetSuite customers - add/update customers into NetSuite with ID or email as the lookup identifier.
   • Built-in import: Import NetSuite cash refunds - add/ignore quotes into NetSuite with the configured custom field as the lookup identifier.

   Before you begin

   • The Shopify products SKU and NetSuite inventory items name/number should be the same. 

   Setup instructions

   1. Create a webhook on Shopify abandoned checkout creation.
   2. Add subsidiary mapping according to your business requirements in Import NetSuite customers, before running the flow.
   3. Configure the following mapping according to your business requirements in Import NetSuite customers, before running the flow.

   

   Create a webhook in Shopify for abandoned checkout creation

   1. Log in to your Shopify admin account.
   2. Navigate to Settings > Notifications > Webhooks.
   3. Click Create webhook. The Add webhook window appears.
   4. From the Event dropdown list, select Abandoned checkout creation.
   5. From the Format dropdown list, select JSON. 
   6. In the URL field, add the Public URL.
   7. From the Webhook API version dropdown list, select the required version.
   8. Click Save.

   Shopify custom collections to NetSuite Shopify collections

   This flow syncs Shopify custom collections as NetSuite Shopify collections on a scheduled basis. When custom collections are added/modified in Shopify, this integration flow exports custom collections from Shopify to NetSuite Shopify collections (custom records).

   Flow details

   • Export source: Shopify
   • Built-in export: Get Shopify custom collections - get all custom collections from Shopify that have been modified since this flow last ran.
   • Import destination: NetSuite
   • Built-in import: Import NetSuite Shopify collections - add/ignore Shopify collections into NetSuite with the configured custom field as the lookup identifier.

   NetSuite items to Shopify products

   This flow syncs NetSuite items as Shopify products on a scheduled basis. When items are added/modified in NetSuite, this integration flow exports items from NetSuite to Shopify products.

   Flow details

   • Export source: NetSuite
   • Built-in export: Get NetSuite items - get all items from NetSuite that have been modified since this flow last ran.
   • Import destination: Shopify
   • Built-in import: Import Shopify products - add/update products into Shopify with the title as the lookup identifier.

   NetSuite item shipments to Shopify fulfillments

   This flow syncs NetSuite item shipments as Shopify fulfillments on a scheduled basis. When item shipments are added in NetSuite, this integration flow exports item shipments from NetSuite to Shopify.

   Flow details

   Exports

   • Source: NetSuite
   • Built-in export: Get NetSuite item shipments - get all item shipments from NetSuite that have been created since this flow last ran.
   • Built-in export: Get Shopify fulfillment orders by ID - get all fulfillment orders associated with the particular Shopify order id.

   Imports

   • Destination: Shopify
   • Built-in import: Import Shopify fulfillment order locations - update the assigned location of the fulfillment order.
   • Built-in import: Import Shopify fulfillments - add/ignore fulfillments into Shopify with the configured custom field as the lookup identifier.
   • Built-in import: Import NetSuite item shipment - update item shipments into NetSuite with internal ID as the lookup identifier.

   Before you begin

   • The Shopify orders should also be present as NetSuite sales orders with pending fulfillment status.

   NetSuite invoices to Shopify billings

   This flow syncs NetSuite invoices as Shopify billings on a scheduled basis. When invoices are created in NetSuite, this integration flow exports invoices from NetSuite to Shopify billings.

   Flow details

   • Export source: NetSuite
   • Built-in export: Get NetSuite invoices - get all invoices from NetSuite that have been created since this flow last ran.
   • Import destination: Shopify
   • Built-in import: Import Shopify billings - add/ignore payment transaction into Shopify order by order ID.

   Before you begin

   • The Shopify orders and NetSuite sales orders must be in sync.
   • The Shopify order ID must be stored as an Order # in the NetSuite sales order record type.

   Setup instructions

   1. Configure the following mapping according to your business requirements in Import Shopify billings, before running the flow.

   

   NetSuite customer refunds to Shopify refunds

   This flow syncs NetSuite customer refunds as Shopify refunds on a scheduled basis. When customer refunds are added/modified in NetSuite, this integration flow exports customer refunds from NetSuite to Shopify refunds.

   Flow details

   • Export source: NetSuite
   • Built-in export: Get NetSuite customer refunds - get all customer refunds from NetSuite that have been created since this flow last ran.
   • Import destination: Shopify
   • Built-in lookup: Get NetSuite return authorizations - syncs all return authorizations from NetSuite.
   • Built-in lookup: Get Shopify orders - syncs all orders from Shopify by ID.
   • Built-in lookup: Get Shopify transactions - syncs all transactions from Shopify by order ID.
   • Built-in import: Import Shopify refunds - add/ignore refunds into Shopify by order ID.

   Before you begin

   • The Shopify orders and NetSuite sales orders must be in sync and the Shopify order ID must be stored as an Order # in the NetSuite sales order record type.

   Setup instructions

   1. Configure the following mapping according to your business requirements in Import Shopify refunds, before running the flow.

   

   NetSuite promotions to Shopify gift cards

   This flow syncs NetSuite promotions as Shopify gift cards on a scheduled basis. When promotions are added/modified in NetSuite, this integration flow exports promotions from NetSuite to Shopify gift cards.

   Flow details

   • Export source: NetSuite
   • Built-in export: Get NetSuite promotions - get all promotions from NetSuite that have been created since this flow last ran.
   • Import destination: Shopify
   • Built-in import: Import Shopify gift cards - add/update gift cards into Shopify with the configured custom field as the lookup identifier.
   • Built-in import: Import NetSuite promotions - update promotions into NetSuite with the ID as the lookup identifier.

   NetSuite promotions to Shopify discounts

   This flow syncs NetSuite promotions as Shopify discounts on a scheduled basis. When promotions are added/modified in NetSuite, this integration flow exports promotions from NetSuite to Shopify discounts.

   Flow details

   • Export source: NetSuite
   • Built-in export: Get NetSuite promotions - get all promotions from NetSuite that have been created since this flow last ran.
   • Import destination: Shopify
   • Built-in import: Import Shopify price rules - add/update price rules into Shopify with ID as the lookup identifier.
   • Built-in import: Import Shopify discount codes - add/update discount codes into Shopify with ID as the lookup identifier.
   • Built-in import: Import NetSuite promotions - update promotions into NetSuite with internal ID as the lookup identifier.

   Setup instructions

   1. Configure the following mapping according to your business requirements in Import Shopify price rules, before running the flow.

   

   NetSuite items to Shopify collects

   This flow syncs NetSuite items as Shopify collects. When items are added/modified in NetSuite, this integration flow exports items from NetSuite to Shopify collects.

   Flow details

   • Export source: NetSuite
   • Built-in export: Get NetSuite items - get all items from NetSuite that have been modified since this flow last ran.
   • Import destination: Shopify
   • Built-in import: Import Shopify collects - add/ignore collects into Shopify with collection ID as the lookup identifier.

   Before you begin

   • The Shopify custom collections and the NetSuite Shopify collection custom records must be in sync.
   • The Shopify product ID should be stored as a custom field in NetSuite items record type.