NetSuite Matrix Items are exported as Product variations in Shopify. The parent Matrix item is exported as Shopify Product while the child Matrix items are exported as variations for the same product in Shopify. The data flow supports Inventory matrix items and Assembly matrix items (Simple, Lot Numbered, Serialized) and also supports exporting the same NetSuite Matrix item to multiple Shopify stores.
Video Overview of Matrix Item Export
Prerequisites for Matrix Item Export
As a part of the configuration for this data flow, the following prerequisites must be set up. In NetSuite, two Saved search records must be set up as shown:
- Celigo Shopify Item Export [Store name] Saved Search
- Celigo Shopify Matrix Item Export [Store name] Saved Search
In the Celigo Shopify Item Export [Store name] Saved Search, in the Criteria subsection, ensure that the:
- Matrix item is set to False
- Matrix child item is set to False
- Pricing level is set up
In the Celigo Shopify Matrix Item Export [Store name] Saved Search, in the Criteria subsection, ensure that the:
- Matrix item is set to True
- Pricing level is set up
Creating Shopify Variation Themes
Shopify only allows three options at the maximum to create a Variation Theme. You need to provide the Option Name (Shopify Option Label) & Option Id (NetSuite Matrix Option Field Internal Id).
In NetSuite, create a matrix item. The variation theme is available in the eTail subsection section.
On the next page, provide a name for the Variation Theme. This could be any label, for example, Color, Size, Length or Width. Inside the Variation Option 1, Variation Option 2, provide values for the option name & field id.
Option (Name) would be the value that would be displayed on Shopify Item as an Option, for example, Color, Size, Length, Width etc.
Option (Field Id) would be the internal id of the NetSuite matrix option field from which the Integration App would read the values for these options. For example, if a NetSuite Matrix Option field "Color" (internal id: custitem_color) is set up to include all the option values for color, then you need to provide the value of this field as custitem_color.
You can setup as many variation themes as you would like for your products and once a variation theme is created, you can assign the same one on as many products as you would like.
Select a Variation Theme on NetSuite Matrix Item
Create a NetSuite Matrix Item. Provide the variation details (like Size, Color) on the Matrix Options fields as usual. Once you are ready to export this item to Shopify, you need to set the eTail Channel to "Shopify". Select the required "Shopify Stores" & then you must choose a value for the "Shopify Variation Theme" on the Matrix Parent Item. See the above section on how to create a variation theme.
Running the Data flow
From the integrator.io Settings page, navigate to the Product section and click the Run icon for the flow NetSuite Matrix item to Shopify Product Add/Update.
The integrator dashboard displays the job status. The flow completes in few seconds.
The matrix items are now visible in the Shopify store.
Click on the product to view the matrix item details.