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 <a href= ‘https://docs.celigo.com/hc/en-us/articles/228223407’ target=’ _blank’>Export matrix items from NetSuite to Shopify</a>”

Reason: The flow displays an error if any of the specified settings or criteria are either omitted or not met during the configuration of the matrix item.

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

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.