Amazon FBA Replacement Order error

Cory Anderson

• December 28, 2021 23:27

We are seeing FBA orders coming in that have "IsReplacementOrder": "true". These orders do not have an amount for the item price and are erroring in NetSuite. How are these replacement orders normally handled? I need to be able to import them to NetSuite to at least decrement the inventory that was shipped. 

1

• 

  Sashikanta Behera QA Engineer

  • December 29, 2021 07:29

  Hi Cory,

  I am Sashi from the Celigo product team. Allow me to address your query. 

  The replacement orders are the ones for which a buyer replaced the original order due to some reasons like size or color issue etc.. So amazon ships an order marking "IsReplacementOrder": "true" with the same SKU as in the original order and the item of order which got replaced, returns back to the warehouse. 

  Can you please help us and share the retry data for those orders if possible, so we can provide you with a workaround. 

   

  Thanks, 

  0
• 

  Cory Anderson

  • December 29, 2021 18:19

  

  

  

  

  

  Sashi - I'm not comfortable posting the retry data here as it has customer address info and other things. I would be happy to send it to you directly. Please advise. 

  Thanks,

  Cory

  0
• 

  Courtney Jordan Experience Strategy & Design Director Community moderator

  • December 29, 2021 18:23

  

  

  

  Hi Cory Anderson,

  Since retry data could potentially contain confidential or PII data, I've created a support ticket on your behalf. Thanks!

  0
• 

  Justin Bodin

  • January 03, 2022 16:09

  

  

  

  Hey Cory Anderson if you're using the default order mapping which maps Amount and not Rate, then you can change the Items : Amount mapping to be Multi-field and then use the following formula. It should fix the mapping error that you are seeing which is caused by the missing item price from Amazon.

  {{#if $.OrderItem[*].ItemPrice.Amount}}{{$.OrderItem[*].ItemPrice.Amount}} {{else}}0{{/if}}

  2

Please sign in to leave a comment.