We noticed the Shopify order billing address is not syncing to NetSuite using the default flow - Shopify order to NetSuite order (cash sale or sales order)
This seems to only happen when the country is a foreign country and country code gets sync'd, but other address fields gets the same value as Shipping Address.
Celigo Support responded there is no issue with the flow mapping. No scripts or workflow in NetSuite blocking this address. Any other ideas? Thanks.
Hi Michael,
What does your field mapping look like on the "Post Orders to NetSuite" import step of the flow?
Check out the Input preview in the mapping on that step.
You'll see 2 properties...
"billing_address" & "shipping_address"
Make sure both properties are always populated in the Input JSON and that the input properties from each are mapped to the correct fields in NetSuite for the order.
I can't remember if the "billing_address" property is populated when the customer uses the "use shipping address as billing address" feature at checkout.
If the billing address property is null, use some handlebar expressions to use the billing_address properties if they are not null, or the shipping_address properties when the billing_address properties are null.
Hope that helps!
Hi Griffin, I checked the shopify json and it does have both billing and shipping address fields. What's weird is, when the country is US, all address fields map correctly. But when you have a country other than US, only the country field is mapped, not others. Any thoughts? Thanks in advance.
Hi Michael,
If the country isn't US, what I believe happens is that in NetSuite, once the country is selected in the address tab, the address fields refresh and thus the other address fields get removed.
You may see this in action in NetSuite, if let's say you add a custom address. Usually it would default to US. You may try filling in the address details but THEN you switch the country then BOOM! The address details get wiped.
To resolve this, what you can do is go to the "Post Orders to NetSuite" import step of the flow and go to the mapping. In the mapping, you may then DRAG the shipping country to a spot above the other shipping address mappings. Then save and close.
Hi Jay,
Thanks for pointing this out. But the Billing Address 1 is not wiped, it is sync to Shipping Address 1 instead.
Hi Jay,
We just ran some tests with the Billing and Shipping Country mapping above the Address1 fields. It worked! Our foreign billing addresses are now mapping correctly. Thank you so much for the suggestions. I think the Celigo Shopify app should come with this mapping order as a default.