[Koha-bugs] [Bug 32804] New: Importing and replacing items causes inconsistency when itemnumber match and biblio match disagree

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32804

            Bug ID: 32804
           Summary: Importing and replacing items causes inconsistency
                    when itemnumber match and biblio match disagree
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: major
          Priority: P5 - low
         Component: Tools
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: nick at bywatersolutions.com
        QA Contact: testopia at bugs.koha-community.org

When 'Item processing' option during import is set to 'replace' itemnumber
matches do not check any other data - so the item's biblionumber is set to the
matched biblionumber, but the biblioitemnumber is not updated or checked

This means that if you import a record containing an item with an itemnumber
from another record you will end up with an item with mismatched biblio and
biblioitem numbers

This happens in consortia when multiple libraries have ordered the same biblio.
Two biblios are created, later the final import with barcodes etc. is imported
to replace items, and the more full bib is chosen for the biblio match, so
items are half moved.

To recreate:
1 - Be using the sample data in koha testing docker
2 - Stage the sample file on this report
3 - Match on KohaBiblio(999$c) / Item processing: replace
4 - Note the biblio match is "The complete novels / Austen, Jane"
5 - View the staged marc, note the barcode 39999000004090 in an item
6 - Search for that barcode
7 - You find biblio "Five novels : complete and unabridged / Gustave Flaubert"
8 - Import the file
9 - Check the db:
    SELECT * FROM items WHERE biblionumber != biblioitemnumber;
10 - Note the mismatch

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.