Agnotiq MarginTide Pricing Intelligence
Start
Help center
Procurement Intelligence

Send supplier costs from another ERP

Any system that can produce a spreadsheet of supplier costs can feed a file link. This page gives the generic recipe and what is known about other ERPs.

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.

The generic recipe

  1. Build a report or export that lists, per item and supplier, the unit cost and the date it applies from.
  2. Name the columns exactly as shown below.
  3. Schedule it to produce a .xlsx or .csv file.
  4. Land the file in Google Sheets, OneDrive, SharePoint or Dropbox, overwriting the same file each time, and share it with "Anyone with the link".

Per ERP

  • Sage Intacct: scheduled report delivery can send to email or cloud storage as CSV or Excel (Sage Intacct help).
  • SAP Business One: Query Manager results can be scheduled and mailed, but attachments are PDF, HTML or XML only, so they cannot feed a file link directly (SAP help).
  • Acumatica, Epicor Prophet 21 and Odoo: we found no vendor documentation for a scheduled export to a shared file, so we cannot give steps. Check with your administrator or partner.

EDI 832

An EDI 832 is a supplier price catalog. Your EDI provider or middleware can map it to the supplier costs API, POST /api/v1/supplier-costs/bulk (see the API and MCP guide). It carries your supplier's catalog prices, never a customer price.

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