Warehouses and Storage Locations import
/erp/data-import/warehouseserp-inventory-warehouses.view (görme, kontrol) · erp-inventory-warehouses.import + .create + .edit (aktarma)Warehouses and the storage locations (bins) within them. The opening stock and stock documents are linked to the warehouse — this workbook is loaded before Stok Açılışı (Opening Stock). A storage location's warehouse can be created on the Depolar (Warehouses) sheet of the same workbook; the sheets are processed in order.
The sample screenshots on this page were taken in the demo installation with a copy that was intentionally prepared with errors (only Kontrol Et (Validate), no records were written): a new warehouse (Açılacak — To be created), a bin whose name changed (Güncellenecek — To be updated), and an unrecognized warehouse type, a bin in a non-existent warehouse and a negative weight capacity (Hatalı — Invalid).
- 1Failed row count
- 2Import skipping failed rows
- 3Create · Update · Unchanged · Failed
- 4Error message — with row and code
Workbook sheets
| Sheet | Matching (record key) | What it writes |
|---|---|---|
| Depolar (Warehouses) | Kod | The warehouse master record. If the code exists it is updated; otherwise it is created. |
| Lokasyonlar (Storage locations) | DepoKodu + Kod | A storage location (bin) within a warehouse. Matched by warehouse + storage location code; its warehouse can be created in the same file. |
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.
Depolar (Warehouses)
The warehouse master record. If the code exists it is updated; otherwise it is created. Matching: Kod.
| Column | Required | Description | Example / allowed values |
|---|---|---|---|
Kod | Yes | The warehouse code — converted to uppercase; the letter i is written as 'I' in codes. | ANA-D |
Ad | Yes | The warehouse name. The same name (including differences in case, spaces and punctuation) is not created twice. | Ana Depo |
TesisKodu | No | The plant it belongs to. For a new warehouse, empty = default plant; a warehouse with stock does not change plant. | MERKEZ |
DepoTuru | No | Empty = Genel (General). | Genel (General) · Hammadde (Raw material) · Karantina (Quarantine) · Üretim (Production) · Mamul (Finished goods) · Yedek Parça (Spare parts) · Hurda (Scrap) |
LokasyonZorunlu | No | If Evet (Yes), every movement into this warehouse is posted with a storage location. | Evet · Hayır |
Durum | No | Empty = Aktif (Active). A warehouse with stock cannot be set to inactive. | Aktif · Pasif |
Lokasyonlar (Storage locations)
A storage location (bin) within a warehouse. Matched by warehouse + storage location code; its warehouse can be
created in the same file. Matching: DepoKodu + Kod.
| Column | Required | Description | Example / allowed values |
|---|---|---|---|
DepoKodu | Yes | The storage location's warehouse — must be on the Depolar sheet or in the system. | ANA-D |
Kod | Yes | The storage location code — unique within the warehouse. | STOK |
Ad | Yes | The storage location name — unique within the warehouse (spelling differences do not count as a different name). | Stok |
GozTipi | No | Empty = Raf (Shelf) (for a new storage location). | Raf (Shelf) · Blok istif (Block stacking) · Mal kabul alanı (Goods receipt area) · Sevk hazırlık alanı (Shipping staging area) |
MaksAgirlikKg | No | Bin capacity, kg. Empty = unlimited. | |
MaksHacimL | No | Bin capacity, liters. Empty = unlimited. | |
TekUrun | No | If Evet (Yes), only one item is kept in the bin. | Evet · Hayır |
Durum | No | Empty = Aktif (Active). A storage location with stock cannot be set to inactive. | Aktif · Pasif |
In the demo package
10-depolar-ve-lokasyonlar.xlsx: the HAMMADDE, KIMYA and MAMUL warehouses and their bins (the MERKEZ warehouse comes
from the master data seed). Kontrol Et (Validate) in the demo installation: 14 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 |
|---|---|
| DepoTuru 'Soğuk Oda' tanınmadı: Genel, Hammadde, Karantina, Üretim, Mamul, Yedek Parça, Hurda. (DepoTuru 'Soğuk Oda' was not recognized: …) | Enter one of the allowed values with the same spelling. |
| 'DEPO-X' kodlu depo bulunamadı — Depolar sayfasında ya da sistemde olmalı. (No warehouse with code 'DEPO-X' was found — it must be on the Depolar sheet or in the system.) | Add the storage location's warehouse to the Depolar sheet first, or correct the code. |
| Ağırlık kapasitesi sıfırdan büyük olmalı; sınırsız için boş bırakın. (The weight capacity must be greater than zero; leave it empty for unlimited.) | Enter a positive number in the capacity column or leave it empty. |