Issue : Users not able to import FBA orders whose address is marked as Confidential on Amazon.
Solution : Some FBA orders will not show the Shipping Address, but instead will show "The shipping address is confidential." This could be because the buyer chose to use the confidential address as the shipping address. The confidential addresses are typical addresses associated with Gift registries, such as Wedding Registries, or Baby Registries, etc. A buyer can sometimes buy orders using the registry option and ship it to the Confidential Address associated with the registry, but the full address is kept confidential.
In this scenario, the Integration App can only create sales orders only when information associated with the mandatory address field is present in the sales order and customer record being imported from Amazon in NetSuite. When this criterion is not met, NetSuite generates an error.
You can make changes in the Integration App settings to import an order even when the shipping information is not present in the Amazon FBA order. This can be achieved by adding default values to the address fields in Order FBA and Customer import integration flows. Perform the following steps in the Integration App to add the default value in various address fields.
-
Navigate to Order (FBA) > Amazon (FBA) Order to NetSuite Order Add > Field Mappings . The Mappings page is displayed.
-
Identify the Mandatory address fields in NetSuite and click the Settings icon for the same field from mappings. The Settings page is displayed.
-
Copy and paste the following expression based on the selected mapping in the Expressions field:
-
Shipping Address 1
{{#if $.ShippingAddress.AddressLine1}} {{$.ShippingAddress.AddressLine1}} {{else}}{{#if $.ShippingAddress.AddressLine2}}{{$.ShippingAddress.AddressLine2}}{{else}} DEFAULT-ADDRESS-LINE1 {{/if}}{{/if}}
Note : From the above expression, replace the bold text (DEFAULT-ADDRESS-LINE1 ) with default address line 1 of your choice. Ex - “Confidential”
-
Shipping City{{#if $.ShippingAddress.City}}{{$.ShippingAddress.City}}{{else}}DFAULT-CITY{{/if}}
Note
From the above expression, replace the bold text (DEFAULT-CITY) with the default city of your choice.
-
Shipping Address State {{#if $.ShippingAddress.StateOrRegion}}{{$.ShippingAddress.StateOrRegion}}{{else}}DEFAULT-STATE{{/if}}
Note
From the above expression, replace the bold text with a default state of your choice.
-
Shipping Address Zip Code{{#if $.ShippingAddress.PostalCode}}{{$.ShippingAddress.PostalCode}}{{else}}DEFAULT_PIN{{/if}}
Note
From the above expression, replace the bold text with the default zip code of your choice.
-
-
Repeat the above steps for the Amazon (FBA) Customer to NetSuite Customer Add flow as well. It is recommended to add Shipping Address 1, Shipping City, Shipping Address State, and Shipping Address Zip Code mappings in the customer import integration flow.
-
Click Save.
-
Click Save & Close.
Comments
Please sign in to leave a comment.