Hello everyone! I wrote an SQL command to generate barcodes for all items in Koha. I did not find a command like this that was already written so I thought I might publish it on this list in case anyone else might find it useful. You will need to find your mysql username and password in your /etc/koha/sites/library/koha-conf.xml ("library" is your Koha instance name). In the commands below replace username with your username, of course, and koha_library with your database name. (You can show all databases in msql by entering: show databases; ) msql -u username -p use koha_library; set @bnum = 524580000000;update items set barcode=(@bnum:=@bnum+1) where barcode is not null; This will set a barcode of 524580000001 for the first book and each subsequent book will be assigned a number that is one higher than the last so the second will be 524580000002 and so on. I am not sure it is necessary but I also did a zebra reindex afterwards. (Again "library" is your Koha instance name.) sudo koha-rebuild-zebra -f -v library Thank you, Father Vlasie IT Director St. Photios Orthodox Theological Seminary 510 Collier Way, Etna, CA 96027, U.S.A. Website: www.spots.school