Skip to main content

Sync your Amazon FBA inventory adjustments

Comments

6 comments

  • Uday

    In order to use this flow, does the SKU from Amazon always has to match with the Item name/number in NetSuite. We are using a custom field in NetSuite to map the SKU from Amazon since it does not match with the Item Name in NetSuite. When we ran the flow, we are getting an error saying that the matching SKU could not be found in NetSuite.

    Could you please confirm if we are using a custom field to match SKU, we should still match the Amazon SKU to Item Name in NetSuite?

    0
  • KHAISAR AHMAD QA Lead

    Hello Uday
    The Order Import flow should also consider any Custom field provided you have correctly update the Item Lookup criteria in the flow. If you look into the mappings of Order Import flow, you would find a mapping for Items : Item (InternalId), where you can define the lookup as per the custom field which have the Item SKU. 

    Please try this out once and let us know if you any further information. 

    0
  • Uday

    Hi Khaisar

    The flow that I have a question about is in regards to the FBA Inventory adjustment flow and not the order flow. 

    0
  • KHAISAR AHMAD QA Lead

    Hello Uday, 

    Thanks for clarifying the flow. Yes, the same would apply for this flow as well. Please update the lookup criteria accordingly in the setting, "Define criteria to search the matching items in NetSuite", and as well enter the field Id of the custom field in NetSuite which is holding the Amazon SKU in the setting "Specify the item field ID that matches with Amazon SKU". No changes are required in mappings. 

    Please review this once and let us know if you are still facing the issue.

    0
  • Uday

    Hi Khaisar

    I have updated the mappings and ran the flow but still encountering the same issue. The fnsku from Amazon matches with Amazon FNSKU filed on the item record in NetSuite.

     

    0
  • KHAISAR AHMAD QA Lead

    Hello Uday
    You are getting this error as the fieldID entered in "Specify the item field ID that matches with Amazon SKU" doesn't hold the SKU value i.e., "QB-32-05-90". In this setting you should enter the fieldID of the field which hold the SKU value. And it is required. that NetSuite Item should have this SKU in any of the field. 

    Please review this and let us know for any further queries. 

    0

Please sign in to leave a comment.