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 — and keep a Google Sheet in sync so nobody has to re-upload it.
A connected sales channel or QuickBooks already fills in suppliers, unit costs and payment terms (see Supplier data from your integrations). A price list is for what only your supplier knows, such as minimum order, case pack, order multiple and quoted lead time, or for when you have nothing to connect. A cost from a price list ranks above a sales channel's or your accounting's, and below one you typed in yourself.
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.
- Choose Choose file and pick the CSV.
- 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.
- 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.
Keeping a Google Sheet in sync, so nobody has to re-upload it. After a price list imports from a Google Sheet, choose Keep this in sync. From then on Skuvelo re-reads that sheet about every 15 minutes and brings in changes on its own — useful when the sheet is maintained by your supplier or a colleague rather than by you. Skuvelo only reads the one file and tab you picked. It cannot see anything else in your Google Drive, and it never could: the access you granted covers only files you hand it through Google's file picker.
Everything you have kept in sync is listed under Kept in sync on Settings → Import data, with the last time each one brought in changes. Each file has its own controls:
- Pause stops the checks without forgetting the file. Resume starts them again and checks straight away.
- Stop syncing removes the file from the list. Skuvelo stops reading it. To take back the Google access itself, disconnect Google.
- A file shown as Stopped says why, in one line: the file was deleted or un-shared, the tab was renamed, or the Google connection expired. Each says what to do about it. A file shown as Needs a look is still being checked, but its last read was rejected — the reason is the same one an ordinary import would have given you, and fixing the sheet is what clears it.
A cosmetic edit — a colour, a column width — does not create an import. Only a change to the data does. If you edit the sheet and nothing has changed by the time you look, the next check has not run yet.
Disconnecting Google removes every file you had kept in sync, because Skuvelo read them through your Google account.
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.
Try the plan on your own stock.
Start a trial with your own sales and stock, or look around the live demo first.