search

dj-tkoizumi / boomi

0 stars 0 forks source link

MG to NS Error: No customer_email on MG SO #58

Open dj-tkoizumi opened 6 years ago

dj-tkoizumi commented 6 years ago

Child Synchronous Process Call: Magento Sales Orders [execution-ab2d3324-57c2-4c15-95d8-233ad2194eae-2017.11.08(shape3)] call ended in error: com.boomi.process.ProcessException: Error with Order 100065604: Invalid upsert document. For Upsert operation, externalId must be set and internalId must be null or blank ; Caused by: Error with Order 100065604: Invalid upsert document. For Upsert operation, externalId must be set and internalId must be null or blank

dj-tkoizumi commented 6 years ago

The Sales Order from Magento did not go into NS as it did not have the customer email. Boomi passes this in the XML as the external ID. This should never happen but it seems to happen for pre orders.

dj-tkoizumi commented 6 years ago

This is actually failing on the Customer create piece of the Create SO process. There is no customer_email being passed to Boomi from Magento on the XML. That is what we had agreed to pass in on the customer record as the Netsuite externalId. Because the email was missing as we are using that as the external id on the upsert, it failed and will continue to fail. I thought the email was used to create an account before ordering and would always be there. I think that was our understanding at the time of creation.

If you add the email address it would move forward with creating a SO or flagging the SO as a dup.