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 item code, currency, purchase unit, minimum order, order multiple, lead time, discount and the tier's price and dates. Export CSV gives you the current terms to review in a spreadsheet; Import pricelist loads a supplier's new prices for many items at once. Every term is explained on the item's Suppliers tab.

An import is always checked before anything is saved, it saves all rows or none, and it never deletes a tier that is not in the file.

#Where to find it

Button Where Exports or imports
Export CSV, Import pricelist Purchasing → Suppliers, page header Export: every supplier and item.
Export CSV, Import pricelist A supplier's Items tab Export: this supplier's items.
Export CSV, Import pricelist An item's Suppliers tab Export: this item's suppliers.
  • Export CSV needs View items and Export inventory reports. Import pricelist needs Create / edit / deactivate items. A button you may not use is not shown. "Exporting vendor pricelists is not available for your access." appears if the server refuses an export.
  • Both are part of the Suppliers plan feature (stock.suppliers).
  • An import may contain any items and suppliers, whichever page you start from.
  • The file is vendor-pricelist-YYYYMMDD.csv, UTF-8 with a byte-order mark. While exporting, the button reads Exporting…; "The pricelist could not be exported." if it fails.

#The columns

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

Column Export Import
item_sku The item's SKU. Required. "No item with this SKU."
supplier_code The supplier's code. Required. The supplier is found by code only. "No supplier with this code."
supplier_name The supplier's name. Ignored (for your reading).
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 The supplier's item code. Optional.
supplier_item_name The supplier's product name. Optional.
currency_code Currency of the prices. Optional, 3 letters.
purchase_unit The purchase unit's code, for example CTN. Optional; the unit must exist ("No unit with this code.") and convert to the item's base unit.
minimum_order_qty Minimum order, in the purchase unit. Optional.
order_multiple Order multiple, in the purchase unit. 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, per purchase unit. 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.
  • The header must contain item_sku and supplier_code: "The file is missing required columns: supplier_code." Other columns may be missing or in another order.
  • Each row needs both: "item_sku and supplier_code are required."
  • At most 5,000 data rows ("Import at most 5000 rows at a time.") and 2 MB ("The file is larger than 2 MB. Split it into smaller files.").
  • Decimals use a dot. Thousands separators and spaces are removed, so 1,250.50 reads as 1250.50.
  • Text that starts with =, +, - or @ is exported with a leading apostrophe so spreadsheets do not run it as a formula; the import removes the apostrophe.
  • Terms without tiers are exported as one row with empty tier columns. The supplier description and a tier's Active box are not in the file; imported tiers are always active.

#How an import is applied

Rows with the same item_sku and supplier_code form one group.

  1. The terms columns (status to price_scale, and notes) come from the first row of the group.
  2. Each row with a min_qty or unit_price is a tier, matched to an existing tier by minimum quantity, valid from and valid to. A match gets the new price and becomes active again; otherwise the tier is added.
  3. Existing tiers not in the file are kept. To retire a price, end it or untick Active on the item's Suppliers tab.
  4. A row with neither min_qty nor unit_price only updates the terms.
  5. The group is saved with the same rules as the terms window: decimals, overlapping tiers, the preferred supplier, inactive suppliers, unit conversion. A message is shown on every row of the group.
  6. Two rows of one group with the same minimum quantity and dates: "Duplicate of row 3 (same item, supplier, minimum quantity and dates)."

If any row has an error, nothing is saved, neither in the check nor when applying.

#Import a pricelist

  1. Click Import pricelist. The window Import vendor pricelist opens: "Check the file first, then apply it. Existing tiers that are not in the file are kept."
  2. Under CSV file choose the file ("UTF-8 CSV with a header row, as produced by Export CSV. Up to 5,000 rows."). Columns opens the list of columns and "item_sku and supplier_code are required. Dates use YYYY-MM-DD and decimals use a dot."
  3. The file is checked straight away ("Checking the file…"). Chips show the number of rows, new, updated, unchanged and errors.
  4. With errors: "Some rows have errors. Nothing has been saved. Correct the file and choose it again." Fix the file, choose it again, or click Check again after fixing data in SolaStock (for example adding a missing unit).
  5. Without errors: "The file is valid. Nothing has been saved yet — choose Apply import to save it." Click Apply import (it reads Working… while saving).
  6. On success the window closes with "Pricelist imported: 2 created, 1 updated, 0 unchanged." and the open lists refresh. If the server finds an error at that moment, nothing is saved: "Nothing was saved because some rows have errors." and the rows are shown again.

