Hi Rajesh, it is possible with SQL, but you will want to do a full reindex after so you can search for your new barcodes. I think something like this could work: UPDATE items SET barcode = CONCAT('000',barcode) where barcode between 10 and 99; UPDATE items SET barcode = CONCAT('00',barcode) where barcode between 100 and 999; ... I'd also recommend doing a backup for doing any changes with SQL and testing your new barcodes well in circulation. Hope this helps, Katrin On 12.04.19 10:55, takan bhatt wrote:
Dear Sir / madam
My current Barcode is XXXXXX but I want to add zero as prefix in all the items, Is is possible in Bulk ?
Pls any SQL command is there ?
pls guide me
Rajesh Bhatt GRIMS LIbrary Vapi India _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha