FTP and NetSuite: Nightly Supplier Catalog Item Import Template
A ready-to-build Spojit template that pulls your supplier's catalog file from FTP every night, parses the CSV, and upserts each line as a NetSuite item record.
What It Builds
A Schedule trigger fires on a nightly cron, then a FTP Connector node downloads the latest supplier catalog file. A CSV utility node parses the rows, a Loop node walks each line, and a NetSuite Connector node in Direct mode upserts each row as an item record, creating new items and updating existing ones by SKU.
The Prompt
Paste this into Miraxa and it builds the workflow, connecting the tools for you:
Build a workflow that runs every night at 2am. Download the latest supplier catalog CSV from our FTP server, parse it, and for each row upsert a NetSuite item record matched on SKU, setting the name, description, price, and supplier fields. Skip rows missing a SKU.Connectors Used
- Schedule trigger - runs the import nightly on a cron you set.
- FTP - downloads the supplier catalog file from your server.
- CSV - parses the catalog file into rows.
- NetSuite - upserts each row as an item record.
Customize It
Edit the prompt to change the run time, the FTP folder or file pattern, the SKU match field, and which catalog columns map onto NetSuite item fields. You can also tell Miraxa to filter out discontinued lines or only import rows with a price above a threshold.
Tips
- Give the FTP connection read access to the exact directory where your supplier drops the file.
- Use the NetSuite node in Direct mode so each upsert maps fields predictably without AI cost.
- Validate and clean the CSV first if your supplier's exports are inconsistent.