Rows table: Row (line number in the file; the header is line 1), Item SKU, Supplier code, Minimum quantity, Unit price, Currency, Status and Message. Rows with an error are highlighted.

Status Meaning
New A tier for a supplier that had no terms for the item, or new terms.
Update A changed price, a reactivated tier, or a tier added to existing terms.
Unchanged The tier already has this price, or a terms-only row for existing terms.
Error The row cannot be saved; see Message.
Not checked Not processed.

Other messages: "The file is empty.", "The file has no data rows.", "The file could not be read.", "The file could not be checked.", "The import could not be applied.", and "You cannot make this change with your current role or plan. Nothing was saved."

#Worked example 1: new carton prices from a local supplier (AED)

{Supplier 5 name} (SUP-DEMO-05) sends new prices for the fourth quarter. {User 2 name} opens the supplier's Items tab, clicks Export CSV and edits the file:

Line item_sku supplier_code currency_code purchase_unit minimum_order_qty order_multiple min_qty unit_price valid_from valid_to
2 CAR-250 SUP-DEMO-05 AED CTN 5 5 5 360.00 2026-01-01
3 CAR-250 SUP-DEMO-05 AED CTN 5 5 20 338.00 2026-10-01 2026-12-31
4 CUM-500 SUP-DEMO-05 AED CTN 2 1 2 410.00 2026-10-01
5 TUR-500 SUP-DEMO-05 AED BOX 1 55.00 2026-10-01

He clicks Import pricelist and chooses the file. The check shows 4 rows, 2 new, 1 updated, 1 unchanged, 0 errors: line 2 Unchanged, line 3 Update (342.00 becomes 338.00), lines 4 and 5 New ({Supplier 5 name} had no terms for cumin and turmeric). He clicks Apply import and sees "Pricelist imported: 2 created, 1 updated, 1 unchanged." The cardamom page now shows 338.00 for 20 cartons; the 5-carton tier is unchanged.

Had BOX not existed as a unit, line 5 would show "No unit with this code." and nothing would have been saved, including lines 2 to 4.

#Worked example 2: a USD supplier with a duplicate and a decimal error

{Supplier 6 name} (SUP-DEMO-06) quotes in USD with 4 price decimals. The buyer prepares:

Line item_sku supplier_code currency_code price_scale discount_percent min_qty unit_price valid_from
2 CAR-250 SUP-DEMO-06 USD 4 5 10 88.0000 2026-10-01
3 CAR-250 SUP-DEMO-06 USD 4 5 50 84.12345 2026-10-01
4 CAR-250 SUP-DEMO-06 USD 4 5 10 87.5000 2026-10-01
5 CAR-250 SUP-KERLA USD 4 5 10 88.0000 2026-10-01

The check reports 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." (84.12345 has five decimals; the whole group shows the message).
  • Line 5: "No supplier with this code." (a typing mistake).

After deleting lines 4 and 5 and correcting the price to 84.1235, the check is clean and Apply import saves two USD tiers. In a SolaStock organization linked to SolaCount, these prices are compared with AED suppliers using SolaCount's rate (1 AED = 0.2723 USD makes 88.00 less 5% ÷ 24 about 12.79 AED per piece); without SolaCount they are listed in the comparison with No exchange rate.

#Tips and common problems

Problem Cause Fix
"The file is missing required columns: …" The header row is missing or renamed. Start from an exported file.
"No supplier with this code." The code is misspelled; names are not used to find suppliers. Copy the code from Suppliers.
Old tiers remain Imports never delete tiers. End or deactivate them on the item.
"This purchase unit has no conversion to the item's base unit…" The unit code exists but does not convert to the item's base unit. Add the unit conversion in Settings.
Arabic text looks garbled in Excel The file was saved in another encoding. Save as CSV UTF-8.
No Export CSV button You lack Export inventory reports. See Team access.