When you sync Amazon orders to NetSuite if you're getting the "Failed to add Amazon Order#xxx" error message, there is a possibility that you are using the ASIN field as a lookup in the Amazon(MFN) Order to NetSuite Order Add flow.
To resolve this error,
- Go to Settings > Integration Flows > Order (MFN).
- Click the Edit Mappings icon (
) of the Amazon (MFN) Order to NetSuite Order Add flow. - In the Edit mapping: Amazon (MFN) Order Import Adaptor pane, replace OrderItem[*].SellerSKU with OrderItem[*].ASIN.
- Click the Settings icon (
) of the same field to access the Settings pane. - Select Amazon Product ASIN in the Refresh search filters setting, next to the expression field, and click Settings.
- On the Operand settings window, choose Expression, and click Save.
- In the Expression field, enter the handlebar expression {{#if OrderItem.*.ASIN}}{{{OrderItem.*.ASIN}}}{{else}}{{{OrderItem.0.ASIN}}}{{/if}}
Note: If you're adding the above handlebar, adding the item(internalid) mapping is recommended after the Quantity mapping. Ensure to disable the dynamic mode. - Click Save & close to save the changes made in the Settings pane. and return to the Edit mapping: Amazon (MFN) Order Import Adaptor pane.
- Click Save & close to save the changes made in the Edit mapping: Amazon (MFN) Order Import Adaptor pane and return to the Amazon(MFN) Order to NetSuite Order Add flow.
) of the Amazon (MFN) Order to NetSuite Order Add flow.
) of the same field to access the Settings pane.