;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 <ksent...@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@lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
