NetSuite to FTP: Weekly Open Purchase Order Export Template
A Spojit template that pulls open NetSuite purchase orders every week, writes them to a CSV, and drops the file in a supplier-facing FTP folder.
What It Builds
A Schedule trigger fires once a week and a NetSuite Connector node reads every purchase order still in an open status. A csv utility turns those rows into a single file, and an FTP Connector node uploads it to the folder your suppliers watch. No one has to run a saved search and hand off a spreadsheet by hand.
The Prompt
Paste this into Miraxa and it builds the workflow, connecting the tools for you:
Every Monday at 7am, get all open purchase orders from NetSuite, build a CSV with the PO number, vendor, order date, expected receipt date, item, quantity, and amount, then upload the file to the /suppliers/open-pos folder on our FTP server named open-purchase-orders-{{ today }}.csv.Connectors Used
- Schedule trigger - runs the workflow weekly on a cron schedule in your time zone.
- NetSuite - reads open purchase orders and their line details.
- csv - assembles the rows into a single downloadable file.
- FTP - uploads the finished CSV to the supplier folder.
Customize It
Change the day and time in the prompt to match your supplier cadence, adjust the column list to the fields your vendors expect, and edit the destination folder or file name pattern. You can also narrow the export to a single subsidiary or location by naming it in the prompt.
Tips
- Use a Connector node in Direct mode for the FTP upload so it always writes the same path with no AI cost.
- Confirm your NetSuite connection has read access to purchase order records before the first run.
- Including
{{ today }}in the file name keeps each weekly export as a separate file instead of overwriting the last one.