Articles in this section

Error: Unable to export matrix item to Shopify

Saikumar Rachamalla
Updated

Data flow: NetSuite matrix item to Shopify product (add or update)

Error code: shopify_matrix_item_export_error

Error message: “Unable to export the matrix item #$##$ because the linked matrix children items might not have one of the following required criteria details: \n– Variation Theme and Variation Options \n– eTail Channel, Shopify Store \n– eTail Shopify Item ID map\n For more information, see Sync matrix items from NetSuite to Shopify.

Reason: The flow displays an error if any of the specified settings or criteria are omitted or not met during matrix item configuration. If you've already verified that all required fields are present in both the parent matrix item and its child matrix items and the error still appears, the issue is likely a desynchronized saved search, and not a missing item configuration.

Resolution: Ensure that the following settings are in place while configuring a matrix item within the Shopify-NetSuite app.

Important: 

  • If all required criteria are already met for both the parent and child matrix items, but the error still appears, first make sure that the saved search is correctly synchronized with integrator.io.
  • Don't update the saved search manually through the export bubble. Instead, go to Shopify-NetSuite integration app > Settings > Product > Saved Search settings on integrator.io and make any edits, updates, or re-selections from there.
  • Skipping this step may cause the flow to use outdated or unsynced search results, leading to false errors, even when the item configuration is correct.

 

Parent item configuration

  1. In NetSuite, create either an inventory item or a non-inventory item.

  2. Under the eTail tab, check the IS VIRTUAL PARENT and IS VIRTUAL Variation checkboxes.
     

  3. Select the Etail channel as Shopify.

  4. Under the Shopify tab, enable the variation theme, stores, and product visibility.
     

  5. Under the Matrix tab, select the associated variation theme option.

  6. Refer to the variation theme configuration.

Note: The matrix tab has the following fields: Name and Field ID. To check the Field ID, click on the field name. If you are unable to see the ID, go to Settings > Set Preferences > SHOW INTERNAL IDs.

Child item configuration

  1. In NetSuite, create either an inventory item or a non-inventory item.

  2. Under the Primary information tab, fill in the SUBITEM OF by mapping the name of the primary item.

  3. Under the eTail Tab, only enable the IS VIRTUAL Variation checkbox. 
     

  4. Select the Etail channel as Shopify.
  5. Under the Shopify tab, select the variation theme, stores, and product visibility as shown in the following screenshot.

  6. Under the Matrix tab, select the associated variation theme option.

     Note: Ensure that the variation theme selected for both the parent and child items is the same.

  7. Ensure that you follow the NetSuite saved search criteria as detailed below; refer to the screenshot for guidance.
     

    The following screenshot displays the Results criteria:

    In case you are using images, include the following criteria:

  8. In the Shopify - NetSuite app, go to Settings > Product > check the Enable virtual variations checkbox.
     

By following the steps outlined above and configuring the settings accordingly, the results should match those displayed in the provided screenshot.

 

Mandatory 'saved search' columns

Before troubleshooting further, confirm that the 'saved search' used to sync matrix items in NetSuite includes these result columns. If any of them is missing or has been altered, the export fails with the same error even when the parent and child item configuration is correct:

  • Price Level
  • Price Currency
  • Is Virtual Variations

Verify the 'saved search' columns

Make sure you always edit and update from Settings > Product > Saved Search settings, as this keeps the saved search synchronized with the integration app settings and ensures the flow uses the latest results.

Resync the saved search

If all required fields and saved search columns are present on the parent and child items but the error persists, resync the saved search using one of the following options.

Option 1: Reselect the existing saved search

  1. In the Shopify-NetSuite integration app, go to Settings > Product.
  2. Locate the saved search setting used to sync matrix items, such as the NetSuite saved search to sync matrix items.
  3. Reselect the existing saved search and save the settings.
  4. Re-run the export.

Option 2: Use a new saved search

  1. In NetSuite, create a saved search using the same criteria as the existing matrix item export search, such as Type, eTail Channel, Shopify Stores, Is Virtual Variation, and Sub-Item Of. Ensure the search includes all required result columns.
  2. In the Shopify-NetSuite integration app, go to Settings > Product.
  3. Select the new saved search in the matrix item sync setting and save the changes.
  4. Re-run the export.

Related articles