FAQ: How can I get a response file (ASN) from FTP back into NetSuite to update an order’s status?

Q: I’m importing orders from a file, where each order goes into a separate folder on my FTP server based on the location in the order data. for more information. After the orders are imported, we receive a response file (ASN acknowledgement) on the FTP server, which is a response to the orders we loaded and contains both a confirmation number and status for the order. The amount of time can be 30 minutes or more. This lets us know if the order is good to go or has issues we need to follow up on. How would I get that data back into NetSuite?

A: For this type of data flow, you'll need a separate one since the export system is now the FTP server instead of NetSuite. To get it back to NetSuite depends on where you want it to go, but you could do something like update the Sales Order record in question and update a Notes field. The caveat here is that the data being sent back from your FTP will need some way to identify the Sales Order in question- generally the Sales Order's InternalId is the best way. With this value, you could then update the record with the response values.