Assign status details to Shopify inventory

You can assign inventory status for a line item that has different statuses. To assign inventory detail, you have to configure sub-record mappings to the following flows:

• Shopify order to NetSuite cash sale (add)
• Shopify order to NetSuite order (cash sale or sales order)
• Shopify refund to NetSuite refund (add)
• Shopify fulfillment to NetSuite item fulfillment

Before you create a sub-record mapping in your Integration App, enable the Inventory Status setting (Setup > Company > Enable Features > Items & Inventory tab > Inventory sub-tab) in your NetSuite account. 

Configure the sub-record mapping

1. Login to your integrator.io account.
2. Click on the Shopify-NetSuite Integration App tile.

Shopify order to NetSuite cash sale (add)

1. Go to Flows > Order.
2. Click on the Shopify order to NetSuite cash sale (add) flow to navigate to the “flow builder” page.
3.  Below "netsuite-cashsale-orders-webhook-import-adaptor", click Import.
4. Configure import settings:
   1. On the “Edit Import” window, below “How would you like the data imported?” field, click +Add subrecord.
   2. On the “Add subrecord import” window, from “Which Cash Sale field should this subrecord set? ” drop-down list, select Items: Inventory Details.
   3. In the “Path to node that contains item data” option, select the appropriate “line_items”.
   4. Click Save on the “Add subrecord import” window.
   5. Click Save on the “Edit Import” window.
5. Configure field mappings:
   1. On the flow builder page, below “netsuite-cashsale-orders-webhook-import-adaptor,” next to the Import icon, click on the Field Mappings icon.
   2. On the "Please select which mapping you would like to edit" window, click netsuite-cashsale-orders-webhook-import-adaptor - Items: Inventory Details (Subrecord)
   3. On the “Define Import-Mapping” window, new fields are added to the Import Field (NetSuite) list. You can configure these fields as per your business needs.
      

      Export Field (HTTP)	Import Field (NetSuite)
      Select the default status which we want to assign it to the line items	Inventory Detail : Status (InternalId)
      Select the “Quantity”	Inventory Detail : Quantity
      “true”	Inventory Detail : Replace All Lines

Shopify order to NetSuite order (cash sale or sales order)

1. Go to Flows > Order.
2. Click on the Shopify order to NetSuite order (cash sale or sales order) flow to navigate to the “flow builder” page. 
3.  Below "netsuite-orders-webhook-import-adaptor", click Import.
4. Configure import settings:
   1. On the “Edit Import” window, below “How would you like the data imported?” field, click +Add subrecord.
   2. On the “Add subrecord import” window, from “Which Sales Order field should this subrecord set? ” drop-down list, select Items: Inventory Details.
   3. In the “Path to node that contains item data” option, select the appropriate “line_items”.
   4. Click Save on the “Add subrecord import” window.
   5. Click Save on the “Edit Import” window.
5. Configure field mappings:
   1. On the flow builder page, below “netsuite-orders-webhook-import-adaptor,” next to the Import icon, click on the Field Mappings icon.
   2. On the "Please select which mapping you would like to edit" window, click netsuite-orders-webhook-import-adaptor - Items: Inventory Details (Subrecord)
   3. On the “Define Import-Mapping” window, new fields are added to the Import Field (NetSuite) list. You can configure these fields as per your business needs.
      

      Export Field (HTTP)	Import Field (NetSuite)
      Select the default status which we want to assign it to the line items	Inventory Detail : Status (InternalId)
      Select the “Quantity”	Inventory Detail : Quantity
      “true”	Inventory Detail : Replace All Lines

Shopify refund to NetSuite refund (add)

1. Go to Flows > Refund.
2. Click on the Shopify refund to NetSuite refund (add) flow to navigate to the “flow builder” page. 
3.  Below "NetSuite Refund Order Import Adaptor", click Import.
4. Configure import settings:
   1. On the “Edit Import” window, below “How would you like the data imported?” field, click +Add subrecord.
   2. On the “Add subrecord import” window, from “Which Refund field should this subrecord set? ” drop-down list, select Items: Inventory Details.
   3. In the “Path to node that contains item data” option, select the appropriate “refund_line_items”.
   4. Click Save on the “Add subrecord import” window.
   5. Click Save on the “Edit Import” window.
5. Configure field mappings:
   1. On the flow builder page, below “NetSuite Refund Order Import Adaptor” next to the Import icon, click on the Field Mappings icon.
   2. On the "Please select which mapping you would like to edit" window, click NetSuite Refund Order Import Adaptor - Items: Inventory Details (Subrecord)
   3. On the “Define Import-Mapping” window, new fields are added to the Import Field (NetSuite) list. You can configure these fields as per your business needs.
      

      Export Field (HTTP)	Import Field (NetSuite)
      Select the default status which we want to assign it to the line items	Inventory Detail : Status (InternalId)
      Select the “Quantity”	Inventory Detail : Quantity
      “true”	Inventory Detail : Replace All Lines