Price List Import
/erp/data-import/price-listserp-sales-price-lists.view (görme, kontrol) · .import + .create + .edit (aktarma)All of sales pricing in a single workbook, eight sheets. Items and business partners are loaded first. For how the price is proposed on a sales document: Price lists.
- The Toplu Değişiklik (Bulk Change) sheet (increase / reduction) is applied to the list's explicit prices, after the Fiyatlar (Prices) sheet. Do not change the same item on both sheets. In the export this sheet is empty; its matching is the row order.
- A period price takes precedence over the permanent price; in quantity scales, the highest threshold met applies.
- For a configurable item, line price = list price + the surcharges of the selected values (Karakteristik Farkları — Characteristic Surcharges).
- Özel Fiyatlar (Special Prices) take precedence over the list; one record per customer × item × currency.
- The workbook is this object's template in the system (Dışa Aktar › Şablonu İndir — Export › Download Template); no separate template is included in the package.
Workbook sheets
| Sheet | Matching (record key) | What it writes |
|---|---|---|
| Fiyat Listeleri (Price Lists) | Kod | The list header. Created if it does not exist, updated if it does. |
| Fiyatlar (Prices) | ListeKodu + UrunKodu | The explicit price in the list. The price of an item not in the file is not deleted. |
| Dönem ve Miktar Fiyatları (Period and Quantity Prices) | ListeKodu + UrunKodu + MinMiktar + Baslangic | A period or quantity scale price. A period price takes precedence over the permanent price; in scales, the highest threshold met applies. |
| Karakteristik Farkları (Characteristic Surcharges) | ListeKodu + UrunKodu + OzellikKodu + DegerKodu | The option surcharge of a configurable item: line price = list price + the surcharges of the selected values. |
| Toplu Değişiklik (Bulk Change) | satır sırası (row order) | Increase / reduction: to the list's EXPLICIT prices, AFTER the Fiyatlar sheet. Do not change the same item on both sheets. Empty in the export. |
| Müşteri Listeleri (Customer Lists) | CariKod | The customer's price list (business partner record › Sales). |
| Özel Fiyatlar (Special Prices) | CariKod + UrunKodu + ParaBirimi | A customer-specific price — takes precedence over the list. One record per customer × item × currency. |
| Grup İskontoları (Group Discounts) | CariKod + KategoriKodu + Baslangic | A category discount — proposed on the list price as a line discount. |
Columns
The tables are generated from the same source as the system's Alan Kılavuzu (Field Guide) tab. If a column with
Required: Yes is left empty, the row becomes Hatalı (Invalid). All cells are read as text; Evet/Hayır
(Yes/No) columns accept no other value, and in a column with a list of allowed values the spelling must match the
list.
Fiyat Listeleri (Price Lists)
The list header. Created if it does not exist, updated if it does. Matching: Kod.
| Column | Required | Description | Example / allowed values |
|---|---|---|---|
Kod | Yes | List code, at most 32 characters. | STANDART |
Ad | No | Required for a new list, at most 128 characters. | Standart Satış Fiyat Listesi |
ParaBirimi | No | ISO code (TRY, USD, EUR). Required for a new list; cannot change on a list that has prices. | TRY |
TemelListe | No | For a derived list, the code of the base list: an item without an explicit price comes from base price × factor. | |
Katsayi | No | Required if TemelListe is filled (1,10 = 10% more). | |
Varsayilan | No | Evet (Yes) = the list for customers without an assigned list. Hayır (No) does not remove the default (it is handed over by making another list the default). | Evet · Hayır |
Durum | No | Aktif (Active) / Pasif (Inactive). | Aktif · Pasif |
Fiyatlar (Prices)
The explicit price in the list. The price of an item not in the file is not deleted. Matching: ListeKodu +
UrunKodu.
| Column | Required | Description | Example / allowed values |
|---|---|---|---|
ListeKodu | Yes | The list on the Fiyat Listeleri sheet or in the system. | STANDART |
UrunKodu | Yes | A sellable item. | MM-0001 |
UrunAdi | No | Information — not read. | |
Birim | No | Information — the price is in the item's base unit. | ADET |
Fiyat | Yes | Per base unit, in the list's currency, excluding VAT. Turkish decimal comma (490720,41). | 490720,41 |
Dönem ve Miktar Fiyatları (Period and Quantity Prices)
A period or quantity scale price. A period price takes precedence over the permanent price; in scales, the highest
threshold met applies. Matching: ListeKodu + UrunKodu + MinMiktar + Baslangic.
| Column | Required | Description | Example / allowed values |
|---|---|---|---|
ListeKodu | Yes | STANDART | |
UrunKodu | Yes | HZ-0001 | |
MinMiktar | No | Scale threshold, in the item's base unit; empty = no scale. | 10 |
Baslangic | No | dd.mm.yyyy; empty = no time limit. | 01.01.2027 |
Bitis | No | dd.mm.yyyy; empty = no time limit. | 31.03.2027 |
Fiyat | Yes | Per base unit, excluding VAT. | 90,00 |
Not | No | 10 saat ve üzeri |
Karakteristik Farkları (Characteristic Surcharges)
The option surcharge of a configurable item: line price = list price + the surcharges of the selected values.
Matching: ListeKodu + UrunKodu + OzellikKodu + DegerKodu.
| Column | Required | Description | Example / allowed values |
|---|---|---|---|
ListeKodu | Yes | STANDART | |
UrunKodu | Yes | A configurable item. | MM-0001 |
OzellikKodu | Yes | A configuration characteristic of the item. | PERON_SAYISI |
DegerKodu | No | For a characteristic with options, the value code (required). Empty for a numeric characteristic: the surcharge is per unit of the value. | 3 |
Fark | Yes | In the list's currency; can be negative. Empty cell = this surcharge is removed. | 209563,69 |
Toplu Değişiklik (Bulk Change)
Increase / reduction: to the list's EXPLICIT prices, AFTER the Fiyatlar sheet. Do not change the same item on both
sheets. Empty in the export. Matching: satır sırası (row order).
| Column | Required | Description | Example / allowed values |
|---|---|---|---|
ListeKodu | Yes | STANDART | |
KategoriKodu | No | The category and its subcategories; empty = the whole list. | |
Arama | No | Text contained in the item code or name; empty = no filter. | |
Yontem | Yes | Yüzde (Percentage): new = old × (1 + value / 100). Tutar (Amount): new = old + value. | Yüzde · Tutar |
Deger | Yes | Percentage: 10 = 10% increase, -5 = 5% reduction. Amount: in the list's currency. | 10 |
Yuvarlama | No | Decimal places (0–4); empty = 2. | 2 |
Müşteri Listeleri (Customer Lists)
The customer's price list (business partner record › Sales). Matching: CariKod.
| Column | Required | Description | Example / allowed values |
|---|---|---|---|
CariKod | Yes | The customer record. | M-00487 |
CariUnvan | No | Information — not read. | |
ListeKodu | Yes | Empty cell = the assignment is removed and the customer gets the default list. | SHELL |
Özel Fiyatlar (Special Prices)
A customer-specific price — takes precedence over the list. One record per customer × item × currency. Matching:
CariKod + UrunKodu + ParaBirimi.
| Column | Required | Description | Example / allowed values |
|---|---|---|---|
CariKod | Yes | M-00487 | |
CariUnvan | No | Information — not read. | |
UrunKodu | Yes | HZ-0001 | |
Fiyat | Yes | Per base unit, excluding VAT. | 85,00 |
ParaBirimi | Yes | ISO code. | TRY |
Baslangic | No | dd.mm.yyyy; empty = no time limit. | |
Bitis | No | dd.mm.yyyy; empty = no time limit. | |
Not | No |
Grup İskontoları (Group Discounts)
A category discount — proposed on the list price as a line discount. Matching: CariKod + KategoriKodu +
Baslangic.
| Column | Required | Description | Example / allowed values |
|---|---|---|---|
CariKod | No | Empty = all customers. | |
KategoriKodu | Yes | The category and its subcategories. | TIC |
IskontoYuzde | Yes | 0 – 100. | 5 |
Baslangic | No | dd.mm.yyyy; empty = no time limit. | |
Bitis | No | dd.mm.yyyy; empty = no time limit. | |
Not | No |
In the demo package
08-fiyat-listesi-aktarimi.xlsx: STANDART, BAYI (Standart × 0,85), IHRACAT (EUR); scale and period prices,
characteristic surcharges, a special price, a group discount. Kontrol Et (Validate) in the demo installation:
109 rows · Hatalı (Invalid) 0.
Common errors
The messages are the same as the text in the system's Kontrol sonucu (Validation result) table (… is the
variable part).
| Message | Cause and solution |
|---|---|
| Yeni listede Ad ve ParaBirimi zorunlu. (Ad and ParaBirimi are required for a new list.) | Fill in both columns for a new list code. |
| '…' fiyat listesi bulunamadı. (Price list '…' was not found.) | Create the list on the Fiyat Listeleri sheet of the same workbook, or correct the code. |
| '…' ürünü bulunamadı. (Item '…' was not found.) | Import the item first. |
| '…' iş ortağı bulunamadı. (Business partner '…' was not found.) | Import the customer record first. |