[Koha] barcodes and price

[Indranil Das Gupta]

;Hi Kazım,

This Koha wiki page provides the detailed mapping between 952 marc field
and koha's items table -
https://wiki.koha-community.org/wiki/Holdings_data_fields_(9xx)

If your barcodes are already in place in the Koha database's items table
you can update the field 952$g (items.price) individually as follows:

UPDATE items SET items.price = 16.45 WHERE items.barcode = '302594';

NOTE: this will require you to run a separate SQL UPDATE query for each
barcode.

Since this is directly working on the database backend, please take a full
database backup before you do this.

Once you are done with the update statements, be sure to restart memcached
service and also rebuild the zebra index.

Hope this helps.

--
Indranil Das Gupta
L2C2 Technologies

Phone : +91-98300-20971
WWW  : http://www.l2c2.co.in
Blog    : http://blog.l2c2.co.in
IRC     : indradg on irc://irc.freenode.net
Twitter : indradg


On Thu, Aug 1, 2024 at 5:06 PM Kazım ŞENTÜRK <ksenturk at uludag.edu.tr> wrote:

> Hello,
>
> The barcodes below (952$p) field of 952$g - Cost, normal purchase price are
> not recorded:
>
> 302594
> 305835
> 314329
>
> I have an Excel file that includes barcode numbers and their price fields
> like below:
>
> 952$p   - 952$g
> 302594 - 16.45
> 305835 - 10.80
> 314329 - 9.60
>
> Could we match the barcode numbers registered in KOHA with the barcode
> numbers in our Excel file to import the price value into 952$g?
>
> Best regards
>
>
> Kazım ŞENTÜRK
> Kütüphane Müdür V.
> Bursa Uludağ Üniversitesi
> Kütüphane ve Dokümantasyon Daire Başkanlığı
> Prof. Dr. Fuat Sezgin Merkez Kütüphanesi
> Görükle Yerleşkesi Nilüfer / Bursa
>
>
>
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>