Solavel Docs
English

Vendor pricelists

Last updated

A vendor pricelist is a CSV file of supplier item terms: one row per price tier, with the supplier's code, currency, purchase unit, minimum order, order multiple, lead time, discount and the tier price and dates. Export it to review or share prices in a spreadsheet, and import it to update many items and suppliers at once. What each column means is explained in Supplier item terms.

An import never deletes anything: tiers that are not in the file are kept. It is checked first (Preview) and saved only when you click Apply import, and only if every row is valid.

#Where to find it

Button Where Exports or imports
Export CSV Item page → Suppliers section That item's terms, for every supplier.
Export CSV Supplier page → Items supplied section That supplier's terms, for every item.
Import pricelist The same two sections Any items and suppliers in the file; the page you start from does not limit the import.
  • Export CSV needs Supplier item terms: View. Import pricelist needs Supplier item terms: Manage, and on the item page it is shown only while the item's terms are editable in SolaCount.
  • Both are part of the Suppliers plan feature. See Permissions and plans.
  • The file is named vendor-pricelist-YYYYMMDD.csv (the download date). It is UTF-8 with a byte-order mark, so Excel opens Arabic text correctly.

#The columns

The header row of an export, in this order (SupplierTermsCsv::COLUMNS):

Column Export Import
item_sku The item's SKU. Required. Finds the item by SKU. "No item with this SKU."
item_name The item's name. Ignored (for your reading only).
supplier_id SolaCount's supplier number. Finds the supplier when it is a number.
supplier_name The supplier's name. Used when supplier_id is empty: the name must match exactly one supplier, ignoring upper and lower case. "No single supplier matches this id or name."
status approved, blocked or historical. Optional; empty keeps the current status (new terms: approved).
preferred yes or no. 1, yes, true, y or نعم mean yes; any other value means no; empty leaves it unchanged.
supplier_sku Supplier SKU. Optional.
supplier_item_name Supplier product name. Optional.
currency_code Currency of the prices. Optional, 3 letters.
purchase_unit Purchase unit text. Optional.
purchase_unit_factor Item units per purchase unit. Optional, greater than 0.
minimum_order_qty Minimum order. Optional.
order_multiple Order multiple. Optional.
lead_time_days Lead time in days. Optional, 0 to 3650.
discount_percent Supplier discount %. Optional, 0 to 100.
price_scale Price decimals, or empty for the organization default. Optional, 3 to 6.
min_qty The tier's minimum quantity. Empty with a price means 1.
unit_price The tier's unit price. Required for a tier row.
valid_from Start date, YYYY-MM-DD. Optional; "Dates must use the YYYY-MM-DD format."
valid_to End date, YYYY-MM-DD. Optional.
notes Notes. Optional.
managed_in SolaCount or SolaStock: the app that manages these terms. Ignored.
  • A file needs at least item_sku and either supplier_id or supplier_name, otherwise nothing is read: "The file needs an item_sku column and a supplier_id or supplier_name column." Other columns may be left out or put in any order.
  • Each row needs both keys: "item_sku and a supplier_id or supplier_name are required."
  • At most 5,000 rows per file: "Import at most 5000 rows at a time." The file may be up to 2 MB.
  • Numbers use a dot for decimals. Thousands separators and spaces are removed, so 1,250.50 reads as 1250.50.
  • The export puts an apostrophe before text that starts with =, +, - or @, so a spreadsheet does not run it as a formula; the import removes that apostrophe again.
  • Terms without tiers are exported as one row with empty tier columns.

#How an import is applied

Rows with the same item and supplier form one group.

  1. The terms columns (status to price_scale, and notes) are read from the first row of the group. Repeat them on every row if you like; later rows do not change them.
  2. Each row with a min_qty or a unit_price is a tier. A tier is matched to an existing tier by minimum quantity, valid from and valid to. A match updates its price and makes it active again; anything else is added as a new tier.
  3. Existing tiers that are not in the file are kept unchanged. To stop an old price, edit it on the item page: untick Active, set Valid to, or remove it.
  4. A row with neither min_qty nor unit_price only updates the terms.
  5. The whole group is then saved with the same checks as the terms window: decimals, overlapping tiers, preferred supplier, inactive supplier and so on. Any message is shown on every row of the group.
  6. Two rows of one group with the same minimum quantity and dates are an error: "Duplicate of row 4 (same item, supplier, minimum quantity and dates)."
  7. Rows for an item whose terms SolaStock manages are refused: "This item's supplier terms are managed in SolaStock. Import this row in SolaStock." Import those rows on SolaStock's vendor pricelist screen instead.

