Agnotiq MarginTide Pricing Intelligence
Start
Help center
Procurement Intelligence

Send supplier costs from NetSuite

Keep your supplier costs current by having NetSuite produce a CSV that a file link reads on a schedule.

What the file link does

A file link pulls one spreadsheet you own on a schedule and applies its rows as supplier costs. You preview it before the first commit, and a file that has not changed since the last pull is skipped.

Steps in NetSuite

  1. Build a saved search on items. The Item Vendors subtab holds Vendor, Vendor Code and Purchase Price, and needs the Multiple Vendors feature (Oracle help).
  2. Give each result column a Custom Label equal to the header names below, and open the CSV once to verify the header row.
  3. NetSuite documents no effective-date field for a purchase price. Add a date column labelled effective_at and verify that it holds the date the cost starts to apply.
  4. On the Email subtab, use "Send Emails According to Schedule", set the Schedule subtab, and in Customize Message choose "Send as CSV" (Oracle help). Never choose "Send as Microsoft Excel": it produces an .xls file, which is refused.

The CSV then has to land in a file you can share. Two ways:

  • A mailbox flow you own: Power Automate "When a new email arrives (V3)" with Only with Attachments, then OneDrive "Update file", so the same file is overwritten.
  • A File Cabinet file with "Available Without Login" (Oracle help), written on a schedule by your own SuiteScript SearchTask (Oracle help).

The columns

Row 1 of the file is the header row, with exactly these names in lowercase:

supplier_name,supplier_sku,product_id,gtin,mpn,brand,unit_cost,pack_qty,uom,currency,effective_at
  • unit_cost and effective_at are required on every row.
  • Each row names exactly one supplier. The template uses supplier_name; supplier_id and supplier_domain are the two other supplier keys.
  • Each row also needs a way to find the item: product_id, supplier_sku, gtin, or mpn together with brand.
  • A column that is not in the list, or a column that appears twice, makes the whole file fail. The other accepted names are supplier_id, supplier_domain.

Example rows, with a made-up supplier and brand:

Example Supply Co.,ESC-1001,,,,,12.40,1,each,USD,2026-11-01
Example Supply Co.,,,,MX-220,Examplebrand,8.15,12,case,USD,2026-11-01

File rules

  • The file is .xlsx or .csv. Old .xls files, .xlsb files and password-protected workbooks are refused.
  • Only the first visible sheet is read, and row 1 must be the header row.
  • Dates are YYYY-MM-DD or a real date cell. Numbers have no currency symbols or thousands separators.
  • The file must stay within the import size limit.
  • Overwrite the same file on every refresh so its name and link stay the same, and share it so "Anyone with the link" can view it.

Connect the link

  1. Go to Settings → Integrations → File links. Scheduled file pulls are available on Pro and above, and only workspace admins can manage links.
  2. Under "What the file holds", choose "Supplier costs".
  3. Paste the file link (Google Sheets, OneDrive, SharePoint, Dropbox or any https link) and select "Save link".
  4. Select "Preview" and read the result, including any "Rows we could not use". Fix the file and preview again until it is clean.
  5. Select "Confirm and start pulling". From then on the file is pulled on a schedule, and a file that has not changed is skipped.

Go further