CSV and NetSuite: Supplier Price List Import Template
Upload a supplier price-list CSV and Spojit validates each row, then upserts the new unit costs onto the matching NetSuite item records.
What It Builds
A Manual trigger lets you start the run and attach a supplier price-list CSV. A csv Connector node parses the file into rows, a Validation step checks that each line has a recognizable item code and a numeric price, and a Loop iterates the clean rows. Inside the loop, a netsuite Connector node in Direct mode finds the matching item by SKU and upserts its unit cost, so your pricing stays current without manual data entry.
The Prompt
Paste this into Miraxa and it builds the workflow, connecting the tools for you:
Build a manually triggered workflow where I upload a supplier price-list CSV with item code and unit cost columns. Parse the file into rows, validate that each row has a non-empty item code and a numeric price, skip any invalid rows, then loop over the valid rows and update the matching NetSuite item record's unit cost by SKU.Connectors Used
- csv - parses the uploaded price list into structured rows. Trigger: Manual.
- netsuite - finds each item by SKU and upserts its unit cost.
Customize It
Change the column names in the prompt to match your supplier's file (for example part_number and list_price), adjust the SKU field NetSuite matches on, or add a markup percentage to the price before it is written. You can also tell Miraxa to update a custom cost field instead of the standard unit cost.
Tips
- Make sure your NetSuite connection has write access to item records before running.
- Use Direct mode on the NetSuite node so each update is a single exact tool call with no AI cost.
- Run a small test file first to confirm the SKU match resolves the right items.