One error stops everything. Preview runs every check and then undoes the work, so nothing is saved. Apply import checks again and saves all rows together, or none if any row has an error.

#Import a pricelist

  1. Click Import pricelist. The window Import pricelist opens with "One row per price tier. Required: item_sku and supplier_id or supplier_name. Existing tiers not in the file are kept."
  2. Under CSV file, choose the file (.csv or .txt). Its name appears under the field.
  3. Click Preview. The summary reads, for example, "12 rows: 3 new, 8 updated, 1 unchanged, 0 with errors", and a table lists each row.
  4. If there are errors you see "Fix the rows with errors, then preview again. Nothing was saved." Correct the file, choose it again and click Preview.
  5. When there are none you see "No errors found. Apply the import to save these rows." Click Apply import.
  6. You see "Import applied."; the page sections reload. Click Close.

Preview table columns: Row (the line number in the file; the header is line 1), Item (SKU and name), Supplier, Min qty, Unit price (with the currency), Status and Message.

Status Meaning
New The row adds a tier to a supplier that had no terms for the item, or creates the terms.
Updated The row changes an existing tier's price, adds a tier to existing terms, or reactivates a tier.
Unchanged The tier already has this price, or a terms-only row for existing terms.
Error The row cannot be saved; the reason is in Message.

Apply import stays greyed out until a preview without errors and with at least one row. While it works, the buttons are disabled and a spinner shows.

#Worked example 1: a quarterly price update (AED)

{Organization name} receives new prices from {Supplier 2 name} (supplier number 14) for the last quarter. {User 1 name} opens the supplier page, clicks Export CSV under Items supplied and edits the file:

Line item_sku supplier_id currency_code purchase_unit purchase_unit_factor min_qty unit_price valid_from valid_to
2 PAP-A4-80 14 AED Box 5 10 95.00 2026-01-01
3 PAP-A4-80 14 AED Box 5 50 88.50 2026-10-01 2026-12-31
4 PAP-A3-80 14 AED Box 5 5 160.00 2026-10-01

She clicks Import pricelist, chooses the file and clicks Preview: "3 rows: 1 new, 1 updated, 1 unchanged, 0 with errors". Line 2 is Unchanged (same tier, same price), line 3 is Updated (90.00 becomes 88.50), and line 4 is New because Emirates had no terms for the A3 paper yet. She clicks Apply import and sees "Import applied." Any other A4 tier that is not in the file, such as a promotional tier she added by hand, is kept.

#Worked example 2: a USD supplier file with errors

{User 1 name} prepares a file for {Supplier 3 name}, a new supplier that quotes in USD and has no terms yet, for an AED organization, identifying the supplier by name:

Line item_sku supplier_name currency_code price_scale min_qty unit_price valid_from
2 PAP-A4-80 pacific paper exports inc. USD 4 1 24.50 2026-10-01
3 PAP-A4-80 pacific paper exports inc. USD 4 100 23.12345 2026-10-01
4 PAP-A4-80 pacific paper exports inc. USD 4 1 24.40 2026-10-01
5 CAR-250 pacific paper exports inc. USD 4 1 3.10 01/10/2026

Preview finds four errors and saves nothing:

  • Line 4: "Duplicate of row 2 (same item, supplier, minimum quantity and dates)."
  • Lines 2 and 3: "Use at most 4 decimal places for this supplier." (23.12345 has five decimals; the message is shown on the whole group).
  • Line 5: "Dates must use the YYYY-MM-DD format."

She deletes line 4, changes 23.12345 to 23.1235 and the date to 2026-10-01, and previews again. Now line 5 shows "This item's supplier terms are managed in SolaStock. Import this row in SolaStock.", because Cardamom 250g is a SolaStock item in this connected organization. She removes that line, previews ("2 rows: 2 new, 0 updated, 0 unchanged, 0 with errors") and applies. The name matched although it was typed in lower case. The USD prices are converted to AED only for comparison, using the latest rate on or before each date; the stored prices stay in USD.

#Tips and common problems

Problem Cause Fix
"The file needs an item_sku column…" The header row is missing or renamed. Start from an exported file.
"No single supplier matches this id or name." No supplier, or several suppliers, have that name. Use supplier_id from an export.
Old prices are still there after an import Imports never delete tiers. Deactivate or end the old tier on the item page.
A whole group shows the same error The group is saved as one unit. Fix the row the message is about, then preview again.
SolaStock rows are refused SolaStock manages those items' terms. Import them in SolaStock.
Excel changed 0012 into 12 Spreadsheets drop leading zeros. Format the column as text before typing SKUs.