I have virtual variations set up in NetSuite and configured in the NetSuite - Shopify IA.
I'm getting this error message from the Export step in the flow 'NetSuite matrix item to Shopify product (add or update)':
Unable to export the matrix item #26733because 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, see ...
However, all of the settings are correct on the parent and child variations in NS, and the flow is exporting the virtual variations and updating them in Shopify correctly. Any ideas on why I'm getting this error?
Hi @coryanderson, we request you 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!
Hi, I assume this was fixed for you, but I had the same issue today and was able to fix it.
I was filtering the matrix search using the parent netsuite id and seems Celigo needs the search to be filtrated using parent+child ids even though is showing only parent results. Once I added that it worked.
Hope it helps
That is not the issue - the flow should just export the parent. The JSCript hook carries out the retrieval of the child items within the Suitelet.
The error is nonsensical and does not actually tell you what the problem is. You can check all those listed fields and they are correctly set.
The issue is that the Saved Search that the flow uses is not actually the one in the Source step . . .
It's specified in the settings for the Product flow (not documented anywhere though . . .)
What seems to be happening is that the Saved Search becomes "de-synchronized" from the flow (i.e a bug) - perhaps from trying to edit it or change the search itself. So to fix this, you need to set to null each of the fields in the Settings > Product tab (Current, Price Level, Compare at Price, Virtual Variant) and save the settings. Then go to the saved search and delete all the settings except for Type and Inactive.
Then add them back in again, each time saving the settings and checking to see that it updates the flow with the criteria.
When all that's done, try running preview again and now the error should be gone.
Celigo should lock that Saved Search field in the Source Step and also stop this "desync" from happening.
Hi Guy, that doesnt sound like normal behavior with the saved searches. To clarify, you are saying you have to go into NS and rebuild (more or less) the saved search?
1 Like
When we ran into this it was related to the id mapping. When we save the parent it triggered the scripts and that would run before the children were fully updated.
So if a product had 10 children we would save the parent, it would immediately trigger the script, while the id map fields were still being created on the children the script would try to sync/flow. So maybe only 5 of 10 children had the id map field added by the time the script reached them. This would cause the above error.
And since the item map field was being created (just late), when we would go look at the children they all would have the necessary fields listed in that error.
Basically, the script for sync triggered on parent save, not when the children were finished saving/updating, and this causes errors when it looks for the id map field.
