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_skuandsupplier_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.50reads 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.
- The terms columns (
statustoprice_scale, andnotes) come from the first row of the group. - Each row with a
min_qtyorunit_priceis 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. - Existing tiers not in the file are kept. To retire a price, end it or untick Active on the item's Suppliers tab.
- A row with neither
min_qtynorunit_priceonly updates the terms. - 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.
- 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
- 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."
- 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."
- The file is checked straight away ("Checking the file…"). Chips show the number of rows, new, updated, unchanged and errors.
- 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).
- 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).
- 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. |