I have imported all product serial numbers and need to now import my physical inventory with the serial numbers intact. I have exported the file to see the structure and it appears it is listing the serial numbers as inventory_line_id/prod_lot_id/id and the values are __export__.stock_inventory_line_15761. As it turns out, when exporting the serial numbers list, the same serial item is listed as __export__.stock_production_lot_15761. So since they are the same last five digits for all my samples I manually entered, I thought I could import by changing the serial ids to the new inventory ids, but it doesn't work and I'm assuming it's creating the inventory ids when creating it via the admin ui.

I have approximately 37,000+ serial numbers and many are long strings like 8889787564783 and 8874738847832F and as you can see, entering them manually is not an option and even if it were, it would be very tedious and error prone. How can I do this?