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 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 connector 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 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.
FAQ
1. How to sort items (matrix/variation) in in Shopify?
Answer: You can now create a custom item field to sort matrix items or items with variations in ascending order in Shopify. You can then use the custom item field to specify the item position. For example, if you have 5 matrix items, in the custom item field you can specify the position (1 through 5) for each matrix item. Generally, in the order in which you want the items to appear in Shopify.
To sort the items (matrix/variation) in Shopify in ascending order:
1. In NetSuite, go to Customization > Lists, Records, & Fields > Item Fields > New to create a new custom item field. The custom item field can only be used for a matrix item or virtual variation item and the item should be an Inventory item.
2. Add the custom field to the Celigo Shopify Matrix Item Export Saved Search.
3. Update mappings of the NetSuite Matrix Item to Shopify Product Add/Update flow to include the custom field you just created.
- If you change the Shopify Store name, the Shopify—NetSuite connector automatically changes the store name in NetSuite Saved Searches and Flow Names in integrator.io.
Note: Only the default components (flows and Saved Searches) that came with the connector will get modified. Any customized component will require manual modification.
Related Topics
Comments
2 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!
Please sign in to leave a comment.