Mapping Amazon's "Ship by" date field to a custom date field in NetSuite Sales orders
Trying to map (Amazon <LatestShipDate>) --> (NetSuite <custbodyamzn_ship_date>)
I can find the Amazon "Ship by" or <LatestShipDate> field in the Amazon column on the left side of the mapping tool. I can't find our custom NetSuite Date field that I want to import into each new sales order on the right-hand side of the mapping tool. Let's say it is a Sales Order custom body field called "Amazon Ship Date" in NetSuite and has <custbodyamzn_ship_date> as its field ID. What steps am I missing making it not show up in the list of fields? Or, do I just use the id.. Like <custbodyamzn_ship_date> ?
0
Comments
Tom Dalton you can put the internal id in without the <> and it should work. You also just might have to refresh your field list. At the top of mapper there is a refresh icon to refresh the list of NetSuite fields. If this field was recently added since last field refresh then that should fix it.
I get this error "Invalid Field Value NaN/NaN/ NaN for the following field: custbodyfulfill_due_date".
I'm trying to go from LatestShipDate (in Amazon) ---> custbodyfulfill_due_date (in NetSuite)
So, it looks like a date formatting issue? When I look at a due date filed in Amazon seller central (*see attached images), one is like "Thu, May 9, 2024 to Fri, May 10, 2024" whereas in NetSuite we have a due date filed like 5/2/2024. I see several date fields in Amazon (*see attached images). Does anyone know how to pull an actual single date for the "Ship by Date" out of Amazon?
-Tom
Tom Dalton there is a date format list within the field mapping for that field. Can you try adjusting it?
Tom Dalton what does the data look like for that field? That actual JSON?
To get a single date from the string I am thinking you could use a SPLIT function to split the string apart at "TO" and take the last date Amazon is providing.
{{trim (split LatestShipDate "to" 1)}}
from there you could use the dateFormat function to format it correctly for insert to NetSuite.
It seems to have worked. I just mapped LatestShipDate (in Amazon) ---> custbodyfulfill_due_date (in NetSuite) and then selected the date type that matches what our NetSuite field is using MM/DD/YYYY, and it is working.
Please sign in to leave a comment.