Guide

Import a supplier price list

Set supplier cost, MOQ, order multiple, case pack and lead time for many items at once from a CSV, a Google Sheet or a file your AI assistant staged.

Supplier price lists import on Settings → Import Data, under Supplier price list. It needs an owner, admin, planner or purchasing role.

The file needs a supplier column, a sku column (or a barcode column — UPC, EAN or GTIN), and at least one of unit_cost, moq, order_multiple, case_pack or lead_time_days. currency, supplier_sku and effective_date are optional. Common alternative headings are matched, and you can pick any column by hand under Columns.

  1. Choose Choose file and pick the CSV.
  2. Read the preview. Every row says New link, Update, Unchanged or Not imported, with what it would set. A supplier Skuvelo does not have yet is named as new.
  3. Choose Apply N rows. Nothing is written until then.

After applying, Recent price list imports shows who imported the file, when, and how many rows were applied, unchanged and rejected, with the reason for each rejected row.

What a row does. A blank cell leaves the current value alone. A row for a supplier the item is already linked to updates that link; otherwise a link is added, and an item's first supplier becomes its preferred one. case_pack is stored on the item itself. Supplier matching is by name, ignoring case and extra spaces.

Rows that are rejected. An unknown SKU, a SKU listed twice for the same supplier, a currency that differs from the supplier's, an effective_date in the future, a new link without a lead time, or a new supplier without a currency. Fix the row and import the file again; rows that already applied show as unchanged.

From Google Sheets or an AI assistant. A price list can also come from a Google Sheet, or be staged by an AI assistant connected to Skuvelo. A staged file waits under Staged by your AI assistant until someone chooses Review and applies it, or Discard.

Planning prices and times every reorder from these values, so recommendations update as soon as the import applies.

When an imported lead time is not what planning uses. If a link already has a planning override or an observed lead time set, planning keeps using that number, not the one this file just imported — the row still updates (nothing is lost), but the preview and the receipt name which number planning is still using. See keeping lead times true for how planning chooses between a supplier's stated lead time, an override, and what receipts actually show.