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.
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.
Related Topics
Comments
3 comments
Question on that last part there in sorting an item matrix. NS will alphabetize size, but as you can imagine, typically size is S, M, L, and XL. Because NS alphabetizes, when it gets imported into Shopify, I end up with L, M, S and XL. Is there a way for NS to not do that? I get that I could follow the instructions laid out above for sorting, but that seems like an awful lot of work for which a simpler solution exists. Moreover, fixing it through the UI could be done but would be inefficient. Thanks.
Hi Hosea Chang,
Just wanted to let you know that we're looking into this and will let you know as soon as possible if there's a workaround for this. Thanks!
Is there a way to force the NetSuite matrix item to Shopify product (add or update) flow to work off of the last change on a matrix child item?
We frequently make in-line edits to matrix children (for instance, changing ETA's on OOS products, or pricing imports that usually do not include a parent item). I have had to remind our staff to go update the parent item – even if there is no change, just hit edit/save – just to get the child items' changes picked up by my scheduled flow.
Please sign in to leave a comment.