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 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 & permanently hard link the item in NetSuite & Shopify for any future updates.
SettingsSettings page enables you to tweak the data before you run the flow (setting up the currency, price levels etc.)
- 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.
- Create Product Tags and Product Types in Shopify - NetSuite Integration App
- Mapping Additional Fields in Shopify - NetSuite Integration App
- How to map metafields at product level using the saved search
- How to map metafields at a variant level using the saved search
- Export Matrix Items from NetSuite to Shopify
- Image Export Using the Product Data Flows
It'd be very helpful to have an article/section in relation to using saved searches to export existing netsuite products in to shopify.
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.
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.
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.
Please sign in to leave a comment.