Articles in this section

Set up item lookup for Amazon order sync using ASIN field

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,

  1. Go to Settings > Integration Flows > Order (MFN).
  2. Click the Edit Mappings icon (Edit mappings) of the Amazon (MFN) Order to NetSuite Order Add flow.
  3. In the Edit mapping: Amazon (MFN) Order Import Adaptor pane, replace OrderItem[*].SellerSKU with OrderItem[*].ASIN.
  4. Click the Settings icon (Settings (gear) button) of the same field to access the Settings pane.
  5. Select Amazon Product ASIN in the Refresh search filters setting, next to the expression field, and click Settings.
    Settings.jpg
  6. On the Operand settings window, choose Expression, and click Save.
    Operand_settings.jpg
  7. In the Expression field, enter the handlebar expression {{#if OrderItem.*.ASIN}}{{{OrderItem.*.ASIN}}}{{else}}{{{OrderItem.0.ASIN}}}{{/if}}
    Expression.jpg

    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.
  8. Click Save & close to save the changes made in the Settings pane. and return to the Edit mapping: Amazon (MFN) Order Import Adaptor pane.
  9. 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.
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.