The 'NetSuite Item to Shopify Product Add' data flow exports items in NetSuite as Products in Shopify every 15 mins. The Integration App exports basic Product Info (Description, Title, Product Type, Price) and other attributes.
The integration app supports the following Item Types: Inventory (Matrix & Non-Matrix), Assembly (Matrix & Non-Matrix), Kit Items, Matrix Item (Parent and Child Items)
The Integration App exports Parent Matrix Item as Shopify Product and links all the child items of the NetSuite Matrix Parent as variations to the Shopify Product. Matrix item data includes product options, in addition to standard item data. Kit items in NetSuite are exported as Simple Items in Shopify.
Items created in NetSuite are exported to Shopify in batch flows and can be configured to transfer data in scheduled intervals. The settings are configured in the integrator.io dashboard.
Screens Depicting the Data Flow
Create an item in NetSuite
Provide the details in the eTail section. Make sure you have selected the "eTail Channel" as "Shopify" and have also selected the store(s) in the "Shopify Stores" you would want to list this item on.
In Celigo Integrator.io, go to the Shopify - NetSuite Integration App tile and click 'Flows' to get to the data flow section. Under the 'Product' data flow, press the "Run" button for the "NetSuite Item to Shopify Product Add/Update" data flow to trigger the export.
The flow status is visible on the dashboard. The status changes from 'queued' to 'in progress' to 'completed' in a few seconds.
When the flow is successfully completed, verify that the item is exported to Shopify in the 'Products' section.
Click the Product to view the details as set up in NetSuite.
Next, the ‘Shopify Product ID to NetSuite Item Update’ data flow is triggered to import the Shopify Product ID and Shopify Variant ID back into NetSuite and permanently hard-link the item in NetSuite and Shopify for any future updates.
Settings
Settings page enables you to tweak the data before you run the flow (setting up the currency, price levels, etc.)
Important: Always update the Saved Search from the Settings rather than modifying it at the flow level. Updates made in Settings will reflect at the flow level, but changes made at the flow level may not update across all areas consistently.
-
NetSuite Saved Search for syncing Item details: Select the desired 'saved search' from the list. Click 'Refresh' to fetch the latest records from NetSuite.
-
NetSuite Saved Search for syncing Matrix Item details: Select the desired 'saved search' from the list. Click 'Refresh' to fetch the latest records from NetSuite.
-
NetSuite currency for syncing product price: Lets you choose the NetSuite currency to be used for exporting the price to Shopify.
-
NetSuite price level for syncing product price: Lets you choose the NetSuite price level to be used for exporting the price to Shopify.
-
NetSuite price level to sync compare at price: Lets you choose the NetSuite price level to be used for exporting the compare at price to Shopify.
-
Each product in Shopify has a unique title - Enable this checkbox to prevent the Integration App from creating two products with the same product title in Shopify.
-
Enable virtual variations - Enable this checkbox if either of the following statements is true. 1.In NetSuite, you have a group of Items (Non-Matrix Items) that have parent-child relationships and those items are to be configured as Matrix Items/Variations in Shopify. 2. In NetSuite, you have a group of Items/Matrix Items that are related to each other (based on Item Field value) and those items are to be configured as Matrix Items/Variations in Shopify.
-
NetSuite field identifier for variation parent item - Provide the internal id of the item field in NetSuite to be used to identify the variation parent item.
-
Add GST/VAT to item price - Enable this checkbox to add GST/VAT to the item price before it is added to Shopify.
- Specify your Shopify metafield components for products and variants: Configure this setting to sync product and variant metafields for simple and matrix items. For more information, see Sync product metafields for simple and matrix items.
-
Sync published scope from NetSuite to Shopify: Enable this checkbox to sync the published scope from NetSuite to Shopify. If this checkbox is not selected, the published scopes will not be updated to Shopify. To add a custom scope in NetSuite, go to eTail > Shopify tab > Shopify Product Visibility, click + to add custom scopes, and then save the changes.
Important:- Ensure that the scope name matches the corresponding name in Shopify.
- After enabling this setting, reauthorize the Shopify connection.
- Scope deletion is not supported.
- Scope updates are supported for products with fewer than 100 variants during the first sync.
- For products with more than 100 variants, the initial sync (Create scenario) will not include scope updates beyond the first 100 variants.
- However, in subsequent syncs (Update scenario), all scope details will sync correctly.
- Sync price lists per market from NetSuite to Shopify: This is a Shopify Markets edition feature. For details, see Shopify Markets edition of the Shopify - NetSuite integration app.
- Sync HS code and country of origin from NetSuite to Shopify: This is a Shopify Markets edition feature. For details, see Shopify Markets edition of the Shopify - NetSuite integration app.
Related Topics
Comments
Hi Diana,
Might want to add in that you need to tick 'Show in Webstore' on the item so it will appear in Shopify. They wont import even if they appear in the saved search that the flow will use.
It'd be very helpful to have an article/section in relation to using saved searches to export existing netsuite products in to shopify.
Is it possible to map multiple (2) fields to Shopify for Price? I would like to have sale items display their sale price and utilize Shopify "Compare at Price" feature.
Hi Gabe Parr, systems development, Benjamin Bartley,
Thank you so much for this feedback and I apologize for the late response! We'll get these updates made and Gabe, I'm checking on this question with the PM.
Would you please update this article for details re the new setting “Sync published scope from NetSuite to Shopify” and how that works?
What is the behaviour with and without this setting turned on? And if it is on - where do you define the scope you want to sync? And this be on create only, ie not update?
With the move to GraphQL we have lost the ability to set the status and published scope on create only which was critical to us. We currently set this as draft and unpublished as we want to enrich the product detail in Shopify before it goes live. The marketing team then manage this in Shopify so that published data is not available in NS (and many of the users do not have NS licences) I am therefore very keen to find a new solution
Please sign in to leave a comment.