Sync matrix items from NetSuite to Shopify

Gogula R Bhavana
  • Updated

Contents

The NetSuite matrix items are synced as product variations to Shopify. The parent matrix item is exported as a Shopify product and 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.

Before you run the flow, configure NetSuite saved search

  • In NetSuite, ensure that two saved search records are 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 following are met. If the child item is not included or does not meet the saved search criteria, it will be removed from Shopify:
    • The matrix item is set to False
    • The matrix child item is set to False
    • The pricing level is set up
  • In the Celigo Shopify Matrix Item Export [Store name] Saved Search, in the Criteria subsection, ensure that the following are met. If the child item does not meet the saved search criteria, it will be removed from Shopify:
    • The matrix item is set to True
    • The pricing level is set up

Create a variation theme in NetSuite

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 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 set up as many variation themes as you would like for your products and once a variation theme is created, you can assign the same one to as many products as you would like.

Select a variation theme on the NetSuite matrix item

Create a NetSuite Matrix Item. Provide the variation details (like Size and 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.

Run the "NetSuite matrix item to Shopify product (add or update)" flow

  1. Log in to your integrator.io account.
  2. Click Shopify - NetSuite.
  3. Go to Flows > Product.
  4. Next to the NetSuite matrix item to Shopify product (add or update) flow, use the toggle button (On/Off) to enable the flow. 
  5. On the Confirm enable pane, click Enable.
  6. Run the flow. The integrator.io dashboard displays the job status. The flow completes in a few seconds.

Understand the matrix item record in Shopify

The matrix items are now visible in the Shopify store.

Click on the product to view the matrix item details.

 

Related Topics

Related articles

Comments

6 comments

Date Votes
  • Hosea Chang

    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.

    0
  • Courtney Jordan Experience Strategy & Design Director Community moderator
    Celigo University Level 4: Legendary
    Awesome Follow-up
    Top Contributor

    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!

    0
  • Mike Meyer

    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.

    0
  • Dipali Mose

    i am getting below error

    Unable to export the matrix item #18065because the linked matrix children items might not have one of the following required criteria details: - Variation Theme and Variation Options - eTail Channel, Shopify Store - eTail Shopify Item ID map For more information

    however all settings for parent and child items are correct

    0
  • Tavano Team

    same here!

    0
  • Nilesh Kumar Senior Product Manager
    • Edited
    Celigo University Level 4: Legendary
    Engaged

    Hi Dipali / Tavano,

    Thanks for reaching out.

    The issue is mostly related to missing fields in items or incorrectly set Items. As the reason can vary on a case to case basis we request you to raise a support ticket with enough information so that our team can assist you to resolve the issue. To learn more about how to raise a support ticket, see here.  Thanks!

    0

Please sign in to leave a comment.