[Koha] change in Barcode

[Katrin Fischer]

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 at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha